Analytics/Reportcard/2.0/Database design

=Database design Report Card 2.0= The current database design consists of 10 tables. Most of these tables have the same structure

Suggested Table Design
Summary of changes:


 * Merge different tables in one single table
 * change CHARSET to UTF8
 * change column type date to timestamp
 * set engine to Innodb instead of MyISAM.
 * add view column which is of type ENUM
 * change size of extension field to 4
 * change size of language_code field to 4
 * change bigint to bigint unsigned as 'value' will always be 0 or large
 * rename binaries to value
 * remove DEFAULT to enforce valid data inserted.
 * rename table name to aggregated_data

Background Links

 * http://backchannel.org/blog/friendfeed-schemaless-mysql