From 699bfdb4960019ad8af4be05c48ec4e2901a4549 Mon Sep 17 00:00:00 2001 From: bochard Date: Sun, 8 Jun 2025 21:55:31 +0800 Subject: [PATCH] remove username column for tasks table on database.sql --- TODO.TXT | 3 ++- database.sql | 5 ++--- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/TODO.TXT b/TODO.TXT index b517d73..d8e941a 100644 --- a/TODO.TXT +++ b/TODO.TXT @@ -4,4 +4,5 @@ 4. add a short animation loading progress bar when user did some actions to a task 6. create 'editing task' feature 7. create 'task sorting' feature -8. create 'task search' feature \ No newline at end of file +8. create 'task search' feature +9. when popup is open, the main window will be unaccessible \ No newline at end of file diff --git a/database.sql b/database.sql index 20669ac..68838c2 100644 --- a/database.sql +++ b/database.sql @@ -1,6 +1,6 @@ -CREATE DATABASE IF NOT EXISTS todolist; +CREATE DATABASE IF NOT EXISTS windo7; -USE todolist; +USE windo7; CREATE TABLE users ( user_id INT(11) NOT NULL AUTO_INCREMENT, @@ -13,7 +13,6 @@ CREATE TABLE users ( CREATE TABLE tasks ( task_id INT(11) NOT NULL AUTO_INCREMENT, - username VARCHAR(20) NOT NULL, task VARCHAR(255) NOT NULL, created_datetime DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, user_id int(11) NOT NULL, -- 2.39.5