test/dummy/db/development.sqlite3 in notee-0.2.6 vs test/dummy/db/development.sqlite3 in notee-0.2.7
- old
+ new
@@ -1,3 +1,10 @@
-SQLite format 3 @ -
-
=//indexunique_schema_migrationsschema_migrationsCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")l//tableschema_migrationsschema_migrationsCREATE TABLE "schema_migrations" ("version" varchar NOT NULL)
-
+SQLite format 3 @
-
+
?%2d
+ v Q%Cindexindex_notee_tokens_on_access_tokennotee_tokens
CREATE UNIQUE INDEX "index_notee_tokens_on_access_token" ON "notee_tokens" ("access_token")s%%)tablenotee_tokensnotee_tokensCREATE TABLE "notee_tokens" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "access_token" varchar NOT NULL, "expires_at" datetime NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)N
+%%_tablenotee_imagesnotee_imagesCREATE TABLE "notee_images" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "content" varchar NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) I-3indexindex_notee_categories_on_slugnotee_categories
+CREATE UNIQUE INDEX "index_notee_categories_on_slug" ON "notee_categories" ("slug")Z--gtablenotee_categoriesnotee_categories CREATE TABLE "notee_categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar DEFAULT 'category_name' NOT NULL, "slug" varchar DEFAULT '2016-19-26-54' NOT NULL, "parent_id" integer, "status" integer DEFAULT 0 NOT NULL, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)z?#indexindex_notee_posts_on_slugnotee_postsCREATE UNIQUE INDEX "index_notee_posts_on_slug" ON "notee_posts" ("slug")P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)p##'tablenotee_postsnotee_postsCREATE TABLE "notee_posts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar DEFAULT 'no title', "content" text, "slug" varchar DEFAULT '2016-19-26-54', "status" integer DEFAULT 0, "category_id" integer DEFAULT 0, "thumbnail_id" integer DEFAULT 0, "published_at" datetime DEFAULT '2016-07-13 10:26:54.346059', "seo_keyword" varchar DEFAULT '', "seo_description" varchar DEFAULT '', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)N55?tablear_internal_metadataar_internal_metadataCREATE TABLE "ar_internal_metadata" ("key" varchar NOT NULL PRIMARY KEY, "value" varchar, "created_at" datetime NOT NULL, "updated_at" datetime 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
)20160713102623)20160713102622)20160713102621)20160713102620
+ )20160713102623)20160713102622)20160713102621) 20160713102620
O##AAenvironmentdevelopment2016-07-13 10:26:54.3858872016-07-13 10:26:54.385887
+ # environment
% notee_tokens
+
+
t MAAAebe2b8312536e3ed77613af9b328cd242016-07-20 10:34:30.1403362016-07-13 10:34:30.0837942016-07-13 10:34:30.083794
+ #M ebe2b8312536e3ed77613af9b328cd24
\ No newline at end of file