2 #
Table structure for table 'sys_preview'
4 CREATE TABLE sys_preview (
5 keyword
varchar(32) DEFAULT '' NOT NULL,
6 tstamp
int(11) DEFAULT '0' NOT NULL,
7 endtime
int(11) DEFAULT '0' NOT NULL,
13 #
Table structure for table 'sys_workspace'
15 CREATE TABLE sys_workspace (
16 title
varchar(30) DEFAULT '' NOT NULL,
17 adminusers
varchar(4000) DEFAULT '' NOT NULL,
18 members
varchar(4000) DEFAULT '' NOT NULL,
19 reviewers
varchar(4000) DEFAULT '' NOT NULL,
20 db_mountpoints
varchar(255) DEFAULT '' NOT NULL,
21 file_mountpoints
varchar(255) DEFAULT '' NOT NULL,
22 publish_time
int(11) DEFAULT '0' NOT NULL,
23 unpublish_time
int(11) DEFAULT '0' NOT NULL,
24 freeze tinyint(3) DEFAULT '0' NOT NULL,
25 live_edit
tinyint(3) DEFAULT '0' NOT NULL,
26 vtypes
tinyint(3) DEFAULT '0' NOT NULL,
27 swap_modes
tinyint(3) DEFAULT '0' NOT NULL,
28 publish_access
tinyint(3) DEFAULT '0' NOT NULL,
29 custom_stages
int(11) DEFAULT '0' NOT NULL,
30 stagechg_notification
tinyint(3) DEFAULT '0' NOT NULL,
31 edit_notification_defaults
varchar(255) DEFAULT '' NOT NULL,
32 edit_notification_preselection
tinyint(3) DEFAULT '3' NOT NULL,
33 edit_allow_notificaton_settings
tinyint(3) DEFAULT '0' NOT NULL,
34 publish_notification_defaults
varchar(255) DEFAULT '' NOT NULL,
35 publish_notification_preselection
tinyint(3) DEFAULT '3' NOT NULL,
36 publish_allow_notificaton_settings
tinyint(3) DEFAULT '0' NOT NULL,
37 execute_notification_defaults
varchar(255) DEFAULT '' NOT NULL,
38 execute_notification_preselection
tinyint(3) DEFAULT '3' NOT NULL,
39 execute_allow_notificaton_settings
tinyint(3) DEFAULT '0' NOT NULL
44 #
Table structure for table 'sys_workspace_stage'
46 CREATE TABLE sys_workspace_stage (
47 title
varchar(30) DEFAULT '' NOT NULL,
48 responsible_persons
varchar(255) DEFAULT '' NOT NULL,
49 default_mailcomment
text,
50 parentid
int(11) DEFAULT '0' NOT NULL,
51 parenttable tinytext
NOT NULL,
52 notification_defaults
varchar(255) DEFAULT '' NOT NULL,
53 allow_notificaton_settings
tinyint(3) DEFAULT '0' NOT NULL,
54 notification_preselection
tinyint(3) DEFAULT '8' NOT NULL