| 1,7 → 1,7 |
|---|
| -- |
| -- hostadmiral sql tables |
| -- |
| -- FIXME: which values has boolean in hibernate - '1':' ' or '1':'0'? |
| -- FIXME: which values has boolean in hibernate - '1':'0' 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 ' ' check (superuser = '1' or superuser = ' '), |
| superuser char(1) default '0' check (superuser = '1' or superuser = '0'), |
| locale varchar(5) default 'en', -- language_country |
| enabled char(1) default '1' check (enabled = '1' or enabled = ' '), |
| enabled char(1) default '1' check (enabled = '1' or enabled = '0'), |
| 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 = ' '), |
| enabled char(1) default '1' check (enabled = '1' or enabled = '0'), |
| 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 = ' '), |
| enabled char(1) default '1' check (enabled = '1' or enabled = '0'), |
| 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 = ' '), |
| spamCheck char(1) default '1' check (spamCheck = '1' or spamCheck = ' '), |
| virusCheck char(1) default '1' check (virusCheck = '1' or virusCheck = '0'), |
| spamCheck char(1) default '1' check (spamCheck = '1' or spamCheck = '0'), |
| systemuser integer, |
| enabled char(1) default '1' check (enabled = '1' or enabled = ' '), |
| enabled char(1) default '1' check (enabled = '1' or enabled = '0'), |
| 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 = ' '), |
| enabled char(1) default '1' check (enabled = '1' or enabled = '0'), |
| 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 = ' '), |
| enabled char(1) default '1' check (enabled = '1' or enabled = '0'), |
| comment text, |
| mod_stamp timestamp, |
| mod_user integer, |