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