1+ CREATE TABLE `channels ` (
2+ ` id` varchar (255 ) COLLATE utf8_unicode_ci NOT NULL ,
3+ ` name` varchar (255 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
4+ ` created_at` datetime DEFAULT NULL ,
5+ ` updated_at` datetime DEFAULT NULL ,
6+ PRIMARY KEY (` id` )
7+ ) ENGINE= InnoDB DEFAULT CHARSET= utf8 COLLATE= utf8_unicode_ci;
8+
9+ CREATE TABLE `messages ` (
10+ ` id` varchar (255 ) COLLATE utf8_unicode_ci NOT NULL ,
11+ ` body` text COLLATE utf8_unicode_ci,
12+ ` created_at` datetime DEFAULT NULL ,
13+ ` updated_at` datetime DEFAULT NULL ,
14+ ` channel_id` varchar (255 ) COLLATE utf8_unicode_ci NOT NULL ,
15+ ` name` varchar (255 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
16+ PRIMARY KEY (` id` )
17+ ) ENGINE= InnoDB DEFAULT CHARSET= utf8 COLLATE= utf8_unicode_ci;
18+
19+ CREATE TABLE `schema_migrations ` (
20+ ` version` varchar (255 ) COLLATE utf8_unicode_ci NOT NULL ,
21+ UNIQUE KEY ` unique_schema_migrations` (` version` )
22+ ) ENGINE= InnoDB DEFAULT CHARSET= utf8 COLLATE= utf8_unicode_ci;
23+
24+ CREATE TABLE `sessions ` (
25+ ` id` int (11 ) NOT NULL AUTO_INCREMENT,
26+ ` session_id` varchar (255 ) COLLATE utf8_unicode_ci NOT NULL ,
27+ ` data` text COLLATE utf8_unicode_ci,
28+ ` created_at` datetime DEFAULT NULL ,
29+ ` updated_at` datetime DEFAULT NULL ,
30+ PRIMARY KEY (` id` ),
31+ KEY ` index_sessions_on_session_id` (` session_id` ),
32+ KEY ` index_sessions_on_updated_at` (` updated_at` )
33+ ) ENGINE= InnoDB AUTO_INCREMENT= 23 DEFAULT CHARSET= utf8 COLLATE= utf8_unicode_ci;
34+
35+ INSERT INTO schema_migrations (version) VALUES (' 20110324001706' );
36+
37+ INSERT INTO schema_migrations (version) VALUES (' 20110324051348' );
38+
39+ INSERT INTO schema_migrations (version) VALUES (' 20110325083934' );
40+
41+ INSERT INTO schema_migrations (version) VALUES (' 20110325211741' );
42+
43+ INSERT INTO schema_migrations (version) VALUES (' 20110326065302' );
44+
45+ INSERT INTO schema_migrations (version) VALUES (' 20110326213742' );
0 commit comments