SQLite format 3 @ X P - Tk s [!Iindexindex_connectors_on_connectable_versionconnectors CREATE INDEX "index_connectors_on_connectable_version" ON "connectors" ("connectable_version")
U!=indexindex_connectors_on_connectable_typeconnectors CREATE INDEX "index_connectors_on_connectable_type" ON "connectors" ("connectable_type")_ !! tableconnectorsconnectors
CREATE TABLE "connectors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer, "page_version" integer, "connectable_id" integer, "connectable_type" varchar(255), "connectable_version" integer, "container" varchar(255), "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)N++Stablecms_attachmentscms_attachments CREATE TABLE "cms_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" integer, "lock_version" integer DEFAULT 0, "data_file_path" varchar(255), "file_location" varchar(255), "data_content_type" varchar(255), "data_file_size" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "data_file_name" varchar(255), "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer, "data_fingerprint" varchar(255), "attachable_type" varchar(255), "attachment_name" varchar(255), "attachable_id" integer, "attachable_version" integer, "cardinality" varchar(255))Ek;qindexindex_attachment_versions_on_original_record_idcms_attachment_versionsCREATE INDEX "index_attachment_versions_on_original_record_id" ON "cms_attachment_versions" ("original_record_id");;tablecms_attachment_versionscms_attachment_versionsCREATE TABLE "cms_attachment_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_record_id" integer, "version" integer, "data_file_path" varchar(255), "file_location" varchar(255), "data_content_type" varchar(255), "data_file_size" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "data_file_name" varchar(255), "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, "updated_by_id" integer, "data_fingerprint" varchar(255), "attachable_type" varchar(255), "attachment_name" varchar(255), "attachable_id" integer, "attachable_version" integer, "cardinality" varchar(255))M))Utablecategory_typescategory_typesCREATE TABLE "category_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)r!!/tablecategoriescategoriesCREATE TABLE "categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_type_id" integer, "parent_id" integer, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)S99Atablebcms_bitly_short_linksbcms_bitly_short_linksCREATE TABLE "bcms_bitly_short_links" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" integer, "lock_version" integer DEFAULT 0, "url" varchar(255), "page_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(255), "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)II tablebcms_bitly_short_link_versionsbcms_bitly_short_link_versionsCREATE TABLE "bcms_bitly_short_link_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_record_id" integer, "version" integer, "url" varchar(255), "page_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(255), "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, >C 23 *
cLA3 !connectors3html_block_versions#html_blocks'page_versions pages
)group_sections 'section_nodes sections
sites /group_permissions9user_group_memberships
groups9group_type_permissions#group_types#permissions'content_types3content_type_groups users
P V )AACms::HtmlBlockmain2012-05-16 19:50:13.5506902012-05-16 19:50:13.550690V )AACms::HtmlBlockmain2012-05-16 19:50:13.4595152012-05-16 19:50:13.459515V )AACms::HtmlBlockmain2012-05-16 19:50:13.4227362012-05-16 19:50:13.422736
)Cms::HtmlBlock)Cms::HtmlBlock)Cms::HtmlBlock
e;0 a II tablebcms_bitly_short_link_versionsbcms_bitly_short_link_versionsCREATE TABLE "bcms_bitly_short_link_versions" II tablebcms_bitly_short_link_versionsbcms_bitly_short_link_versionsCREATE TABLE "bcms_bitly_short_link_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_record_id" integer, "version" integer, "url" varchar(255), "page_id" integer, "created_at" datetime NOT NULL, "updated_at" dateII tablebcms_bitly_short_link_versionsbcms_bitly_short_link_versionsCREATE TABLE "bcms_bitly_short_link_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_record_id" integer, "version" integer, "url" varchar(255), "page_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(255), "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, "updated_by_id" integer)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)S99Atablebcms_bitly_short_linksbcms_bitly_short_linksCREATE TABLE "bcms_bitly_short_links" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" integer, "lock_version" integer DEFAULT 0, "url" varchar(255), "page_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "name" varchar(255), "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer)r!!/tablecategoriescategoriesCREATE TABLE "categories" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "category_type_id" integer, "parent_id" integer, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)M))Utablecategory_typescategory_typesCREATE TABLE "category_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL);;tablecms_attachment_versionscms_attachment_versionsCREATE TABLE "cms_attachment_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_record_id" integer, "version" integer, "data_file_path" varchar(255), "file_location" varchar(255), "data_content_type" varchar(255), "data_file_size" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "data_file_name" varchar(255), "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, "updated_by_id" integer, "data_fingerprint" varchar(255), "attachable_type" varchar(255), "attachment_name" varchar(255), "attachable_id" integer, "attachable_version" integer, "cardinality" varchar(255))Ek;qindexindex_attachment_versions_on_original_record_idcms_attachment_versionsCREATE INDEX "index_attachment_versions_on_original_record_id" ON "cms_attachment_versions" ("original_record_id")N++Stablecms_attachmentscms_attachments CREATE TABLE "cms_attachments" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" integer, "lock_version" integer DEFAULT 0, "data_file_path" varchar(255), "file_location" varchar(255), "data_content_type" varchar(255), "data_file_size" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "data_file_name" varchar(255), "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer, "data_fingerprint" varchar(255), "attachable_type" varchar(255), "attachment_name" varchar(255), "attachable_id" integer, "attachable_version" integer, "cardinality" varchar(255))_ !! tableconnectorsconnectors
CREATE TABLE "connectors" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_id" integer, "page_version" integer, "connectable_id" integer, "connectable_type" varchar(255), "connectable_version" integer, "container" varchar(255), "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
)- F _ D a \ X s?#indexindex_file_blocks_on_typefile_blocks CREATE INDEX "index_file_blocks_on_type" ON "file_blocks" ("type")|E# indexindex_file_blocks_on_deletedfile_blocks CREATE INDEX "index_file_blocks_on_deleted" ON "file_blocks" ("deleted")x C!indexindex_connectors_on_page_idconnectors
CREATE INDEX "index_connectors_on_page_id" ON "connectors" ("page_id")
M!-indexindex_connectors_on_page_ver
U!=indexindex_connectors_on_connectable_typeconnectors CREATE INDEX "index_connectors_on_connectable_type" ON "connectors" ("connectable_type") [!Iindexindex_connectors_on_connectable_versionconnectors CREATE INDEX "index_connectors_on_connectable_version" ON "connectors" ("connectable_version")x C!indexindex_connectors_on_page_idconnectors
CREATE INDEX "index_connectors_on_page_id" ON "connectors" ("page_id")
M!-indexindex_connectors_on_page_versionconnectorsCREATE INDEX "index_connectors_on_page_version" ON "connectors" ("page_version")\33_tablecontent_type_groupscontent_type_groupsCREATE TABLE "content_type_groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) ''Qtablecontent_typescontent_typesCREATE TABLE "content_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "content_type_group_id" integer, "priority" integer DEFAULT 2, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL).e']indexindex_content_types_on_content_type_group_idcontent_typesCREATE INDEX "index_content_types_on_content_type_group_id" ON "content_types" ("content_type_group_id"){C'indexindex_content_types_on_namecontent_typesCREATE INDEX "index_content_types_on_name" ON "content_types" ("name")77Ktabledynamic_view_versionsdynamic_view_versionsCREATE TABLE "dynamic_view_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_record_id" integer, "version" integer, "type" varchar(255), "name" varchar(255), "format" varchar(255), "handler" varchar(255), "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, "updated_by_id" integer)b''tabledynamic_viewsdynamic_viewsCREATE TABLE "dynamic_views" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" integer, "lock_version" integer DEFAULT 0, "type" varchar(255), "name" varchar(255), "format" varchar(255), "handler" varchar(255), "body" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer)L))Stableemail_messagesemail_messagesCREATE TABLE "email_messages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "sender" varchar(255), "recipients" text, "subject" text, "cc" text, "bcc" text, "body" text, "content_type" varchar(255), "delivered_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) 33=tablefile_block_versionsfile_block_versionsCREATE TABLE "file_block_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_record_id" integer, "version" integer, "type" varchar(255), "name" varchar(255), "attachment_id" integer, "attachment_version" integer, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, "updated_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=k3iindexindex_file_block_versions_on_original_record_idfile_block_versionsCREATE INDEX "index_file_block_versions_on_original_record_id" ON "file_block_versions" ("original_record_id") U3=indexindex_file_block_versions_on_versionfile_block_versionsCREATE INDEX "index_file_block_versions_on_version" ON "file_block_versions" ("version")
x x = AACore2012-05-16 19:50:12.6810282012-05-16 19:50:12.681028G )AACategorization2012-05-16 19:50:12.6644852012-05-16 19:50:12.664485
d 8
L +AACms::ImageBlock2012-05-16 19:50:12.6935432012-05-16 19:50:12.693543K )AACms::FileBlock2012-05-16 19:50:12.6892912012-05-16 19:50:12.689291I %AACms::Portlet2012-05-16 19:50:12.6853012012-05-16 19:50:12.685301K )AACms::HtmlBlock2012-05-16 19:50:12.6818392012-05-16 19:50:12.681839E AACms::Tag2012-05-16 19:50:12.6768152012-05-16 19:50:12.676815J 'AACms::Category2012-05-16 19:50:12.6720402012-05-16 19:50:12.672040N /AACms::CategoryType2012-05-16 19:50:12.6661942012-05-16 19:50:12.666194
+Cms::ImageBlock)Cms::FileBlock%Cms::Portlet)Cms::HtmlBlock Cms::Tag'Cms::Category/Cms::CategoryType
Y Y3&@ u
{ I a
|,E# indexindex_html_blocks_on_deletedhtml_blocks0CREATE INDEX "index_htW##utablefile_blocksfile_blocksCREATE TABLE "file_blocks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" integer, "lock_version" integer DEFAULT 0, "type" varchar(255), "name" varchar(255), "attachment_id" integer, "attachment_version" integer, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)|E# indexindex_file_blocks_on_deletedfile_blocks CREATE INDEX "index_file_blocks_on_deleted" ON "file_blocks" ("deleted")s?#indexindex_file_blocks_on_typefile_blocks CREATE INDEX "index_file_blocks_on_type" ON "file_blocks" ("type").// tablegroup_permissionsgroup_permissions CREATE TABLE "group_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "group_id" integer, "permission_id" integer)L w/indexindex_group_permissions_on_group_id_and_permission_idgroup_permissions CREATE INDEX "index_group_permissions_on_group_id_and_permission_id" ON "group_permissions" ("group_id", "permission_id") S/9indexindex_group_permissions_on_group_idgroup_permissions!CREATE INDEX "index_group_permissions_on_group_id" ON "group_permissions" ("group_id")& ]/Mindexindex_group_permissions_on_permission_idgroup_permissions"CREATE INDEX "index_group_permissions_on_permission_id" ON "group_permissions" ("permission_id")" ))tablegroup_sectionsgroup_sections#CREATE TABLE "group_sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "group_id" integer, "section_id" integer) M)-indexindex_group_sections_on_group_idgroup_sections$CREATE INDEX "index_group_sections_on_group_id" ON "group_sections" ("group_id")!Q)5indexindex_group_sections_on_section_idgroup_sections%CREATE INDEX "index_group_sections_on_section_id" ON "group_sections" ("section_id")B"99 tablegroup_type_permissionsgroup_type_permissions&CREATE TABLE "group_type_permissions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "group_type_id" integer, "permission_id" integer)###Mtablegroup_typesgroup_types'CREATE TABLE "group_types" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "guest" boolean DEFAULT 'f', "cms_access" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)$K#)indexindex_group_types_on_cms_accessgroup_types(CREATE INDEX "index_group_types_on_cms_access" ON "group_types" ("cms_access")c%!tablegroupsgroups)CREATE TABLE "groups" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "code" varchar(255), "group_type_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)^&5}indexindex_groups_on_codegroups*CREATE INDEX "index_groups_on_code" ON "groups" ("code")z'G!indexindex_groups_on_group_type_idgroups+CREATE INDEX "index_groups_on_group_type_id" ON "groups" ("group_type_id")Y(33Ytablehtml_block_versionshtml_block_versions,CREATE TABLE "html_block_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_record_id" integer, "version" integer, "name" varchar(255), "content" varchar(65537), "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, "updated_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)=)k3iindexindex_html_block_versions_on_original_record_idhtml_block_versions-CREATE INDEX "index_html_block_versions_on_original_record_id" ON "html_block_versions" ("original_record_id") *U3=indexindex_html_block_versions_on_versionhtml_block_versions.CREATE INDEX "index_html_block_versions_on_version" ON "html_block_versions" ("version")
g E AACMS Userft2012-05-16 19:50:12.7512922012-05-16 19:50:12.751292S 9AARegistered Public Userff2012-05-16 19:50:12.7474842012-05-16 19:50:12.747484B AAGuesttf2012-05-16 19:50:12.7431182012-05-16 19:50:12.743118
tff
_ Y +)AAContent Editorscontent-editor2012-05-16 19:50:12.8626472012-05-16 19:50:12.862647W 1 AACms Administratorscms-admin2012-05-16 19:50:12.8585372012-05-16 19:50:12.858537F AAGuestguest2012-05-16 19:50:12.8535302012-05-16 19:50:12.853530
)content-editor
cms-admin guest
\
A %UAAServer ErrorThe server encountered an unexpected condition that prevented it from fulfilling the request.
tffCreated2012-05-16 19:50:13.5293292012-05-16 19:50:13.5363319 'CAAAccess DeniedYou have tried to reach a resource or page which you do not have permission to view.
tffCreated2012-05-16 19:50:13.4397922012-05-16 19:50:13.445140! )AAPage Not FoundThe page you tried to access does not exist on this server.
tffCreated2012-05-16 19:50:13.3799872012-05-16 19:50:13.394790
d
9 %UAA Server ErrorThe server encountered an unexpected condition that prevented it from fulfilling the request.
tff2012-05-16 19:50:13.4749732012-05-16 19:50:13.4749731 'CAA Access DeniedYou have tried to reach a resource or page which you do not have permission to view.
tff2012-05-16 19:50:13.4383622012-05-16 19:50:13.438362 )AA Page Not FoundThe page you tried to access does not exist on this server.
tff2012-05-16 19:50:13.3729282012-05-16 19:50:13.372928
fff
-] }
|
& A %+##tablehtml_blockshtml_blocks/CREATE TABLE "html_blocks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" integer, "lock_version" integer DEFAULT 0, "name" varchar(255), "content" varchar(65537), "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)|,E# indexindex_html_blocks_on_deletedhtml_blocks0CREATE INDEX "index_html_blocks_on_deleted" ON "html_blocks" ("deleted")c-''tablelink_versio%+##tablehtml_blockshtml_blocks/CREATE TABLE "html_blocks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" integer, "lock_version" integer DEFAULT 0, "name" varchar(255), "content" varchar(65537), "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)|,E# indexindex_html_blocks_on_deletedhtml_blocks0CREATE INDEX "index_html_blocks_on_deleted" ON "html_blocks" ("deleted")c-''tablelink_versionslink_versions1CREATE TABLE "link_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_record_id" integer, "version" integer, "name" varchar(255), "url" varchar(255), "new_window" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, "updated_by_id" integer)I.qtablelinkslinks3CREATE TABLE "links" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" integer, "lock_version" integer DEFAULT 0, "name" varchar(255), "url" varchar(255), "new_window" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer, "latest_version" integer) /11etablepage_route_optionspage_route_options4CREATE TABLE "page_route_options" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "page_route_id" integer, "type" varchar(255), "name" varchar(255), "value" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)|0##?tablepage_routespage_routes5CREATE TABLE "page_routes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "pattern" varchar(255), "page_id" integer, "code" text, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)x1''/tablepage_versionspage_versions6CREATE TABLE "page_versions" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "original_record_id" integer, "version" integer, "name" varchar(255), "title" varchar(255), "path" varchar(255), "template_file_name" varchar(255), "description" text, "keywords" text, "language" varchar(255), "cacheable" boolean DEFAULT 'f', "hidden" boolean DEFAULT 'f', "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "version_comment" varchar(255), "created_by_id" integer, "updated_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)%2_'Qindexindex_page_versions_on_original_record_idpage_versions7CREATE INDEX "index_page_versions_on_original_record_id" ON "page_versions" ("original_record_id")^3tablepagespages8CREATE TABLE "pages" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "version" integer, "lock_version" integer DEFAULT 0, "name" varchar(255), "title" varchar(255), "path" varchar(255), "template_file_name" varchar(255), "description" text, "keywords" text, "language" varchar(255), "cacheable" boolean DEFAULT 'f', "hidden" boolean DEFAULT 'f', "published" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "archived" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "latest_version" integer)
w
) e > % 5- AAServer Error/system/server_errordefault.html.erbtttffHtml Block 'Server Error' was added to the 'main' container2012-05-16 19:50:13.5461312012-05-16 19:50:13.546131A ' 7- AAAccess Denied/system/access_denieddefault.html.erbtttffHtml Block 'Access Denied' was added to the 'main' container2012-05-16 19:50:13.4547942012-05-16 19:50:13.454794? ) /- AAPage Not Found/system/not_founddefault.html.erbtttffHtml Block 'Page Not Found' was added to the 'main' container2012-05-16 19:50:13.4068102012-05-16 19:50:13.406810 % 5- AAServer Error/system/server_errordefault.html.erbtttffCreated2012-05-16 19:50:13.3209732012-05-16 19:50:13.326960 ' 7- AAAccess Denied/system/access_denieddefault.html.erbtttffCreated2012-05-16 19:50:13.2987442012-05-16 19:50:13.304859 ) /- AAPage Not Found/system/not_founddefault.html.erbtttffCreated2012-05-16 19:50:13.2789712012-05-16 19:50:13.284286n - AAHome/default.html.erbtftffCreated2012-05-16 19:50:13.2125872012-05-16 19:50:13.563993
% 5- AA Server Error/system/server_errordefault.html.erbtttff2012-05-16 19:50:13.3189372012-05-16 19:50:13.318937 ' 7- AA Access Denied/system/access_denieddefault.html.erbtttff2012-05-16 19:50:13.2971482012-05-16 19:50:13.297148 ) /- AA Page Not Found/system/not_founddefault.html.erbtttff2012-05-16 19:50:13.2772642012-05-16 19:50:13.277264h - AA Home/default.html.erbtftff2012-05-16 19:50:13.2043062012-05-16 19:50:13.204306
ffff
5/system/server_error7/system/access_denied//system/not_found/
`
$ ++ AApublish_contentPublish ContentAllows users to Save and Publish, Hide and Archive both Pages and Blocks.2012-05-16 19:50:12.7214682012-05-16 19:50:12.721468D %%k AAedit_contentEdit ContentAllows users to Add, Edit and Delete both Pages and Blocks. Can Save (but not Publish) and Assign them as well.2012-05-16 19:50:12.7162032012-05-16 19:50:12.716203 %) AAadministrateAdminister CMSAllows users to administer the CMS, including adding users and groups.2012-05-16 19:50:12.7101512012-05-16 19:50:12.710151
9w
$ ~
kFv dI9indexindex_tasks_on_page_idtasks (L[9Iindexindex_user_group_memberships_on_user_iduser_group_membershipsRCREATE INDEX "index_user_group_memberships_on_user_id" ON "user_group_memberships" ("user_id")+K]9Mindexindex_user_group_memberships_on_group_iduser_group_membershipsQCREATE INDEX "index_user_group_memberships_on_group_id" ON "user_group_memberships" ("group_id")=811%tableportlet_attributesportlet_attributes=CREATE TABLE "portlet_attributes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "portlet_id" integer, "name" varchar(255), "value" text)!9Y1Eindexindex_portlet_attributes_on_portlet_idportlet_attributes?CREATE INDEX "index_portlet_attributes_on_portlet_id" ON "portlet_attributes" ("portlet_id")A: Utableportletsportlets@CREATE TABLE "portlets" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "type" varchar(255), "name" varchar(255), "archived" boolean DEFAULT 'f', "deleted" boolean DEFAULT 'f', "created_by_id" integer, "updated_by_id" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)g;9 d49indexindex_pages_on_deletedpages9CREATE INDEX "index_pages_on_deleted" ON "pages" ("deleted")Z53yindexindex_pages_on_pathpages:CREATE INDEX "index_pages_on_path" ON "pages" ("path")d69indexindex_pages_on_versionpages;CREATE INDEX "index_pages_on_version" ON "pages" ("version")7##qtablepermissionspermissions'']tablesection_nodessection_nodesDCREATE TABLE "section_nodes" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "node_type" varchar(255), "node_id" integer, "position" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL, "ancestry" varchar(255))?K')indexindex_section_nodes_on_ancestrysection_nodesECREATE INDEX "index_section_nodes_on_ancestry" ON "section_nodes" ("ancestry")
@M'-indexindex_section_nodes_on_node_typesection_nodesFCREATE INDEX "index_section_nodes_on_node_type" ON "section_nodes" ("node_type")
A gtablesectionssectionsGCREATE TABLE "sections" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "path" varchar(255), "root" boolean DEFAULT 'f', "hidden" boolean DEFAULT 'f', "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)gB9 indexindex_sections_on_pathsectionsHCREATE INDEX "index_sections_on_path" ON "sections" ("path")`C tablesitessitesICREATE TABLE "sites" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "domain" varchar(255), "the_default" boolean, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)
9 g 9 J AACms::Page2012-05-16 19:50:13.3233682012-05-16 19:50:13.3233681/2J AACms::Page2012-05-16 19:50:13.3008292012-05-16 19:50:13.3008291/2J AACms::Page2012-05-16 19:50:13.2808602012-05-16 19:50:13.2808601/2H AACms::Page2012-05-16 19:50:13.2153372012-05-16 19:50:13.2153371K %AACms::Section2012-05-16 19:50:13.0342952012-05-16 19:50:13.0342951J %AA Cms::Section2012-05-16 19:50:13.0242212012-05-16 19:50:13.024221
1/21/21/211
Cms::Page
Cms::Page
Cms::Page
Cms::Page%Cms::Section%Cms::Section
k k K AAsystem/systemft2012-05-16 19:50:13.0322082012-05-16 19:50:13.032208F AAMy Site/tf2012-05-16 19:50:13.0206692012-05-16 19:50:13.020669
/system/
N #AADefaultexample.comt2012-05-16 19:50:12.9711192012-05-16 19:50:12.971119
? ? > '5]]AA cmsadminCMSAdministratorcmsadmin@example.com79f4e4d5799eec282f5e8e644e0a7f92c769f52b19e29ae697eb2ba85cbf492dc85c8860d7b421c92012-05-16 19:50:12.5749422012-05-16 19:50:12.574942
O " . | W
jLO Q=//indexunique_schema_migrationsschema_migrationsXCREATE UNIQUE INDEX "unique_schema_migrations" ON "schema_migrations" ("version")qP//tableschema_migrationsschema_migrationsWCREATE TABLE "schema_migrations" ("version" varchar(255) NOT NULL)eO5 indexindex_users_on_loginusersVCREATE UNIQUE INDEX "index_users_on_login" ON "users" ("login")mN?indexindex_users_on_expires_atusersUCREATE INDEX "index_users_on_expires_at" ON "users" ("expires_at") D etabletaggingstaggingsJCREATE TABLE "taggings" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "tag_id" integer, "taggable_id" integer, "taggable_type" varchar(255), "taggable_version" integer, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)/EAtabletagstagsKCREATE TABLE "tags" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL) FtabletaskstasksLCREATE TABLE "tasks" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "assigned_by_id" integer, "assigned_to_id" integer, "page_id" integer, "comment" text, "due_date" date, "completed_at" datetime, "created_at" datetime NOT NULL, "updated_at" datetime NOT NULL)yGG!indexindex_tasks_on_assigned_to_idtasksMCREATE INDEX "index_tasks_on_assigned_to_id" ON "tasks" ("assigned_to_id")sHCindexindex_tasks_on_completed_attasksNCREATE INDEX "index_tasks_on_completed_at" ON "tasks" ("completed_at")dI9indexindex_tasks_on_page_idtasksOCREATE INDEX "index_tasks_on_page_id" ON "tasks" ("page_id")7J99 tableuser_group_membershipsuser_group_membershipsPCREATE TABLE "user_group_memberships" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "user_id" integer, "group_id" integer)+K]9Mindexindex_user_group_memberships_on_group_iduser_group_membershipsQCREATE INDEX "index_user_group_memberships_on_group_id" ON "user_group_memberships" ("group_id")(L[9Iindexindex_user_group_memberships_on_user_iduser_group_membershipsRCREATE INDEX "index_user_group_memberships_on_user_id" ON "user_group_memberships" ("user_id")MtableusersusersSCREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "login" varchar(40), "first_name" varchar(40), "last_name" varchar(40), "email" varchar(40), "crypted_password" varchar(40), "salt" varchar(40), "created_at" datetime, "updated_at" datetime, "expires_at" datetime, "remember_token" varchar(40), "remember_token_expires_at" datetime, "reset_token" varchar(255))
cmsadmin
)20120515202558)20120515202557)20120515202556)20120515202555)20120515202554)20120515202553)20120516162513
{ { )20120515202558)20120515202557)20120515202556)20120515202555)20120515202554)20120515202553)20120516162513