summaryrefslogtreecommitdiff
path: root/dichroism/src/migrations/products.sql
diff options
context:
space:
mode:
authorAdam T. Carpenter <atc@53hor.net>2022-05-02 22:32:52 -0400
committerAdam T. Carpenter <atc@53hor.net>2022-05-02 22:32:52 -0400
commitc7d885e4b8189e4539c1f259a44ec37c6cd027b2 (patch)
treedc2b0486c123404854ae44fc49ac57f0eca18734 /dichroism/src/migrations/products.sql
parentf243a3b7341012227d6e8342a65f9c5d7784256f (diff)
downloadtheglassyladies-c7d885e4b8189e4539c1f259a44ec37c6cd027b2.tar.xz
theglassyladies-c7d885e4b8189e4539c1f259a44ec37c6cd027b2.zip
feat: reset button read config start db pool and launch axum serverssr
Diffstat (limited to 'dichroism/src/migrations/products.sql')
-rw-r--r--dichroism/src/migrations/products.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/dichroism/src/migrations/products.sql b/dichroism/src/migrations/products.sql
new file mode 100644
index 0000000..0603a5c
--- /dev/null
+++ b/dichroism/src/migrations/products.sql
@@ -0,0 +1,12 @@
+CREATE TABLE IF NOT EXISTS "products" (
+ "id" INTEGER NOT NULL,
+ "photo_set" INTEGER NOT NULL,
+ "cents" INTEGER NOT NULL,
+ "quantity" INTEGER NOT NULL,
+ "name" TEXT NOT NULL,
+ "description" TEXT NOT NULL,
+ "featured" INTEGER NOT NULL,
+ "category" TEXT NOT NULL,
+ PRIMARY KEY("id"),
+ FOREIGN KEY("photo_set") REFERENCES "photo_sets"("id")
+); \ No newline at end of file