spec/dummy/log/development.log in trusty-cms-2.0.10.pre.beta vs spec/dummy/log/development.log in trusty-cms-2.0.11

- old
+ new

@@ -1012,5 +1012,161 @@ AND fk.table_schema = 'trusty_cms_dev' AND fk.table_name = 'users'  (0.1ms) SHOW CREATE TABLE `users` ActiveRecord::SchemaMigration Load (0.2ms) SELECT `schema_migrations`.* FROM `schema_migrations` +  (0.5ms) SELECT DISTINCT class_name FROM pages WHERE class_name <> '' AND class_name IS NOT NULL +  (59.7ms) DROP DATABASE IF EXISTS `trusty_cms_test` +  (0.7ms) CREATE DATABASE `trusty_cms_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci` +  (31.0ms) CREATE TABLE `config` (`id` int(11) auto_increment PRIMARY KEY, `key` varchar(40) DEFAULT '' NOT NULL, `value` varchar(255) DEFAULT '') ENGINE=InnoDB +  (33.8ms) CREATE UNIQUE INDEX `key` USING btree ON `config` (`key`)  +  (15.3ms) CREATE TABLE `extension_meta` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(255), `schema_version` int(11) DEFAULT 0, `enabled` tinyint(1) DEFAULT 1) ENGINE=InnoDB +  (18.5ms) CREATE TABLE `layouts` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(100), `content` text, `created_at` datetime, `updated_at` datetime, `created_by_id` int(11), `updated_by_id` int(11), `content_type` varchar(40), `lock_version` int(11) DEFAULT 0) ENGINE=InnoDB +  (17.2ms) CREATE TABLE `page_fields` (`id` int(11) auto_increment PRIMARY KEY, `page_id` int(11), `name` varchar(255), `content` varchar(255)) ENGINE=InnoDB +  (17.0ms) CREATE INDEX `index_page_fields_on_page_id_and_name_and_content` USING btree ON `page_fields` (`page_id`, `name`, `content`)  +  (18.1ms) CREATE TABLE `page_parts` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(100), `filter_id` varchar(25), `content` mediumtext, `page_id` int(11)) ENGINE=InnoDB +  (21.3ms) CREATE INDEX `parts_by_page` USING btree ON `page_parts` (`page_id`, `name`)  +  (20.0ms) CREATE TABLE `pages` (`id` int(11) auto_increment PRIMARY KEY, `title` varchar(255), `slug` varchar(100), `breadcrumb` varchar(160), `class_name` varchar(25), `status_id` int(11) DEFAULT 1 NOT NULL, `parent_id` int(11), `layout_id` int(11), `created_at` datetime, `updated_at` datetime, `published_at` datetime, `created_by_id` int(11), `updated_by_id` int(11), `virtual` tinyint(1) DEFAULT 0 NOT NULL, `lock_version` int(11) DEFAULT 0, `allowed_children_cache` text) ENGINE=InnoDB +  (19.8ms) CREATE INDEX `pages_class_name` USING btree ON `pages` (`class_name`)  +  (19.6ms) CREATE INDEX `pages_parent_id` USING btree ON `pages` (`parent_id`) +  (23.3ms) CREATE INDEX `pages_child_slug` USING btree ON `pages` (`slug`, `parent_id`)  +  (36.3ms) CREATE INDEX `pages_published` USING btree ON `pages` (`virtual`, `status_id`) +  (13.0ms) CREATE TABLE `sessions` (`id` int(11) auto_increment PRIMARY KEY, `session_id` varchar(255), `data` text, `updated_at` datetime) ENGINE=InnoDB +  (19.9ms) CREATE INDEX `index_sessions_on_session_id` USING btree ON `sessions` (`session_id`) +  (19.6ms) CREATE INDEX `index_sessions_on_updated_at` USING btree ON `sessions` (`updated_at`)  +  (18.3ms) CREATE TABLE `snippets` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(100) DEFAULT '' NOT NULL, `filter_id` varchar(25), `content` text, `created_at` datetime, `updated_at` datetime, `created_by_id` int(11), `updated_by_id` int(11), `lock_version` int(11) DEFAULT 0) ENGINE=InnoDB +  (22.7ms) CREATE UNIQUE INDEX `name` USING btree ON `snippets` (`name`)  +  (22.1ms) CREATE TABLE `users` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(100), `email` varchar(255), `login` varchar(40) DEFAULT '' NOT NULL, `password` varchar(40), `created_at` datetime, `updated_at` datetime, `created_by_id` int(11), `updated_by_id` int(11), `admin` tinyint(1) DEFAULT 0 NOT NULL, `designer` tinyint(1) DEFAULT 0 NOT NULL, `notes` text, `lock_version` int(11) DEFAULT 0, `salt` varchar(255), `session_token` varchar(255), `locale` varchar(255)) ENGINE=InnoDB +  (20.5ms) CREATE UNIQUE INDEX `login` USING btree ON `users` (`login`)  +  (25.3ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB +  (32.3ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  +  (0.3ms) SELECT version FROM `schema_migrations` +  (0.4ms) INSERT INTO `schema_migrations` (version) VALUES ('20120209231801') +  (0.7ms) INSERT INTO `schema_migrations` (version) VALUES ('1') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('2') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('4') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('5') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('7') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('8') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('9') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('12') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('13') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('14') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('15') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('16') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('17') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('18') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('21') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20081203140407') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20090226140109') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20090929164633') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20091003095744') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20100805154952') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20100805155020') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20100810151922') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20110902203823') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20111016150725') +  (0.2ms) SELECT DISTINCT class_name FROM pages WHERE class_name <> '' AND class_name IS NOT NULL +  (17.0ms) DROP DATABASE IF EXISTS `trusty_cms_test` +  (0.6ms) CREATE DATABASE `trusty_cms_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci` +  (24.2ms) CREATE TABLE `config` (`id` int(11) auto_increment PRIMARY KEY, `key` varchar(40) DEFAULT '' NOT NULL, `value` varchar(255) DEFAULT '') ENGINE=InnoDB +  (27.2ms) CREATE UNIQUE INDEX `key` USING btree ON `config` (`key`)  +  (21.3ms) CREATE TABLE `extension_meta` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(255), `schema_version` int(11) DEFAULT 0, `enabled` tinyint(1) DEFAULT 1) ENGINE=InnoDB +  (18.3ms) CREATE TABLE `layouts` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(100), `content` text, `created_at` datetime, `updated_at` datetime, `created_by_id` int(11), `updated_by_id` int(11), `content_type` varchar(40), `lock_version` int(11) DEFAULT 0) ENGINE=InnoDB +  (14.6ms) CREATE TABLE `page_fields` (`id` int(11) auto_increment PRIMARY KEY, `page_id` int(11), `name` varchar(255), `content` varchar(255)) ENGINE=InnoDB +  (21.1ms) CREATE INDEX `index_page_fields_on_page_id_and_name_and_content` USING btree ON `page_fields` (`page_id`, `name`, `content`)  +  (27.1ms) CREATE TABLE `page_parts` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(100), `filter_id` varchar(25), `content` mediumtext, `page_id` int(11)) ENGINE=InnoDB +  (28.3ms) CREATE INDEX `parts_by_page` USING btree ON `page_parts` (`page_id`, `name`)  +  (29.2ms) CREATE TABLE `pages` (`id` int(11) auto_increment PRIMARY KEY, `title` varchar(255), `slug` varchar(100), `breadcrumb` varchar(160), `class_name` varchar(25), `status_id` int(11) DEFAULT 1 NOT NULL, `parent_id` int(11), `layout_id` int(11), `created_at` datetime, `updated_at` datetime, `published_at` datetime, `created_by_id` int(11), `updated_by_id` int(11), `virtual` tinyint(1) DEFAULT 0 NOT NULL, `lock_version` int(11) DEFAULT 0, `allowed_children_cache` text) ENGINE=InnoDB +  (23.8ms) CREATE INDEX `pages_class_name` USING btree ON `pages` (`class_name`)  +  (33.7ms) CREATE INDEX `pages_parent_id` USING btree ON `pages` (`parent_id`) +  (32.2ms) CREATE INDEX `pages_child_slug` USING btree ON `pages` (`slug`, `parent_id`)  +  (26.1ms) CREATE INDEX `pages_published` USING btree ON `pages` (`virtual`, `status_id`) +  (30.7ms) CREATE TABLE `sessions` (`id` int(11) auto_increment PRIMARY KEY, `session_id` varchar(255), `data` text, `updated_at` datetime) ENGINE=InnoDB +  (57.5ms) CREATE INDEX `index_sessions_on_session_id` USING btree ON `sessions` (`session_id`) +  (31.4ms) CREATE INDEX `index_sessions_on_updated_at` USING btree ON `sessions` (`updated_at`)  +  (35.8ms) CREATE TABLE `snippets` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(100) DEFAULT '' NOT NULL, `filter_id` varchar(25), `content` text, `created_at` datetime, `updated_at` datetime, `created_by_id` int(11), `updated_by_id` int(11), `lock_version` int(11) DEFAULT 0) ENGINE=InnoDB +  (21.6ms) CREATE UNIQUE INDEX `name` USING btree ON `snippets` (`name`)  +  (20.6ms) CREATE TABLE `users` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(100), `email` varchar(255), `login` varchar(40) DEFAULT '' NOT NULL, `password` varchar(40), `created_at` datetime, `updated_at` datetime, `created_by_id` int(11), `updated_by_id` int(11), `admin` tinyint(1) DEFAULT 0 NOT NULL, `designer` tinyint(1) DEFAULT 0 NOT NULL, `notes` text, `lock_version` int(11) DEFAULT 0, `salt` varchar(255), `session_token` varchar(255), `locale` varchar(255)) ENGINE=InnoDB +  (20.9ms) CREATE UNIQUE INDEX `login` USING btree ON `users` (`login`)  +  (21.5ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB +  (24.9ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  +  (0.3ms) SELECT version FROM `schema_migrations` +  (0.4ms) INSERT INTO `schema_migrations` (version) VALUES ('20120209231801') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('1') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('2') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('4') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('5') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('7') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('8') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('9') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('12') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('13') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('14') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('15') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('16') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('17') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('18') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('21') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20081203140407') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20090226140109') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20090929164633') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20091003095744') +  (0.5ms) INSERT INTO `schema_migrations` (version) VALUES ('20100805154952') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20100805155020') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20100810151922') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20110902203823') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20111016150725') +  (0.3ms) SELECT DISTINCT class_name FROM pages WHERE class_name <> '' AND class_name IS NOT NULL +  (18.0ms) DROP DATABASE IF EXISTS `trusty_cms_test` +  (0.6ms) CREATE DATABASE `trusty_cms_test` DEFAULT CHARACTER SET `utf8` COLLATE `utf8_unicode_ci` +  (25.6ms) CREATE TABLE `config` (`id` int(11) auto_increment PRIMARY KEY, `key` varchar(40) DEFAULT '' NOT NULL, `value` varchar(255) DEFAULT '') ENGINE=InnoDB +  (32.6ms) CREATE UNIQUE INDEX `key` USING btree ON `config` (`key`)  +  (25.0ms) CREATE TABLE `extension_meta` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(255), `schema_version` int(11) DEFAULT 0, `enabled` tinyint(1) DEFAULT 1) ENGINE=InnoDB +  (26.5ms) CREATE TABLE `layouts` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(100), `content` text, `created_at` datetime, `updated_at` datetime, `created_by_id` int(11), `updated_by_id` int(11), `content_type` varchar(40), `lock_version` int(11) DEFAULT 0) ENGINE=InnoDB +  (16.2ms) CREATE TABLE `page_fields` (`id` int(11) auto_increment PRIMARY KEY, `page_id` int(11), `name` varchar(255), `content` varchar(255)) ENGINE=InnoDB +  (23.6ms) CREATE INDEX `index_page_fields_on_page_id_and_name_and_content` USING btree ON `page_fields` (`page_id`, `name`, `content`)  +  (27.7ms) CREATE TABLE `page_parts` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(100), `filter_id` varchar(25), `content` mediumtext, `page_id` int(11)) ENGINE=InnoDB +  (25.9ms) CREATE INDEX `parts_by_page` USING btree ON `page_parts` (`page_id`, `name`)  +  (23.2ms) CREATE TABLE `pages` (`id` int(11) auto_increment PRIMARY KEY, `title` varchar(255), `slug` varchar(100), `breadcrumb` varchar(160), `class_name` varchar(25), `status_id` int(11) DEFAULT 1 NOT NULL, `parent_id` int(11), `layout_id` int(11), `created_at` datetime, `updated_at` datetime, `published_at` datetime, `created_by_id` int(11), `updated_by_id` int(11), `virtual` tinyint(1) DEFAULT 0 NOT NULL, `lock_version` int(11) DEFAULT 0, `allowed_children_cache` text) ENGINE=InnoDB +  (19.5ms) CREATE INDEX `pages_class_name` USING btree ON `pages` (`class_name`)  +  (35.7ms) CREATE INDEX `pages_parent_id` USING btree ON `pages` (`parent_id`) +  (34.0ms) CREATE INDEX `pages_child_slug` USING btree ON `pages` (`slug`, `parent_id`)  +  (29.7ms) CREATE INDEX `pages_published` USING btree ON `pages` (`virtual`, `status_id`) +  (27.8ms) CREATE TABLE `sessions` (`id` int(11) auto_increment PRIMARY KEY, `session_id` varchar(255), `data` text, `updated_at` datetime) ENGINE=InnoDB +  (32.6ms) CREATE INDEX `index_sessions_on_session_id` USING btree ON `sessions` (`session_id`) +  (27.4ms) CREATE INDEX `index_sessions_on_updated_at` USING btree ON `sessions` (`updated_at`)  +  (29.3ms) CREATE TABLE `snippets` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(100) DEFAULT '' NOT NULL, `filter_id` varchar(25), `content` text, `created_at` datetime, `updated_at` datetime, `created_by_id` int(11), `updated_by_id` int(11), `lock_version` int(11) DEFAULT 0) ENGINE=InnoDB +  (23.5ms) CREATE UNIQUE INDEX `name` USING btree ON `snippets` (`name`)  +  (31.8ms) CREATE TABLE `users` (`id` int(11) auto_increment PRIMARY KEY, `name` varchar(100), `email` varchar(255), `login` varchar(40) DEFAULT '' NOT NULL, `password` varchar(40), `created_at` datetime, `updated_at` datetime, `created_by_id` int(11), `updated_by_id` int(11), `admin` tinyint(1) DEFAULT 0 NOT NULL, `designer` tinyint(1) DEFAULT 0 NOT NULL, `notes` text, `lock_version` int(11) DEFAULT 0, `salt` varchar(255), `session_token` varchar(255), `locale` varchar(255)) ENGINE=InnoDB +  (28.2ms) CREATE UNIQUE INDEX `login` USING btree ON `users` (`login`)  +  (24.5ms) CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL) ENGINE=InnoDB +  (30.6ms) CREATE UNIQUE INDEX `unique_schema_migrations` ON `schema_migrations` (`version`)  +  (0.2ms) SELECT version FROM `schema_migrations` +  (0.4ms) INSERT INTO `schema_migrations` (version) VALUES ('20120209231801') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('1') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('2') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('4') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('5') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('7') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('8') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('9') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('12') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('13') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('14') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('15') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('16') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('17') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('18') +  (0.3ms) INSERT INTO `schema_migrations` (version) VALUES ('20') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('21') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20081203140407') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20090226140109') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20090929164633') +  (0.6ms) INSERT INTO `schema_migrations` (version) VALUES ('20091003095744') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20100805154952') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20100805155020') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20100810151922') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20110902203823') +  (0.2ms) INSERT INTO `schema_migrations` (version) VALUES ('20111016150725')