diff options
author | Tomek Dubrownik <t.dubrownik@gmail.com> | 2012-01-26 19:58:09 +0100 |
---|---|---|
committer | Tomek Dubrownik <t.dubrownik@gmail.com> | 2012-01-26 19:58:09 +0100 |
commit | ae406076f7a5691a9922a9b66d29c29f03fb2892 (patch) | |
tree | 8125cfb8fe2506e50a128e1593c8f19bfd32d673 /dbsetup.sql | |
download | checkinator-ae406076f7a5691a9922a9b66d29c29f03fb2892.tar.gz checkinator-ae406076f7a5691a9922a9b66d29c29f03fb2892.tar.bz2 checkinator-ae406076f7a5691a9922a9b66d29c29f03fb2892.zip |
initial commit
Diffstat (limited to 'dbsetup.sql')
-rw-r--r-- | dbsetup.sql | 13 |
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 +); |