RMS OTA

Database sync

Tables

ATTRS - Table 'error_log'

ALTER TABLE ~error_log ENGINE = MyISAM, CHARACTER SET = utf8, COLLATE = utf8_unicode_ci
ALTER TABLE ~error_log CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci

ATTRS - Table 'properties'

ALTER TABLE ~properties ENGINE = InnoDB, CHARACTER SET = utf8, COLLATE = utf8_unicode_ci
ALTER TABLE ~properties CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci

ATTRS - Table 'categories'

ALTER TABLE ~categories ENGINE = InnoDB, CHARACTER SET = utf8, COLLATE = utf8_unicode_ci
ALTER TABLE ~categories CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci

ATTRS - Table 'rates'

ALTER TABLE ~rates ENGINE = InnoDB, CHARACTER SET = utf8, COLLATE = utf8_unicode_ci
ALTER TABLE ~rates CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci

ATTRS - Table 'rate_items'

ALTER TABLE ~rate_items ENGINE = InnoDB, CHARACTER SET = utf8, COLLATE = utf8_unicode_ci
ALTER TABLE ~rate_items CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci

ATTRS - Table 'inventories'

ALTER TABLE ~inventories ENGINE = InnoDB, CHARACTER SET = utf8, COLLATE = utf8_unicode_ci
ALTER TABLE ~inventories CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci

ATTRS - Table 'constraints'

ALTER TABLE ~constraints ENGINE = InnoDB, CHARACTER SET = utf8, COLLATE = utf8_unicode_ci
ALTER TABLE ~constraints CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci

ATTRS - Table 'channel_logs'

ALTER TABLE ~channel_logs ENGINE = InnoDB, CHARACTER SET = utf8, COLLATE = utf8_unicode_ci
ALTER TABLE ~channel_logs CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci