spec/dummy/db/test.sqlite3 in active_admin-state_machine-0.1.1 vs spec/dummy/db/test.sqlite3 in active_admin-state_machine-1.0.0.pre1
- old
+ new
@@ -1,9 +1,10 @@
-SQLite format 3 @
-$
:
^ BR =//indexunique_schema_migrationsschema_migrations
CREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")q//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)
-qtablepostspostsCREATE TABLE "posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255) NOT NULL, "body" text NOT NULL, "status" varchar(255) NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "category_id" integer)A !!Mtablecategoriescategories
-CREATE TABLE "categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)*_#_indexindex_admin_users_on_reset_password_tokenadmin_users CREATE UNIQUE INDEX "index_admin_users_on_reset_password_token" ON "admin_users" ("reset_password_token")}A##indexindex_admin_users_on_emailadmin_usersCREATE UNIQUE INDEX "index_admin_users_on_email" ON "admin_users" ("email")##ytableadmin_usersadmin_usersCREATE TABLE "admin_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)Qq7indexindex_admin_notes_on_resource_type_and_resource_idactive_admin_commentsCREATE INDEX "index_admin_notes_on_resource_type_and_resource_id" ON "active_admin_comments" ("resource_type", "resource_id")*]7Mindexindex_active_admin_comments_on_namespaceactive_admin_commentsCREATE INDEX "index_active_admin_comments_on_namespace" ON "active_admin_comments" ("namespace")Y}7indexindex_active_admin_comments_on_author_type_and_author_idactive_admin_commentsCREATE INDEX "index_active_admin_comments_on_author_type_and_author_id" ON "active_admin_comments" ("author_type", "author_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)q77tableactive_admin_commentsactive_admin_commentsCREATE TABLE "active_admin_comments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "resource_id" varchar(255) NOT NULL, "resource_type" varchar(255) NOT NULL, "author_id" integer, "author_type" varchar(255), "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "namespace" varchar(255))
posts
! categories#admin_users
+SQLite format 3 @ .O}
N
r N T
55Ktablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime(6) NOT NULL, "updated_at" datetime(6) NOT NULL)G[5 indexsqlite_autoindex_ar_internal_metadata_1ar_internal_metadatax//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL PRIMARY KEY)AU/ indexsqlite_autoindex_schema_migrations_1schema_migrations
+]tablepostspostsCREATE TABLE "posts" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "body" text NOT NULL, "status" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "category_id" integer)< !!Ctablecategoriescategories
+CREATE TABLE "categories" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)*_#_indexindex_admin_users_on_reset_password_tokenadmin_users CREATE UNIQUE INDEX "index_admin_users_on_reset_password_token" ON "admin_users" ("reset_password_token")}A##indexindex_admin_users_on_emailadmin_usersCREATE UNIQUE INDEX "index_admin_users_on_email" ON "admin_users" ("email")!## tableadmin_usersadmin_usersCREATE TABLE "admin_users" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "email" varchar DEFAULT '' NOT NULL, "encrypted_password" varchar DEFAULT '' NOT NULL, "reset_password_token" varchar, "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, "last_sign_in_ip" varchar, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "super_admin" boolean DEFAULT 0)Qq7indexindex_admin_notes_on_resource_type_and_resource_idactive_admin_commentsCREATE INDEX "index_admin_notes_on_resource_type_and_resource_id" ON "active_admin_comments" ("resource_type", "resource_id")*]7Mindexindex_active_admin_comments_on_namespaceactive_admin_commentsCREATE INDEX "index_active_admin_comments_on_namespace" ON "active_admin_comments" ("namespace")Y}7indexindex_active_admin_comments_on_author_type_and_author_idactive_admin_commentsCREATE INDEX "index_active_admin_comments_on_author_type_and_author_id" ON "active_admin_comments" ("author_type", "author_id")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)]77Ytableactive_admin_commentsactive_admin_commentsCREATE TABLE "active_admin_comments" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "resource_id" varchar NOT NULL, "resource_type" varchar NOT NULL, "author_id" integer, "author_type" varchar, "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "namespace" varchar)
) posts categories admin_users
-
m V / AAAAuser1@example.com$2a$04$dgPqNdooy58Rid15aDpx9e1x5cQCMoklVvUq8H3XRNnvgWhrLWGOa2013-09-08 10:19:54.7167142013-09-08 10:19:54.716714127.0.0.1127.0.0.12013-09-08 10:19:53.9815712013-09-08 10:19:54.718151 / AAadmin@example.com$2a$04$RtQ.sr1gknPMhc27Ch0adulSgn741uyg6tI80D6dUVAGuroCIw15.2013-09-08 10:13:09.4622532013-09-08 10:13:09.462253
- /user1@example.com/ admin@example.com
-
C !AACategory 12013-09-08 10:19:53.9901242013-09-08 10:19:53.990124
R #AA Post 1lorem ipsumdraft2013-09-08 10:19:54.0054782013-09-08 10:19:54.005478
)20130817005638)20130817004307)20130817004306)20130817004304)20130829000200
- )20130817005638)20130817004307)20130817004306)20130817004304) 20130829000200
+
&