github.com/jancarloviray/community@v0.41.1-0.20170124221257-33a66c87cf2f/core/database/scripts/autobuild/db_00009.sql (about)

     1  /* community edition */
     2  DROP TABLE IF EXISTS `block`;
     3  
     4  CREATE TABLE IF NOT EXISTS `block` (
     5  	`id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
     6  	`refid` CHAR(16) NOT NULL COLLATE utf8_bin,
     7  	`orgid` CHAR(16) NOT NULL COLLATE utf8_bin,
     8  	`labelid` CHAR(16) DEFAULT '' COLLATE utf8_bin,
     9  	`userid` CHAR(16) DEFAULT '' COLLATE utf8_bin,
    10  	`contenttype` CHAR(20) NOT NULL DEFAULT 'wysiwyg',
    11  	`pagetype` CHAR(10) NOT NULL DEFAULT 'section',
    12  	`title` NVARCHAR(2000) NOT NULL,
    13  	`body` LONGTEXT,
    14  	`excerpt` NVARCHAR(2000) NOT NULL,
    15  	`used` INT UNSIGNED NOT NULL,
    16  	`rawbody` LONGBLOB,
    17  	`config` JSON,
    18      `externalsource` BOOL DEFAULT 0,
    19  	`created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    20  	`revised` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    21  	CONSTRAINT pk_id PRIMARY KEY (id),
    22  	INDEX `idx_block_refid` (`refid` ASC),
    23  	INDEX `idx_block_labelid` (`labelid` ASC))
    24  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
    25  ENGINE =  InnoDB;
    26  
    27  ALTER TABLE page ADD COLUMN `blockid` CHAR(16) NOT NULL DEFAULT '' COLLATE utf8_bin AFTER `pagetype`;
    28  /* Note: version history table does not need blockid field as they are populated once during page creation:
    29    - you cannot mark an existing section as a preset
    30    - a page is only marked as preset during it's creation (e.g. created from an existing preset)
    31   */