[Sommaire] [Imprimer]

   1  ####
   2  #### Important notes:
   3  #### If you make modifications (additions, subtractions), please
   4  #### make the appropriate change in the db_update files.  If you don't
   5  #### know the syntax for a different database, e-mail the list for
   6  #### help.
   7  ####
   8  ####
   9  
  10  #
  11  # Table structure for table '{PREFIX}authors'
  12  #
  13  
  14  create table {PREFIX}authors (
  15    realname varchar(255) NOT NULL default '',
  16    username varchar(32) default null,
  17    password varchar(32) default null,
  18    authorid {AUTOINCREMENT} {PRIMARY},
  19    mail_comments int(1) default '1',
  20    mail_trackbacks int(1) default '1',
  21    email varchar(128) not null default '',
  22    userlevel int(4) {UNSIGNED} not null default '0',
  23    right_publish int(1) default '1'
  24  ) {UTF_8};
  25  
  26  create table {PREFIX}groups (
  27    id {AUTOINCREMENT} {PRIMARY},
  28    name varchar(64) default null
  29  ) {UTF_8};
  30  
  31  create table {PREFIX}groupconfig (
  32    id int(10) {UNSIGNED} not null default '0',
  33    property varchar(128) default null,
  34    value varchar(32) default null
  35  ) {UTF_8};
  36  
  37  CREATE INDEX groupid_idx ON {PREFIX}groupconfig (id);
  38  CREATE INDEX groupprop_idx ON {PREFIX}groupconfig (id, property);
  39  
  40  create table {PREFIX}authorgroups (
  41    groupid int(10) {UNSIGNED} not null default '0',
  42    authorid int(10) {UNSIGNED} not null default '0'
  43  ) {UTF_8};
  44  
  45  CREATE INDEX authorgroup_idxA ON {PREFIX}authorgroups (groupid);
  46  CREATE INDEX authorgroup_idxB ON {PREFIX}authorgroups (authorid);
  47  
  48  create table {PREFIX}access (
  49    groupid int(10) {UNSIGNED} not null default '0',
  50    artifact_id int(10) {UNSIGNED} not null default '0',
  51    artifact_type varchar(64) NOT NULL default '',
  52    artifact_mode varchar(64) NOT NULL default '',
  53    artifact_index varchar(64) NOT NULL default ''
  54  ) {UTF_8};
  55  
  56  CREATE INDEX accessgroup_idx ON {PREFIX}access(groupid);
  57  CREATE INDEX accessgroupT_idx ON {PREFIX}access(artifact_id,artifact_type,artifact_mode);
  58  CREATE INDEX accessforeign_idx ON {PREFIX}access(artifact_id);
  59  
  60  
  61  #
  62  # table structure for table '{PREFIX}comments'
  63  #
  64  
  65  create table {PREFIX}comments (
  66    id {AUTOINCREMENT} {PRIMARY},
  67    entry_id int(10) {UNSIGNED} not null default '0',
  68    parent_id int(10) {UNSIGNED} not null default '0',
  69    timestamp int(10) {UNSIGNED} default null,
  70    title varchar(150) default null,
  71    author varchar(80) default null,
  72    email varchar(200) default null,
  73    url varchar(200) default null,
  74    ip varchar(64) default null,
  75    body text,
  76    type varchar(100) default 'regular',
  77    subscribed {BOOLEAN},
  78    status varchar(50) not null,
  79    referer varchar(200) default null
  80  ) {UTF_8};
  81  
  82  CREATE INDEX commentry_idx ON {PREFIX}comments (entry_id);
  83  CREATE INDEX commpentry_idx ON {PREFIX}comments (parent_id);
  84  CREATE INDEX commtype_idx ON {PREFIX}comments (type);
  85  CREATE INDEX commstat_idx ON {PREFIX}comments (status);
  86  
  87  #
  88  # table structure for table '{PREFIX}entries'
  89  #
  90  
  91  create table {PREFIX}entries (
  92    id {AUTOINCREMENT} {PRIMARY},
  93    title varchar(200) default null,
  94    timestamp int(10) {UNSIGNED} default null,
  95    body text,
  96    comments int(4) {UNSIGNED} default '0',
  97    trackbacks int(4) {UNSIGNED} default '0',
  98    extended text,
  99    exflag int(1) default null,
 100    author varchar(20) default null,
 101    authorid int(11) default null,
 102    isdraft {BOOLEAN},
 103    allow_comments {BOOLEAN},
 104    last_modified int(10) {UNSIGNED} default null,
 105    moderate_comments {BOOLEAN}
 106  ) {UTF_8};
 107  
 108  # FULLTEXT_MYSQL is ignored on all Non-MySQL setups (SQLite, PostgreSQL)
 109  CREATE {FULLTEXT_MYSQL} INDEX entry_idx on {PREFIX}entries (title,body,extended);
 110  CREATE INDEX date_idx ON {PREFIX}entries (timestamp);
 111  CREATE INDEX mod_idx ON {PREFIX}entries (last_modified);
 112  CREATE INDEX edraft_idx ON {PREFIX}entries (isdraft);
 113  CREATE INDEX eauthor_idx ON {PREFIX}entries (authorid);
 114  
 115  #
 116  # table structure for table '{PREFIX}references'
 117  #
 118  
 119  create table {PREFIX}references (
 120    id {AUTOINCREMENT} {PRIMARY},
 121    entry_id int(10) {UNSIGNED} not null default '0',
 122    link text,
 123    name text,
 124    type varchar(128) not null default ''
 125  ) {UTF_8};
 126  
 127  CREATE INDEX refentry_idx ON {PREFIX}references (entry_id);
 128  CREATE INDEX reftype_idx ON {PREFIX}references (type);
 129  
 130  #
 131  # Table structure for table '{PREFIX}exits'
 132  #
 133  
 134  CREATE TABLE {PREFIX}exits (
 135    entry_id int(11) NOT NULL default '0',
 136    day date NOT NULL,
 137    count int(11) NOT NULL default '0',
 138    scheme varchar(5),
 139    host varchar(128) NOT NULL,
 140    port varchar(5),
 141    path varchar(255),
 142    query varchar(255),
 143    PRIMARY KEY  (host,path,day,entry_id)
 144  ) {UTF_8};
 145  
 146  CREATE INDEX exits_idx ON {PREFIX}exits (entry_id,day,host);
 147  
 148  #
 149  # Table structure for table '{PREFIX}referrers'
 150  #
 151  
 152  CREATE TABLE {PREFIX}referrers (
 153    entry_id int(11) NOT NULL default '0',
 154    day date NOT NULL,
 155    count int(11) NOT NULL default '0',
 156    scheme varchar(5),
 157    host varchar(128) NOT NULL,
 158    port varchar(5),
 159    path varchar(255),
 160    query varchar(255),
 161    PRIMARY KEY  (host,day,entry_id)
 162  ) {UTF_8};
 163  
 164  CREATE INDEX referrers_idx ON {PREFIX}referrers (entry_id,day);
 165  
 166  #
 167  # Table structure for table 'serendipity_config'
 168  #
 169  
 170  create table {PREFIX}config (
 171    name varchar(255) not null,
 172    value text not null,
 173    authorid int(11) default '0'
 174  ) {UTF_8};
 175  
 176  CREATE INDEX configauthorid_idx ON {PREFIX}config (authorid);
 177  
 178  create table {PREFIX}options (
 179    name varchar(255) not null,
 180    value text not null,
 181    okey varchar(64) not null default ''
 182  ) {UTF_8};
 183  
 184  CREATE INDEX options_idx ON {PREFIX}options (okey);
 185  
 186  CREATE TABLE {PREFIX}suppress (
 187    ip varchar(64) default NULL,
 188    scheme varchar(5),
 189    host varchar(128),
 190    port varchar(5),
 191    path varchar(255),
 192    query varchar(255),
 193    last timestamp NOT NULL
 194  ) {UTF_8};
 195  
 196  CREATE INDEX url_idx on {PREFIX}suppress (host, ip);
 197  CREATE INDEX urllast_idx on {PREFIX}suppress (last);
 198  
 199  CREATE TABLE {PREFIX}plugins (
 200    name varchar(128) not null,
 201    placement varchar(6) not null default 'right',
 202    sort_order int(4) not null default '0',
 203    authorid int(11) default '0',
 204    path varchar(255) default null,
 205    PRIMARY KEY(name)
 206  ) {UTF_8};
 207  
 208  CREATE INDEX pluginauthorid_idx ON {PREFIX}plugins (authorid);
 209  CREATE INDEX pluginplace_idx ON {PREFIX}plugins (placement);
 210  CREATE INDEX pluginretr_idx ON {PREFIX}plugins (placement, sort_order);
 211  
 212  CREATE TABLE {PREFIX}category (
 213    categoryid {AUTOINCREMENT} {PRIMARY},
 214    category_name varchar(255) default NULL,
 215    category_icon varchar(255) default NULL,
 216    category_description text,
 217    authorid int(11) default NULL,
 218    category_left int(11) default '0',
 219    category_right int(11) default '0',
 220    parentid int(11) DEFAULT '0' NOT NULL,
 221    sort_order int(11),
 222    hide_sub int(1)
 223  ) {UTF_8};
 224  
 225  CREATE INDEX categorya_idx ON {PREFIX}category (authorid);
 226  CREATE INDEX categoryp_idx ON {PREFIX}category (parentid);
 227  CREATE INDEX categorylr_idx ON {PREFIX}category (category_left, category_right);
 228  CREATE INDEX categoryso_idx ON {PREFIX}category (sort_order);
 229  
 230  CREATE TABLE {PREFIX}images (
 231    id {AUTOINCREMENT} {PRIMARY},
 232    name varchar(255) not null default '',
 233    extension varchar(5) not null default '',
 234    mime varchar(255) not null default '',
 235    size int(11) not null default '0',
 236    dimensions_width int(11) not null default '0',
 237    dimensions_height int(11) not null default '0',
 238    date int(11) not null default '0',
 239    thumbnail_name varchar(255) not null default '',
 240    authorid int(11) default '0',
 241    path text,
 242    hotlink int(1),
 243    realname varchar(255) not null default ''
 244  ) {UTF_8};
 245  
 246  CREATE INDEX imagesauthorid_idx ON {PREFIX}images (authorid);
 247  CREATE {FULLTEXT} INDEX pathkey_idx on {PREFIX}images (path);
 248  
 249  CREATE TABLE {PREFIX}entrycat (
 250    entryid int(11) not null,
 251    categoryid int(11) not null
 252  ) {UTF_8};
 253  
 254  CREATE UNIQUE INDEX entryid_idx ON {PREFIX}entrycat (entryid, categoryid);
 255  
 256  create table {PREFIX}entryproperties (
 257    entryid int(11) not null,
 258    property varchar(255) not null,
 259    value text
 260  ) {UTF_8};
 261  
 262  CREATE INDEX entrypropid_idx ON {PREFIX}entryproperties (entryid);
 263  CREATE UNIQUE INDEX prop_idx ON {PREFIX}entryproperties (entryid, property);
 264  
 265  create table {PREFIX}mediaproperties (
 266    mediaid int(11) not null,
 267    property varchar(128) not null,
 268    property_group varchar(50) not null default '',
 269    property_subgroup varchar(50) not null default '',
 270    value text
 271  ) {UTF_8};
 272  
 273  CREATE INDEX mediapropid_idx ON {PREFIX}mediaproperties (mediaid);
 274  CREATE UNIQUE INDEX media_idx ON {PREFIX}mediaproperties (mediaid, property, property_group, property_subgroup);
 275  
 276  CREATE TABLE {PREFIX}permalinks (
 277      permalink varchar(255) not null default '',
 278      entry_id int(10) {UNSIGNED} not null default '0',
 279      type varchar(200) not null default '',
 280      data text
 281  ) {UTF_8};
 282  
 283  CREATE INDEX pl_idx ON {PREFIX}permalinks (permalink);
 284  CREATE INDEX ple_idx ON {PREFIX}permalinks (entry_id);
 285  CREATE INDEX plt_idx ON {PREFIX}permalinks (type);
 286  CREATE INDEX plcomb_idx ON {PREFIX}permalinks (permalink, type);
 287  
 288  create table {PREFIX}plugincategories (
 289    class_name varchar(250) default null,
 290    category varchar(250) default null
 291  ) {UTF_8};
 292  
 293  CREATE INDEX plugincat_idx ON {PREFIX}plugincategories(class_name, category);
 294  
 295  create table {PREFIX}pluginlist (
 296    plugin_file varchar(255) NOT NULL default '',
 297    class_name varchar(255) NOT NULL default '',
 298    plugin_class varchar(255) NOT NULL default '',
 299    pluginPath varchar(255) NOT NULL default '',
 300    name varchar(255) NOT NULL default '',
 301    description text NOT NULL,
 302    version varchar(12) NOT NULL default '',
 303    upgrade_version varchar(12) NOT NULL default '',
 304    plugintype varchar(255) NOT NULL default '',
 305    pluginlocation varchar(255) NOT NULL default '',
 306    stackable int(1) NOT NULL default '0',
 307    author varchar(255) NOT NULL default '',
 308    requirements text NOT NULL,
 309    website varchar(255) NOT NULL default '',
 310    last_modified int(11) NOT NULL default '0'
 311  ) {UTF_8};
 312  
 313  CREATE INDEX pluginlist_f_idx ON {PREFIX}pluginlist(plugin_file);
 314  CREATE INDEX pluginlist_cn_idx ON {PREFIX}pluginlist(class_name);
 315  CREATE INDEX pluginlist_pt_idx ON {PREFIX}pluginlist(plugintype);
 316  CREATE INDEX pluginlist_pl_idx ON {PREFIX}pluginlist(pluginlocation);