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

     1  /* community edition */
     2  DROP TABLE IF EXISTS `link`;
     3  
     4  CREATE TABLE IF NOT EXISTS `link` (
     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  	`folderid` CHAR(16) NOT NULL COLLATE utf8_bin,
     9  	`userid` CHAR(16) NOT NULL COLLATE utf8_bin,
    10  	`sourcedocumentid` CHAR(16) NOT NULL COLLATE utf8_bin,
    11  	`sourcepageid` CHAR(16) NOT NULL COLLATE utf8_bin,
    12  	`linktype` CHAR(16) NOT NULL COLLATE utf8_bin,
    13  	`targetdocumentid` CHAR(16) NOT NULL COLLATE utf8_bin,
    14  	`targetid` CHAR(16) NOT NULL DEFAULT '' COLLATE utf8_bin,
    15  	`orphan` BOOL NOT NULL DEFAULT 0,
    16  	`created` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    17  	`revised` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    18  	CONSTRAINT pk_id PRIMARY KEY (id))
    19  DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci
    20  ENGINE =  InnoDB;