[Summary view] [Print] [Text view]

   1  TRUNCATE TABLE {$NAMESPACE}_almanac.almanac_device;
   2  
   3  ALTER TABLE {$NAMESPACE}_almanac.almanac_device
   4    CHANGE name name VARCHAR(128) NOT NULL COLLATE utf8_bin;
   5  
   6  ALTER TABLE {$NAMESPACE}_almanac.almanac_device
   7    ADD nameIndex BINARY(12) NOT NULL;
   8  
   9  ALTER TABLE {$NAMESPACE}_almanac.almanac_device
  10    ADD mailKey BINARY(20) NOT NULL;
  11  
  12  ALTER TABLE {$NAMESPACE}_almanac.almanac_device
  13    ADD UNIQUE KEY `key_name` (nameIndex);
  14  
  15  ALTER TABLE {$NAMESPACE}_almanac.almanac_device
  16    ADD KEY `key_nametext` (name);
  17  
  18  ALTER TABLE {$NAMESPACE}_almanac.almanac_device
  19    ADD viewPolicy VARBINARY(64) NOT NULL;
  20  
  21  ALTER TABLE {$NAMESPACE}_almanac.almanac_device
  22    ADD editPolicy VARBINARY(64) NOT NULL;