initial commit

1 files changed, 13 insertions, 0 deletions

diff --git a/sql/tables/auth.users.sql b/sql/tables/auth.users.sql
new file mode 100644
index 0000000..8eecf76
--- /dev/null
+++ b/sql/tables/auth.users.sql
@@ -0,0 +1,13 @@
+drop table auth.users cascade;
+
+create table auth.users (
+    id serial8 primary key,
+    username character varying(255) not null,
+    pwd bytea,
+    first_name character varying(255) not null,
+    last_name character varying(255) not null,
+    email character varying(255) not null,
+    phone character varying(255),
+    active bool,
+    created timestamp without time zone not null default now()
+);