sql contents and structure files added

[brisk.git] / sql / sql.d / 001-struct.sql

diff --git a/sql/sql.d/001-struct.sql b/sql/sql.d/001-struct.sql
new file mode 100644 (file)
index 0000000..a95af6b
--- /dev/null
+++ b/sql/sql.d/001-struct.sql
@@ -0,0 +1,18 @@
+-- TODO
+--   DONE - CASCADE ON DELETE of orders related tables
+--   DONE - STATUS on orders
+
+DROP TABLE #PFX#users;
+CREATE TABLE #PFX#users (
+                        code  integer PRIMARY KEY,
+                        login text,
+                        pass  text,
+                        email text,
+                        type  integer
+                        );
+
+DROP TABLE #PFX#groups;
+CREATE TABLE #PFX#groups (
+                        code  integer PRIMARY KEY,
+                        gname text
+                        );