summaryrefslogtreecommitdiffstats
path: root/dbsetup.sql
diff options
context:
space:
mode:
authorTomek Dubrownik <t.dubrownik@gmail.com>2012-09-15 01:38:30 +0200
committerTomek Dubrownik <t.dubrownik@gmail.com>2012-09-15 01:38:30 +0200
commitc0e8cc2ccf39a6b6b23a9503e8ebb9ee287ed675 (patch)
tree161af6c72defc5fb598d666084b51af248b53d79 /dbsetup.sql
parent3cb096cc76c7463a0f94649d1fe321c2b7cbffe7 (diff)
downloadcheckinator-c0e8cc2ccf39a6b6b23a9503e8ebb9ee287ed675.tar.gz
checkinator-c0e8cc2ccf39a6b6b23a9503e8ebb9ee287ed675.tar.bz2
checkinator-c0e8cc2ccf39a6b6b23a9503e8ebb9ee287ed675.zip
basic ldap support, needs SSL verify
Diffstat (limited to 'dbsetup.sql')
-rw-r--r--dbsetup.sql9
1 files changed, 1 insertions, 8 deletions
diff --git a/dbsetup.sql b/dbsetup.sql
index 441a266..6f85b51 100644
--- a/dbsetup.sql
+++ b/dbsetup.sql
@@ -1,13 +1,6 @@
-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),
+ owner varchar(100) not null,
ignored boolean
);