b2evolution PHP Cross Reference Blogging Systems

Source: /inc/collections/model/_collections.install.php - 491 lines - 22839 bytes - Text - Print

Description: This is the install file for the collections module

   1  <?php
   2  /**
   3   * This is the install file for the collections module
   4   *
   5   * @copyright (c)2003-2014 by Francois Planque - {@link http://fplanque.com/}
   6   *
   7   * @package evocore
   8   *
   9   * @version $Id: _collections.install.php 6136 2014-03-08 07:59:48Z manuel $
  10   */
  11  if( !defined('EVO_CONFIG_LOADED') ) die( 'Please, do not access this page directly.' );
  12  
  13  
  14  global $db_storage_charset;
  15  
  16  
  17  /**
  18   * The b2evo database scheme.
  19   *
  20   * This gets updated through {@link db_delta()} which generates the queries needed to get
  21   * to this scheme.
  22   *
  23   * Please see {@link db_delta()} for things to take care of.
  24   */
  25  $schema_queries = array_merge( $schema_queries, array(
  26      'T_skins__skin' => array(
  27          'Creating table for installed skins',
  28          "CREATE TABLE T_skins__skin (
  29                  skin_ID      int(10) unsigned                                  NOT NULL auto_increment,
  30                  skin_name    varchar(32)                                       NOT NULL,
  31                  skin_type    enum('normal','feed','sitemap','mobile','tablet') NOT NULL default 'normal',
  32                  skin_folder  varchar(32)                                       NOT NULL,
  33                  PRIMARY KEY skin_ID (skin_ID),
  34                  UNIQUE skin_folder( skin_folder ),
  35                  KEY skin_name( skin_name )
  36              ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
  37  
  38      'T_skins__container' => array(
  39          'Creating table for skin containers',
  40          "CREATE TABLE T_skins__container (
  41                  sco_skin_ID   int(10) unsigned      NOT NULL,
  42                  sco_name      varchar(40)           NOT NULL,
  43                  PRIMARY KEY (sco_skin_ID, sco_name)
  44              ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
  45  
  46      'T_blogs' => array(
  47          'Creating table for Blogs',
  48          "CREATE TABLE T_blogs (
  49              blog_ID              int(11) unsigned NOT NULL auto_increment,
  50              blog_shortname       varchar(255) NULL default '',
  51              blog_name            varchar(255) NOT NULL default '',
  52              blog_owner_user_ID   int(11) unsigned NOT NULL default 1,
  53              blog_advanced_perms  TINYINT(1) NOT NULL default 0,
  54              blog_tagline         varchar(250) NULL default '',
  55              blog_description     varchar(250) NULL default '',
  56              blog_longdesc        TEXT NULL DEFAULT NULL,
  57              blog_locale          VARCHAR(20) NOT NULL DEFAULT 'en-EU',
  58              blog_access_type     VARCHAR(10) NOT NULL DEFAULT 'extrapath',
  59              blog_siteurl         varchar(120) NOT NULL default '',
  60              blog_urlname         VARCHAR(255) NOT NULL DEFAULT 'urlname',
  61              blog_notes           TEXT NULL,
  62              blog_keywords        tinytext,
  63              blog_allowtrackbacks TINYINT(1) NOT NULL default 0,
  64              blog_allowblogcss    TINYINT(1) NOT NULL default 1,
  65              blog_allowusercss    TINYINT(1) NOT NULL default 1,
  66              blog_in_bloglist     TINYINT(1) NOT NULL DEFAULT 1,
  67              blog_links_blog_ID   INT(11) NULL DEFAULT NULL,
  68              blog_media_location  ENUM( 'default', 'subdir', 'custom', 'none' ) DEFAULT 'default' NOT NULL,
  69              blog_media_subdir    VARCHAR( 255 ) NULL,
  70              blog_media_fullpath  VARCHAR( 255 ) NULL,
  71              blog_media_url       VARCHAR( 255 ) NULL,
  72              blog_UID             VARCHAR(20),
  73              blog_type            ENUM( 'std', 'photo', 'group', 'forum', 'manual' ) DEFAULT 'std' NOT NULL,
  74              PRIMARY KEY blog_ID (blog_ID),
  75              UNIQUE KEY blog_urlname (blog_urlname)
  76          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
  77  
  78      'T_coll_settings' => array(
  79          'Creating collection settings table',
  80          "CREATE TABLE T_coll_settings (
  81              cset_coll_ID INT(11) UNSIGNED NOT NULL,
  82              cset_name    VARCHAR( 50 ) NOT NULL,
  83              cset_value   VARCHAR( 10000 ) NULL COMMENT 'The AdSense plugin wants to store very long snippets of HTML',
  84              PRIMARY KEY ( cset_coll_ID, cset_name )
  85          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
  86  
  87      'T_widget' => array(
  88          'Creating components table',
  89          "CREATE TABLE T_widget (
  90              wi_ID                    INT(10) UNSIGNED auto_increment,
  91              wi_coll_ID    INT(11) UNSIGNED NOT NULL,
  92              wi_sco_name   VARCHAR( 40 ) NOT NULL,
  93              wi_order      INT(10) NOT NULL,
  94              wi_enabled    TINYINT(1) NOT NULL DEFAULT 1,
  95              wi_type       ENUM( 'core', 'plugin' ) NOT NULL DEFAULT 'core',
  96              wi_code       VARCHAR(32) NOT NULL,
  97              wi_params     TEXT NULL,
  98              PRIMARY KEY ( wi_ID ),
  99              UNIQUE wi_order( wi_coll_ID, wi_sco_name, wi_order )
 100          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 101  
 102      'T_categories' => array(
 103          'Creating table for Categories',
 104          "CREATE TABLE T_categories (
 105              cat_ID          int(10) unsigned NOT NULL auto_increment,
 106              cat_parent_ID   int(10) unsigned NULL,
 107              cat_name        varchar(255) NOT NULL,
 108              cat_urlname     varchar(255) NOT NULL COLLATE ascii_bin,
 109              cat_blog_ID     int(10) unsigned NOT NULL default 2,
 110              cat_description varchar(255) NULL DEFAULT NULL,
 111              cat_order       int(11) NULL DEFAULT NULL,
 112              cat_meta        tinyint(1) NOT NULL DEFAULT 0,
 113              cat_lock        tinyint(1) NOT NULL DEFAULT 0,
 114              PRIMARY KEY cat_ID (cat_ID),
 115              UNIQUE cat_urlname( cat_urlname ),
 116              KEY cat_blog_ID (cat_blog_ID),
 117              KEY cat_parent_ID (cat_parent_ID),
 118              KEY cat_order (cat_order)
 119          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 120  
 121      'T_items__item' => array(
 122          'Creating table for Posts',
 123          "CREATE TABLE T_items__item (
 124              post_ID                     int(11) unsigned NOT NULL auto_increment,
 125              post_parent_ID              int(11) unsigned NULL,
 126              post_creator_user_ID        int(11) unsigned NOT NULL,
 127              post_lastedit_user_ID       int(11) unsigned NULL,
 128              post_assigned_user_ID       int(11) unsigned NULL,
 129              post_dateset                tinyint(1) NOT NULL DEFAULT 1,
 130              post_datestart              DATETIME NOT NULL DEFAULT '2000-01-01 00:00:00',
 131              post_datedeadline           datetime NULL,
 132              post_datecreated            TIMESTAMP NOT NULL DEFAULT '2000-01-01 00:00:00',
 133              post_datemodified           TIMESTAMP NOT NULL DEFAULT '2000-01-01 00:00:00',
 134              post_last_touched_ts        TIMESTAMP NOT NULL DEFAULT '2000-01-01 00:00:00',
 135              post_status                 enum('published','community','deprecated','protected','private','review','draft','redirected') NOT NULL default 'published',
 136              post_pst_ID                 int(11) unsigned NULL,
 137              post_ptyp_ID                int(10) unsigned NOT NULL DEFAULT 1,
 138              post_locale                 VARCHAR(20) NOT NULL DEFAULT 'en-EU',
 139              post_content                MEDIUMTEXT NULL,
 140              post_excerpt                text NULL,
 141              post_excerpt_autogenerated  TINYINT(1) NULL DEFAULT NULL,
 142              post_title                  text NOT NULL,
 143              post_urltitle               VARCHAR(210) NOT NULL COLLATE ascii_bin,
 144              post_canonical_slug_ID      int(10) unsigned NULL DEFAULT NULL,
 145              post_tiny_slug_ID           int(10) unsigned NULL DEFAULT NULL,
 146              post_titletag               VARCHAR(255) NULL DEFAULT NULL,
 147              post_url                    VARCHAR(255) NULL DEFAULT NULL,
 148              post_main_cat_ID            int(11) unsigned NOT NULL,
 149              post_notifications_status   ENUM('noreq','todo','started','finished') NOT NULL DEFAULT 'noreq',
 150              post_notifications_ctsk_ID  INT(10) unsigned NULL DEFAULT NULL,
 151              post_views                  INT(11) UNSIGNED NOT NULL DEFAULT 0,
 152              post_wordcount              int(11) default NULL,
 153              post_comment_status         ENUM('disabled', 'open', 'closed') NOT NULL DEFAULT 'open',
 154              post_renderers              TEXT NOT NULL,
 155              post_priority               int(11) unsigned null COMMENT 'Task priority in workflow',
 156              post_featured               tinyint(1) NOT NULL DEFAULT 0,
 157              post_order                  DOUBLE NULL,
 158              post_ctry_ID                INT(10) UNSIGNED NULL,
 159              post_rgn_ID                 INT(10) UNSIGNED NULL,
 160              post_subrg_ID               INT(10) UNSIGNED NULL,
 161              post_city_ID                INT(10) UNSIGNED NULL,
 162              PRIMARY KEY post_ID( post_ID ),
 163              UNIQUE post_urltitle( post_urltitle ),
 164              INDEX post_datestart( post_datestart ),
 165              INDEX post_main_cat_ID( post_main_cat_ID ),
 166              INDEX post_creator_user_ID( post_creator_user_ID ),
 167              INDEX post_status( post_status ),
 168              INDEX post_parent_ID( post_parent_ID ),
 169              INDEX post_assigned_user_ID( post_assigned_user_ID ),
 170              INDEX post_ptyp_ID( post_ptyp_ID ),
 171              INDEX post_pst_ID( post_pst_ID ),
 172              INDEX post_order( post_order )
 173          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 174  
 175      'T_postcats' => array(
 176          'Creating table for Categories-to-Posts relationships',
 177          "CREATE TABLE T_postcats (
 178              postcat_post_ID int(11) unsigned NOT NULL,
 179              postcat_cat_ID int(11) unsigned NOT NULL,
 180              PRIMARY KEY postcat_pk (postcat_post_ID,postcat_cat_ID),
 181              UNIQUE catpost ( postcat_cat_ID, postcat_post_ID )
 182          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 183  
 184      'T_comments' => array(    // Note: pingbacks no longer supported, but previous pingbacks are to be preserved in the DB
 185          'Creating table for Comments',
 186          "CREATE TABLE T_comments (
 187              comment_ID                 int(11) unsigned NOT NULL auto_increment,
 188              comment_post_ID            int(11) unsigned NOT NULL default '0',
 189              comment_type               enum('comment','linkback','trackback','pingback') NOT NULL default 'comment',
 190              comment_status             ENUM('published','community','deprecated','protected','private','review','draft','trash') DEFAULT 'published' NOT NULL,
 191              comment_in_reply_to_cmt_ID INT(10) unsigned NULL,
 192              comment_author_ID          int unsigned NULL default NULL,
 193              comment_author             varchar(100) NULL,
 194              comment_author_email       varchar(255) NULL,
 195              comment_author_url         varchar(255) NULL,
 196              comment_author_IP          varchar(23) NOT NULL default '',
 197              comment_IP_ctry_ID         int(10) unsigned NULL,
 198              comment_date               datetime NOT NULL DEFAULT '2000-01-01 00:00:00',
 199              comment_content            text NOT NULL,
 200              comment_renderers          TEXT NOT NULL,
 201              comment_rating             TINYINT(1) NULL DEFAULT NULL,
 202              comment_featured           TINYINT(1) NOT NULL DEFAULT 0,
 203              comment_nofollow           TINYINT(1) NOT NULL DEFAULT 1,
 204              comment_helpful_addvotes   INT NOT NULL default 0,
 205              comment_helpful_countvotes INT unsigned NOT NULL default 0,
 206              comment_spam_addvotes      INT NOT NULL default 0,
 207              comment_spam_countvotes    INT unsigned NOT NULL default 0,
 208              comment_karma              INT(11) NOT NULL DEFAULT 0,
 209              comment_spam_karma         TINYINT NULL,
 210              comment_allow_msgform      TINYINT NOT NULL DEFAULT 0,
 211              comment_secret             varchar(32) NULL default NULL,
 212              comment_notif_status       ENUM('noreq','todo','started','finished') NOT NULL DEFAULT 'noreq' COMMENT 'Have notifications been sent for this comment? How far are we in the process?',
 213              comment_notif_ctsk_ID      INT(10) unsigned NULL DEFAULT NULL COMMENT 'When notifications for this comment are sent through a scheduled job, what is the job ID?',
 214              PRIMARY KEY comment_ID (comment_ID),
 215              KEY comment_post_ID (comment_post_ID),
 216              KEY comment_date (comment_date),
 217              KEY comment_type (comment_type),
 218              KEY comment_status(comment_status)
 219          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 220  
 221      'T_comments__votes' => array(
 222          'Creating table for Comments Votes',
 223          "CREATE TABLE T_comments__votes (
 224              cmvt_cmt_ID  int(10) unsigned NOT NULL,
 225              cmvt_user_ID int(10) unsigned NOT NULL,
 226              cmvt_helpful TINYINT(1) NULL DEFAULT NULL,
 227              cmvt_spam    TINYINT(1) NULL DEFAULT NULL,
 228              PRIMARY KEY (cmvt_cmt_ID, cmvt_user_ID),
 229              KEY cmvt_cmt_ID (cmvt_cmt_ID),
 230              KEY cmvt_user_ID (cmvt_user_ID)
 231          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 232  
 233      'T_items__prerendering' => array(
 234          'Creating item prerendering cache table',
 235          "CREATE TABLE T_items__prerendering(
 236              itpr_itm_ID                   INT(11) UNSIGNED NOT NULL,
 237              itpr_format                   ENUM('htmlbody','entityencoded','xml','text') NOT NULL,
 238              itpr_renderers                TEXT NOT NULL,
 239              itpr_content_prerendered      MEDIUMTEXT NULL,
 240              itpr_datemodified             TIMESTAMP NOT NULL,
 241              PRIMARY KEY (itpr_itm_ID, itpr_format)
 242          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 243  
 244      'T_comments__prerendering' => array(
 245          'Creating comment prerendering cache table',
 246          "CREATE TABLE T_comments__prerendering(
 247              cmpr_cmt_ID                   INT(11) UNSIGNED NOT NULL,
 248              cmpr_format                   ENUM('htmlbody','entityencoded','xml','text') NOT NULL,
 249              cmpr_renderers                TEXT NOT NULL,
 250              cmpr_content_prerendered      MEDIUMTEXT NULL,
 251              cmpr_datemodified             TIMESTAMP NOT NULL,
 252              PRIMARY KEY (cmpr_cmt_ID, cmpr_format)
 253          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 254  
 255      'T_items__version' => array(    // fp> made iver_edit_user_ID NULL because of INSERT INTO SELECT statement that can try to write NULL
 256          'Creating item versions table',
 257          "CREATE TABLE T_items__version (
 258              iver_ID            INT UNSIGNED NOT NULL,
 259              iver_itm_ID        INT UNSIGNED NOT NULL ,
 260              iver_edit_user_ID  INT UNSIGNED NULL ,
 261              iver_edit_datetime DATETIME NOT NULL ,
 262              iver_status        ENUM('published','community','deprecated','protected','private','review','draft','redirected') NULL ,
 263              iver_title         TEXT NULL ,
 264              iver_content       MEDIUMTEXT NULL ,
 265              INDEX iver_ID_itm_ID ( iver_ID , iver_itm_ID )
 266          ) ENGINE = innodb ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 267  
 268      'T_items__status' => array(
 269          'Creating table for Post Statuses',
 270          "CREATE TABLE T_items__status (
 271              pst_ID   int(11) unsigned not null AUTO_INCREMENT,
 272              pst_name varchar(30)      not null,
 273              primary key ( pst_ID )
 274          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 275  
 276      'T_items__type' => array(
 277          'Creating table for Post Types',
 278          "CREATE TABLE T_items__type (
 279              ptyp_ID   int(11) unsigned not null auto_increment,
 280              ptyp_name varchar(30)      not null,
 281              primary key (ptyp_ID)
 282          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 283  
 284      'T_items__tag' => array(
 285          'Creating table for Tags',
 286          "CREATE TABLE T_items__tag (
 287              tag_ID   int(11) unsigned not null AUTO_INCREMENT,
 288              tag_name varbinary(50) not null,
 289              primary key (tag_ID),
 290              UNIQUE tag_name( tag_name )
 291          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 292  
 293      'T_items__itemtag' => array(
 294          'Creating table for Post-to-Tag relationships',
 295          "CREATE TABLE T_items__itemtag (
 296              itag_itm_ID int(11) unsigned NOT NULL,
 297              itag_tag_ID int(11) unsigned NOT NULL,
 298              PRIMARY KEY (itag_itm_ID, itag_tag_ID),
 299              UNIQUE tagitem ( itag_tag_ID, itag_itm_ID )
 300          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 301  
 302      'T_items__subscriptions' => array(
 303          'Creating table for subscriptions to individual blog posts',
 304          "CREATE TABLE T_items__subscriptions (
 305              isub_item_ID    int(11) unsigned NOT NULL,
 306              isub_user_ID    int(11) unsigned NOT NULL,
 307              isub_comments   tinyint(1) NOT NULL DEFAULT 0 COMMENT 'The user wants to receive notifications for new comments on this post',
 308              PRIMARY KEY (isub_item_ID, isub_user_ID)
 309          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 310  
 311      'T_items__item_settings' => array(
 312          'Creating item settings table',
 313          "CREATE TABLE T_items__item_settings (
 314              iset_item_ID  int(10) unsigned NOT NULL,
 315              iset_name     varchar( 50 ) NOT NULL,
 316              iset_value    varchar( 2000 ) NULL,
 317              PRIMARY KEY ( iset_item_ID, iset_name )
 318          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 319  
 320      'T_subscriptions' => array(
 321          'Creating table for subscriptions',
 322          "CREATE TABLE T_subscriptions (
 323              sub_coll_ID     int(11) unsigned    not null,
 324              sub_user_ID     int(11) unsigned    not null,
 325              sub_items       tinyint(1)          not null,
 326              sub_comments    tinyint(1)          not null,
 327              primary key (sub_coll_ID, sub_user_ID)
 328          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 329  
 330      // Important if you change the perm_poststatuses or perm_cmtstatuses set content or order you must change the get_statuse_permvalue() content respectively
 331      'T_coll_user_perms' => array(
 332          'Creating table for Blog-User permissions',
 333          "CREATE TABLE T_coll_user_perms (
 334              bloguser_blog_ID              int(11) unsigned NOT NULL default 0,
 335              bloguser_user_ID              int(11) unsigned NOT NULL default 0,
 336              bloguser_ismember             tinyint NOT NULL default 0,
 337              bloguser_perm_poststatuses    set('review','draft','private','protected','deprecated','community','published','redirected') NOT NULL default '',
 338              bloguser_perm_edit            ENUM('no','own','lt','le','all','redirected') NOT NULL default 'no',
 339              bloguser_perm_delpost         tinyint NOT NULL default 0,
 340              bloguser_perm_edit_ts         tinyint NOT NULL default 0,
 341              bloguser_perm_delcmts         tinyint NOT NULL default 0,
 342              bloguser_perm_recycle_owncmts tinyint NOT NULL default 0,
 343              bloguser_perm_vote_spam_cmts  tinyint NOT NULL default 0,
 344              bloguser_perm_cmtstatuses     set('review','draft','private','protected','deprecated','community','published') NOT NULL default '',
 345              bloguser_perm_edit_cmt        ENUM('no','own','anon','lt','le','all') NOT NULL default 'no',
 346              bloguser_perm_cats            tinyint NOT NULL default 0,
 347              bloguser_perm_properties      tinyint NOT NULL default 0,
 348              bloguser_perm_admin           tinyint NOT NULL default 0,
 349              bloguser_perm_media_upload    tinyint NOT NULL default 0,
 350              bloguser_perm_media_browse    tinyint NOT NULL default 0,
 351              bloguser_perm_media_change    tinyint NOT NULL default 0,
 352              bloguser_perm_page            tinyint NOT NULL default 0,
 353              bloguser_perm_intro           tinyint NOT NULL default 0,
 354              bloguser_perm_podcast         tinyint NOT NULL default 0,
 355              bloguser_perm_sidebar         tinyint NOT NULL default 0,
 356              PRIMARY KEY bloguser_pk (bloguser_blog_ID,bloguser_user_ID)
 357          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 358  
 359      // Important if you change the perm_poststatuses or perm_cmtstatuses set content or order you must change the get_status_permvalue() content respectively
 360      'T_coll_group_perms' => array(
 361          'Creating table for blog-group permissions',
 362          "CREATE TABLE T_coll_group_perms (
 363              bloggroup_blog_ID              int(11) unsigned NOT NULL default 0,
 364              bloggroup_group_ID             int(11) unsigned NOT NULL default 0,
 365              bloggroup_ismember             tinyint NOT NULL default 0,
 366              bloggroup_perm_poststatuses    set('review','draft','private','protected','deprecated','community','published','redirected') NOT NULL default '',
 367              bloggroup_perm_edit            ENUM('no','own','lt','le','all','redirected') NOT NULL default 'no',
 368              bloggroup_perm_delpost         tinyint NOT NULL default 0,
 369              bloggroup_perm_edit_ts         tinyint NOT NULL default 0,
 370              bloggroup_perm_delcmts         tinyint NOT NULL default 0,
 371              bloggroup_perm_recycle_owncmts tinyint NOT NULL default 0,
 372              bloggroup_perm_vote_spam_cmts  tinyint NOT NULL default 0,
 373              bloggroup_perm_cmtstatuses     set('review','draft','private','protected','deprecated','community','published') NOT NULL default '',
 374              bloggroup_perm_edit_cmt        ENUM('no','own','anon','lt','le','all') NOT NULL default 'no',
 375              bloggroup_perm_cats            tinyint NOT NULL default 0,
 376              bloggroup_perm_properties      tinyint NOT NULL default 0,
 377              bloggroup_perm_admin           tinyint NOT NULL default 0,
 378              bloggroup_perm_media_upload    tinyint NOT NULL default 0,
 379              bloggroup_perm_media_browse    tinyint NOT NULL default 0,
 380              bloggroup_perm_media_change    tinyint NOT NULL default 0,
 381              bloggroup_perm_page            tinyint NOT NULL default 0,
 382              bloggroup_perm_intro           tinyint NOT NULL default 0,
 383              bloggroup_perm_podcast         tinyint NOT NULL default 0,
 384              bloggroup_perm_sidebar         tinyint NOT NULL default 0,
 385              PRIMARY KEY bloggroup_pk (bloggroup_blog_ID,bloggroup_group_ID)
 386          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 387  
 388      'T_links' => array(
 389          'Creating table for Post Links',
 390          "CREATE TABLE T_links (
 391              link_ID               int(11) unsigned  not null AUTO_INCREMENT,
 392              link_datecreated      datetime          not null DEFAULT '2000-01-01 00:00:00',
 393              link_datemodified     datetime          not null DEFAULT '2000-01-01 00:00:00',
 394              link_creator_user_ID  int(11) unsigned  NULL,
 395              link_lastedit_user_ID int(11) unsigned  NULL,
 396              link_itm_ID           int(11) unsigned  NULL,
 397              link_cmt_ID           int(11) unsigned  NULL COMMENT 'Used for linking files to comments (comment attachments)',
 398              link_usr_ID           int(11) unsigned  NULL COMMENT 'Used for linking files to users (user profile picture)',
 399              link_dest_itm_ID      int(11) unsigned  NULL,
 400              link_file_ID          int(11) unsigned  NULL,
 401              link_ltype_ID         int(11) unsigned  NOT NULL default 1,
 402              link_external_url     VARCHAR(255)      NULL,
 403              link_title            TEXT              NULL,
 404              link_position         varchar(10)       NOT NULL,
 405              link_order            int(11) unsigned  NOT NULL,
 406              PRIMARY KEY (link_ID),
 407              UNIQUE link_itm_ID_order (link_itm_ID, link_order),
 408              INDEX link_itm_ID( link_itm_ID ),
 409              INDEX link_cmt_ID( link_cmt_ID ),
 410              INDEX link_usr_ID( link_usr_ID ),
 411              INDEX link_dest_itm_ID (link_dest_itm_ID),
 412              INDEX link_file_ID (link_file_ID)
 413          ) ENGINE = innodb DEFAULT CHARSET = $db_storage_charset" ),
 414  ) );
 415  
 416  /*
 417   * _collections.install.php,v
 418   * Revision 1.46  2011/10/23 09:19:42  efy-yurybakh
 419   * Implement new permission for comment editing
 420   *
 421   * Revision 1.45  2011/09/27 13:30:14  efy-yurybakh
 422   * spam vote checkbox
 423   *
 424   * Revision 1.44  2011/09/25 07:06:21  efy-yurybakh
 425   * Implement new permission for spam voting
 426   *
 427   * Revision 1.43  2011/09/23 14:01:58  fplanque
 428   * Quick/temporary fixes so we can work in the meantime
 429   *
 430   * Revision 1.42  2011/09/22 05:03:11  efy-yurybakh
 431   * 4 new fileds in the table T_comments
 432   *
 433   * Revision 1.41  2011/09/22 03:20:54  fplanque
 434   * minor
 435   *
 436   * Revision 1.40  2011/09/21 13:01:09  efy-yurybakh
 437   * feature "Was this comment helpful?"
 438   *
 439   * Revision 1.39  2011/09/19 23:23:43  fplanque
 440   * Db fixes
 441   *
 442   * Revision 1.38  2011/09/17 22:16:05  fplanque
 443   * cleanup
 444   *
 445   * Revision 1.37  2011/09/10 00:57:23  fplanque
 446   * doc
 447   *
 448   * Revision 1.36  2011/09/08 17:58:08  lxndral
 449   * Comments task fix (table sql fix)
 450   *
 451   * Revision 1.35  2011/09/08 05:22:40  efy-asimo
 452   * Remove item attending and add item settings
 453   *
 454   * Revision 1.34  2011/09/04 22:13:14  fplanque
 455   * copyright 2011
 456   *
 457   * Revision 1.33  2011/09/04 21:32:16  fplanque
 458   * minor MFB 4-1
 459   *
 460   * Revision 1.32  2011/08/25 07:31:14  efy-asimo
 461   * DB documentation
 462   *
 463   * Revision 1.31  2011/08/25 02:54:12  efy-james
 464   * Add checkbox for no teaser
 465   *
 466   * Revision 1.30  2011/08/25 01:02:10  fplanque
 467   * doc/minor
 468   *
 469   * Revision 1.24  2011/03/03 12:47:29  efy-asimo
 470   * comments attachments
 471   *
 472   * Revision 1.23  2011/03/02 09:45:59  efy-asimo
 473   * Update collection features allow_comments, disable_comments_bypost, allow_attachments, allow_rating
 474   *
 475   * Revision 1.22  2011/02/14 14:13:24  efy-asimo
 476   * Comments trash status
 477   *
 478   * Revision 1.21  2011/02/10 23:07:21  fplanque
 479   * minor/doc
 480   *
 481   * Revision 1.17.2.6  2010/10/19 01:04:48  fplanque
 482   * doc
 483   *
 484   * Revision 1.3  2009/08/30 12:31:44  tblue246
 485   * Fixed CVS keywords
 486   *
 487   * Revision 1.1  2009/08/30 00:34:15  fplanque
 488   * increased modularity
 489   *
 490   */
 491  ?>

title

Description

title

Description

title

Description

title

title

Body