Added database migration files

[perfect-gift.git] / backend / migrations / 001-create_item.sql

diff --git a/backend/migrations/001-create_item.sql b/backend/migrations/001-create_item.sql
new file mode 100644 (file)
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
+);