spec/fixtures/interact_models_db.sqlite in datashift-0.1.0 vs spec/fixtures/interact_models_db.sqlite in datashift-0.2.1
- old
+ new
@@ -1,8 +1,8 @@
-SQLite format 3 @ $ - 2 P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)x CtableprojectsprojectsCREATE TABLE "projects" ("id" integer primary key autoincrement not null, "title" varchar(255), "value_as_string" varchar(255), "value_as_text" text, "value_as_boolean" boolean DEFAULT 'f', "value_as_datetime" datetime, "value_as_integer" integer DEFAULT 0, "value_as_double" decimal(8,2) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255)
)20110803201325
- )20110803201325
t E AAf W 3
AA099myprefixmy post`# 7
AA099Default Project Value @X 2012-02-25 11:11:05.3040002012-02-25 11:11:05.304000" g
AAA003003 Can handle different column naming stylest2011-05-19 00:00:00.000000 @X 2012-02-25 11:11:05.2810002012-02-25 11:11:05.281000u! +
AAA002Loads via Jrubyf2011-03-23 00:00:00.000000 @X 2012-02-25 11:11:05.2640002012-02-25 11:11:05.264000z # AAA001Demo stringblah blaV& ' AAValue as Textt @R I^2012-02-25 16:04:38.1260002012-02-25 16:04:38.126000
!categories !categories
projects
8 8 5 4 q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")x CtableprojectsprojectsCREATE TABLE "projects" ("id" integer primary key autoincrement not null, "title" varchar(255), "value_as_string" varchar(255), "value_as_text" text, "value_as_boolean" boolean DEFAULT 'f', "value_as_datetime" datetime, "value_as_integer" integer DEFAULT 0, "value_as_double" decimal(8,2) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq){!!AtablemilestonesmilestonesCREATE TABLE "milestones" ("id" integer primary key autoincrement not null, "name" varchar(255), "datetime" datetime, "cost" decimal(8,2) DEFAULT 0.0, "project_id" integer, "created_at" datetime, "updated_at" datetime)
[ [T n j j
+SQLite format 3 @ $ - 2 P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)x CtableprojectsprojectsCREATE TABLE "projects" ("id" integer primary key autoincrement not null, "title" varchar(255), "value_as_string" varchar(255), "value_as_text" text, "value_as_boolean" boolean DEFAULT 'f', "value_as_datetime" datetime, "value_as_integer" integer DEFAULT 0, "value_as_double" decimal(8,2) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255)
)20110803201325
+ )20110803201325
t E AAf W 3
AA099myprefixmy post`# 7
AA099Default Project Value @X 2012-02-25 11:11:05.3040002012-02-25 11:11:05.304000" g
AAA003003 Can handle different column naming stylest2011-05-19 00:00:00.000000 @X 2012-02-25 11:11:05.2810002012-02-25 11:11:05.281000u! +
AAA002Loads via Jrubyf2011-03-23 00:00:00.000000 @X 2012-02-25 11:11:05.2640002012-02-25 11:11:05.264000z # AAA001Demo stringblah blaV( ' AAValue as Textt @R I^2012-02-29 07:47:15.8520002012-02-29 07:47:15.852000
!categories !categories
projects
8 8 5 4 q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")x CtableprojectsprojectsCREATE TABLE "projects" ("id" integer primary key autoincrement not null, "title" varchar(255), "value_as_string" varchar(255), "value_as_text" text, "value_as_boolean" boolean DEFAULT 'f', "value_as_datetime" datetime, "value_as_integer" integer DEFAULT 0, "value_as_double" decimal(8,2) DEFAULT 0.0, "created_at" datetime, "updated_at" datetime)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq){!!AtablemilestonesmilestonesCREATE TABLE "milestones" ("id" integer primary key autoincrement not null, "name" varchar(255), "datetime" datetime, "cost" decimal(8,2) DEFAULT 0.0, "project_id" integer, "created_at" datetime, "updated_at" datetime)
[ [T n j j
++ tableloader_releasesloader_releases
CREATE TABLE "loader_releases" ("id" integer primary key autoincrement not null, "name" varchar(255), "project_id" integer, "version_id" integer, "created_at" datetime, "updated_at" datetime)9MtableownersownersCREATE TABLE "owners" ("id" integer primary key autoincrement not null, "name" varchar(255), "project_id" integer, "created_at" datetime, "updated_at" datetime)4!!3tablecategoriescategories
-CREATE TABLE "categories" ("id" integer primary key autoincrement not null, "reference" varchar(255), "created_at" datetime, "updated_at" datetime)33-tablecategories_projectscategories_projects CREATE TABLE "categories_projects" ("category_id" integer, "project_id" integer)) %tableversionsversions CREATE TABLE "versions" ("id" integer primary key autoincrement not null, "name" varchar(255), "created_at" datetime, "updated_at" datetime)
p( E7 %AAcategory_0052012-02-25 16:04:38.6640002012-02-25 16:04:38.664000E6 %AAcategory_0042012-02-25 16:04:38.6470002012-02-25 16:04:38.647000E5 %AAcategory_0032012-02-25 16:04:38.6210002012-02-25 16:04:38.621000E4 %AAcategory_0022012-02-25 16:04:38.5360002012-02-25 16:04:38.536000E3 %AAcategory_0012012-02-25 16:04:38.5120002012-02-25 16:04:38.512000 $f_XQJC<5.' xqjc\UNG@92+$
}ume]UME=5-%
l' k& j% i' h& g% f' e& d% c# b$ a$ `# _" ^$ ]# \" [$ Z# Y" X W! V! U T S! R Q P! O N M L K J I H G F E D ~C ~BtAr@q?q>q=o<o;o:n9m8m7c6a5`4`3`2^1^0^/].\-\, ?+ =* <) <(
+CREATE TABLE "categories" ("id" integer primary key autoincrement not null, "reference" varchar(255), "created_at" datetime, "updated_at" datetime)33-tablecategories_projectscategories_projects CREATE TABLE "categories_projects" ("category_id" integer, "project_id" integer)) %tableversionsversions CREATE TABLE "versions" ("id" integer primary key autoincrement not null, "name" varchar(255), "created_at" datetime, "updated_at" datetime)
p( E< %AAcategory_0052012-02-29 07:47:16.0700002012-02-29 07:47:16.070000E; %AAcategory_0042012-02-29 07:47:16.0550002012-02-29 07:47:16.055000E: %AAcategory_0032012-02-29 07:47:16.0390002012-02-29 07:47:16.039000E9 %AAcategory_0022012-02-29 07:47:16.0240002012-02-29 07:47:16.024000E8 %AAcategory_0012012-02-29 07:47:16.0080002012-02-29 07:47:16.008000 $f_XQJC<5.' xqjc\UNG@92+$
}ume]UME=5-%
l' k& j% i' h& g% f' e& d% c# b$ a$ `# _" ^$ ]# \" [$ Z# Y" X W! V! U T S! R Q P! O N M L K J I H G F E D ~C ~BtAr@q?q>q=o<o;o:n9m8m7c6a5`4`3`2^1^0^/].\-\, ?+ =* <) <(
<' :& :%
:$ 9# 8"
8!. , + + + ))) ('' #f " !> j B n F r J v " N z & J l
1 c tableemptiesemptiesCREATE TABLE "empties" ("id" integer primary key autoincrement not null)j
++ tableloader_releasesloader_releases
CREATE TABLE "loader_releases" ("id" integer primary key autoincrement not null, "name" varchar(255), "project_id" integer, "version_id" integer, "created_at" datetime, "updated_at" datetime)_ __
tablelong_and_complex_table_linked_to_versionslong_and_complex_table_linked_to_versionsCREATE TABLE "long_and_complex_table_linked_to_versions" ("id" integer primary key autoincrement not null, "version_id" integer)
l {tmf_XQJC<5.' xqjc\UNG@92+$
}ume]UME=5-%
l' k& j% i' h& g% f' e& d% c# b$ a$ `# _" ^$ ]# \" [$ Z# Y" X W! V! U T S! R Q P! O N M L K J I H G F E D ~C ~BtAr@q?q>q=o<o;o:n9m8m7c6a5`4`3`2^1^0^/].\-\, ?+ =* <) <(
<' :& :%
\ No newline at end of file