1,7 → 1,7 |
-- |
-- hostadmiral sql tables |
-- |
-- FIXME: which values has boolean in hibernate - '1':'0' or '1':'0'? |
-- FIXME: which values has boolean in hibernate - '1':' ' or '1':'0'? |
|
create sequence hibernate_sequence; |
|
17,9 → 17,9 |
login varchar(255) not null, |
password varchar(255) not null, |
boss integer, |
superuser char(1) default '0' check (superuser = '1' or superuser = '0'), |
superuser char(1) default ' ' check (superuser = '1' or superuser = ' '), |
locale varchar(5) default 'en', -- language_country |
enabled char(1) default '1' check (enabled = '1' or enabled = '0'), |
enabled char(1) default '1' check (enabled = '1' or enabled = ' '), |
comment text, |
mod_stamp timestamp, |
mod_user integer, |
54,7 → 54,7 |
uid integer not null, |
name varchar(255) not null, |
owner integer, |
enabled char(1) default '1' check (enabled = '1' or enabled = '0'), |
enabled char(1) default '1' check (enabled = '1' or enabled = ' '), |
comment text, |
mod_stamp timestamp, |
mod_user integer, |
70,7 → 70,7 |
id integer not null, |
name varchar(255) not null, |
owner integer not null, |
enabled char(1) default '1' check (enabled = '1' or enabled = '0'), |
enabled char(1) default '1' check (enabled = '1' or enabled = ' '), |
comment text, |
mod_stamp timestamp, |
mod_user integer, |
89,10 → 89,10 |
password varchar(255), -- if null, then owner's password is used |
domain integer not null, |
owner integer not null, |
virusCheck char(1) default '1' check (virusCheck = '1' or virusCheck = '0'), |
spamCheck char(1) default '1' check (spamCheck = '1' or spamCheck = '0'), |
virusCheck char(1) default '1' check (virusCheck = '1' or virusCheck = ' '), |
spamCheck char(1) default '1' check (spamCheck = '1' or spamCheck = ' '), |
systemuser integer, |
enabled char(1) default '1' check (enabled = '1' or enabled = '0'), |
enabled char(1) default '1' check (enabled = '1' or enabled = ' '), |
comment text, |
mod_stamp timestamp, |
mod_user integer, |
111,7 → 111,7 |
address varchar(255) not null, |
domain integer not null, |
owner integer not null, |
enabled char(1) default '1' check (enabled = '1' or enabled = '0'), |
enabled char(1) default '1' check (enabled = '1' or enabled = ' '), |
comment text, |
mod_stamp timestamp, |
mod_user integer, |
128,7 → 128,7 |
alias integer not null, |
mailbox integer, |
email varchar(255), |
enabled char(1) default '1' check (enabled = '1' or enabled = '0'), |
enabled char(1) default '1' check (enabled = '1' or enabled = ' '), |
comment text, |
mod_stamp timestamp, |
mod_user integer, |