test/dummy/db/test.sqlite3 in git_wit-0.0.3 vs test/dummy/db/test.sqlite3 in git_wit-0.0.4.pre
- old
+ new
@@ -1,15 +1 @@
-SQLite format 3 @ -$
;
@
-
- +0 =//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)]#Kindexindex_users_roles_on_user_id_and_role_idusers_rolesCREATE INDEX "index_users_roles_on_user_id_and_role_id" ON "users_roles" ("user_id", "role_id")d##tableusers_rolesusers_rolesCREATE TABLE "users_roles" ("user_id" integer, "role_id" integer)
SGindexindex_users_on_reset_password_tokenusersCREATE UNIQUE INDEX "index_users_on_reset_password_token" ON "users" ("reset_password_token")e5indexindex_users_on_emailusers
CREATE UNIQUE INDEX "index_users_on_email" ON "users" ("email") tableusersusersCREATE TABLE "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, "username" varchar(255))Z
-3yindexindex_roles_on_namerolesCREATE INDEX "index_roles_on_name" ON "roles" ("name")? w}indexindex_roles_on_name_and_resource_type_and_resource_idroles
-CREATE INDEX "index_roles_on_name_and_resource_type_and_resource_id" ON "roles" ("name", "resource_type", "resource_id")g-tablerolesroles CREATE TABLE "roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "resource_id" integer, "resource_type" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) G%!indexindex_repositories_on_user_idrepositoriesCREATE INDEX "index_repositories_on_user_id" ON "repositories" ("user_id")wA%indexindex_repositories_on_pathrepositoriesCREATE INDEX "index_repositories_on_path" ON "repositories" ("path")%%EtablerepositoriesrepositoriesCREATE TABLE "repositories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "path" varchar(255), "user_id" integer, "public" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)|E#indexindex_public_keys_on_user_idpublic_keysCREATE INDEX "index_public_keys_on_user_id" ON "public_keys" ("user_id")E#+indexindex_public_keys_on_contentpublic_keysCREATE UNIQUE INDEX "index_public_keys_on_content" ON "public_keys" ("content")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)j##tablepublic_keyspublic_keysCREATE TABLE "public_keys" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "content" text, "comment" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
-
-
-
-
-
-
-
-
-
)20130217191808)20130217114405)20130217111055)20130217110616)20130217221157
- )20130217191808)20130217114405)20130217111055)20130217110616) 20130217221157
\ No newline at end of file