spec/dummy/db/development.sqlite3 in flms-0.1.0 vs spec/dummy/db/development.sqlite3 in flms-0.9.0

- old
+ new

@@ -1,16 +1,12 @@ -SQLite format 3@ ,-$ >  t +SQLite format 3@  -$   t --U$>##mtableflms_layersflms_layersCREATE TABLE "flms_layers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "block_id" integer, "type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "image" varchar(255), "text" varchar(255), "font_size" float, "color" varchar(255), "width" float, "height" float, "dom_remove" boolean DEFAULT 't', "header" varchar(255), "body" text, "z_index" varchar(255) DEFAULT '0' NOT NULL, "embed_code" text, "active" boolean DEFAULT 't', "image_display_mode" varchar(255) DEFAULT 'cover', "frame_rate" integer, "frame_count" integer, "image_width" integer, "image_height" integer)F))Gtableflms_keyframesflms_keyframesCREATE TABLE "flms_keyframes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "layer_id" integer, "type" varchar(255), "scroll_start" integer, "scroll_duration" integer, "width" float, "height" float, "position_x" float, "position_y" float, "opacity" float, "scale" float, "blur" float, "margin_left" float DEFAULT 0, "margin_top" float DEFAULT 0) fG#!indexit ##/tableflms_blocksflms_blocks -CREATE TABLE "flms_blocks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "thumbnail" varchar(255), "title" varchar(255))G#!indexindex_flms_layers_on_block_idflms_layersCREATE INDEX "index_flms_layers_on_block_id" ON "flms_layers" ("block_id") Q/5indexindex_flms_blocks_pages_on_page_idflms_blocks_pages CREATE INDEX "index_flms_blocks_pages_on_page_id" ON "flms_blocks_pages" ("page_id") S/9indexindex_flms_blocks_pages_on_block_idflms_blocks_pages CREATE INDEX "index_flms_blocks_pages_on_block_id" ON "flms_blocks_pages" ("block_id") -//Ktableflms_blocks_pagesflms_blocks_pages CREATE TABLE "flms_blocks_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "block_id" integer, "page_id" integer, "ordering" integer, "active" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)##Otableflms_blocksflms_blocks -CREATE TABLE "flms_blocks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)l;! indexindex_flms_pages_on_urlflms_pages CREATE INDEX "index_flms_pages_on_url" ON "flms_pages" ("url")V!!wtableflms_pagesflms_pagesCREATE TABLE "flms_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "url" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)&]![indexindex_flms_users_on_reset_password_tokenflms_usersCREATE UNIQUE INDEX "index_flms_users_on_reset_password_token" ON "flms_users" ("reset_password_token")y?!indexindex_flms_users_on_emailflms_usersCREATE UNIQUE INDEX "index_flms_users_on_email" ON "flms_users" ("email")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)!!wtableflms_usersflms_usersCREATE TABLE "flms_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" 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) tp^L:(t)20130514202128)20130508234709)20130508174355)20130508002138)20130507222721)20130506232533)20130506204547)20130430224538)20130426171058 )20130422193150 )20130418222016 )20130418191643 -)20130417210408 )20130415185500)20130404201756)20130327183815)20130313002421)20130312220011)20130302015459)20130302011705)20130216032241)20130208224914 -_|iVC0 -r_)20130514202128)20130508234709)20130508174355)20130508002138)20130507222721)20130506232533)20130506204547)20130430224538)20130426171058)20130422193150 )20130418222016 )20130418191643 )20130417210408 -)20130415185500 )20130404201756)20130327183815)20130313002421)20130312220011)20130302015459)20130302011705)20130216032241) 20130208224914 _A AAAAkevin.goslar@originate.com$2a$10$GmHvWm4YPL/M6qYyEbzSuuwtPjvn9mQcyPH/0vGkMlrm1U/kBcikG2013-05-06 17:37:06.7991792013-05-06 17:37:06.799179127.0.0.1127.0.0.12013-05-06 17:37:01.5990412013-05-06 17:37:06.800200 /flms_blocks_pages#flms_blocks ! flms_pages ! flms_users -A kevin.goslar@originate.com - BAApage1oeu2013-05-06 17:37:16.0143162013-05-06 17:37:16.014316 - oeu ~~?AAblock22013-05-06 17:37:33.8288002013-05-06 17:37:33.828800?AAblock12013-05-06 17:37:28.1075892013-05-06 17:37:28.107589 = AA2013-05-06 17:38:05.1485992013-05-06 17:38:05.148599< AA2013-05-06 17:38:03.5528142013-05-06 17:38:03.552814 - -   -  +- 6%sM ##atableflms_layersflms_layersCREATE TABLE "flms_layers" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "type" varchar(255), "block_id" integer, "width" float, "height" float, "z_index" varchar(255) DEFAULT '0' NOT NULL, "image_display_mode" varchar(255) DEFAULT 'cover', "dom_remove" boolean DEFAULT 't' NOT NULL, "active" boolean DEFAULT 't', "image" varchar(255), "text" varchar(255), "font_size" float, "color" varchar(255), "header" varchar(255), "body" text, "embed_code" text, "frame_rate" integer, "frame_count" integer, "image_width" integer, "image_height" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "easing_function" varchar(255) DEFAULT 'linear')X))ktableflms_keyframesflms_keyframesCREATE TABLE "flms_keyframes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "layer_id" integer, "type" varchar(255), "scroll_start" integer, "scroll_duration" integer, "width" float, "height" float, "position_x" float, "position_y" float, "margin_left" float DEFAULT 0 NOT NULL, "margin_top" float DEFAULT 0 NOT NULL, "opacity" float, "scale" float, "blur" float)G#!indexindex_flms_layers_on_block_idflms_layersCREATE INDEX "index_flms_layers_on_block_id" ON "flms_layers" ("block_id") Q/5indexindex_flms_blocks_pages_on_page_idflms_blocks_pages CREATE INDEX "index_flms_blocks_pages_on_page_id" ON "flms_blocks_pages" ("page_id") S/9indexindex_flms_blocks_pages_on_block_idflms_blocks_pages CREATE INDEX "index_flms_blocks_pages_on_block_id" ON "flms_blocks_pages" ("block_id") +//Ktableflms_blocks_pagesflms_blocks_pages CREATE TABLE "flms_blocks_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "block_id" integer, "page_id" integer, "ordering" integer, "active" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)t ##/tableflms_blocksflms_blocks +CREATE TABLE "flms_blocks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "title" varchar(255), "thumbnail" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)l;! indexindex_flms_pages_on_urlflms_pages CREATE INDEX "index_flms_pages_on_url" ON "flms_pages" ("url")V!!wtableflms_pagesflms_pagesCREATE TABLE "flms_pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "url" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)&]![indexindex_flms_users_on_reset_password_tokenflms_usersCREATE UNIQUE INDEX "index_flms_users_on_reset_password_token" ON "flms_users" ("reset_password_token")y?!indexindex_flms_users_on_emailflms_usersCREATE UNIQUE INDEX "index_flms_users_on_email" ON "flms_users" ("email")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)!!wtableflms_usersflms_usersCREATE TABLE "flms_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar(255) DEFAULT '' NOT NULL, "encrypted_password" varchar(255) DEFAULT '' NOT NULL, "reset_password_token" varchar(255), "reset_password_sent_at" datetime, "remember_created_at" datetime, "sign_in_count" integer DEFAULT 0, "current_sign_in_at" datetime, "last_sign_in_at" datetime, "current_sign_in_ip" varchar(255), "last_sign_in_ip" 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) )20130610200850)20130327183815)20130312220011)20130302015459)20130302011705)20130216032241)20130208224914 +||)20130610200850)20130327183815)20130312220011)20130302015459)20130302011705)20130216032241) 20130208224914   + +  +   + +  +  \ No newline at end of file