[TASK] Deprecate GeneralUtility::getHostName
[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 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
40 );
41
42
43 #
44 # Table structure for table 'sys_workspace_stage'
45 #
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
55 );