--- /dev/null
+CREATE TABLE ITEM(
+ ID INTEGER PRIMARY KEY AUTOINCREMENT,
+ URL TEXT UNIQUE NOT NULL
+);
--- /dev/null
+CREATE TABLE WISHLIST(
+ ID TEXT PRIMARY KEY,
+ NAME TEXT NOT NULL,
+ NOTE TEXT
+);
--- /dev/null
+CREATE TABLE USER(
+ ID INTEGER PRIMARY KEY AUTOINCREMENT,
+ USERNAME TEXT NOT NULL,
+ HASH TEXT NOT NULL,
+ SALT BLOB NOT NULL,
+ EMAIL TEXT
+);
--- /dev/null
+CREATE TABLE WISHLIST_ENTRY(
+ WISHLIST_ID TEXT NOT NULL REFERENCES WISHLIST(ID),
+ ITEM_ID INTEGER NOT NULL REFERENCES ITEM(ID),
+ NAME TEXT NOT NULL,
+ DESCRIPTION TEXT,
+ PRIMARY KEY(WISHLIST_ID, ITEM_ID)
+);
--- /dev/null
+CREATE TABLE USER_WISHLIST(
+ USER_ID INTEGER NOT NULL REFERENCES USER(ID),
+ WISHLIST_ID TEXT NOT NULL REFERENCES WISHLIST(ID),
+ PRIMARY KEY(USER_ID, WISHLIST_ID)
+);