test/dummy/db/development.sqlite3 in markable-0.1.0 vs test/dummy/db/development.sqlite3 in markable-0.1.1
- old
+ new
@@ -1,13 +1,11 @@
-SQLite format 3 @ # # -
- N
D
-T 3
+SQLite format 3 @ 6
6 -
4 N
D
+T 4 5Etablecitiescities
CREATE TABLE "cities" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)/AtablecarscarsCREATE 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_markmarksCREATE 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)
)20120214114957)20120214105421)20120214105411)20120214103741)20120214103734
- )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
+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
drinks
-admins users foods
B B ? 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 C ; 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
`)N
r
=
3AUserFoodfavorite2012-03-12 09:25:38.8722383AUserFoodfavorite2012-02-17 10:20:28.0220053
AUserUserfriendly2012-02-17 10:20:09.5422333AUserUserfriendly2012-02-17 10:20:02.6673806AAdminAdminfollowing2012-02-16 11:06:07.2809006
-AAdminAdminfollowing2012-02-16 11:04:55.8801285 ADrinkDrinkfavorite2012-02-16 06:43:49.4250905AAdminDrinkfavorite2012-02-16 06:37:39.4680125AAdminDrinkfavorite2012-02-15 16:22:55.7302325AAdminDrinkfavorite2012-02-15 09:33:13.2628804AAdminFoodfavorite2012-02-15 09:26:34.2194045AAdminDrinkfavorite2012-02-15 08:57:22.8960134AAdminFoodfavorite2012-02-15 08:56:55.1070353AFoodUserfavorite2012-02-14 12:35:46.5743043AUserFoodfavorite2012-02-14 12:03:47.274830
- \1Gq FoodfavoriteFoodfavoriteUserfriendly
UserfriendlyAdminfollowingAdminfollowing
-Drinkfavorite DrinkfavoriteDrinkfavoriteDrinkfavoriteFoodfavoriteDrinkfavoriteFoodfavoriteUserfavoriteFoodfavorite
- o/EZ UserfavoriteUserfavoriteUserfriendly
UserfriendlyAdminfollowingAdminfollowing
-Drinkfavorite AdminfavoriteAdminfavoriteAdminfavoriteAdminfavoriteAdminfavoriteAdminfavoriteFoodfavoriteUserfavorite
+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
=
= 5AUserFoodfavorite2012-03-12 09:25:38.8722383AUserFoodfavorite2012-02-17 10:20:28.022005 AUserUserfriendly2012-02-17 10:20:09.542233 5AUserUserfriendly2012-02-17 10:20:02.667380
8AAdminAdminfollowing2012-02-16 11:06:07.280900 8AAdminAdminfollowing2012-02-16 11:04:55.880128N 7ADrinkDrinkfavorite2012-02-16 06:43:49.425090 AAdminDrinkfavorite2012-02-16 06:37:39.468012 {AAdminDrinkfavorite2012-02-15 16:22:55.730232 DAAdminDrinkfavorite2012-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 jAFoodUserfavorite2012-02-14 12:35:46.574304 5AUserFoodfavorite2012-02-14 12:03:47.274830
+ GGGGqqqqqqqqqq FoodfavoriteFoodfavorite
Userfriendly
Userfriendly1 Adminfollowingq Adminfollowing
+\ Drinkfavorite Drinkfavorite Drinkfavorite zDrinkfavorite eFoodfavorite QDrinkfavorite <Foodfavorite (Userfavorite Foodfavorite
+ ZZZZZZZZZZZ UserfavoriteUserfavorite Userfriendly
Userfriendly/ Adminfollowingo Adminfollowing
+Z Drinkfavorite Adminfavorite Adminfavorite |Adminfavorite gAdminfavorite RAdminfavorite =Adminfavorite (Foodfavorite Userfavorite
\ No newline at end of file