test/dummy/db/development.sqlite3 in markable-0.1.2 vs test/dummy/db/development.sqlite3 in markable-0.1.3
- old
+ new
@@ -1,11 +1,11 @@
-SQLite format 3 @ 6
6 -
4 N
D
+SQLite format 3 @ ;
; -$
4 N
D
T 4 5 Etablecitiescities
CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)/ Atablecarscars CREATE TABLE "cars" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)3
omindexindex_marks_on_marker_id_and_marker_type_and_markmarks CREATE INDEX "index_marks_on_marker_id_and_marker_type_and_mark" ON "marks" ("marker_id", "marker_type", "mark")? w}indexindex_marks_on_markable_id_and_markable_type_and_markmarks
CREATE INDEX "index_marks_on_markable_id_and_markable_type_and_mark" ON "marks" ("markable_id", "markable_type", "mark")>[tablemarksmarks CREATE TABLE "marks" ("marker_id" integer, "marker_type" varchar(255), "markable_id" integer, "markable_type" varchar(255), "mark" varchar(128), "created_at" datetime)5EtabledrinksdrinksCREATE TABLE "drinks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)2CtablefoodsfoodsCREATE TABLE "foods" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)5EtableadminsadminsCREATE TABLE "admins" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)2CtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
)20120520101231)20120520101223)20120214114957)20120214105421)20120214105411)20120214103741)20120214103734
- { { )20120520101231)20120520101223)20120214114957)20120214105421)20120214105411)20120214103741)20120214103734
9 AA2012-02-17 10:19:35.8469202012-02-17 10:19:35.846920 =AAMe2012-02-14 11:57:51.5444922012-02-14 11:57:51.544492
+ { { )20120520101231)20120520101223)20120214114957)20120214105421)20120214105411)20120214103741)20120214103734
MM 9 AA2012-11-06 10:45:49.0394402012-11-06 10:45:49.0394409 AA2012-02-17 10:19:35.8469202012-02-17 10:19:35.846920 9 AA2012-11-06 10:41:33.3985542012-11-06 10:41:33.398554
drinks
-admins users foods
B BB ? AAadmin22012-02-16 06:37:32.3427212012-02-16 06:37:32.342721> AAhrome2012-02-15 13:42:29.9487822012-02-15 13:42:29.948782 =AASA2012-02-15 08:06:14.0120612012-02-15 08:06:14.012061
D D < AAPie2012-02-14 12:35:25.4978452012-02-14 12:35:25.497845< AAWok2012-02-14 12:35:20.6403692012-02-14 12:35:20.640369> AAPizza2012-02-14 11:51:41.2442432012-02-14 11:51:41.244243
C CC ; AA2012-02-17 08:29:32.7793732012-02-17 08:29:32.779373= AASoda2012-02-15 16:22:55.7195812012-02-15 16:22:55.719581= AACola2012-02-15 09:33:05.4949932012-02-15 09:33:05.494993 ?AABeer2012-02-15 08:20:02.3556672012-02-15 08:20:02.355667
=
= 5 AUserFoodfavorite2012-03-12 09:25:38.8722383 AUserFoodfavorite2012-02-17 10:20:28.022005 AUserUserfriendly2012-02-17 10:20:09.542233 5 AUserUserfriendly2012-02-17 10:20:02.667380
8 AAdminAdminfollowing2012-02-16 11:06:07.280900 8 AAdminAdminfollowing2012-02-16 11:04:55.880128N 7 ADrinkDrinkfavorite2012-02-16 06:43:49.425090 AAdminDrinkfavorite2012-02-16 06:37:39.468012 { AAdminDrinkfavorite2012-02-15 16:22:55.730232 D AAdminDrinkfavorite2012-02-15 09:33:13.262880
AAdminFoodfavorite2012-02-15 09:26:34.219404 AAdminDrinkfavorite2012-02-15 08:57:22.896013 AAdminFoodfavorite2012-02-15 08:56:55.107035 j AFoodUserfavorite2012-02-14 12:35:46.574304 5 AUserFoodfavorite2012-02-14 12:03:47.274830
- GGGGqqqqqqqqqq Foodfavorite Foodfavorite
Userfriendly
Userfriendly 1 Adminfollowing q Adminfollowing
-\ Drinkfavorite Drinkfavorite Drinkfavorite z Drinkfavorite e Foodfavorite Q Drinkfavorite < Foodfavorite ( Userfavorite Foodfavorite
- ZZZZZZZZZZZ Userfavorite Userfavorite Userfriendly
Userfriendly / Adminfollowing o Adminfollowing
-Z Drinkfavorite Adminfavorite Adminfavorite | Adminfavorite g Adminfavorite R Adminfavorite = Adminfavorite ( Foodfavorite Userfavorite
+admins users foods
B BB ? AAadmin22012-02-16 06:37:32.3427212012-02-16 06:37:32.342721> AAhrome2012-02-15 13:42:29.9487822012-02-15 13:42:29.948782 =AASA2012-02-15 08:06:14.0120612012-02-15 08:06:14.012061
D 9 AA2012-11-06 10:45:49.0690782012-11-06 10:45:49.0690789 AA2012-11-06 10:41:33.4281402012-11-06 10:41:33.428140< AAPie2012-02-14 12:35:25.4978452012-02-14 12:35:25.497845< AAWok2012-02-14 12:35:20.6403692012-02-14 12:35:20.640369> AAPizza2012-02-14 11:51:41.2442432012-02-14 11:51:41.244243
C CC ; AA2012-02-17 08:29:32.7793732012-02-17 08:29:32.779373= AASoda2012-02-15 16:22:55.7195812012-02-15 16:22:55.719581= AACola2012-02-15 09:33:05.4949932012-02-15 09:33:05.494993 ?AABeer2012-02-15 08:20:02.3556672012-02-15 08:20:02.355667
=
= 5 AUserFoodfavorite2012-03-12 09:25:38.8722383 AUserFoodfavorite2012-02-17 10:20:28.022005 AUserUserfriendly2012-02-17 10:20:09.542233 5 AUserUserfriendly2012-02-17 10:20:02.667380
8 AAdminAdminfollowing2012-02-16 11:06:07.280900 8 AAdminAdminfollowing2012-02-16 11:04:55.880128N 7 ADrinkDrinkfavorite2012-02-16 06:43:49.425090 AAdminDrinkfavorite2012-02-16 06:37:39.468012 { AAdminDrinkfavorite2012-02-15 16:22:55.730232 D AAdminDrinkfavorite2012-02-15 09:33:13.262880
AAdminFoodfavorite2012-02-15 09:26:34.219404 AAdminDrinkfavorite2012-02-15 08:57:22.896013 AAdminFoodfavorite2012-02-15 08:56:55.107035 j AFoodUserfavorite2012-02-14 12:35:46.5743043 AUserFoodfavorite2012-11-06 10:45:49.079052
+ GGGqqqqqqqqqq Foodfavorite Foodfavorite Userfriendly
Userfriendly 1 Adminfollowing q Adminfollowing
+\ Drinkfavorite Drinkfavorite Drinkfavorite z Drinkfavorite e Foodfavorite Q Drinkfavorite < Foodfavorite ( Userfavorite Foodfavorite
+ ZZZZZZZZZZZ Userfavorite Userfavorite Userfriendly
Userfriendly / Adminfollowing o Adminfollowing
+Z Drinkfavorite Adminfavorite Adminfavorite | Adminfavorite g Adminfavorite R Adminfavorite = Adminfavorite ( Foodfavorite Userfavorite
\ No newline at end of file