Merge "[FEATURE] Improve information for detail view"
[Packages/TYPO3.CMS.git] / typo3 / sysext / workspaces / ext_tables.sql
1 #
2 # Table structure for table 'sys_workspace'
3 #
4 CREATE TABLE sys_workspace (
5 uid int(11) NOT NULL auto_increment,
6 pid int(11) DEFAULT '0' NOT NULL,
7 tstamp int(11) DEFAULT '0' NOT NULL,
8 deleted tinyint(1) DEFAULT '0' NOT NULL,
9 title varchar(30) DEFAULT '' NOT NULL,
10 description varchar(255) DEFAULT '' NOT NULL,
11 adminusers text,
12 members text,
13 reviewers text,
14 db_mountpoints varchar(255) DEFAULT '' NOT NULL,
15 file_mountpoints varchar(255) DEFAULT '' NOT NULL,
16 publish_time int(11) DEFAULT '0' NOT NULL,
17 unpublish_time int(11) DEFAULT '0' NOT NULL,
18 freeze tinyint(3) DEFAULT '0' NOT NULL,
19 live_edit tinyint(3) DEFAULT '0' NOT NULL,
20 vtypes tinyint(3) DEFAULT '0' NOT NULL,
21 disable_autocreate tinyint(1) DEFAULT '0' NOT NULL,
22 swap_modes tinyint(3) DEFAULT '0' NOT NULL,
23 publish_access tinyint(3) DEFAULT '0' NOT NULL,
24 custom_stages int(11) DEFAULT '0' NOT NULL,
25 stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
26
27 PRIMARY KEY (uid),
28 KEY parent (pid)
29 );
30
31
32 #
33 # Table structure for table 'sys_workspace_stage'
34 #
35 CREATE TABLE sys_workspace_stage (
36 uid int(11) NOT NULL auto_increment,
37 pid int(11) DEFAULT '0' NOT NULL,
38 tstamp int(11) DEFAULT '0' NOT NULL,
39 deleted tinyint(1) DEFAULT '0' NOT NULL,
40 sorting int(11) unsigned DEFAULT '0' NOT NULL,
41 title varchar(30) DEFAULT '' NOT NULL,
42 responsible_persons varchar(255) DEFAULT '' NOT NULL,
43 default_mailcomment text,
44 parentid int(11) DEFAULT '0' NOT NULL,
45 parenttable tinytext NOT NULL,
46
47 PRIMARY KEY (uid),
48 KEY parent (pid)
49 );