test/database.sqlite3 in classy-inheritance-0.6.4 vs test/database.sqlite3 in classy-inheritance-0.7.0
- old
+ new
@@ -1,6 +1,9 @@
-SQLite format 3 @ ß ç ô úôî …O ‹w ‹t
¸ ¸ F -33joebloggsjoe@bloggs.co.uk2009-02-06 19:26:202009-02-06 19:26:20
° õçÙ̽° offices
addresses artists profiles contents pages
Ž Ž àÃ~? P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)_‹q ƒtableprofilesprofilesCREATE TABLE "profiles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "email" varchar(255), "created_at" datetime, "updated_at" datetime)7‹r‚MtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(255), "profile_id" integer, "created_at" datetime, "updated_at" datetime)=‹s‚QtableauthorsauthorsCREATE TABLE "authors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(255), "profile_id" integer, "created_at" datetime, "updated_at" datetime)=‹t‚QtableartistsartistsCREATE TABLE "artists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(255), "profile_id" integer, "created_at" datetime, "updated_at" datetime)
Ô ³j Ô G # 33999 MyHouseMycity987652009-02-06 19:26:202009-02-06 19:26:20K ' 33123 SomewhereSomecity123452009-02-06 19:26:202009-02-06 19:26:20G # 33999 MyHouseMycity987652009-02-06 19:26:202009-02-06 19:26:20K ' 33123 SomewhereSomecity123452009-02-06 19:26:202009-02-06 19:26:20
é é1 ‚D‹u „WtableaddressesaddressesCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "line_one" varchar(255), "line_two" varchar(255), "city" varchar(255), "state_code" varchar(255), "postal_code" varchar(255), "owner_type" varchar(255), "owner_id" integer, "created_at" datetime, "updated_at" datetime)c‹vƒ tableofficesoffices CREATE TABLE "offices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "billing_address_id" integer, "shipping_address_id" integer, "created_at" datetime, "updated_at" datetime)d‹w ƒtablecontentscontents
-CREATE TABLE "contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "presentable_type" varchar(255), "presentable_id" integer, "created_at" datetime, "updated_at" datetime)
È 6 33Initest2009-02-06 19:26:202009-02-06 19:26:206 33Initest2009-02-06 19:26:202009-02-06 19:26:20
t ÅŠOÙžc%ê¯t 9 33My PagePage 2009-02-06 19:26:192009-02-06 19:26:199
+SQLite format 3 @ î úôî Œ Œ Œ
+
¸ ¸ F -33joebloggsjoe@bloggs.co.uk2009-04-11 13:02:502009-04-11 13:02:50
+j ìÞɺ¯¡“†wj
+offices
addresses artists profiles contents pages
databases+database_logins accounts)account_logins
6 6 ˆkNE P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)_Œ ƒtableprofilesprofilesCREATE TABLE "profiles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "email" varchar(255), "created_at" datetime, "updated_at" datetime)_Œ ƒtableaccountsaccounts CREATE TABLE "accounts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "first_name" varchar(255), "last_name" varchar(255), "email" varchar(255), "created_at" datetime, "updated_at" datetime)sŒ ))ƒ!tableaccount_loginsaccount_loginsCREATE TABLE "account_logins" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(255), "password" varchar(255), "account_email" varchar(255), "created_at" datetime, "updated_at" datetime)7Œ
+‚MtableusersusersCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(255), "profile_id" integer, "created_at" datetime, "updated_at" datetime)
Ô ³j Ô G # 33999 MyHouseMycity987652009-04-11 13:02:502009-04-11 13:02:50K ' 33123 SomewhereSomecity123452009-04-11 13:02:502009-04-11 13:02:50G # 33999 MyHouseMycity987652009-04-11 13:02:502009-04-11 13:02:50K ' 33123 SomewhereSomecity123452009-04-11 13:02:502009-04-11 13:02:50
ô ôµv& =Œ ‚QtableauthorsauthorsCREATE TABLE "authors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(255), "profile_id" integer, "created_at" datetime, "updated_at" datetime)=Œ ‚QtableartistsartistsCREATE TABLE "artists" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(255), "profile_id" integer, "created_at" datetime, "updated_at" datetime),Œ
‚'tabledatabasesdatabasesCREATE TABLE "databases" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime, "updated_at" datetime)VŒ++‚ctabledatabase_loginsdatabase_loginsCREATE TABLE "database_logins" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(255), "database_id" integer, "created_at" datetime, "updated_at" datetime)
È 6 33Initest2009-04-11 13:02:502009-04-11 13:02:506 33Initest2009-04-11 13:02:502009-04-11 13:02:50
t ÅŠOÙžc%ê¯t 9 33My PagePage 2009-04-11 13:02:502009-04-11 13:02:509
33My PagePage
-2009-02-06 19:26:192009-02-06 19:26:199 33My PagePage 2009-02-06 19:26:192009-02-06 19:26:19< !33First PagePage2009-02-06 19:26:192009-02-06 19:26:199 33My PagePage2009-02-06 19:26:192009-02-06 19:26:199 33My PagePage2009-02-06 19:26:192009-02-06 19:26:199 33My PagePage2009-02-06 19:26:192009-02-06 19:26:199 33My PagePage2009-02-06 19:26:192009-02-06 19:26:199 33My PagePage2009-02-06 19:26:192009-02-06 19:26:199 33My PagePage2009-02-06 19:26:192009-02-06 19:26:199 33My PagePage2009-02-06 19:26:192009-02-06 19:26:19
¾|:ø¶t2Í‹I @ 733Something interesting2009-02-06 19:26:192009-02-06 19:26:19@
- 733Something interesting2009-02-06 19:26:192009-02-06 19:26:19@ 733Something interesting2009-02-06 19:26:192009-02-06 19:26:19c }33Some really informative stuff that would be a lot longer2009-02-06 19:26:192009-02-06 19:26:19@ 733Something interesting2009-02-06 19:26:192009-02-06 19:26:19@ 733Something interesting2009-02-06 19:26:192009-02-06 19:26:19@ 733Something interesting2009-02-06 19:26:192009-02-06 19:26:19@ 733Something interesting2009-02-06 19:26:192009-02-06 19:26:19@ 733Something interesting2009-02-06 19:26:192009-02-06 19:26:19@ 733Something interesting2009-02-06 19:26:192009-02-06 19:26:19@ 733Something interesting2009-02-06 19:26:192009-02-06 19:26:19
‚>…M „Otablecontentscontents
-CREATE TABLE "contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255) DEFAULT NULL NULL, "presentable_type" varchar(255) DEFAULT NULL NULL, "presentable_id" integer DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL)N…N‚{tablepagespages CREATE TABLE "pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" text DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL)‚U…O „ytabledocumentsdocuments
CREATE TABLE "documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version_file_name" varchar(255) DEFAULT NULL NULL, "version_content_type" varchar(255) DEFAULT NULL NULL, "version_file_size" integer DEFAULT NULL NULL, "created_at" datetime DEFAULT NULL NULL, "updated_at" datetime DEFAULT NULL NULL)
Î Î 0 33joe2009-02-06 19:26:202009-02-06 19:26:20
e e ‹x‚tablepagespages CREATE TABLE "pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" text, "created_at" datetime, "updated_at" datetime){‹y ƒEtabledocumentsdocuments
CREATE TABLE "documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version_file_name" varchar(255), "version_content_type" varchar(255), "version_file_size" integer, "created_at" datetime, "updated_at" datetime)
+2009-04-11 13:02:502009-04-11 13:02:509 33My PagePage 2009-04-11 13:02:502009-04-11 13:02:50< !33First PagePage2009-04-11 13:02:502009-04-11 13:02:509 33My PagePage2009-04-11 13:02:502009-04-11 13:02:509 33My PagePage2009-04-11 13:02:502009-04-11 13:02:509 33My PagePage2009-04-11 13:02:502009-04-11 13:02:509 33My PagePage2009-04-11 13:02:502009-04-11 13:02:509 33My PagePage2009-04-11 13:02:502009-04-11 13:02:509 33My PagePage2009-04-11 13:02:502009-04-11 13:02:509 33My PagePage2009-04-11 13:02:502009-04-11 13:02:50
¾|:ø¶t2Í‹I @ 733Something interesting2009-04-11 13:02:502009-04-11 13:02:50@
+ 733Something interesting2009-04-11 13:02:502009-04-11 13:02:50@ 733Something interesting2009-04-11 13:02:502009-04-11 13:02:50c }33Some really informative stuff that would be a lot longer2009-04-11 13:02:502009-04-11 13:02:50@ 733Something interesting2009-04-11 13:02:502009-04-11 13:02:50@ 733Something interesting2009-04-11 13:02:502009-04-11 13:02:50@ 733Something interesting2009-04-11 13:02:502009-04-11 13:02:50@ 733Something interesting2009-04-11 13:02:502009-04-11 13:02:50@ 733Something interesting2009-04-11 13:02:502009-04-11 13:02:50@ 733Something interesting2009-04-11 13:02:502009-04-11 13:02:50@ 733Something interesting2009-04-11 13:02:502009-04-11 13:02:50
¸ ¸ F -33joebloggsjoe@bloggs.co.uk2009-04-11 13:02:502009-04-11 13:02:50
Î Î 0 33joe2009-04-11 13:02:502009-04-11 13:02:50
é é1 ‚DŒ „WtableaddressesaddressesCREATE TABLE "addresses" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "line_one" varchar(255), "line_two" varchar(255), "city" varchar(255), "state_code" varchar(255), "postal_code" varchar(255), "owner_type" varchar(255), "owner_id" integer, "created_at" datetime, "updated_at" datetime)cŒƒ tableofficesoffices CREATE TABLE "offices" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "billing_address_id" integer, "shipping_address_id" integer, "created_at" datetime, "updated_at" datetime)dŒ ƒtablecontentscontents
+CREATE TABLE "contents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "presentable_type" varchar(255), "presentable_id" integer, "created_at" datetime, "updated_at" datetime)
¶ ¶ H -33joepasswordjoe@bloggs.co.uk2009-04-11 13:02:502009-04-11 13:02:50
Ï Ï / 33page2009-04-11 13:02:502009-04-11 13:02:50
Î Î 0 33joe2009-04-11 13:02:502009-04-11 13:02:50
e e Œ‚tablepagespages CREATE TABLE "pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" text, "created_at" datetime, "updated_at" datetime){Œ ƒEtabledocumentsdocuments
CREATE TABLE "documents" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version_file_name" varchar(255), "version_content_type" varchar(255), "version_file_size" integer, "created_at" datetime, "updated_at" datetime)
\ No newline at end of file