diff options
author | James Golovich <james@gnuinter.net> | 2004-03-20 07:51:56 +0000 |
---|---|---|
committer | James Golovich <james@gnuinter.net> | 2004-03-20 07:51:56 +0000 |
commit | 1498cc552f41f913114b26173de1c7c36e96dabf (patch) | |
tree | 359dcd469b425e2f6b5cc849f8545a2443879d74 /contrib/scripts/vmdb.sql | |
parent | 32bde5b00967229e74942137130904dc07f224cd (diff) |
Make primary key context and voicemailbox and make the file easier on
the eyes (bug 1208)
git-svn-id: https://origsvn.digium.com/svn/asterisk/trunk@2492 65c4cc65-6c06-0410-ace0-fbb531ad65f3
Diffstat (limited to 'contrib/scripts/vmdb.sql')
-rwxr-xr-x | contrib/scripts/vmdb.sql | 11 |
1 files changed, 10 insertions, 1 deletions
diff --git a/contrib/scripts/vmdb.sql b/contrib/scripts/vmdb.sql index dbef17316..59238c659 100755 --- a/contrib/scripts/vmdb.sql +++ b/contrib/scripts/vmdb.sql @@ -1,2 +1,11 @@ drop table if exists users; -create table users (mailbox VARCHAR(80) NOT NULL PRIMARY KEY, context VARCHAR(80), password VARCHAR(80), fullname VARCHAR(80), email VARCHAR(80), pager VARCHAR(80), options VARCHAR(160)); +create table users ( +context VARCHAR(80) NOT NULL, +mailbox VARCHAR(80) NOT NULL, +password VARCHAR(80) NOT NULL DEFAULT '', +fullname VARCHAR(80) NOT NULL DEFAULT '', +email VARCHAR(80) NOT NULL DEFAULT '', +pager VARCHAR(80) NOT NULL DEFAULT '', +options VARCHAR(160) NOT NULL DEFAULT '', +PRIMARY KEY (context, mailbox) +); |