spec/dummy/db/development.sqlite3 in page_engine-0.0.4 vs spec/dummy/db/development.sqlite3 in page_engine-0.0.5
- old
+ new
@@ -1,21 +1,18 @@
-SQLite format 3 @ . . -
)20110814185929
- )20110814185929
J J G 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")6KtablepagespagesCREATE TABLE "pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "meta_description" text, "meta_keywords" text, "status" varchar(255), "publish_from" datetime, "publish_to" datetime, "created_by" integer, "permalink" varchar(255), "url" varchar(255), "display_in_menu" boolean DEFAULT 't', "display_in_sitemap" boolean DEFAULT 't', "menu_css_class" varchar(255), "no_link" boolean DEFAULT 'f', "controller" varchar(255), "action" varchar(255), "layout" varchar(255), "js" text, "css" text, "parent_id" integer, "lft" integer, "rgt" integer, "authorable_type" varchar(255), "authorable_id" integer, "created_at" datetime, "updated_at" datetime)
!page_parts( pages
y y P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)j!! tablepage_partspage_partsCREATE TABLE "page_parts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" text, "page_id" integer, "filter" varchar(255), "created_at" datetime, "updated_at" datetime)d##tablepages_rolespages_roles CREATE TABLE "pages_roles" ("page_id" integer, "role_id" integer)_''}tablepage_snippetspage_snippets
-CREATE TABLE "page_snippets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "filter" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime) '
- Ctest-2-copy-20110829-194719
-test-7
+SQLite format 3 @ / / -
)20111002230859)20111002171742)20110814185929
+ )20111002230859)20111002171742)20110814185929
#
AArubberDraftrubberttrubberfwelcomeindexapplication
2011-10-13 00:35:37.1851182011-10-13 00:58:18.381038{
#
AAtest 6Publishedtest-6tttest-6fapplication
+ 2011-10-03 01:46:58.3787892011-10-03 01:47:10.146288{
#
AAtest 5Publishedtest-5tttest-5fapplication 2011-10-03 01:46:44.0182992011-10-12 23:29:21.954524{
#
AAtest 4Publishedtest-4tttest-4fapplication2011-10-03 01:46:28.3917412011-10-12 23:29:21.760913{
#
AAtest 3Publishedtest-3tttest-3fapplication2011-10-03 01:46:00.2559582011-10-12 23:29:21.849592 w
AAtest 2Publishedtest-2tttest-2ftrouble2011-10-02 23:36:11.3694902011-10-13 01:03:23.094844|
AAHomePublishedhometttestfwelcomeindextrouble2011-10-02 23:21:24.5961022011-10-13 01:02:25.941714
J J G 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")6KtablepagespagesCREATE TABLE "pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "meta_description" text, "meta_keywords" text, "status" varchar(255), "publish_from" datetime, "publish_to" datetime, "created_by" integer, "permalink" varchar(255), "url" varchar(255), "display_in_menu" boolean DEFAULT 't', "display_in_sitemap" boolean DEFAULT 't', "menu_css_class" varchar(255), "no_link" boolean DEFAULT 'f', "controller" varchar(255), "action" varchar(255), "layout" varchar(255), "js" text, "css" text, "parent_id" integer, "lft" integer, "rgt" integer, "authorable_type" varchar(255), "authorable_id" integer, "created_at" datetime, "updated_at" datetime)
!page_roles !page_parts$ pages#weird_users
odd_roles
S S P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)j!! tablepage_partspage_partsCREATE TABLE "page_parts" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar(255), "content" text, "page_id" integer, "filter" varchar(255), "created_at" datetime, "updated_at" datetime)d##tablepages_rolespages_roles CREATE TABLE "pages_roles" ("page_id" integer, "role_id" integer)_''}tablepage_snippetspage_snippets
+CREATE TABLE "page_snippets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "filter" varchar(255), "content" text, "created_at" datetime, "updated_at" datetime)7!!9tablepage_rolespage_roles CREATE TABLE "page_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer, "required_role_id" integer, "excluded_role_id" integer)j =
indexindex_pages_on_permalinkpages CREATE INDEX "index_pages_on_permalink" ON "pages" ("permalink")
+
+rubber
test-6
test-5
test-4
test-3
-test-2test
-
t Jpt { C'indexindex_page_snippets_on_namepage_snippetsCREATE INDEX "index_page_snippets_on_name" ON "page_snippets" ("name")W 1uindexindex_pages_on_urlpagesCREATE INDEX "index_pages_on_url" ON "pages" ("url")7!!9tablepage_rolespage_roles CREATE TABLE "page_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer, "required_role_id" integer, "excluded_role_id" integer)j =
indexindex_pages_on_permalinkpages CREATE INDEX "index_pages_on_permalink" ON "pages" ("permalink")
-U;indexindex_pages_on_controller_and_actionpages
CREATE INDEX "index_pages_on_controller_and_action" ON "pages" ("controller", "action")
-
-
Z r*Q
-y0 Z F
AArightnone2011-08-28 22:34:42.4192202011-08-28 22:34:42.419220E
AAleftnone2011-08-28 22:34:42.4157032011-08-28 22:34:42.415703E
AAbodynone2011-08-28 22:34:42.4120742011-08-28 22:34:42.412074G
-
AAfooternone2011-08-28 22:34:34.1165972011-08-28 22:34:34.116597G
AAheadernone2011-08-28 22:34:34.1134402011-08-28 22:34:34.113440F
AArightnone2011-08-28 22:34:34.1102362011-08-28 22:34:34.110236E
AAleftnone2011-08-28 22:34:34.1068942011-08-28 22:34:34.106894E
AAbodynone2011-08-28 22:34:34.1031432011-08-28 22:34:34.103143G
AAfooternone2011-08-23 22:47:17.4751642011-08-23 22:47:17.475164G
AAheadernone2011-08-23 22:47:17.4732212011-08-23 22:47:17.473221F
AArightnone2011-08-23 22:47:17.4709842011-08-23 22:47:17.470984E
AAleftnone2011-08-23 22:47:17.4676772011-08-23 22:47:17.467677E
AAbodynone2011-08-23 22:47:17.4636892011-08-23 22:47:17.463689
T n'Ox0 T H
AAbodytextile2011-08-28 22:35:06.6416502011-08-29 16:39:36.245405G
AAfooternone2011-08-28 22:34:57.5473822011-08-28 22:34:57.547382G
AAheadernone2011-08-28 22:34:57.5442522011-08-28 22:34:57.544252F
AArightnone2011-08-28 22:34:57.5410372011-08-28 22:34:57.541037E
AAleftnone2011-08-28 22:34:57.5376792011-08-28 22:34:57.537679E
AAbodynone2011-08-28 22:34:57.5338772011-08-28 22:34:57.533877G
AAfooternone2011-08-28 22:34:50.1487592011-08-28 22:34:50.148759G
AAheadernone2011-08-28 22:34:50.1416502011-08-28 22:34:50.141650F
AArightnone2011-08-28 22:34:50.1331762011-08-28 22:34:50.133176E
AAleftnone2011-08-28 22:34:50.1249282011-08-28 22:34:50.124928E
AAbodynone2011-08-28 22:34:50.1210742011-08-28 22:34:50.121074G
AAfooternone2011-08-28 22:34:42.4259822011-08-28 22:34:42.425982G
AAheadernone2011-08-28 22:34:42.4225632011-08-28 22:34:42.422563
X q(Q w0 X G'
AAheadernone2011-08-28 22:34:34.1134402011-08-28 22:34:34.113440F&
AArightnone2011-08-28 22:34:34.1102362011-08-28 22:34:34.110236E%
AAleftnone2011-08-28 22:34:34.1068942011-08-28 22:34:34.106894E$
AAbodynone2011-08-28 22:34:34.1031432011-08-28 22:34:34.103143G#
AAfooternone2011-08-28 22:35:13.8691252011-08-28 22:35:13.869125G"
AAheadernone2011-08-28 22:35:13.8660642011-08-28 22:35:13.866064F!
AArightnone2011-08-28 22:35:13.8628232011-08-28 22:35:13.862823E
AAleftnone2011-08-28 22:35:13.8568032011-08-28 22:35:13.856803E
AAbodynone2011-08-28 22:35:13.8499472011-08-28 22:35:13.849947G
AAfooterhtml2011-08-28 22:35:06.6548082011-08-29 16:39:36.253477G
AAheaderhtml2011-08-28 22:35:06.6517172011-08-29 16:39:36.251744F
AArighthtml2011-08-28 22:35:06.6485802011-08-29 16:39:36.250084E
AAlefthtml2011-08-28 22:35:06.6453732011-08-29 16:39:36.248306
I I F
#yE AAtestPublishedtesttttestfapplication$('document').ready(function(){
- alert('test');
-});body {
- background: red;
-}2011-08-23 22:47:17.4146322011-08-29 22:31:12.377948{
#
AAtest 7Publishedtest-7tttest-7fapplication2011-08-28 22:35:13.8326342011-08-29 18:42:28.771404{
#
AAtest 6Publishedtest-6tttest-6fapplication 2011-08-28 22:35:06.6308652011-08-29 18:42:28.439564{
#
AAtest 5Publishedtest-5tttest-5fapplication
-2011-08-28 22:34:57.4672732011-08-29 18:42:28.663745{
#
AAtest 4Publishedtest-4tttest-4fapplication 2011-08-28 22:34:50.1103102011-08-29 18:42:28.556045{
#
AAtest 3Publishedtest-3tttest-3fapplication
2011-08-28 22:34:42.4018112011-08-29 18:42:28.305457{
#
AAtest 2Publishedtest-2tttest-2fapplication2011-08-28 22:34:34.0927292011-08-29 18:47:25.761113
V V ' G
C
#
AAtest 2 (copy) 20110829_194719Publishedtest-2-copy-20110829-194719tttest-2fapplication2011-08-28 22:34:34.0927292011-08-29 18:47:25.867651
G(
AAfooternone2011-08-28 22:34:34.1165972011-08-28 22:34:34.116597
+test-2home
+ welcomeindex welcomeindex
jq
+U;indexindex_pages_on_controller_and_actionpages
CREATE INDEX "index_pages_on_controller_and_action" ON "pages" ("controller", "action")W 1uindexindex_pages_on_urlpagesCREATE INDEX "index_pages_on_url" ON "pages" ("url"){ C'indexindex_page_snippets_on_namepage_snippetsCREATE INDEX "index_page_snippets_on_name" ON "page_snippets" ("name")~
Ktableodd_rolesodd_rolesCREATE TABLE "odd_roles" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255))##Otableweird_usersweird_usersCREATE TABLE "weird_users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255)) 777tableodd_roles_weird_usersodd_roles_weird_usersCREATE TABLE "odd_roles_weird_users" ("weird_user_id" integer, "odd_role_id" integer)
+
+
User Author Editor Admin
Bob
Z r*Q
+y0 Z Z F
AArightnone2011-10-03 01:46:00.2671602011-10-03 01:46:00.267160E
AAleftnone2011-10-03 01:46:00.2648062011-10-03 01:46:00.264806E
AAbodynone2011-10-03 01:46:00.2621932011-10-03 01:46:00.262193G
+
AAfooternone2011-10-02 23:36:11.3885272011-10-02 23:36:11.388527G
AAheadernone2011-10-02 23:36:11.3862552011-10-02 23:36:11.386255F
AArightnone2011-10-02 23:36:11.3839482011-10-02 23:36:11.383948E
AAleftnone2011-10-02 23:36:11.3817002011-10-02 23:36:11.381700E
AAbodynone2011-10-02 23:36:11.3785542011-10-02 23:36:11.378554 I G
AAheadernone2011-10-02 23:21:24.6180372011-10-02 23:21:24.618037F
AArightnone2011-10-02 23:21:24.6157752011-10-02 23:21:24.615775E
AAleftnone2011-10-02 23:21:24.6124952011-10-02 23:21:24.612495E
AAbodynone2011-10-02 23:21:24.6086882011-10-02 23:21:24.608688
W n'Ox0 W E
AAbodynone2011-10-03 01:46:58.3848962011-10-03 01:46:58.384896G
AAfooternone2011-10-03 01:46:44.0359602011-10-03 01:46:44.035960G
AAheadernone2011-10-03 01:46:44.0333502011-10-03 01:46:44.033350F
AArightnone2011-10-03 01:46:44.0307002011-10-03 01:46:44.030700E
AAleftnone2011-10-03 01:46:44.0282072011-10-03 01:46:44.028207E
AAbodynone2011-10-03 01:46:44.0250902011-10-03 01:46:44.025090G
AAfooternone2011-10-03 01:46:28.4109952011-10-03 01:46:28.410995G
AAheadernone2011-10-03 01:46:28.4071342011-10-03 01:46:28.407134F
AArightnone2011-10-03 01:46:28.4047942011-10-03 01:46:28.404794E
AAleftnone2011-10-03 01:46:28.4023222011-10-03 01:46:28.402322E
AAbodynone2011-10-03 01:46:28.3993742011-10-03 01:46:28.399374G
AAfooternone2011-10-03 01:46:00.2716972011-10-03 01:46:00.271697G
AAheadernone2011-10-03 01:46:00.2693972011-10-03 01:46:00.269397
+/ q(Q w/ F$
AAstuffnone2011-10-22 18:09:13.3641182011-10-22 18:09:13.364118G#
AAfooternone2011-10-13 00:35:37.2026402011-10-13 00:35:37.202640G"
AAheadernone2011-10-13 00:35:37.1999982011-10-13 00:35:37.199998F!
AArightnone2011-10-13 00:35:37.1974882011-10-13 00:35:37.197488E
AAleftnone2011-10-13 00:35:37.1949532011-10-13 00:35:37.194953E
AAbodynone2011-10-13 00:35:37.1918002011-10-13 00:35:37.191800G
AAfooternone2011-10-03 01:46:58.4020102011-10-03 01:46:58.402010G
AAheadernone2011-10-03 01:46:58.3985722011-10-03 01:46:58.398572F
AArightnone2011-10-03 01:46:58.3941672011-10-03 01:46:58.394167E
AAleftnone2011-10-03 01:46:58.3873952011-10-03 01:46:58.387395
\ No newline at end of file