[ Index ]
 

Code source de Typo3 4.1.3

Accédez au Source d'autres logiciels libres

Classes | Fonctions | Variables | Constantes | Tables

title

Body

[fermer]

/t3lib/stddb/ -> tables.sql (source)

   1  # MySQL dump 6.4
   2  #
   3  # Host: localhost    Database: t3_testsite
   4  #--------------------------------------------------------
   5  # Server version    3.22.27
   6  #
   7  # TYPO3 CVS ID: $Id: tables.sql 2236 2007-04-02 19:13:04Z mundaun $
   8  
   9  #
  10  # Table structure for table 'be_groups'
  11  #
  12  CREATE TABLE be_groups (
  13    uid int(11) unsigned NOT NULL auto_increment,
  14    pid int(11) unsigned DEFAULT '0' NOT NULL,
  15    tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  16    title varchar(50) DEFAULT '' NOT NULL,
  17    non_exclude_fields text NOT NULL,
  18    explicit_allowdeny text NOT NULL,
  19    allowed_languages tinytext NOT NULL,
  20    custom_options text NOT NULL,
  21    db_mountpoints varchar(255) DEFAULT '' NOT NULL,
  22    pagetypes_select tinytext NOT NULL,
  23    tables_select text NOT NULL,
  24    tables_modify text NOT NULL,
  25    crdate int(11) unsigned DEFAULT '0' NOT NULL,
  26    cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  27    groupMods text NOT NULL,
  28    file_mountpoints varchar(255) DEFAULT '' NOT NULL,
  29    hidden tinyint(1) unsigned DEFAULT '0' NOT NULL,
  30    inc_access_lists tinyint(3) unsigned DEFAULT '0' NOT NULL,
  31    description text NOT NULL,
  32    lockToDomain varchar(50) DEFAULT '' NOT NULL,
  33    deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
  34    TSconfig text NOT NULL,
  35    subgroup tinytext NOT NULL,
  36    hide_in_lists tinyint(4) DEFAULT '0' NOT NULL,
  37    workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
  38    PRIMARY KEY (uid),
  39    KEY parent (pid)
  40  );
  41  
  42  #
  43  # Table structure for table 'be_sessions'
  44  #
  45  CREATE TABLE be_sessions (
  46    ses_id varchar(32) DEFAULT '' NOT NULL,
  47    ses_name varchar(32) DEFAULT '' NOT NULL,
  48    ses_iplock varchar(39) DEFAULT '' NOT NULL,
  49    ses_hashlock int(11) DEFAULT '0' NOT NULL,
  50    ses_userid int(11) unsigned DEFAULT '0' NOT NULL,
  51    ses_tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  52    ses_data longtext NOT NULL,
  53    ses_backuserid int(11) NOT NULL default '0',
  54    PRIMARY KEY (ses_id,ses_name)
  55  );
  56  
  57  #
  58  # Table structure for table 'be_users'
  59  #
  60  CREATE TABLE be_users (
  61    uid int(11) unsigned NOT NULL auto_increment,
  62    pid int(11) unsigned DEFAULT '0' NOT NULL,
  63    tstamp int(11) unsigned DEFAULT '0' NOT NULL,
  64    username varchar(50) DEFAULT '' NOT NULL,
  65    password varchar(40) DEFAULT '' NOT NULL,
  66    admin tinyint(4) unsigned DEFAULT '0' NOT NULL,
  67    usergroup tinytext NOT NULL,
  68    disable tinyint(1) unsigned DEFAULT '0' NOT NULL,
  69    starttime int(11) unsigned DEFAULT '0' NOT NULL,
  70    endtime int(11) unsigned DEFAULT '0' NOT NULL,
  71    lang char(2) DEFAULT '' NOT NULL,
  72    email varchar(80) DEFAULT '' NOT NULL,
  73    db_mountpoints varchar(255) DEFAULT '' NOT NULL,
  74    options tinyint(4) unsigned DEFAULT '0' NOT NULL,
  75    crdate int(11) unsigned DEFAULT '0' NOT NULL,
  76    cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
  77    realName varchar(80) DEFAULT '' NOT NULL,
  78    userMods tinytext NOT NULL,
  79    allowed_languages tinytext NOT NULL,
  80    uc text NOT NULL,
  81    file_mountpoints varchar(255) DEFAULT '' NOT NULL,
  82    fileoper_perms tinyint(4) DEFAULT '0' NOT NULL,
  83    workspace_perms tinyint(3) DEFAULT '1' NOT NULL,
  84    lockToDomain varchar(50) DEFAULT '' NOT NULL,
  85    disableIPlock tinyint(1) unsigned DEFAULT '0' NOT NULL,
  86    deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
  87    TSconfig text NOT NULL,
  88    lastlogin int(10) unsigned DEFAULT '0' NOT NULL,
  89    createdByAction int(11) DEFAULT '0' NOT NULL,
  90    usergroup_cached_list tinytext NOT NULL,
  91    workspace_id int(11) DEFAULT '0' NOT NULL,
  92    workspace_preview tinyint(3) DEFAULT '1' NOT NULL,
  93    PRIMARY KEY (uid),
  94    KEY parent (pid),
  95    KEY username (username)
  96  );
  97  
  98  #
  99  # Table structure for table 'cache_extensions'
 100  #
 101  CREATE TABLE cache_extensions (
 102    extkey varchar(60) NOT NULL default '',
 103    version varchar(10) NOT NULL default '',
 104    alldownloadcounter int(11) unsigned NOT NULL default '0',
 105    downloadcounter int(11) unsigned NOT NULL default '0',
 106    title varchar(150) NOT NULL default '',
 107    description mediumtext NOT NULL,
 108    state int(4) NOT NULL default '0',
 109    reviewstate int(4) NOT NULL default '0',
 110    category int(4) NOT NULL default '0',
 111    lastuploaddate int(11) unsigned NOT NULL default '0',
 112    dependencies mediumtext NOT NULL,
 113    authorname varchar(100) NOT NULL default '',
 114    authoremail varchar(100) NOT NULL default '',
 115    ownerusername varchar(50) NOT NULL default '',
 116    t3xfilemd5 varchar(35) NOT NULL default '',
 117    uploadcomment mediumtext NOT NULL,
 118    authorcompany varchar(100) NOT NULL default '',
 119    intversion int(11) NOT NULL default '0',
 120    lastversion int(3) NOT NULL default '0',
 121    lastreviewedversion int(3) NOT NULL default '0',
 122    PRIMARY KEY (extkey,version)
 123  );
 124  
 125  #
 126  # Table structure for table 'cache_hash'
 127  #
 128  CREATE TABLE cache_hash (
 129    hash varchar(32) DEFAULT '' NOT NULL,
 130    content mediumblob NOT NULL,
 131    tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 132    ident varchar(20) DEFAULT '' NOT NULL,
 133    PRIMARY KEY (hash)
 134  ) ENGINE=InnoDB;
 135  
 136  #
 137  # Table structure for table 'cache_imagesizes'
 138  #
 139  CREATE TABLE cache_imagesizes (
 140    md5hash varchar(32) DEFAULT '' NOT NULL,
 141    md5filename varchar(32) DEFAULT '' NOT NULL,
 142    tstamp int(11) DEFAULT '0' NOT NULL,
 143    filename tinytext NOT NULL,
 144    imagewidth mediumint(11) unsigned DEFAULT '0' NOT NULL,
 145    imageheight mediumint(11) unsigned DEFAULT '0' NOT NULL,
 146    PRIMARY KEY (md5filename)
 147  ) ENGINE=InnoDB;
 148  
 149  #
 150  # Table structure for table 'pages'
 151  #
 152  CREATE TABLE pages (
 153    uid int(11) NOT NULL auto_increment,
 154    pid int(11) DEFAULT '0' NOT NULL,
 155    t3ver_oid int(11) DEFAULT '0' NOT NULL,
 156    t3ver_id int(11) DEFAULT '0' NOT NULL,
 157    t3ver_wsid int(11) DEFAULT '0' NOT NULL,
 158    t3ver_label varchar(30) DEFAULT '' NOT NULL,
 159    t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
 160    t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
 161    t3ver_count int(11) DEFAULT '0' NOT NULL,
 162    t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
 163    t3ver_swapmode tinyint(4) DEFAULT '0' NOT NULL,
 164    t3_origuid int(11) DEFAULT '0' NOT NULL,
 165    tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 166    sorting int(11) unsigned DEFAULT '0' NOT NULL,
 167    deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 168    perms_userid int(11) unsigned DEFAULT '0' NOT NULL,
 169    perms_groupid int(11) unsigned DEFAULT '0' NOT NULL,
 170    perms_user tinyint(4) unsigned DEFAULT '0' NOT NULL,
 171    perms_group tinyint(4) unsigned DEFAULT '0' NOT NULL,
 172    perms_everybody tinyint(4) unsigned DEFAULT '0' NOT NULL,
 173    editlock tinyint(4) unsigned DEFAULT '0' NOT NULL,
 174    crdate int(11) unsigned DEFAULT '0' NOT NULL,
 175    cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
 176    title tinytext NOT NULL,
 177    doktype tinyint(3) unsigned DEFAULT '0' NOT NULL,
 178    TSconfig text NOT NULL,
 179    storage_pid int(11) DEFAULT '0' NOT NULL,
 180    is_siteroot tinyint(4) DEFAULT '0' NOT NULL,
 181    php_tree_stop tinyint(4) DEFAULT '0' NOT NULL,
 182    tx_impexp_origuid int(11) DEFAULT '0' NOT NULL,
 183    PRIMARY KEY (uid),
 184    KEY t3ver_oid (t3ver_oid,t3ver_wsid),
 185    KEY parent (pid,sorting)
 186  );
 187  
 188  #
 189  # Table structure for table 'sys_be_shortcuts'
 190  #
 191  CREATE TABLE sys_be_shortcuts (
 192    uid int(11) unsigned NOT NULL auto_increment,
 193    userid int(11) unsigned DEFAULT '0' NOT NULL,
 194    module_name tinytext NOT NULL,
 195    url text NOT NULL,
 196    description tinytext NOT NULL,
 197    sorting int(11) DEFAULT '0' NOT NULL,
 198    sc_group tinyint(4) DEFAULT '0' NOT NULL,
 199    PRIMARY KEY (uid),
 200    KEY event (userid)
 201  );
 202  
 203  
 204  #
 205  # Table structure for table 'sys_preview'
 206  #
 207  CREATE TABLE sys_preview (
 208    keyword varchar(32) DEFAULT '' NOT NULL,
 209    tstamp int(11) DEFAULT '0' NOT NULL,
 210    endtime int(11) DEFAULT '0' NOT NULL,
 211    config text NOT NULL,
 212    PRIMARY KEY (keyword)
 213  );
 214  
 215  
 216  #
 217  # Table structure for table 'sys_filemounts'
 218  #
 219  CREATE TABLE sys_filemounts (
 220    uid int(11) unsigned NOT NULL auto_increment,
 221    pid int(11) unsigned DEFAULT '0' NOT NULL,
 222    tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 223    title varchar(30) DEFAULT '' NOT NULL,
 224    path varchar(120) DEFAULT '' NOT NULL,
 225    base tinyint(4) unsigned DEFAULT '0' NOT NULL,
 226    hidden tinyint(3) unsigned DEFAULT '0' NOT NULL,
 227    deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
 228    PRIMARY KEY (uid),
 229    KEY parent (pid)
 230  );
 231  
 232  #
 233  # Table structure for table 'sys_workspace'
 234  #
 235  CREATE TABLE sys_workspace (
 236    uid int(11) NOT NULL auto_increment,
 237    pid int(11) DEFAULT '0' NOT NULL,
 238    tstamp int(11) DEFAULT '0' NOT NULL,
 239    deleted tinyint(1) DEFAULT '0' NOT NULL,
 240    title varchar(30) DEFAULT '' NOT NULL,
 241    description tinytext NOT NULL,
 242    adminusers tinytext NOT NULL,
 243    members text NOT NULL,
 244    reviewers text NOT NULL,
 245    db_mountpoints varchar(255) DEFAULT '' NOT NULL,
 246    file_mountpoints varchar(255) DEFAULT '' NOT NULL,
 247    publish_time int(11) DEFAULT '0' NOT NULL,
 248    unpublish_time int(11) DEFAULT '0' NOT NULL,
 249    freeze tinyint(3) DEFAULT '0' NOT NULL,
 250    live_edit tinyint(3) DEFAULT '0' NOT NULL,
 251    review_stage_edit tinyint(3) DEFAULT '0' NOT NULL,
 252    vtypes tinyint(3) DEFAULT '0' NOT NULL,
 253    disable_autocreate tinyint(1) DEFAULT '0' NOT NULL,
 254    swap_modes tinyint(3) DEFAULT '0' NOT NULL,
 255    publish_access tinyint(3) DEFAULT '0' NOT NULL,
 256    stagechg_notification tinyint(3) DEFAULT '0' NOT NULL,
 257  
 258    PRIMARY KEY (uid),
 259    KEY parent (pid)
 260  );
 261  
 262  #
 263  # Table structure for table 'sys_history'
 264  #
 265  CREATE TABLE sys_history (
 266    uid int(11) unsigned NOT NULL auto_increment,
 267    sys_log_uid int(11) DEFAULT '0' NOT NULL,
 268    history_data mediumtext NOT NULL,
 269    fieldlist text NOT NULL,
 270    recuid int(11) DEFAULT '0' NOT NULL,
 271    tablename varchar(40) DEFAULT '' NOT NULL,
 272    tstamp int(11) DEFAULT '0' NOT NULL,
 273    history_files mediumtext NOT NULL,
 274    snapshot tinyint(4) DEFAULT '0' NOT NULL,
 275    PRIMARY KEY (uid),
 276    KEY recordident (tablename,recuid,tstamp),
 277    KEY sys_log_uid (sys_log_uid)
 278  );
 279  
 280  #
 281  # Table structure for table 'sys_lockedrecords'
 282  #
 283  CREATE TABLE sys_lockedrecords (
 284    uid int(11) unsigned NOT NULL auto_increment,
 285    userid int(11) unsigned DEFAULT '0' NOT NULL,
 286    tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 287    record_table varchar(40) DEFAULT '' NOT NULL,
 288    record_uid int(11) DEFAULT '0' NOT NULL,
 289    record_pid int(11) DEFAULT '0' NOT NULL,
 290    username varchar(20) DEFAULT '' NOT NULL,
 291    PRIMARY KEY (uid),
 292    KEY event (userid,tstamp)
 293  );
 294  
 295  #
 296  # Table structure for table 'sys_refindex'
 297  #
 298  CREATE TABLE sys_refindex (
 299    hash varchar(32) DEFAULT '' NOT NULL,
 300    tablename varchar(40) DEFAULT '' NOT NULL,
 301    recuid int(11) DEFAULT '0' NOT NULL,
 302    field varchar(40) DEFAULT '' NOT NULL,
 303    flexpointer tinytext NOT NULL,
 304    softref_key varchar(30) DEFAULT '' NOT NULL,
 305    softref_id varchar(40) DEFAULT '' NOT NULL,
 306    sorting int(11) DEFAULT '0' NOT NULL,
 307    deleted tinyint(1) DEFAULT '0' NOT NULL,
 308    ref_table varchar(40) DEFAULT '' NOT NULL,
 309    ref_uid int(11) DEFAULT '0' NOT NULL,
 310    ref_string varchar(200) DEFAULT '' NOT NULL,
 311  
 312    PRIMARY KEY (hash),
 313    KEY lookup_rec (tablename,recuid),
 314    KEY lookup_uid (ref_table,ref_uid),
 315    KEY lookup_string (ref_table,ref_string)
 316  );
 317  
 318  #
 319  # Table structure for table ''
 320  #
 321  CREATE TABLE sys_refindex_words (
 322    wid int(11) DEFAULT '0' NOT NULL,
 323    baseword varchar(60) DEFAULT '' NOT NULL,
 324    PRIMARY KEY (wid)
 325  );
 326  
 327  #
 328  # Table structure for table ''
 329  #
 330  CREATE TABLE sys_refindex_rel (
 331    rid int(11) DEFAULT '0' NOT NULL,
 332    wid int(11) DEFAULT '0' NOT NULL,
 333    PRIMARY KEY (rid,wid)
 334  );
 335  
 336  
 337  #
 338  # Table structure for table ''
 339  #
 340  CREATE TABLE sys_refindex_res (
 341    rid int(11) DEFAULT '0' NOT NULL,
 342    tablename varchar(100) DEFAULT '' NOT NULL,
 343    recuid int(11) DEFAULT '0' NOT NULL,
 344    PRIMARY KEY (rid)
 345  );
 346  
 347  #
 348  # Table structure for table 'sys_log'
 349  #
 350  CREATE TABLE sys_log (
 351    uid int(11) unsigned NOT NULL auto_increment,
 352    userid int(11) unsigned DEFAULT '0' NOT NULL,
 353    action tinyint(4) unsigned DEFAULT '0' NOT NULL,
 354    recuid int(11) unsigned DEFAULT '0' NOT NULL,
 355    tablename varchar(40) DEFAULT '' NOT NULL,
 356    recpid int(11) DEFAULT '0' NOT NULL,
 357    error tinyint(4) unsigned DEFAULT '0' NOT NULL,
 358    details tinytext NOT NULL,
 359    tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 360    type tinyint(3) unsigned DEFAULT '0' NOT NULL,
 361    details_nr tinyint(3) unsigned DEFAULT '0' NOT NULL,
 362    IP varchar(39) DEFAULT '' NOT NULL,
 363    log_data tinytext NOT NULL,
 364    event_pid int(11) DEFAULT '-1' NOT NULL,
 365    workspace int(11) DEFAULT '0' NOT NULL,
 366    NEWid varchar(20) DEFAULT '' NOT NULL,
 367    PRIMARY KEY (uid),
 368    KEY event (userid,event_pid),
 369    KEY recuidIdx (recuid,uid)
 370  ) ENGINE=InnoDB;
 371  
 372  #
 373  # Table structure for table 'sys_language'
 374  #
 375  CREATE TABLE sys_language (
 376    uid int(11) unsigned NOT NULL auto_increment,
 377    pid int(11) unsigned DEFAULT '0' NOT NULL,
 378    tstamp int(11) unsigned DEFAULT '0' NOT NULL,
 379    hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
 380    title varchar(80) DEFAULT '' NOT NULL,
 381    flag varchar(20) DEFAULT '' NOT NULL,
 382    static_lang_isocode int(11) unsigned DEFAULT '0' NOT NULL,
 383    PRIMARY KEY (uid),
 384    KEY parent (pid)
 385  );
 386  


Généré le : Sun Nov 25 17:13:16 2007 par Balluche grâce à PHPXref 0.7
  Clicky Web Analytics