From e37c73e33a4aaf7fb8d25b5af03627f20bcda19f Mon Sep 17 00:00:00 2001
From: Doog <157747121+doogongithub@users.noreply.github.com>
Date: Sat, 24 Feb 2024 20:08:35 -0500
Subject: add gitignore

---
 db/scripts/water_init.sql | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

(limited to 'db/scripts/water_init.sql')

diff --git a/db/scripts/water_init.sql b/db/scripts/water_init.sql
index d7b912a..0751c41 100644
--- a/db/scripts/water_init.sql
+++ b/db/scripts/water_init.sql
@@ -1,13 +1,13 @@
 -- user table for users.
 CREATE TABLE IF NOT EXISTS Users (
-    id INT PRIMARY KEY,
+    id INTEGER PRIMARY KEY,
     name TEXT NOT NULL,
     UNIQUE(name)
 );
 
 -- statistics table for users to log their consumption
 CREATE TABLE IF NOT EXISTS Statistics (
-    id INT PRIMARY KEY,
+    id INTEGER PRIMARY KEY,
     date DATETIME NOT NULL,
     user_id INT NOT NULL,
     quantity INT
@@ -15,7 +15,7 @@ CREATE TABLE IF NOT EXISTS Statistics (
 
 -- preferences table for a user.
 CREATE TABLE IF NOT EXISTS Preferences (
-    id INT PRIMARY KEY,
+    id INTEGER PRIMARY KEY,
     color TEXT NOT NULL DEFAULT "#000000",
     user_id INT NOT NULL,
     size_id INT NOT NULL DEFAULT 1,
@@ -25,8 +25,8 @@ CREATE TABLE IF NOT EXISTS Preferences (
 
 -- lookup table for sizes.
 CREATE TABLE IF NOT EXISTS Sizes (
-    id INT PRIMARY KEY,
-    size INT NOT NULL
+    id INTEGER PRIMARY KEY,
+    size INT NOT NULL,
     unit TEXT DEFAULT "oz"
 );
 
-- 
cgit v1.1

