ce21b693d8c6fe4b23e76ebd44a627d00e45a914
[Packages/TYPO3.CMS.git] / typo3 / sysext / sys_action / ext_tables.sql
1 #
2 # Table structure for table 'sys_action'
3 #
4 CREATE TABLE sys_action (
5 uid int(11) unsigned NOT NULL auto_increment,
6 pid int(11) unsigned DEFAULT '0' NOT NULL,
7 tstamp int(11) unsigned DEFAULT '0' NOT NULL,
8 crdate int(11) unsigned DEFAULT '0' NOT NULL,
9 cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
10 sorting int(10) DEFAULT '0' NOT NULL,
11 title varchar(255) DEFAULT '' NOT NULL,
12 description text NOT NULL,
13 type tinyint(3) unsigned DEFAULT '0' NOT NULL,
14 t1_userprefix varchar(20) DEFAULT '' NOT NULL,
15 t1_copy_of_user int(11) DEFAULT '0' NOT NULL,
16 t1_allowed_groups tinyblob NOT NULL,
17 t2_data blob NOT NULL,
18 assign_to_groups int(11) DEFAULT '0' NOT NULL,
19 hidden tinyint(4) DEFAULT '0' NOT NULL,
20 t1_create_user_dir tinyint(4) DEFAULT '0' NOT NULL,
21 t3_listPid int(11) DEFAULT '0' NOT NULL,
22 t3_tables varchar(40) DEFAULT '' NOT NULL,
23 t4_recordsToEdit text NOT NULL,
24
25 PRIMARY KEY (uid),
26 KEY cruser_id (cruser_id),
27 KEY parent (pid)
28 );
29
30 #
31 # Table structure for table 'sys_action_asgr_mm'
32 #
33 CREATE TABLE sys_action_asgr_mm (
34 uid_local int(11) unsigned DEFAULT '0' NOT NULL,
35 uid_foreign int(11) unsigned DEFAULT '0' NOT NULL,
36 sorting int(11) unsigned DEFAULT '0' NOT NULL,
37 KEY uid_local (uid_local),
38 KEY uid_foreign (uid_foreign)
39 );
40