20121226.config.sql
No OneTemporary
Actions

Size

533 B

Referenced Files

None

Subscribers

None

20121226.config.sql
View Options

	CREATE TABLE {$NAMESPACE}_config.config_entry (
	`id` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
	`phid` VARCHAR(64) NOT NULL COLLATE utf8_bin,
	`namespace` VARCHAR(64) BINARY NOT NULL COLLATE utf8_bin,
	`configKey` VARCHAR(64) BINARY NOT NULL COLLATE utf8_bin,
	`value` LONGTEXT NOT NULL,
	`isDeleted` BOOL NOT NULL,
	`dateCreated` INT UNSIGNED NOT NULL,
	`dateModified` INT UNSIGNED NOT NULL,
	UNIQUE KEY `key_phid` (`phid`),
	UNIQUE KEY `key_name` (`namespace`, `configKey`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;