-
Type:
Task
-
Status: Done (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: common 0.11
-
Fix Version/s: common 0.11
-
Labels:None
Currently there are tables with different DB Engine and charset:
show create table BRANCH; ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
show create table BRANCHES; ENGINE=MyISAM DEFAULT CHARSET=latin1
show create table BRANCH_SUBSCRIPTIONS; ENGINE=InnoDB DEFAULT CHARSET=utf8
show create table COMPONENTS; ENGINE=MyISAM DEFAULT CHARSET=latin1
show create table CONTACT_TYPE; ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8
show create table GROUPS; ENGINE=MyISAM DEFAULT CHARSET=latin1
show create table GROUP_USER_REF; ENGINE=MyISAM DEFAULT CHARSET=latin1
show create table JC_USER_DETAILS; ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
show create table POST; ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
show create table PRIVATE_MESSAGE; ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
show create table PROPERTIES; ENGINE=MyISAM DEFAULT CHARSET=latin1
show create table RANKS; ENGINE=MyISAM DEFAULT CHARSET=latin1
show create table SECTION; ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
show create table SECTIONS; ENGINE=MyISAM DEFAULT CHARSET=latin1
show create table TOPIC; ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
show create table TOPIC_SUBSCRIPTIONS; ENGINE=InnoDB DEFAULT CHARSET=utf8
show create table USERS; ENGINE=InnoDB DEFAULT CHARSET=utf8
show create table USER_CONTACT; ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
show create table acl_class; ENGINE=InnoDB DEFAULT CHARSET=utf8
show create table acl_entry; ENGINE=InnoDB DEFAULT CHARSET=utf8
show create table acl_object_identity; ENGINE=InnoDB DEFAULT CHARSET=utf8
show create table acl_sid; ENGINE=InnoDB DEFAULT CHARSET=utf8
All need to be ENGINE=InnoDB DEFAULT CHARSET=utf8
