$tables = { "tables" => { "Session" => { "columns" => [ {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true}, {"name" => "idhash", "type" => "varchar"}, {"name" => "sess_data", "type" => "text"}, {"name" => "date_added", "type" => "datetime"}, {"name" => "ip", "type" => "varchar", "maxlength" => 15} ], "indexes" => [ {"name" => "date_added", "columns" => ["date_added"]}, {"name" => "idhash", "columns" => ["idhash"]} ], "renames" => ["sessions"] }, "Translation" => { "columns" => [ {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true}, {"name" => "object_class", "type" => "varchar", "maxlength" => 50}, {"name" => "object_id", "type" => "bigint"}, {"name" => "key", "type" => "varchar", "maxlength" => 50}, {"name" => "locale", "type" => "varchar", "maxlength" => 5}, {"name" => "value", "type" => "text"} ], "indexes" => [ {"name" => "lookup", "columns" => ["object_class", "object_id", "key", "locale"]} ], "indexes_remove" => { "object_class" => true }, "renames" => ["translations"] }, "Log" => { "columns" => [ {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true}, {"name" => "text_value_id", "type" => "bigint"}, {"name" => "date_saved", "type" => "datetime"}, {"name" => "get_keys_data_id", "type" => "bigint"}, {"name" => "get_values_data_id", "type" => "bigint"}, {"name" => "post_keys_data_id", "type" => "bigint"}, {"name" => "post_values_data_id", "type" => "bigint"} ], "indexes" => [ {"name" => "text_value_id", "columns" => ["text_value_id"]} ] }, "Log_access" => { "columns" => [ {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true}, {"name" => "session_id", "type" => "bigint"}, {"name" => "date_request", "type" => "datetime"}, {"name" => "ip_data_id", "type" => "bigint"}, {"name" => "get_keys_data_id", "type" => "bigint"}, {"name" => "get_values_data_id", "type" => "bigint"}, {"name" => "post_keys_data_id", "type" => "bigint"}, {"name" => "post_values_data_id", "type" => "bigint"}, {"name" => "cookie_keys_data_id", "type" => "bigint"}, {"name" => "cookie_values_data_id", "type" => "bigint"}, {"name" => "meta_keys_data_id", "type" => "bigint"}, {"name" => "meta_values_data_id", "type" => "bigint"} ], "indexes" => [ {"name" => "session_id", "columns" => ["session_id"]}, {"name" => "date_request", "columns" => ["date_request"]} ] }, "Log_data" => { "columns" => [ {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true}, {"name" => "id_hash", "type" => "varchar"} ], "indexes" => [ {"name" => "id_hash", "columns" => ["id_hash"]} ] }, "Log_data_link" => { "columns" => [ {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true}, {"name" => "no", "type" => "int"}, {"name" => "data_id", "type" => "bigint"}, {"name" => "value_id", "type" => "bigint"} ], "indexes" => [ {"name" => "data_id", "columns" => ["data_id"]}, {"name" => "value_id", "columns" => ["value_id"]} ] }, "Log_data_value" => { "columns" => [ {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true}, {"name" => "value", "type" => "text"} ] }, "Log_link" => { "columns" => [ {"name" => "id", "type" => "bigint", "autoincr" => true, "primarykey" => true}, {"name" => "log_id", "type" => "bigint"}, {"name" => "object_class_value_id", "type" => "bigint"}, {"name" => "object_id", "type" => "bigint"} ], "indexes" => [ {"name" => "log_id", "columns" => ["log_id"]}, {"name" => "object_id", "columns" => ["object_id"]}, {"name" => "object_class_value_id", "columns" => ["object_class_value_id"]}, {"name" => "object_lookup", "columns" => ["object_class_value_id", "object_id"]}, {"name" => "log_lookup", "columns" => ["object_class_value_id", "object_id", "log_id"]} ] } } }