From d52f08d6553f3c61ee71067c791b94f1f1e041da Mon Sep 17 00:00:00 2001 From: Dana Truempy Date: Sun, 17 May 2020 14:50:03 -0500 Subject: [PATCH] Added database migration files --- backend/migrations/001-create_item.sql | 4 ++++ backend/migrations/002-create_wishlist.sql | 5 +++++ backend/migrations/003-create_user.sql | 7 +++++++ backend/migrations/004-create_wishlist_entry.sql | 7 +++++++ backend/migrations/005-create_user_wishlist.sql | 5 +++++ 5 files changed, 28 insertions(+) create mode 100644 backend/migrations/001-create_item.sql create mode 100644 backend/migrations/002-create_wishlist.sql create mode 100644 backend/migrations/003-create_user.sql create mode 100644 backend/migrations/004-create_wishlist_entry.sql create mode 100644 backend/migrations/005-create_user_wishlist.sql diff --git a/backend/migrations/001-create_item.sql b/backend/migrations/001-create_item.sql new file mode 100644 index 0000000..4e337c0 --- /dev/null +++ b/backend/migrations/001-create_item.sql @@ -0,0 +1,4 @@ +CREATE TABLE ITEM( + ID INTEGER PRIMARY KEY AUTOINCREMENT, + URL TEXT UNIQUE NOT NULL +); diff --git a/backend/migrations/002-create_wishlist.sql b/backend/migrations/002-create_wishlist.sql new file mode 100644 index 0000000..758ba25 --- /dev/null +++ b/backend/migrations/002-create_wishlist.sql @@ -0,0 +1,5 @@ +CREATE TABLE WISHLIST( + ID TEXT PRIMARY KEY, + NAME TEXT NOT NULL, + NOTE TEXT +); diff --git a/backend/migrations/003-create_user.sql b/backend/migrations/003-create_user.sql new file mode 100644 index 0000000..3ae517a --- /dev/null +++ b/backend/migrations/003-create_user.sql @@ -0,0 +1,7 @@ +CREATE TABLE USER( + ID INTEGER PRIMARY KEY AUTOINCREMENT, + USERNAME TEXT NOT NULL, + HASH TEXT NOT NULL, + SALT BLOB NOT NULL, + EMAIL TEXT +); diff --git a/backend/migrations/004-create_wishlist_entry.sql b/backend/migrations/004-create_wishlist_entry.sql new file mode 100644 index 0000000..9826d5a --- /dev/null +++ b/backend/migrations/004-create_wishlist_entry.sql @@ -0,0 +1,7 @@ +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) +); diff --git a/backend/migrations/005-create_user_wishlist.sql b/backend/migrations/005-create_user_wishlist.sql new file mode 100644 index 0000000..9480c30 --- /dev/null +++ b/backend/migrations/005-create_user_wishlist.sql @@ -0,0 +1,5 @@ +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) +); -- 2.20.1