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