aboutsummaryrefslogtreecommitdiffstats
path: root/contrib/scripts/vmdb.sql
blob: 59238c659fe72961261300aa44ad093c501139a3 (plain)
1
2
3
4
5
6
7
8
9
10
11
drop table if exists users;
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)
);