Skip to content

joeyhlu/tracksite

Repository files navigation

Download and create change the sql to fit yours SQL: CREATE DATABASE tracksite_db; SHOW DATABASES; CREATE USER 'tracksite_user'@'localhost' IDENTIFIED BY 123; GRANT ALL PRIVILEGES ON tracksite_db.* TO 'tracksite_user'@'localhost'; FLUSH PRIVILEGES;

USE tracksite_db;

CREATE TABLE folders ( id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL UNIQUE );

CREATE TABLE bookmarks ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255) NOT NULL, url VARCHAR(2048) NOT NULL, type VARCHAR(50) DEFAULT 'url', folder_id INT, FOREIGN KEY (folder_id) REFERENCES folders(id) ON DELETE SET NULL );

image alt

About

Created using MYSQL, React, and FastAPI

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published