[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_nuance.nuance_source
   2    DROP KEY key_type;
   3  
   4  ALTER TABLE {$NAMESPACE}_nuance.nuance_source
   5    DROP COLUMN type;
   6  
   7  ALTER TABLE {$NAMESPACE}_nuance.nuance_source
   8    ADD type VARCHAR(32) NOT NULL COLLATE utf8_bin AFTER name;
   9  
  10  ALTER TABLE {$NAMESPACE}_nuance.nuance_source
  11    ADD KEY `key_type` (type, dateModified);