typo3/sysext/core/ext_tables.sql

   1 #
   2
   3 #
   4 # Table structure for table 'be_groups'
   5 #
   6 CREATE TABLE be_groups (
   7   uid int(11) unsigned NOT NULL auto_increment,
   8   pid int(11) unsigned DEFAULT '0' NOT NULL,
   9   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  10   title varchar(50) DEFAULT '' NOT NULL,
  11   non_exclude_fields text,
  12   explicit_allowdeny text,
  13   allowed_languages varchar(255) DEFAULT '' NOT NULL,
  14   custom_options text,
  15   db_mountpoints varchar(255) DEFAULT '' NOT NULL,
  16   pagetypes_select varchar(255) DEFAULT '' NOT NULL,
  17   tables_select text,
  18   tables_modify text,
  19   crdate int(11) unsigned DEFAULT '0' NOT NULL,
  20   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  21   groupMods text,
  22   file_mountpoints varchar(255) DEFAULT '' NOT NULL,
  23   file_permissions text,
  24   hidden tinyint(1) unsigned DEFAULT '0' NOT NULL,
  25   inc_access_lists tinyint(3) unsigned DEFAULT '0' NOT NULL,
  26   description text,
  27   lockToDomain varchar(50) DEFAULT '' NOT NULL,
  28   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
  29   TSconfig text,
  30   subgroup text,
  31   hide_in_lists tinyint(4) DEFAULT '0' NOT NULL,
  32   workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
  33   PRIMARY KEY (uid),
  34   KEY parent (pid)
  35 );
  36
  37 #
  38 # Table structure for table 'be_sessions'
  39 #
  40 CREATE TABLE be_sessions (
  41   ses_id varchar(32) DEFAULT '' NOT NULL,
  42   ses_name varchar(32) DEFAULT '' NOT NULL,
  43   ses_iplock varchar(39) DEFAULT '' NOT NULL,
  44   ses_hashlock int(11) DEFAULT '0' NOT NULL,
  45   ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
  46   ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  47   ses_data longtext,
  48   ses_backuserid int(11) NOT NULL default '0',
  49   PRIMARY KEY (ses_id,ses_name),
  50   KEY ses_tstamp (ses_tstamp)
  51 );
  52
  53 #
  54 # Table structure for table 'be_users'
  55 #
  56 CREATE TABLE be_users (
  57   uid int(11) unsigned NOT NULL auto_increment,
  58   pid int(11) unsigned DEFAULT '0' NOT NULL,
  59   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  60   username varchar(50) DEFAULT '' NOT NULL,
  61   password varchar(100) DEFAULT '' NOT NULL,
  62   admin tinyint(4) unsigned DEFAULT '0' NOT NULL,
  63   usergroup varchar(255) DEFAULT '' NOT NULL,
  64   disable tinyint(1) unsigned DEFAULT '0' NOT NULL,
  65   starttime int(11) unsigned DEFAULT '0' NOT NULL,
  66   endtime int(11) unsigned DEFAULT '0' NOT NULL,
  67   lang char(2) DEFAULT '' NOT NULL,
  68   email varchar(80) DEFAULT '' NOT NULL,
  69   db_mountpoints varchar(255) DEFAULT '' NOT NULL,
  70   options tinyint(4) unsigned DEFAULT '0' NOT NULL,
  71   crdate int(11) unsigned DEFAULT '0' NOT NULL,
  72   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  73   realName varchar(80) DEFAULT '' NOT NULL,
  74   userMods text,
  75   allowed_languages varchar(255) DEFAULT '' NOT NULL,
  76   uc mediumtext,
  77   file_mountpoints varchar(255) DEFAULT '' NOT NULL,
  78   file_permissions text,
  79   workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
  80   lockToDomain varchar(50) DEFAULT '' NOT NULL,
  81   disableIPlock tinyint(1) unsigned DEFAULT '0' NOT NULL,
  82   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
  83   TSconfig text,
  84   lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
  85   createdByAction int(11) DEFAULT '0' NOT NULL,
  86   usergroup_cached_list text,
  87   workspace_id int(11) DEFAULT '0' NOT NULL,
  88   workspace_preview tinyint(3) DEFAULT '1' NOT NULL,
  89   PRIMARY KEY (uid),
  90   KEY parent (pid),
  91   KEY username (username)
  92 );
  93
  94 #
  95 # Table structure for table 'cache_imagesizes'
  96 #
  97 CREATE TABLE cache_imagesizes (
  98   md5hash varchar(32) DEFAULT '' NOT NULL,
  99   md5filename varchar(32) DEFAULT '' NOT NULL,
 100   tstamp int(11) DEFAULT '0' NOT NULL,
 101   filename varchar(255) DEFAULT '' NOT NULL,
 102   imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
 103   imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
 104   PRIMARY KEY (md5filename)
 105 ) ENGINE=InnoDB;
 106
 107 #
 108 # Table structure for table 'pages'
 109 #
 110 CREATE TABLE pages (
 111   uid int(11) NOT NULL auto_increment,
 112   pid int(11) DEFAULT '0' NOT NULL,
 113   t3ver_oid int(11) DEFAULT '0' NOT NULL,
 114   t3ver_id int(11) DEFAULT '0' NOT NULL,
 115   t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 116   t3ver_label varchar(255) DEFAULT '' NOT NULL,
 117   t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 118   t3ver_stage int(11) DEFAULT '0' NOT NULL,
 119   t3ver_count int(11) DEFAULT '0' NOT NULL,
 120   t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 121   t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 122   t3_origuid int(11) DEFAULT '0' NOT NULL,
 123   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 124   sorting int(11) unsigned DEFAULT '0' NOT NULL,
 125   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 126   perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
 127   perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
 128   perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
 129   perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
 130   perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
 131   editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
 132   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 133   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 134   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 135   title varchar(255) DEFAULT '' NOT NULL,
 136   doktype int(11) unsigned DEFAULT '0' NOT NULL,
 137   TSconfig text,
 138   storage_pid int(11) DEFAULT '0' NOT NULL,
 139   is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
 140   php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
 141   tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
 142   url varchar(255) DEFAULT '' NOT NULL,
 143   starttime int(11) unsigned DEFAULT '0' NOT NULL,
 144   endtime int(11) unsigned DEFAULT '0' NOT NULL,
 145   urltype tinyint(4) unsigned DEFAULT '0' NOT NULL,
 146   shortcut int(10) unsigned DEFAULT '0' NOT NULL,
 147   shortcut_mode int(10) unsigned DEFAULT '0' NOT NULL,
 148   no_cache int(10) unsigned DEFAULT '0' NOT NULL,
 149   fe_group varchar(100) DEFAULT '0' NOT NULL,
 150   subtitle varchar(255) DEFAULT '' NOT NULL,
 151   layout int(11) unsigned DEFAULT '0' NOT NULL,
 152   url_scheme tinyint(3) unsigned DEFAULT '0' NOT NULL,
 153   target varchar(80) DEFAULT '' NOT NULL,
 154   media text,
 155   lastUpdated int(10) unsigned DEFAULT '0' NOT NULL,
 156   keywords text,
 157   cache_timeout int(10) unsigned DEFAULT '0' NOT NULL,
 158   cache_tags varchar(255) DEFAULT '' NOT NULL,
 159   newUntil int(10) unsigned DEFAULT '0' NOT NULL,
 160   description text,
 161   no_search tinyint(3) unsigned DEFAULT '0' NOT NULL,
 162   SYS_LASTCHANGED int(10) unsigned DEFAULT '0' NOT NULL,
 163   abstract text,
 164   module varchar(10) DEFAULT '' NOT NULL,
 165   extendToSubpages tinyint(3) unsigned DEFAULT '0' NOT NULL,
 166   author varchar(255) DEFAULT '' NOT NULL,
 167   author_email varchar(80) DEFAULT '' NOT NULL,
 168   nav_title varchar(255) DEFAULT '' NOT NULL,
 169   nav_hide tinyint(4) DEFAULT '0' NOT NULL,
 170   content_from_pid int(10) unsigned DEFAULT '0' NOT NULL,
 171   mount_pid int(10) unsigned DEFAULT '0' NOT NULL,
 172   mount_pid_ol tinyint(4) DEFAULT '0' NOT NULL,
 173   alias varchar(32) DEFAULT '' NOT NULL,
 174   l18n_cfg tinyint(4) DEFAULT '0' NOT NULL,
 175   fe_login_mode tinyint(4) DEFAULT '0' NOT NULL,
 176   backend_layout int(10) DEFAULT '0' NOT NULL,
 177   backend_layout_next_level int(10) DEFAULT '0' NOT NULL,
 178   PRIMARY KEY (uid),
 179   KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 180   KEY parent (pid,deleted,sorting),
 181   KEY alias (alias)
 182 );
 183
 184 #
 185 # Table structure for table 'sys_registry'
 186 #
 187 CREATE TABLE sys_registry (
 188   uid int(11) unsigned NOT NULL auto_increment,
 189   entry_namespace varchar(128) DEFAULT '' NOT NULL,
 190   entry_key varchar(128) DEFAULT '' NOT NULL,
 191   entry_value blob,
 192   PRIMARY KEY (uid),
 193   UNIQUE KEY entry_identifier (entry_namespace,entry_key)
 194 );
 195
 196 #
 197 # Table structure for table 'sys_be_shortcuts'
 198 #
 199 CREATE TABLE sys_be_shortcuts (
 200   uid int(11) unsigned NOT NULL auto_increment,
 201   userid int(11) unsigned DEFAULT '0' NOT NULL,
 202   module_name varchar(255) DEFAULT '' NOT NULL,
 203   url text,
 204   description varchar(255) DEFAULT '' NOT NULL,
 205   sorting int(11) DEFAULT '0' NOT NULL,
 206   sc_group tinyint(4) DEFAULT '0' NOT NULL,
 207   PRIMARY KEY (uid),
 208   KEY event (userid)
 209 );
 210
 211
 212 #
 213 # Table structure for table 'sys_news'
 214 #
 215 CREATE TABLE sys_news (
 216   uid int(11) unsigned NOT NULL auto_increment,
 217   pid int(11) unsigned DEFAULT '0' NOT NULL,
 218   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 219   crdate int(11) unsigned DEFAULT '0' NOT NULL,
 220   cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 221   deleted tinyint(3) unsigned DEFAULT '0' NOT NULL,
 222   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 223   starttime int(11) unsigned DEFAULT '0' NOT NULL,
 224   endtime int(11) unsigned DEFAULT '0' NOT NULL,
 225   title varchar(255) DEFAULT '' NOT NULL,
 226   content mediumtext,
 227
 228   PRIMARY KEY (uid),
 229   KEY parent (pid)
 230 );
 231
 232
 233 #
 234 # Table structure for table 'sys_filemounts'
 235 #
 236 CREATE TABLE sys_filemounts (
 237   uid int(11) unsigned NOT NULL auto_increment,
 238   pid int(11) unsigned DEFAULT '0' NOT NULL,
 239   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 240   title varchar(30) DEFAULT '' NOT NULL,
 241   path varchar(120) DEFAULT '' NOT NULL,
 242   base tinyint(4) unsigned DEFAULT '0' NOT NULL,
 243   hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
 244   deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 245   sorting int(11) unsigned DEFAULT '0' NOT NULL,
 246   PRIMARY KEY (uid),
 247   KEY parent (pid)
 248 );
 249
 250
 251 #
 252 # Table structure for table 'sys_file_storage'
 253 #
 254 CREATE TABLE sys_file_storage (
 255         uid int(11) NOT NULL auto_increment,
 256         pid int(11) DEFAULT '0' NOT NULL,
 257         tstamp int(11) DEFAULT '0' NOT NULL,
 258         crdate int(11) DEFAULT '0' NOT NULL,
 259         cruser_id int(11) DEFAULT '0' NOT NULL,
 260         deleted tinyint(4) DEFAULT '0' NOT NULL,
 261         hidden tinyint(4) DEFAULT '0' NOT NULL,
 262
 263         name tinytext,
 264         description text,
 265         driver tinytext,
 266         configuration text,
 267         is_browsable tinyint(4) DEFAULT '0' NOT NULL,
 268         is_public tinyint(4) DEFAULT '0' NOT NULL,
 269         is_writable tinyint(4) DEFAULT '0' NOT NULL,
 270         is_online tinyint(4) DEFAULT '1' NOT NULL,
 271         processingfolder tinytext,
 272
 273         PRIMARY KEY (uid),
 274         KEY parent (pid,deleted)
 275 );
 276
 277 #
 278 # Table structure for table 'sys_file'
 279 #
 280 CREATE TABLE sys_file (
 281         uid int(11) NOT NULL auto_increment,
 282         pid int(11) DEFAULT '0' NOT NULL,
 283         # update timestamp of the database record, not the file!
 284         tstamp int(11) DEFAULT '0' NOT NULL,
 285
 286         # management information
 287         missing tinyint(4) DEFAULT '0' NOT NULL,
 288         storage int(11) DEFAULT '0' NOT NULL,
 289         type varchar(10) DEFAULT '' NOT NULL,
 290         metadata int(11) DEFAULT '0' NOT NULL,
 291
 292         # file info data
 293         identifier varchar(200) DEFAULT '' NOT NULL,
 294         extension varchar(255) DEFAULT '' NOT NULL,
 295         mime_type varchar(255) DEFAULT '' NOT NULL,
 296         name tinytext,
 297         sha1 tinytext,
 298         size int(11) DEFAULT '0' NOT NULL,
 299         creation_date int(11) DEFAULT '0' NOT NULL,
 300         modification_date int(11) DEFAULT '0' NOT NULL,
 301
 302         PRIMARY KEY (uid),
 303         KEY sel01 (storage,identifier(20)),
 304         KEY sha1 (sha1(40))
 305 );
 306
 307 #
 308 # Table structure for table 'sys_file_metadata'
 309 #
 310 CREATE TABLE sys_file_metadata (
 311         uid int(11) NOT NULL auto_increment,
 312         pid int(11) DEFAULT '0' NOT NULL,
 313         tstamp int(11) DEFAULT '0' NOT NULL,
 314         crdate int(11) DEFAULT '0' NOT NULL,
 315         cruser_id int(11) DEFAULT '0' NOT NULL,
 316
 317         # Versioning fields
 318         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 319         t3ver_id int(11) DEFAULT '0' NOT NULL,
 320         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 321         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 322         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 323         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 324         t3ver_count int(11) DEFAULT '0' NOT NULL,
 325         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 326         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 327         t3_origuid int(11) DEFAULT '0' NOT NULL,
 328
 329         file int(11) DEFAULT '0' NOT NULL,
 330         title tinytext,
 331         width int(11) DEFAULT '0' NOT NULL,
 332         height int(11) DEFAULT '0' NOT NULL,
 333         description text,
 334         alternative text,
 335
 336         PRIMARY KEY (uid),
 337         KEY file (file),
 338         KEY t3ver_oid (t3ver_oid,t3ver_wsid)
 339 );
 340
 341
 342 #
 343 # Table structure for table 'sys_file_processedfile'.
 344 # which is a "temporary" file, like an image preview
 345 # This table does not have a TCA representation, as it is only written
 346 # to using direct SQL queries in the code
 347 #
 348 CREATE TABLE sys_file_processedfile (
 349         uid int(11) NOT NULL auto_increment,
 350         tstamp int(11) DEFAULT '0' NOT NULL,
 351         crdate int(11) DEFAULT '0' NOT NULL,
 352
 353         storage int(11) DEFAULT '0' NOT NULL,
 354         original int(11) DEFAULT '0' NOT NULL,
 355         identifier varchar(512) DEFAULT '' NOT NULL,
 356         name tinytext,
 357         configuration text,
 358         originalfilesha1 varchar(40) DEFAULT '' NOT NULL,
 359         task_type varchar(200) DEFAULT '' NOT NULL,
 360         checksum varchar(255) DEFAULT '' NOT NULL,
 361         width int(11) DEFAULT '0',
 362         height int(11) DEFAULT '0',
 363
 364         PRIMARY KEY (uid)
 365 );
 366
 367 #
 368 # Table structure for table 'sys_file_reference'
 369 # which is one usage of a file with overloaded metadata
 370 #
 371 CREATE TABLE sys_file_reference (
 372         uid int(11) NOT NULL auto_increment,
 373         pid int(11) DEFAULT '0' NOT NULL,
 374         tstamp int(11) DEFAULT '0' NOT NULL,
 375         crdate int(11) DEFAULT '0' NOT NULL,
 376         cruser_id int(11) DEFAULT '0' NOT NULL,
 377         sorting int(10) DEFAULT '0' NOT NULL,
 378         deleted tinyint(4) DEFAULT '0' NOT NULL,
 379         hidden tinyint(4) DEFAULT '0' NOT NULL,
 380
 381         # Versioning fields
 382         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 383         t3ver_id int(11) DEFAULT '0' NOT NULL,
 384         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 385         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 386         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 387         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 388         t3ver_count int(11) DEFAULT '0' NOT NULL,
 389         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 390         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 391         t3_origuid int(11) DEFAULT '0' NOT NULL,
 392
 393         # Language fields
 394         sys_language_uid int(11) DEFAULT '0' NOT NULL,
 395         l10n_parent int(11) DEFAULT '0' NOT NULL,
 396         l10n_diffsource mediumblob NOT NULL,
 397
 398         # Reference fields (basically same as MM table)
 399         uid_local int(11) DEFAULT '0' NOT NULL,
 400         uid_foreign int(11) DEFAULT '0' NOT NULL,
 401         tablenames varchar(255) DEFAULT '' NOT NULL,
 402         fieldname tinytext,
 403         sorting_foreign int(11) DEFAULT '0' NOT NULL,
 404         table_local varchar(255) DEFAULT '' NOT NULL,
 405
 406         # Local usage overlay fields
 407         title tinytext,
 408         description text,
 409         alternative tinytext,
 410         link tinytext,
 411         downloadname tinytext,
 412
 413         PRIMARY KEY (uid),
 414         KEY parent (pid,deleted)
 415 );
 416
 417
 418 #
 419 # Table structure for table 'sys_file_collection'
 420 #
 421 CREATE TABLE sys_file_collection (
 422         uid int(11) NOT NULL auto_increment,
 423         pid int(11) DEFAULT '0' NOT NULL,
 424         tstamp int(11) DEFAULT '0' NOT NULL,
 425         crdate int(11) DEFAULT '0' NOT NULL,
 426         cruser_id int(11) DEFAULT '0' NOT NULL,
 427         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 428         t3ver_id int(11) DEFAULT '0' NOT NULL,
 429         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 430         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 431         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 432         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 433         t3ver_count int(11) DEFAULT '0' NOT NULL,
 434         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 435         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 436         t3_origuid int(11) DEFAULT '0' NOT NULL,
 437         sys_language_uid int(11) DEFAULT '0' NOT NULL,
 438         l10n_parent int(11) DEFAULT '0' NOT NULL,
 439         l10n_diffsource mediumtext,
 440         deleted tinyint(4) DEFAULT '0' NOT NULL,
 441         hidden tinyint(4) DEFAULT '0' NOT NULL,
 442         starttime int(11) DEFAULT '0' NOT NULL,
 443         endtime int(11) DEFAULT '0' NOT NULL,
 444
 445         # Actual fields
 446         title tinytext,
 447         description text,
 448         type varchar(6) DEFAULT 'static' NOT NULL,
 449
 450         # for type=static
 451         files int(11) DEFAULT '0' NOT NULL,
 452
 453         # for type=folder:
 454         storage int(11) DEFAULT '0' NOT NULL,
 455         folder text NOT NULL,
 456
 457         PRIMARY KEY (uid),
 458         KEY parent (pid,deleted),
 459         KEY t3ver_oid (t3ver_oid,t3ver_wsid)
 460 );
 461
 462 #
 463 # Table structure for table 'sys_collection'
 464 #
 465 CREATE TABLE sys_collection (
 466         uid int(11) NOT NULL auto_increment,
 467         pid int(11) DEFAULT '0' NOT NULL,
 468         tstamp int(11) DEFAULT '0' NOT NULL,
 469         crdate int(11) DEFAULT '0' NOT NULL,
 470         cruser_id int(11) DEFAULT '0' NOT NULL,
 471         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 472         t3ver_id int(11) DEFAULT '0' NOT NULL,
 473         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 474         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 475         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 476         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 477         t3ver_count int(11) DEFAULT '0' NOT NULL,
 478         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 479         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 480         t3_origuid int(11) DEFAULT '0' NOT NULL,
 481         sys_language_uid int(11) DEFAULT '0' NOT NULL,
 482         l10n_parent int(11) DEFAULT '0' NOT NULL,
 483         l10n_diffsource mediumtext,
 484         deleted tinyint(4) DEFAULT '0' NOT NULL,
 485         hidden tinyint(4) DEFAULT '0' NOT NULL,
 486         starttime int(11) DEFAULT '0' NOT NULL,
 487         endtime int(11) DEFAULT '0' NOT NULL,
 488         fe_group int(11) DEFAULT '0' NOT NULL,
 489
 490         title tinytext,
 491         description text,
 492         type varchar(32) DEFAULT 'static' NOT NULL,
 493         table_name tinytext,
 494         items int(11) DEFAULT '0' NOT NULL,
 495
 496         PRIMARY KEY (uid),
 497         KEY parent (pid,deleted),
 498         KEY t3ver_oid (t3ver_oid,t3ver_wsid)
 499 );
 500
 501 #
 502 # Table structure for table 'sys_collection_entries'
 503 #
 504 CREATE TABLE sys_collection_entries (
 505         uid int(11) NOT NULL auto_increment,
 506         uid_local int(11) DEFAULT '0' NOT NULL,
 507         uid_foreign int(11) DEFAULT '0' NOT NULL,
 508         tablenames varchar(30) DEFAULT '' NOT NULL,
 509         sorting int(11) DEFAULT '0' NOT NULL,
 510
 511         KEY uid_local (uid_local),
 512         KEY uid_foreign (uid_foreign),
 513         PRIMARY KEY (uid)
 514 );
 515
 516 #
 517 # Table structure for table 'sys_history'
 518 #
 519 CREATE TABLE sys_history (
 520   uid int(11) unsigned NOT NULL auto_increment,
 521   pid int(11) unsigned DEFAULT '0' NOT NULL,
 522   sys_log_uid int(11) DEFAULT '0' NOT NULL,
 523   history_data mediumtext,
 524   fieldlist text,
 525   recuid int(11) DEFAULT '0' NOT NULL,
 526   tablename varchar(255) DEFAULT '' NOT NULL,
 527   tstamp int(11) DEFAULT '0' NOT NULL,
 528   history_files mediumtext,
 529   snapshot int(11) DEFAULT '0' NOT NULL,
 530   PRIMARY KEY (uid),
 531   KEY parent (pid),
 532   KEY recordident_1 (tablename,recuid),
 533   KEY recordident_2 (tablename,tstamp),
 534   KEY sys_log_uid (sys_log_uid)
 535 ) ENGINE=InnoDB;
 536
 537 #
 538 # Table structure for table 'sys_lockedrecords'
 539 #
 540 CREATE TABLE sys_lockedrecords (
 541   uid int(11) unsigned NOT NULL auto_increment,
 542   userid int(11) unsigned DEFAULT '0' NOT NULL,
 543   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 544   record_table varchar(255) DEFAULT '' NOT NULL,
 545   record_uid int(11) DEFAULT '0' NOT NULL,
 546   record_pid int(11) DEFAULT '0' NOT NULL,
 547   username varchar(50) DEFAULT '' NOT NULL,
 548   feuserid int(11) unsigned DEFAULT '0' NOT NULL,
 549   PRIMARY KEY (uid),
 550   KEY event (userid,tstamp)
 551 );
 552
 553 #
 554 # Table structure for table 'sys_refindex'
 555 #
 556 CREATE TABLE sys_refindex (
 557   hash varchar(32) DEFAULT '' NOT NULL,
 558   tablename varchar(255) DEFAULT '' NOT NULL,
 559   recuid int(11) DEFAULT '0' NOT NULL,
 560   field varchar(40) DEFAULT '' NOT NULL,
 561   flexpointer varchar(255) DEFAULT '' NOT NULL,
 562   softref_key varchar(30) DEFAULT '' NOT NULL,
 563   softref_id varchar(40) DEFAULT '' NOT NULL,
 564   sorting int(11) DEFAULT '0' NOT NULL,
 565   deleted tinyint(1) DEFAULT '0' NOT NULL,
 566   ref_table varchar(255) DEFAULT '' NOT NULL,
 567   ref_uid int(11) DEFAULT '0' NOT NULL,
 568   ref_string varchar(200) DEFAULT '' NOT NULL,
 569
 570   PRIMARY KEY (hash),
 571   KEY lookup_rec (tablename,recuid),
 572   KEY lookup_uid (ref_table,ref_uid),
 573   KEY lookup_string (ref_string)
 574 );
 575
 576 #
 577 # Table structure for table 'sys_log'
 578 #
 579 CREATE TABLE sys_log (
 580   uid int(11) unsigned NOT NULL auto_increment,
 581   pid int(11) unsigned DEFAULT '0' NOT NULL,
 582   userid int(11) unsigned DEFAULT '0' NOT NULL,
 583   action tinyint(4) unsigned DEFAULT '0' NOT NULL,
 584   recuid int(11) unsigned DEFAULT '0' NOT NULL,
 585   tablename varchar(255) DEFAULT '' NOT NULL,
 586   recpid int(11) DEFAULT '0' NOT NULL,
 587   error tinyint(4) unsigned DEFAULT '0' NOT NULL,
 588   details text NOT NULL,
 589   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 590   type tinyint(3) unsigned DEFAULT '0' NOT NULL,
 591   details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
 592   IP varchar(39) DEFAULT '' NOT NULL,
 593   log_data text,
 594   event_pid int(11) DEFAULT '-1' NOT NULL,
 595   workspace int(11) DEFAULT '0' NOT NULL,
 596   NEWid varchar(20) DEFAULT '' NOT NULL,
 597   request_id varchar(13) DEFAULT '' NOT NULL,
 598   time_micro float DEFAULT '0' NOT NULL,
 599   component varchar(255) DEFAULT '' NOT NULL,
 600   level tinyint(1) unsigned DEFAULT '0' NOT NULL,
 601   message text,
 602   data text,
 603   PRIMARY KEY (uid),
 604   KEY parent (pid),
 605   KEY event (userid,event_pid),
 606   KEY recuidIdx (recuid,uid),
 607   KEY user_auth (type,action,tstamp),
 608   KEY request (request_id)
 609 ) ENGINE=InnoDB;
 610
 611 #
 612 # Table structure for table 'sys_language'
 613 #
 614 CREATE TABLE sys_language (
 615   uid int(11) unsigned NOT NULL auto_increment,
 616   pid int(11) unsigned DEFAULT '0' NOT NULL,
 617   tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 618   hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 619   title varchar(80) DEFAULT '' NOT NULL,
 620   flag varchar(20) DEFAULT '' NOT NULL,
 621   static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
 622   PRIMARY KEY (uid),
 623   KEY parent (pid)
 624 );
 625
 626 #
 627 # Table structure for table 'sys_category'
 628 #
 629 CREATE TABLE sys_category (
 630         uid int(11) NOT NULL auto_increment,
 631         pid int(11) DEFAULT '0' NOT NULL,
 632         tstamp int(11) DEFAULT '0' NOT NULL,
 633         crdate int(11) DEFAULT '0' NOT NULL,
 634         cruser_id int(11) DEFAULT '0' NOT NULL,
 635         deleted tinyint(4) DEFAULT '0' NOT NULL,
 636         hidden tinyint(4) DEFAULT '0' NOT NULL,
 637         starttime int(11) unsigned DEFAULT '0' NOT NULL,
 638         endtime int(11) unsigned DEFAULT '0' NOT NULL,
 639
 640         t3ver_oid int(11) DEFAULT '0' NOT NULL,
 641         t3ver_id int(11) DEFAULT '0' NOT NULL,
 642         t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 643         t3ver_label varchar(30) DEFAULT '' NOT NULL,
 644         t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 645         t3ver_stage int(11) DEFAULT '0' NOT NULL,
 646         t3ver_count int(11) DEFAULT '0' NOT NULL,
 647         t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 648         t3ver_move_id int(11) DEFAULT '0' NOT NULL,
 649         t3_origuid int(11) DEFAULT '0' NOT NULL,
 650         sorting int(11) unsigned DEFAULT '0' NOT NULL,
 651
 652         sys_language_uid int(11) DEFAULT '0' NOT NULL,
 653         l10n_parent int(11) DEFAULT '0' NOT NULL,
 654         l10n_diffsource mediumblob NOT NULL,
 655
 656         title tinytext NOT NULL,
 657         description text NOT NULL,
 658         parent int(11) DEFAULT '0' NOT NULL,
 659         items int(11) DEFAULT '0' NOT NULL,
 660
 661         PRIMARY KEY (uid),
 662         KEY parent (pid),
 663         KEY t3ver_oid (t3ver_oid,t3ver_wsid)
 664 );
 665
 666 #
 667 # Table structure for table 'sys_category_record_mm'
 668 #
 669 CREATE TABLE sys_category_record_mm (
 670         uid_local int(11) DEFAULT '0' NOT NULL,
 671         uid_foreign int(11) DEFAULT '0' NOT NULL,
 672         tablenames varchar(255) DEFAULT '' NOT NULL,
 673         fieldname varchar(255) DEFAULT '' NOT NULL,
 674         sorting int(11) DEFAULT '0' NOT NULL,
 675         sorting_foreign int(11) DEFAULT '0' NOT NULL,
 676
 677         KEY uid_local_foreign (uid_local,uid_foreign),
 678         KEY uid_foreign_tablenames (uid_foreign,tablenames)
 679 );