It's a simple app to save links.
CRUD using Node as a back-end and MySQL as a database
/signup /links /links/add /links/edit/:id npm run dev CREATE DATABASE f34th3r_links; USE f34th3r_links; -- TABLE USER -- all pasword wil be encrypted using SHA1 CREATE TABLE users ( id INT(11) NOT NULL, username VARCHAR(16) NOT NULL, password VARCHAR(60) NOT NULL, fullname VARCHAR(100) NOT NULL ); ALTER TABLE users ADD PRIMARY KEY (id); ALTER TABLE users MODIFY id INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 2; DESCRIBE users; INSERT INTO users (id, username, password, fullname) VALUES (1, 'feather', 'secret', 'Feather io'); SELECT * FROM users; -- LINKS TABLE CREATE TABLE links ( id INT(11) NOT NULL, title VARCHAR(150) NOT NULL, url VARCHAR(255) NOT NULL, description TEXT, user_id INT(11), created_at timestamp NOT NULL DEFAULT current_timestamp, CONSTRAINT fk_user FOREIGN KEY(user_id) REFERENCES users(id) ); ALTER TABLE links ADD PRIMARY KEY (id); ALTER TABLE links MODIFY id INT(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT = 2; DESCRIBE links;
