[TASK] Restructure nightly plans in stages a 50 jobs
[Packages/TYPO3.CMS.git] / typo3 / sysext / workspaces / ext_tables.sql
1 #
2 # Table structure for table 'sys_preview'
3 #
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,
8 config text,
9 PRIMARY KEY (keyword)
10 );
11
12 #
13 # Table structure for table 'sys_workspace'
14 #
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 db_mountpoints text,
20 file_mountpoints text,
21 publish_time int(11) DEFAULT '0' NOT NULL,
22 freeze tinyint(3) DEFAULT '0' NOT NULL,
23 live_edit tinyint(3) DEFAULT '0' NOT NULL,
24 swap_modes tinyint(3) DEFAULT '0' NOT NULL,
25 publish_access tinyint(3) DEFAULT '0' NOT NULL,
26 custom_stages int(11) DEFAULT '0' NOT NULL,
27 stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
28 edit_notification_defaults varchar(255) DEFAULT '' NOT NULL,
29 edit_notification_preselection tinyint(3) DEFAULT '3' NOT NULL,
30 edit_allow_notificaton_settings tinyint(3) DEFAULT '0' NOT NULL,
31 publish_notification_defaults varchar(255) DEFAULT '' NOT NULL,
32 publish_notification_preselection tinyint(3) DEFAULT '3' NOT NULL,
33 publish_allow_notificaton_settings tinyint(3) DEFAULT '0' NOT NULL,
34 execute_notification_defaults varchar(255) DEFAULT '' NOT NULL,
35 execute_notification_preselection tinyint(3) DEFAULT '3' NOT NULL,
36 execute_allow_notificaton_settings tinyint(3) DEFAULT '0' NOT NULL
37 );
38
39
40 #
41 # Table structure for table 'sys_workspace_stage'
42 #
43 CREATE TABLE sys_workspace_stage (
44 title varchar(30) DEFAULT '' NOT NULL,
45 responsible_persons varchar(255) DEFAULT '' NOT NULL,
46 default_mailcomment text,
47 parentid int(11) DEFAULT '0' NOT NULL,
48 parenttable varchar(255) DEFAULT '' NOT NULL,
49 notification_defaults varchar(255) DEFAULT '' NOT NULL,
50 allow_notificaton_settings tinyint(3) DEFAULT '0' NOT NULL,
51 notification_preselection tinyint(3) DEFAULT '8' NOT NULL
52 );