diff options
| author | citats <citats@f38db490-d61c-443f-a65b-d21fe96a405b> | 2004-03-20 07:51:56 +0000 |
|---|---|---|
| committer | citats <citats@f38db490-d61c-443f-a65b-d21fe96a405b> | 2004-03-20 07:51:56 +0000 |
| commit | c903eba88f040df2a3256e8893cd897349b1df14 (patch) | |
| tree | 359dcd469b425e2f6b5cc849f8545a2443879d74 /contrib | |
| parent | e0b3f1f410e3a7c2dc24f15eb1ca3fb7221cbdec (diff) | |
Make primary key context and voicemailbox and make the file easier on
the eyes (bug 1208)
git-svn-id: http://svn.digium.com/svn/asterisk/trunk@2492 f38db490-d61c-443f-a65b-d21fe96a405b
Diffstat (limited to 'contrib')
| -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) +); |