Imported workspaces system extension from GitHub repository after commit f1cd6371d96f...
[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 db_mountpoints varchar(255) DEFAULT '' NOT NULL,
14 file_mountpoints varchar(255) DEFAULT '' NOT NULL,
15 publish_time int(11) DEFAULT '0' NOT NULL,
16 unpublish_time int(11) DEFAULT '0' NOT NULL,
17 freeze tinyint(3) DEFAULT '0' NOT NULL,
18 live_edit tinyint(3) DEFAULT '0' NOT NULL,
19 review_stage_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
26 PRIMARY KEY (uid),
27 KEY parent (pid)
28 );
29
30
31 #
32 # Table structure for table 'sys_workspace_stage'
33 #
34 CREATE TABLE sys_workspace_stage (
35 uid int(11) NOT NULL auto_increment,
36 pid int(11) DEFAULT '0' NOT NULL,
37 tstamp int(11) DEFAULT '0' NOT NULL,
38 deleted tinyint(1) DEFAULT '0' NOT NULL,
39 sorting int(11) unsigned DEFAULT '0' NOT NULL,
40 title varchar(30) DEFAULT '' NOT NULL,
41 responsible_persons varchar(255) DEFAULT '' NOT NULL,
42 default_mailcomment text,
43 parentid int(11) DEFAULT '0' NOT NULL,
44 parenttable tinytext NOT NULL,
45
46 PRIMARY KEY (uid),
47 KEY parent (pid)
48 );