[Sommaire] [Imprimer]

   1  <?php
   2  
   3  $Tables["articles"]["schema"] = "
   4    id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
   5    date T(14) NOTNULL,
   6    modification_date T(14) NOTNULL,
   7    user_id I(10) UNSIGNED NOTNULL DEFAULT '0',
   8    blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
   9    status I(5) NOTNULL DEFAULT 1,
  10    num_reads I(10) DEFAULT '0',
  11    properties TEXT NOTNULL DEFAULT '',
  12    slug C(255) NOTNULL DEFAULT '',
  13    num_comments I(10) NOTNULL DEFAULT '0', 
  14    num_nonspam_comments I(10) NOTNULL DEFAULT '0', 
  15    num_trackbacks I(10) NOTNULL DEFAULT '0',
  16    num_nonspam_trackbacks I(10) NOTNULL DEFAULT '0',
  17    global_category_id I(10) NOTNULL DEFAULT '0',
  18    in_summary_page I1(1) NOTNULL DEFAULT '1',
  19    INDEX num_reads (num_reads),
  20    INDEX user_id (user_id),
  21    INDEX slug (slug),
  22    INDEX blog_id_status_date (blog_id, status, date),
  23    INDEX global_category_status (global_category_id, status),
  24    INDEX date(date)
  25  ";
  26  $Tables["articles"]["options"] = "TYPE=MyISAM";
  27  
  28  $Tables["articles_categories"]["schema"] = "
  29    id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
  30    name C(255) NOTNULL DEFAULT '',
  31    url C(255) NOTNULL DEFAULT '',
  32    blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  33    last_modification T(14) NOTNULL,
  34    in_main_page I1(1) NOTNULL DEFAULT '1',
  35    parent_id I(10) NOTNULL DEFAULT '0',
  36    description TEXT NOTNULL DEFAULT '',
  37    properties TEXT NOTNULL DEFAULT '',
  38    mangled_name C(255) NOTNULL DEFAULT '',
  39    num_articles I(10) NOTNULL DEFAULT 0,
  40    num_published_articles I(10) NOTNULL DEFAULT 0
  41    INDEX parent_id (parent_id),
  42    INDEX blog_id (blog_id),
  43    INDEX mangled_name (mangled_name)
  44  ";
  45  $Tables["articles_categories"]["options"] = "TYPE=MyISAM";
  46  
  47  
  48  $Tables["articles_comments"]["schema"] = "
  49    id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
  50    article_id I(10) UNSIGNED NOTNULL DEFAULT 0,
  51    blog_id I(10) UNSIGNED NOTNULL DEFAULT 0,
  52    topic TEXT NOTNULL,
  53    text X,
  54    date T(14) NOTNULL,
  55    user_id I(10) DEFAULT '0',
  56    user_email C(255) DEFAULT '',
  57    user_url C(255) DEFAULT '',
  58    user_name C(255) NOTNULL DEFAULT Anonymous,
  59    parent_id I(10) UNSIGNED DEFAULT '0',
  60    client_ip varchar(15) DEFAULT 0.0.0.0,
  61    send_notification I1(1) DEFAULT '0',
  62    status I1(2) DEFAULT '1',
  63    spam_rate float DEFAULT '0',
  64    properties TEXT NOTNULL DEFAULT '',
  65    normalized_text TEXT NOTNULL DEFAULT '',
  66    normalized_topic TEXT NOTNULL DEFAULT '',
  67    type I(3) NOTNULL DEFAULT '1', 
  68    INDEX parent_id (parent_id),
  69    INDEX article_id_blog_id(article_id,blog_id),
  70    INDEX article_id_type(article_id,type),  
  71    INDEX blog_id_type(blog_id,type),
  72    FULLTEXT normalized_fields (normalized_text,normalized_topic),
  73    FULLTEXT normalized_text (normalized_text),
  74    FULLTEXT normalized_topic (normalized_topic)
  75  ";
  76  $Tables["articles_comments"]["options"] = "TYPE=MyISAM";
  77  
  78  $Tables["articles_notifications"]["schema"] = "
  79    id I(10) NOTNULL AUTOINCREMENT PRIMARY,
  80    blog_id I(10) NOTNULL DEFAULT '0',
  81    user_id I(10) NOTNULL DEFAULT '0',
  82    article_id I(10) NOTNULL DEFAULT '0',
  83    INDEX article_id (article_id),
  84    INDEX user_id (user_id),
  85    INDEX blog_id (blog_id)
  86  ";
  87  $Tables["articles_notifications"]["options"] = "TYPE=MyISAM";
  88  
  89  $Tables["blogs"]["schema"] = "
  90    id I(10) UNSIGNED NOTNULL AUTOINCREMENT INDEX PRIMARY,
  91    blog varchar(50) NOTNULL DEFAULT '',
  92    owner_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  93    blog_category_id I(10) UNSIGNED NOTNULL DEFAULT '0',
  94    about X,
  95    settings TEXT NOTNULL,
  96    mangled_blog varchar(50) NOTNULL DEFAULT '',
  97    status I(4) NOTNULL DEFAULT '1',
  98    show_in_summary I(4) NOTNULL DEFAULT '1',
  99    create_date T(14) NOTNULL,
 100    last_update_date T(14) NOTNULL,
 101    num_posts I(10) NOTNULL DEFAULT '0',
 102    num_comments I(10) NOTNULL DEFAULT '0',
 103    num_trackbacks I(10) NOTNULL DEFAULT '0',
 104    custom_domain C(50), 
 105    INDEX owner_id (owner_id),
 106    INDEX mangled_blog (mangled_blog),
 107    INDEX blog_category_id(blog_category_id),
 108    INDEX custom_domain(custom_domain),
 109    INDEX create_date(create_date)
 110  ";
 111  $Tables["blogs"]["options"] = "TYPE=MyISAM";
 112  
 113  $Tables["mylinks"]["schema"] = "
 114    id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
 115    category_id I(10) UNSIGNED NOTNULL DEFAULT '0',
 116    url C(255) NOTNULL DEFAULT '',
 117    name varchar(100) DEFAULT '',
 118    description TEXT NOTNULL,
 119    blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
 120    rss_feed C(255) NOTNULL DEFAULT '',
 121    date T(14) NOTNULL,
 122    properties TEXT NOTNULL DEFAULT '',
 123    INDEX blog_id (blog_id),
 124    INDEX category_id (category_id)
 125  ";
 126  $Tables["mylinks"]["options"] = "TYPE=MyISAM";
 127  
 128  $Tables["mylinks_categories"]["schema"] = "
 129    id I(10) NOTNULL AUTOINCREMENT PRIMARY,
 130    name varchar(100) NOTNULL DEFAULT '',
 131    blog_id I(10) NOTNULL DEFAULT '0',
 132    last_modification T(14) NOTNULL,
 133    properties TEXT NOTNULL DEFAULT '',
 134    num_links I(10) NOTNULL DEFAULT '0',
 135    INDEX blog_id (blog_id)
 136  ";
 137  $Tables["mylinks_categories"]["options"] = "TYPE=MyISAM";
 138  
 139  $Tables["permissions"]["schema"] = "
 140    id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
 141    permission varchar(25) NOTNULL DEFAULT '',
 142    description varchar(100) NOTNULL DEFAULT '',
 143    admin_only I(1) NOTNULL DEFAULT '1',
 144    core_perm I(1) NOTNULL DEFAULT '1'
 145  ";
 146  $Tables["permissions"]["options"] = "TYPE=MyISAM";
 147  
 148  $Tables["referers"]["schema"] = "
 149    id I(10) NOTNULL AUTOINCREMENT PRIMARY,
 150    url TEXT NOTNULL,
 151    article_id I(10) NOTNULL DEFAULT '0',
 152    blog_id I(10) NOTNULL DEFAULT '0',
 153    hits I(10) DEFAULT '1',
 154    last_date T(14),
 155    INDEX article_id (article_id),
 156    INDEX blog_id_article_id (blog_id, article_id)
 157  ";
 158  $Tables["referers"]["options"] = "TYPE=MyISAM";
 159  
 160  $Tables["users"]["schema"] = "
 161    id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
 162    user varchar(15) NOTNULL DEFAULT '',
 163    password varchar(32) NOTNULL DEFAULT '',
 164    email C(255) NOTNULL DEFAULT '',
 165    full_name C(255) NOTNULL DEFAULT '',
 166    about X,
 167    properties TEXT NOTNULL DEFAULT '',
 168    status I(4) NOTNULL DEFAULT 1,
 169    resource_picture_id I(10) NOTNULL DEFAULT 0,
 170    site_admin I(10) NOTNULL DEFAULT '0',
 171    last_login T(14),
 172    UNIQUE user (user)
 173  ";
 174  $Tables["users"]["options"] = "TYPE=MyISAM";
 175  
 176  $Tables["users_permissions"]["schema"] = "
 177    id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
 178    user_id I(10) UNSIGNED NOTNULL DEFAULT '0',
 179    blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
 180    permission_id I(10) UNSIGNED NOTNULL DEFAULT '0',
 181    INDEX blog_id (blog_id),
 182    INDEX user_id_permission_id (user_id,permission_id)
 183  ";
 184  $Tables["users_permissions"]["options"] = "TYPE=MyISAM";
 185  
 186  //
 187  // temporary table only used during the upgrade process, will be dropped at the end of it
 188  //
 189  $Tables["tmp_users_permissions"]["schema"] = "
 190    id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
 191    user_id I(10) UNSIGNED NOTNULL DEFAULT '0',
 192    blog_id I(10) UNSIGNED NOTNULL DEFAULT '0',
 193    permission_id I(10) UNSIGNED NOTNULL DEFAULT '0',
 194    INDEX blog_id (blog_id),
 195    INDEX user_id_permission_id (user_id,permission_id)
 196  ";
 197  $Tables["users_permissions"]["options"] = "TYPE=MyISAM";
 198  
 199  $Tables["config"]["schema"] = "
 200     config_key C(255) NOTNULL DEFAULT '' PRIMARY,
 201     config_value TEXT NOTNULL,
 202     value_type I(3) DEFAULT '0'
 203  ";
 204  $Tables["config"]["options"] = "TYPE=MyISAM";
 205  
 206  $Tables["filtered_content"]["schema"] = "
 207     id I(10) NOTNULL AUTOINCREMENT PRIMARY,
 208     reg_exp X,
 209     blog_id I(10) NOTNULL DEFAULT '0',
 210     reason X,
 211     date T(14) NOTNULL,
 212     INDEX blog_id (blog_id)
 213  ";
 214  $Tables["filtered_content"]["options"] = "TYPE=MyISAM";
 215  
 216  $Tables["host_blocking_rules"]["schema"] = "
 217     id I(10) NOTNULL AUTOINCREMENT PRIMARY,
 218     reason X,
 219     date T(14) NOTNULL,
 220     blog_id I(10) NOTNULL DEFAULT '0',
 221     block_type I(1) DEFAULT '1',
 222     list_type I(1) DEFAULT '1',
 223     mask I(2) DEFAULT '0',
 224     host varchar(15) DEFAULT '0.0.0.0',
 225     INDEX block_type (block_type),
 226     INDEX blog_id_block_type(blog_id, block_type)
 227  ";
 228  $Tables["host_blocking_rules"]["options"] = "TYPE=MyISAM";
 229  
 230  $Tables["gallery_resources"]["schema"] = "
 231     id I(10) NOTNULL AUTOINCREMENT PRIMARY,
 232     owner_id I(10) NOTNULL DEFAULT '0',
 233     album_id I(10) NOTNULL DEFAULT '0',
 234     description X,
 235     date T(14) NOTNULL,
 236     flags I(10) DEFAULT '0',
 237     resource_type I(3) DEFAULT NULL,
 238     file_path C(255) DEFAULT '',
 239     file_name C(255) DEFAULT '',
 240     file_size I(20) NOTNULL DEFAULT 0,
 241     metadata X,
 242     thumbnail_format varchar(4) NOTNULL DEFAULT 'same',
 243     normalized_description TEXT NOTNULL DEFAULT '',
 244     properties TEXT NOTNULL DEFAULT '',
 245     INDEX owner_id (owner_id),
 246     INDEX file_name (file_name),
 247     INDEX album_id_owner_id (album_id, owner_id),
 248     INDEX resource_type (resource_type),
 249     FULLTEXT normalized_description (normalized_description)
 250  ";
 251  $Tables["gallery_resources"]["options"] = "TYPE=MyISAM";
 252  
 253  $Tables["gallery_albums"]["schema"] = "
 254     id I(10) NOTNULL AUTOINCREMENT PRIMARY,
 255     owner_id I(10) NOTNULL DEFAULT '0',
 256     description TEXT NOTNULL,
 257     name C(255) NOTNULL DEFAULT '',
 258     flags I(10) NOTNULL DEFAULT '0',
 259     parent_id I(10) NOTNULL DEFAULT '0',
 260     date T(14) NOTNULL,
 261     properties TEXT NOTNULL DEFAULT '',
 262     show_album I1(1) DEFAULT 1,
 263     normalized_description TEXT NOTNULL DEFAULT '',
 264     normalized_name C(255) NOTNULL DEFAULT '',
 265     mangled_name C(255) NOTNULL DEFAULT '',
 266     num_resources I(10) NOTNULL DEFAULT '0',
 267     num_children I(10) NOTNULL DEFAULT '0',
 268     INDEX parent_id (parent_id),
 269     INDEX mangled_name (mangled_name),
 270     INDEX owner_id_mangled_name (owner_id, mangled_name),
 271     FULLTEXT normalized_name (normalized_name),
 272     FULLTEXT normalized_description (normalized_description),
 273     FULLTEXT normalized_fields (normalized_name, normalized_description)
 274  ";
 275  $Tables["gallery_albums"]["options"] = "TYPE=MyISAM";
 276  
 277  $Tables["bayesian_filter_info"]["schema"] = "
 278     id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
 279     blog_id I(10) UNSIGNED DEFAULT NULL,
 280     total_spam I(10) UNSIGNED DEFAULT NULL,
 281     total_nonspam I(10) UNSIGNED DEFAULT NULL,
 282     INDEX blog_id (blog_id)
 283  ";
 284  $Tables["bayesian_filter_info"]["options"] = "TYPE=MyISAM";
 285  
 286  $Tables["bayesian_tokens"]["schema"] = "
 287     id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
 288     blog_id I(10) UNSIGNED DEFAULT NULL,
 289     token char(100) DEFAULT NULL,
 290     spam_occurrences I(10) UNSIGNED DEFAULT NULL,
 291     nonspam_occurrences I(10) UNSIGNED DEFAULT NULL,
 292     prob F DEFAULT NULL,
 293     INDEX blog_id (blog_id),
 294     INDEX token (token)
 295  ";
 296  $Tables["bayesian_tokens"]["options"] = "TYPE=MyISAM";
 297  
 298  $Tables["article_categories_link"]["schema"] = "
 299     article_id I(10) NOTNULL PRIMARY,
 300     category_id I(10) NOTNULL PRIMARY
 301  ";
 302  $Tables["article_categories_link"]["options"] = "TYPE=MyISAM";
 303  
 304  $Tables["custom_fields_definition"]["schema"] = "
 305     id I(10) NOTNULL AUTOINCREMENT PRIMARY,
 306     field_name C(255) NOTNULL DEFAULT '' PRIMARY,
 307     field_description TEXT NOTNULL,
 308     field_type I(2) NOTNULL DEFAULT '1',
 309     field_values TEXT NOTNULL DEFAULT '',
 310     blog_id I(10) NOTNULL DEFAULT '0',
 311     date T(14),
 312     searchable I1(1) DEFAULT 1,
 313     hidden I1(1) DEFAULT 1,
 314     INDEX blog_id (blog_id)
 315  ";
 316  $Tables["custom_fields_definition"]["options"] = "TYPE=MyISAM";
 317  
 318  $Tables["custom_fields_values"]["schema"] = "
 319     id I(10) NOTNULL AUTOINCREMENT PRIMARY,
 320     field_id I(10) NOTNULL DEFAULT '0',
 321     field_value TEXT NOTNULL,
 322     normalized_value TEXT NOTNULL,
 323     blog_id I(10) DEFAULT NULL,
 324     article_id I(10) DEFAULT NULL,
 325     FULLTEXT normalized_value (normalized_value),
 326     INDEX article_id (article_id),
 327     INDEX field_id (field_id),
 328     INDEX blog_id_article_id (blog_id, article_id)
 329  ";
 330  $Tables["custom_fields_values"]["options"] = "TYPE=MyISAM";
 331  
 332  $Tables["articles_text"]["schema"] = "
 333     id I(10) NOTNULL AUTOINCREMENT PRIMARY,
 334     article_id I(10) NOTNULL DEFAULT 0,
 335     text TEXT NOTNULL DEFAULT '',
 336     topic TEXT NOTNULL DEFAULT '',
 337     normalized_text TEXT NOTNULL DEFAULT '',
 338     normalized_topic TEXT NOTNULL DEFAULT '',
 339     mangled_topic TEXT NOTNULL,
 340     INDEX article_id (article_id),
 341     FULLTEXT normalized_text (normalized_text),
 342     FULLTEXT normalized_topic (normalized_topic),
 343     FULLTEXT normalized_fields (normalized_text, normalized_topic)
 344  ";
 345  $Tables["articles_text"]["options"] = "TYPE=MyISAM";
 346     
 347  $Tables["phpbb2_users"]["schema"] = "
 348     id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
 349     phpbb_id I(10) UNSIGNED NOTNULL,
 350     full_name C(255) NOTNULL DEFAULT '',
 351     about X,
 352     properties TEXT NOTNULL DEFAULT '',
 353     resource_picture_id I(10) NOTNULL DEFAULT 0,
 354     status I(10) NOTNULL DEFAULT 0,
 355     UNIQUE phpbb_id(phpbb_id)
 356  ";
 357  $Tables["phpbb2_users"]["options"] = "TYPE=MyISAM";
 358     
 359  $Tables["blog_categories"]["schema"] = "
 360     id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
 361     name C(255) NOTNULL DEFAULT '',
 362     description C(255) NOTNULL DEFAULT '',
 363     mangled_name C(255) NOTNULL DEFAULT '',
 364     properties TEXT NOTNULL DEFAULT '',
 365     num_blogs I(10) NOTNULL DEFAULT '0',
 366     num_active_blogs I(10) NOTNULL DEFAULT '0',
 367     INDEX mangled_name(mangled_name)
 368  ";
 369  $Tables["blog_categories"]["options"] = "TYPE=MyISAM";
 370     
 371  $Tables["global_articles_categories"]["schema"] = "
 372     id I(10) UNSIGNED NOTNULL AUTOINCREMENT PRIMARY,
 373     name C(255) NOTNULL DEFAULT '',
 374     description C(255) NOTNULL DEFAULT '',
 375     mangled_name C(255) NOTNULL DEFAULT '',
 376     properties TEXT NOTNULL DEFAULT '',
 377     num_articles I(10) NOTNULL DEFAULT '0',
 378     num_active_articles I(10) NOTNULL DEFAULT '0',
 379     INDEX mangled_name(mangled_name)
 380  ";
 381  $Tables["global_articles_categories"]["options"] = "TYPE=MyISAM";
 382  
 383  ?>