CUAUjV6c

1CREATE TABLE IF NOT EXISTS `Entity` (
2    `Id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
3    `Title` VARCHAR(255) NOT NULL,
4    `Keywords` VARCHAR(255),
5    `Path` VARCHAR(255) NOT NULL,
6    `Description` VARCHAR(5000),
7    `Timestamp` TIMESTAMP DEFAULT CURRENT_TIMESTAMP(),
8    `Parent` INT UNSIGNED DEFAULT 0,
9    PRIMARY KEY (Id)
10) CHARACTER SET utf8 COLLATE utf8_general_ci ENGINE=InnoDB;
11
12CREATE INDEX EntityKeywords ON Entity(Keywords) USING BTREE;
13CREATE UNIQUE INDEX EntityPath ON Entity(Path) USING BTREE;