[Summary view] [Print] [Text view]

   1  CREATE TABLE {$NAMESPACE}_almanac.almanac_device (
   2    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
   3    phid VARBINARY(64) NOT NULL,
   4    name VARCHAR(255) NOT NULL COLLATE utf8_bin,
   5    dateCreated INT UNSIGNED NOT NULL,
   6    dateModified INT UNSIGNED NOT NULL,
   7    UNIQUE KEY `key_phid` (phid)
   8  ) ENGINE=InnoDB, COLLATE utf8_bin;
   9  
  10  CREATE TABLE {$NAMESPACE}_almanac.almanac_deviceproperty (
  11    id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
  12    devicePHID VARBINARY(64) NOT NULL,
  13    `key` VARCHAR(128) NOT NULL COLLATE utf8_bin,
  14    value LONGTEXT NOT NULL,
  15    dateCreated INT UNSIGNED NOT NULL,
  16    dateModified INT UNSIGNED NOT NULL,
  17    KEY `key_device` (devicePHID, `key`)
  18  ) ENGINE=InnoDB, COLLATE utf8_bin;