summaryrefslogtreecommitdiffstats
path: root/dbsetup.sql
diff options
context:
space:
mode:
authorTomek Dubrownik <t.dubrownik@gmail.com>2012-01-26 19:58:09 +0100
committerTomek Dubrownik <t.dubrownik@gmail.com>2012-01-26 19:58:09 +0100
commitae406076f7a5691a9922a9b66d29c29f03fb2892 (patch)
tree8125cfb8fe2506e50a128e1593c8f19bfd32d673 /dbsetup.sql
downloadcheckinator-ae406076f7a5691a9922a9b66d29c29f03fb2892.tar.gz
checkinator-ae406076f7a5691a9922a9b66d29c29f03fb2892.tar.bz2
checkinator-ae406076f7a5691a9922a9b66d29c29f03fb2892.zip
initial commit
Diffstat (limited to 'dbsetup.sql')
-rw-r--r--dbsetup.sql13
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
+);