db optimisation

[GoogleCodeExporter]

What steps will reproduce the problem?

There is no comments in table or table column. Because of this developer could 
not understand why this column in used or where the column is used. This could 
be solved. (Minor problem)

There is no key constraint or relation among the table. Like in user table user 
id must be related to those table's user id where it is used. For this many 
demo data has been inserted. This could be solved. (major problem)

Different type of table constraints are used, LIke some user creat table by 
MyISAM some create InnoDB. We should use similar type of table type. Could be 
solved. (Major problem)

Original issue reported on code.google.com by cih...@gmail.com on 28 Sep 2013 at 8:08

[GoogleCodeExporter]

comments on table and table column is completed

Original comment by bdsa...@gmail.com on 30 Sep 2013 at 6:01

[GoogleCodeExporter]

type conversion of table is completed

Original comment by bdsa...@gmail.com on 30 Sep 2013 at 6:01

[GoogleCodeExporter]

only making relation of constraint remains

Original comment by bdsa...@gmail.com on 30 Sep 2013 at 6:02

[GoogleCodeExporter]

Database foreign key constraints completed

Original comment by bdsa...@gmail.com on 1 Oct 2013 at 6:27

[GoogleCodeExporter]

All the issues assigned to me are completed

Original comment by bdsa...@gmail.com on 1 Oct 2013 at 6:27

[GoogleCodeExporter]

Original comment by cih...@gmail.com on 3 Nov 2013 at 11:07

• Changed state: Verified