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,
  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,
  17   t2_data blob,
  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,
  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