[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_config.config_entry (
   2    `id` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT,
   3    `phid` VARCHAR(64) NOT NULL COLLATE utf8_bin,
   4    `namespace` VARCHAR(64) BINARY NOT NULL COLLATE utf8_bin,
   5    `configKey` VARCHAR(64) BINARY NOT NULL COLLATE utf8_bin,
   6    `value` LONGTEXT NOT NULL,
   7    `isDeleted` BOOL NOT NULL,
   8    `dateCreated` INT UNSIGNED NOT NULL,
   9    `dateModified` INT UNSIGNED NOT NULL,
  10    UNIQUE KEY `key_phid` (`phid`),
  11    UNIQUE KEY `key_name` (`namespace`, `configKey`)
  12  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;