2 #
Table structure for table 'sys_action'
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,
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 tinytext
,
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(255) DEFAULT '' NOT NULL,
23 t4_recordsToEdit
text,
26 KEY cruser_id (cruser_id
),
31 #
Table structure for table 'sys_action_asgr_mm'
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
)