tc-thinh / GitGPS-3.0

3 stars 0 forks source link

S-006: ExpressJS, SQLite DB and migration files #8

Open tc-thinh opened 2 months ago

tc-thinh commented 2 months ago

AC:

CREATE TABLE tasks ( taskID INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE, userID INTEGER, taskDesc TEXT, isComplete BOOLEAN, FOREIGN KEY(userID) REFERENCES Users(id) );

CREATE TABLE users ( userID INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE, username STRING NOT NULL UNIQUE, passwordHash STRING );

CREATE TABLE AuthTokens ( token STRING NOT NULL UNIQUE, userID INTEGER NOT NULL, FOREIGN KEY(userID) REFERENCES Users(id) );

-- Down DROP TABLE tasks; DROP TABLE users; DROP TABLE AuthTokens;


https://www.npmjs.com/package/sqlite3
- Basic functionalities to handle CRUD operations
- No authentication needed