initial commit

1 files changed, 13 insertions, 0 deletions

diff --git a/dbsetup.sql b/dbsetup.sql
new file mode 100644
index 0000000..441a266
--- /dev/null
+++ b/dbsetup.sql
@@ -0,0 +1,13 @@
+create table users (
+  userid integer primary key,
+  login varchar(50) unique not null,
+  pass character(64),
+  url varchar(300)
+);
+
+create table devices (
+  hwaddr character(17) primary key,
+  name varchar(50),
+  owner integer references users(userid),
+  ignored boolean
+);