text: CREATE INDEX wiki_contents_page_id ON wiki_contents 
  CREATE TABLE ' . $name . ' (id int(11) AUTO_INCREMENT, bool tinyint(1), small_int tinyint(2), primary key(id), KEY `pointless_bool` ( `bool` ), KEY `pointless_small_int` ( `small_int` ), KEY `one_way` ( `bool`, `small_int` ), KEY `other_way` ( `small_int`, `bool` ))
  INSERT INTO schema_migrations VALUES ('46')
  CREATE TABLE IF NOT EXISTS `{prefix}users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `login` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `hashed_password` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `firstname` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `lastname` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `mail` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `mail_notification` tinyint(1) NOT NULL DEFAULT '1', `admin` tinyint(1) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '1', `last_login_on` datetime DEFAULT NULL, `language` varchar(5) COLLATE utf8_unicode_ci DEFAULT '', `auth_source_id` int(11) DEFAULT NULL, `created_on` datetime DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`))
  CREATE TABLE IF NOT EXISTS `{prefix}journals` ( `id` int(11) NOT NULL AUTO_INCREMENT, `journalized_id` int(11) NOT NULL DEFAULT '0', `journalized_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `user_id` int(11) NOT NULL DEFAULT '0', `notes` text COLLATE utf8_unicode_ci, `created_on` datetime NOT NULL, PRIMARY KEY (`id`), KEY `journals_journalized_id` (`journalized_id`,`journalized_type`))
  CREATE TABLE IF NOT EXISTS `time_entries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `issue_id` int(11) DEFAULT NULL, `hours` float NOT NULL, `comments` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `activity_id` int(11) NOT NULL, `spent_on` date NOT NULL, `tyear` int(11) NOT NULL, `tmonth` int(11) NOT NULL, `tweek` int(11) NOT NULL, `created_on` datetime NOT NULL, `updated_on` datetime NOT NULL, PRIMARY KEY (`id`), KEY `time_entries_project_id` (`project_id`), KEY `time_entries_issue_id` (`issue_id`))
  CREATE TABLE IF NOT EXISTS `wikis` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `start_page` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `status` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `wikis_project_id` (`project_id`))
  CREATE TABLE {$table} (\n\t{$columns}\n)
  INSERT INTO schema_migrations VALUES ('67')
  SELECT COUNT(*) FROM users); --";
  CREATE TABLE IF NOT EXISTS `{prefix}wiki_pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `wiki_id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `created_on` datetime NOT NULL, `protected` tinyint(1) NOT NULL DEFAULT '0', `parent_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `wiki_pages_wiki_id_title` (`wiki_id`,`title`))
  CREATE TABLE IF NOT EXISTS `trackers` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `name` varchar(30) NOT NULL DEFAULT '', `is_in_chlog` tinyinteger(1) NOT NULL DEFAULT '0', `position` integer(11) DEFAULT '1', `is_in_roadmap` tinyinteger(1) NOT NULL DEFAULT '1')
  CREATE TABLE IF NOT EXISTS `{prefix}schema_migrations` ( `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL, UNIQUE KEY `unique_schema_migrations` (`version`))
  INSERT INTO workflows VALUES (1, 1, 1, 2, 3)
  INSERT INTO schema_migrations VALUES ('81')
  update saved_urls set url = :url  where id = :id
  INSERT INTO schema_migrations VALUES ('60')
  INSERT INTO workflows VALUES (2, 1, 1, 3, 3)
  CREATE TABLE IF NOT EXISTS `projects` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `name` varchar(30) NOT NULL DEFAULT '', `description` text, `homepage` varchar(255) DEFAULT '', `is_public` tinyinteger(1) NOT NULL DEFAULT '1', `parent_id` integer(11) DEFAULT NULL, `projects_count` integer(11) DEFAULT '0', `created_on` datetime DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `identifier` varchar(20) DEFAULT NULL, `status` integer(11) NOT NULL DEFAULT '1')
  INSERT INTO workflows VALUES (64, 3, 1, 5, 3)
  INSERT INTO workflows VALUES (129, 3, 4, 5, 4)
  INSERT INTO workflows VALUES (116, 2, 4, 5, 4)
  CREATE TABLE test_list (id VARCHAR(255))
  CREATE TABLE IF NOT EXISTS `{prefix}enabled_modules` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `enabled_modules_project_id` (`project_id`))
  CREATE TABLE settings ( id integer NOT NULL, name character varying(30) NOT NULL, value text, updated_on timestamp without time zone)
  INSERT INTO workflows VALUES (40, 2, 2, 6, 3)
  CREATE TABLE IF NOT EXISTS `changes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `changeset_id` int(11) NOT NULL, `action` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `from_path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `from_revision` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `revision` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `branch` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `changesets_changeset_id` (`changeset_id`))
  INSERT INTO workflows VALUES (71, 3, 3, 1, 3)
  INSERT INTO schema_migrations VALUES ('94')
  CREATE TABLE ' . $name . ' (id int(11) AUTO_INCREMENT, name varchar(255), description text, primary key(id), FULLTEXT KEY `MyFtIndex` ( `name`, `description` ))
  INSERT INTO workflows VALUES (23, 1, 5, 3, 3)
  CREATE TABLE {prefix}news ( id integer NOT NULL, project_id integer, title character varying(60) NOT NULL, summary character varying(255) DEFAULT NULL::character varying, description text, author_id integer DEFAULT 0 NOT NULL, created_on timestamp without time zone, comments_count integer DEFAULT 0 NOT NULL)
  CREATE TABLE {$name} (name varchar(10))
  INSERT INTO workflows VALUES (117, 3, 1, 2, 4)
  CREATE TABLE IF NOT EXISTS `issue_relations` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `issue_from_id` integer(11) NOT NULL, `issue_to_id` integer(11) NOT NULL, `relation_type` varchar(255) NOT NULL DEFAULT '', `delay` integer(11) DEFAULT NULL)
  INSERT INTO workflows VALUES (46, 2, 4, 1, 3)
  CREATE TABLE IF NOT EXISTS `versions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL DEFAULT '0', `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `effective_date` date DEFAULT NULL, `created_on` datetime DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `wiki_page_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `versions_project_id` (`project_id`))
  CREATE TABLE IF NOT EXISTS `workflows` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `tracker_id` integer(11) NOT NULL DEFAULT '0', `old_status_id` integer(11) NOT NULL DEFAULT '0', `new_status_id` integer(11) NOT NULL DEFAULT '0', `role_id` integer(11) NOT NULL DEFAULT '0')
  SELECT color, name FROM ' . $this->Dbo->fullTableName('apples') . ' ORDER BY id');
  CREATE TABLE IF NOT EXISTS `custom_fields_trackers` ( `custom_field_id` int(11) NOT NULL DEFAULT '0', `tracker_id` int(11) NOT NULL DEFAULT '0')
  SELECT * FROM users WHERE login = ?;', array($value), false);
  INSERT INTO schema_migrations VALUES ('64')
  INSERT INTO schema_migrations VALUES ('92')
  CREATE TABLE IF NOT EXISTS `changesets` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `repository_id` integer(11) NOT NULL, `revision` varchar(255) NOT NULL, `committer` varchar(255) DEFAULT NULL, `committed_on` datetime NOT NULL, `comments` text, `commit_date` date DEFAULT NULL, `scmid` varchar(255) DEFAULT NULL, `user_id` integer(11) DEFAULT NULL, UNIQUE (`repository_id`,`revision`))
  CREATE TABLE projects_trackers ( project_id integer NOT NULL, tracker_id integer DEFAULT 0 NOT NULL)
  CREATE TABLE ' . $name . ' (id int(11) AUTO_INCREMENT, bool tinyint(1), small_int tinyint(2), primary key(id), KEY `pointless_bool` ( `bool` ), KEY `pointless_small_int` ( `small_int` ), KEY `one_way` ( `bool`, `small_int` ))
  INSERT INTO schema_migrations VALUES ('15')
  INSERT INTO schema_migrations VALUES ('26')
  INSERT INTO issue_statuses VALUES (5, 'Closed', true, true, 5)
  INSERT INTO workflows VALUES (127, 3, 4, 2, 4)
  CREATE TABLE IF NOT EXISTS `{prefix}projects_trackers` ( `project_id` int(11) NOT NULL DEFAULT '0', `tracker_id` int(11) NOT NULL DEFAULT '0', KEY `projects_trackers_project_id` (`project_id`))
  CREATE TABLE IF NOT EXISTS `{prefix}workflows` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tracker_id` int(11) NOT NULL DEFAULT '0', `old_status_id` int(11) NOT NULL DEFAULT '0', `new_status_id` int(11) NOT NULL DEFAULT '0', `role_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `wkfs_role_tracker_old_status` (`role_id`,`tracker_id`,`old_status_id`))
  INSERT INTO workflows VALUES (3, 1, 1, 4, 3)
  CREATE TABLE IF NOT EXISTS `wiki_contents` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `page_id` integer(11) NOT NULL, `author_id` integer(11) DEFAULT NULL, `text` text, `comments` varchar(255) DEFAULT '', `updated_on` datetime NOT NULL, `version` integer(11) NOT NULL)
  INSERT INTO schema_migrations VALUES ('61')
  INSERT INTO workflows VALUES (51, 2, 5, 1, 3)
  INSERT INTO schema_migrations VALUES ('68')
  INSERT INTO workflows VALUES (89, 3, 6, 4, 3)
  CREATE TABLE $name (	id INT(11) NOT NULL AUTO_INCREMENT,	phone VARCHAR(10),	limit_date TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,	PRIMARY KEY(id))
  INSERT INTO workflows VALUES (98, 1, 3, 2, 4)
  update saved_urls set url = http where id = 1
  INSERT INTO tokens VALUES (4, 3, 'feeds', 'HxAUNOsdgv1y3m8Y0ilEOpW6P3sQaydgCxcmsHx8', '2009-03-04 23:08:46')
  CREATE TABLE IF NOT EXISTS `issue_statuses` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `is_closed` tinyint(1) NOT NULL DEFAULT '0', `is_default` tinyint(1) NOT NULL DEFAULT '0', `position` int(11) DEFAULT '1', PRIMARY KEY (`id`))
  CREATE TABLE acos ( id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, parent_id INTEGER(10) DEFAULT NULL, model VARCHAR(255) DEFAULT '', foreign_key INTEGER(10) UNSIGNED DEFAULT NULL, alias VARCHAR(255) DEFAULT '', lft INTEGER(10) DEFAULT NULL, rght INTEGER(10) DEFAULT NULL, PRIMARY KEY (id))
  CREATE TABLE IF NOT EXISTS `plugin_schema_info` ( `plugin_name` varchar(255) DEFAULT NULL, `version` integer(11) DEFAULT NULL)
  INSERT INTO user_preferences VALUES (1, 1, '--- {}', false, NULL)
  INSERT INTO schema_migrations VALUES ('70')
  INSERT INTO trackers VALUES (2, 'Feature', true, 2, true)
  CREATE TABLE IF NOT EXISTS `{prefix}enumerations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `opt` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `position` int(11) DEFAULT '1', `is_default` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`))
  INSERT INTO schema_migrations VALUES ('28')
  INSERT INTO schema_migrations VALUES ('101')
  INSERT INTO workflows VALUES (93, 1, 1, 4, 4)
  SELECT COUNT(*) FROM $commentsTable WHERE `Article`.`id` = `$commentsTable`.`article_id`) AS `comment_count`";
  INSERT INTO workflows VALUES (108, 2, 2, 3, 4)
  CREATE TABLE {prefix}time_entries ( id integer NOT NULL, project_id integer NOT NULL, user_id integer NOT NULL, issue_id integer, hours double precision NOT NULL, comments character varying(255) DEFAULT NULL::character varying, activity_id integer NOT NULL, spent_on date NOT NULL, tyear integer NOT NULL, tmonth integer NOT NULL, tweek integer NOT NULL, created_on timestamp without time zone NOT NULL, updated_on timestamp without time zone NOT NULL)
  CREATE TABLE IF NOT EXISTS `{prefix}issues` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tracker_id` int(11) NOT NULL DEFAULT '0', `project_id` int(11) NOT NULL DEFAULT '0', `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `description` text COLLATE utf8_unicode_ci, `due_date` date DEFAULT NULL, `category_id` int(11) DEFAULT NULL, `status_id` int(11) NOT NULL DEFAULT '0', `assigned_to_id` int(11) DEFAULT NULL, `priority_id` int(11) NOT NULL DEFAULT '0', `fixed_version_id` int(11) DEFAULT NULL, `author_id` int(11) NOT NULL DEFAULT '0', `lock_version` int(11) NOT NULL DEFAULT '0', `created_on` datetime DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `start_date` date DEFAULT NULL, `done_ratio` int(11) NOT NULL DEFAULT '0', `estimated_hours` float DEFAULT NULL, PRIMARY KEY (`id`), KEY `issues_project_id` (`project_id`))
  INSERT INTO schema_migrations VALUES ('17')
  INSERT INTO workflows VALUES (91, 1, 1, 2, 4)
  INSERT INTO workflows VALUES (103, 1, 4, 5, 4)
  CREATE TABLE issue_categories ( id integer NOT NULL, project_id integer DEFAULT 0 NOT NULL, name character varying(30) NOT NULL, assigned_to_id integer)
  INSERT INTO schema_migrations VALUES ('65')
  CREATE TABLE IF NOT EXISTS `schema_migrations` ( `version` varchar(255) COLLATE utf8_unicode_ci NOT NULL, UNIQUE KEY `unique_schema_migrations` (`version`))
  CREATE TABLE IF NOT EXISTS `{prefix}settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `value` text COLLATE utf8_unicode_ci, `updated_on` datetime DEFAULT NULL, PRIMARY KEY (`id`))
  CREATE TABLE {prefix}projects_trackers ( project_id integer NOT NULL, tracker_id integer DEFAULT 0 NOT NULL)
  CREATE TABLE IF NOT EXISTS `trackers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `is_in_chlog` tinyint(1) NOT NULL DEFAULT '0', `position` int(11) DEFAULT '1', `is_in_roadmap` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`))
  CREATE TABLE IF NOT EXISTS `journals` ( `id` int(11) NOT NULL AUTO_INCREMENT, `journalized_id` int(11) NOT NULL DEFAULT '0', `journalized_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `user_id` int(11) NOT NULL DEFAULT '0', `notes` text COLLATE utf8_unicode_ci, `created_on` datetime NOT NULL, PRIMARY KEY (`id`), KEY `journals_journalized_id` (`journalized_id`,`journalized_type`))
  INSERT INTO schema_migrations VALUES ('22')
  INSERT INTO enumerations VALUES (9, 'ACTI', 'Development', 2, false)
  CREATE TABLE IF NOT EXISTS `wiki_contents` ( `id` int(11) NOT NULL AUTO_INCREMENT, `page_id` int(11) NOT NULL, `author_id` int(11) DEFAULT NULL, `text` text COLLATE utf8_unicode_ci, `comments` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `updated_on` datetime NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `wiki_contents_page_id` (`page_id`))
  INSERT INTO workflows VALUES (101, 1, 4, 2, 4)
  CREATE TABLE IF NOT EXISTS `{prefix}changes` ( `id` int(11) NOT NULL AUTO_INCREMENT, `changeset_id` int(11) NOT NULL, `action` varchar(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `path` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `from_path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `from_revision` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `revision` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `branch` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `changesets_changeset_id` (`changeset_id`))
  CREATE TABLE IF NOT EXISTS `plugin_schema_info` ( `plugin_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `version` int(11) DEFAULT NULL)
  INSERT INTO schema_migrations VALUES ('7')
  INSERT INTO workflows VALUES (102, 1, 4, 3, 4)
  CREATE TABLE IF NOT EXISTS `documents` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL DEFAULT '0', `category_id` int(11) NOT NULL DEFAULT '0', `title` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `description` text COLLATE utf8_unicode_ci, `created_on` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_project_id` (`project_id`))
  INSERT INTO projects_trackers VALUES (1, 2)
  CREATE TABLE {prefix}users ( id integer NOT NULL, login character varying(30) NOT NULL, hashed_password character varying(40) NOT NULL, firstname character varying(30) NOT NULL, lastname character varying(30) NOT NULL, mail character varying(60) NOT NULL, mail_notification boolean DEFAULT true NOT NULL, admin boolean DEFAULT false NOT NULL, status integer DEFAULT 1 NOT NULL, last_login_on timestamp without time zone, language character varying(5) DEFAULT NULL::character varying, auth_source_id integer, created_on timestamp without time zone, updated_on timestamp without time zone, type character varying(255) DEFAULT NULL::character varying)
  INSERT INTO workflows VALUES (16, 1, 4, 1, 3)
  CREATE TABLE IF NOT EXISTS `enumerations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `opt` varchar(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `position` int(11) DEFAULT '1', `is_default` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`))
  INSERT INTO workflows VALUES (86, 3, 6, 1, 3)
  CREATE TABLE IF NOT EXISTS `members` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT '0', `project_id` int(11) NOT NULL DEFAULT '0', `role_id` int(11) NOT NULL DEFAULT '0', `created_on` datetime DEFAULT NULL, `mail_notification` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`))
  INSERT INTO projects_trackers VALUES (1, 3)
  CREATE TABLE {prefix}members ( id integer NOT NULL, user_id integer DEFAULT 0 NOT NULL, project_id integer DEFAULT 0 NOT NULL, role_id integer DEFAULT 0 NOT NULL, created_on timestamp without time zone, mail_notification boolean DEFAULT false NOT NULL)
  INSERT INTO enumerations VALUES (6, 'IPRI', 'Urgent', 4, false)
  INSERT INTO workflows VALUES (114, 2, 4, 2, 4)
  CREATE TABLE workflows ( id integer NOT NULL, tracker_id integer DEFAULT 0 NOT NULL, old_status_id integer DEFAULT 0 NOT NULL, new_status_id integer DEFAULT 0 NOT NULL, role_id integer DEFAULT 0 NOT NULL)
  CREATE TABLE wiki_pages ( id integer NOT NULL, wiki_id integer NOT NULL, title character varying(255) NOT NULL, created_on timestamp without time zone NOT NULL, protected boolean DEFAULT false NOT NULL, parent_id integer)
  INSERT INTO workflows VALUES (55, 2, 5, 6, 3)
  CREATE TABLE IF NOT EXISTS `messages` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `board_id` integer(11) NOT NULL, `parent_id` integer(11) DEFAULT NULL, `subject` varchar(255) NOT NULL DEFAULT '', `content` text , `author_id` integer(11) DEFAULT NULL, `replies_count` integer(11) NOT NULL DEFAULT '0', `last_reply_id` integer(11) DEFAULT NULL, `created_on` datetime NOT NULL, `updated_on` datetime NOT NULL, `locked` tinyinteger(1) DEFAULT '0', `sticky` integer(11) DEFAULT '0')
  INSERT INTO workflows VALUES (120, 3, 1, 5, 4)
  INSERT INTO schema_migrations VALUES ('47')
  INSERT INTO schema_migrations VALUES ('76')
  INSERT INTO schema_migrations VALUES ('13')
  CREATE TABLE IF NOT EXISTS `{prefix}versions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL DEFAULT '0', `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `effective_date` date DEFAULT NULL, `created_on` datetime DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `wiki_page_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `versions_project_id` (`project_id`))
  INSERT INTO issue_statuses VALUES (3, 'Resolved', false, true, 3)
  INSERT INTO workflows VALUES (10, 1, 2, 6, 3)
  INSERT INTO workflows VALUES (25, 1, 5, 6, 3)
  INSERT INTO schema_migrations VALUES ('75')
  CREATE INDEX custom_values_customized ON custom_values 
  CREATE INDEX pointless_bool ON ' . $name . '(
  INSERT INTO workflows VALUES (106, 2, 1, 4, 4)
  INSERT INTO issues VALUES (1, 1, 1, 'Sample Ticket', 'Hello candycane users.', NULL, NULL, 1, NULL, 4, NULL, 3, 0, '2009-03-14 10:32:00', '2009-03-14 10:32:00', '2009-03-14', 0, NULL)
  CREATE TABLE IF NOT EXISTS `custom_fields_projects` ( `custom_field_id` integer(11) NOT NULL DEFAULT '0', `project_id` integer(11) NOT NULL DEFAULT '0')
  CREATE TABLE IF NOT EXISTS `projects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `description` text COLLATE utf8_unicode_ci, `homepage` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `is_public` tinyint(1) NOT NULL DEFAULT '1', `parent_id` int(11) DEFAULT NULL, `projects_count` int(11) DEFAULT '0', `created_on` datetime DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `identifier` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`))
  INSERT INTO workflows VALUES (61, 3, 1, 2, 3)
  CREATE TABLE {prefix}changesets_issues ( changeset_id integer NOT NULL, issue_id integer NOT NULL)
  INSERT INTO workflows VALUES (82, 3, 5, 2, 3)
  INSERT INTO workflows VALUES (83, 3, 5, 3, 3)
  INSERT INTO workflows VALUES (12, 1, 3, 2, 3)
  INSERT INTO workflows VALUES (87, 3, 6, 2, 3)
  INSERT INTO schema_migrations VALUES ('51')
  SELECT * FROM ? WHERE ? = ? AND ? = ?';
  INSERT INTO schema_migrations VALUES ('50')
  CREATE TABLE {$table} (\n{$columns})
  CREATE TABLE auth_sources ( id integer NOT NULL, type character varying(30) NOT NULL, name character varying(60) NOT NULL, host character varying(60) DEFAULT NULL::character varying, port integer, account character varying(255) DEFAULT NULL::character varying, account_password character varying(60) DEFAULT NULL::character varying, base_dn character varying(255) DEFAULT NULL::character varying, attr_login character varying(30) DEFAULT NULL::character varying, attr_firstname character varying(30) DEFAULT NULL::character varying, attr_lastname character varying(30) DEFAULT NULL::character varying, attr_mail character varying(30) DEFAULT NULL::character varying, onthefly_register boolean DEFAULT false NOT NULL, tls boolean DEFAULT false NOT NULL)
  CREATE TABLE IF NOT EXISTS `{prefix}changesets` ( `id` int(11) NOT NULL AUTO_INCREMENT, `repository_id` int(11) NOT NULL, `revision` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `committer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `committed_on` datetime NOT NULL, `comments` text COLLATE utf8_unicode_ci, `commit_date` date DEFAULT NULL, `scmid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `changesets_repos_rev` (`repository_id`,`revision`))
  INSERT INTO schema_migrations VALUES ('31')
  CREATE TABLE IF NOT EXISTS `{prefix}attachments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `container_id` int(11) NOT NULL DEFAULT '0', `container_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `disk_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `filesize` int(11) NOT NULL DEFAULT '0', `content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `digest` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `downloads` int(11) NOT NULL DEFAULT '0', `author_id` int(11) NOT NULL DEFAULT '0', `created_on` datetime DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`))
  INSERT INTO schema_migrations VALUES ('66')
  CREATE TABLE custom_values ( id integer NOT NULL, customized_type character varying(30) NOT NULL, customized_id integer DEFAULT 0 NOT NULL, custom_field_id integer DEFAULT 0 NOT NULL, value text)
  INSERT INTO workflows VALUES (50, 2, 4, 6, 3)
  INSERT INTO enumerations VALUES (5, 'IPRI', 'High', 3, false)
  INSERT INTO workflows VALUES (77, 3, 4, 2, 3)
  CREATE TABLE IF NOT EXISTS `projects_trackers` ( `project_id` int(11) NOT NULL DEFAULT '0', `tracker_id` int(11) NOT NULL DEFAULT '0', KEY `projects_trackers_project_id` (`project_id`))
  INSERT INTO tokens VALUES (1, 1, 'feeds', 'D7ukdhHJXK7MTwDELqToVcTHPczo4rbCsLTim0pv', '2009-03-04 23:03:11')
  CREATE TABLE aros ( id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, parent_id INTEGER(10) DEFAULT NULL, model VARCHAR(255) DEFAULT '', foreign_key INTEGER(10) UNSIGNED DEFAULT NULL, alias VARCHAR(255) DEFAULT '', lft INTEGER(10) DEFAULT NULL, rght INTEGER(10) DEFAULT NULL, PRIMARY KEY (id))
  INSERT INTO workflows VALUES (115, 2, 4, 3, 4)
  INSERT INTO schema_migrations VALUES ('30')
  INSERT INTO schema_migrations VALUES ('37')
  INSERT INTO workflows VALUES (58, 2, 6, 3, 3)
  INSERT INTO workflows VALUES (126, 3, 3, 5, 4)
  INSERT INTO workflows VALUES (85, 3, 5, 6, 3)
  CREATE TABLE IF NOT EXISTS `{prefix}documents` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL DEFAULT '0', `category_id` int(11) NOT NULL DEFAULT '0', `title` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `description` text COLLATE utf8_unicode_ci, `created_on` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `documents_project_id` (`project_id`))
  CREATE TABLE {$name} (mood ENUM('','happy','sad','ok') NOT NULL)
  INSERT INTO workflows VALUES (53, 2, 5, 3, 3)
  CREATE TABLE {prefix}tokens ( id integer NOT NULL, user_id integer DEFAULT 0 NOT NULL, action character varying(30) NOT NULL, value character varying(40) NOT NULL, created_on timestamp without time zone NOT NULL)
  CREATE TABLE comments ( id integer NOT NULL, commented_type character varying(30) NOT NULL, commented_id integer DEFAULT 0 NOT NULL, author_id integer DEFAULT 0 NOT NULL, comments text, created_on timestamp without time zone NOT NULL, updated_on timestamp without time zone NOT NULL)
  CREATE TABLE wiki_redirects ( id integer NOT NULL, wiki_id integer NOT NULL, title character varying(255) DEFAULT NULL::character varying, redirects_to character varying(255) DEFAULT NULL::character varying, created_on timestamp without time zone NOT NULL)
  INSERT INTO schema_migrations VALUES ('72')
  INSERT INTO schema_migrations VALUES ('12')
  SELECT title, body FROM ';
  INSERT INTO schema_migrations VALUES ('71')
  CREATE TABLE IF NOT EXISTS `workflows` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tracker_id` int(11) NOT NULL DEFAULT '0', `old_status_id` int(11) NOT NULL DEFAULT '0', `new_status_id` int(11) NOT NULL DEFAULT '0', `role_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `wkfs_role_tracker_old_status` (`role_id`,`tracker_id`,`old_status_id`))
  CREATE TABLE IF NOT EXISTS `{prefix}wiki_contents` ( `id` int(11) NOT NULL AUTO_INCREMENT, `page_id` int(11) NOT NULL, `author_id` int(11) DEFAULT NULL, `text` text COLLATE utf8_unicode_ci, `comments` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `updated_on` datetime NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `wiki_contents_page_id` (`page_id`))
  CREATE TABLE IF NOT EXISTS `{prefix}comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `commented_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `commented_id` int(11) NOT NULL DEFAULT '0', `author_id` int(11) NOT NULL DEFAULT '0', `comments` text COLLATE utf8_unicode_ci, `created_on` datetime NOT NULL, `updated_on` datetime NOT NULL, PRIMARY KEY (`id`))
  INSERT INTO trackers VALUES (1, 'Bug', true, 1, false)
  CREATE TABLE {prefix}changes ( id integer NOT NULL, changeset_id integer NOT NULL, action character varying(1) NOT NULL, path character varying(255) NOT NULL, from_path character varying(255) DEFAULT NULL::character varying, from_revision character varying(255) DEFAULT NULL::character varying, revision character varying(255) DEFAULT NULL::character varying, branch character varying(255) DEFAULT NULL::character varying)
  INSERT INTO users VALUES (1, 'admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', 'Redmine', 'Admin', 'admin@example.net', true, true, 1, '2009-03-04 23:06:50', 'eng', NULL, '2009-03-04 23:00:57', '2009-03-04 23:06:50', 'User')
  CREATE TABLE changes ( id integer NOT NULL, changeset_id integer NOT NULL, action character varying(1) NOT NULL, path character varying(255) NOT NULL, from_path character varying(255) DEFAULT NULL::character varying, from_revision character varying(255) DEFAULT NULL::character varying, revision character varying(255) DEFAULT NULL::character varying, branch character varying(255) DEFAULT NULL::character varying)
  INSERT INTO user_preferences VALUES (2, 2, '--- {}', false, NULL)
  CREATE TABLE {prefix}auth_sources ( id integer NOT NULL, type character varying(30) NOT NULL, name character varying(60) NOT NULL, host character varying(60) DEFAULT NULL::character varying, port integer, account character varying(255) DEFAULT NULL::character varying, account_password character varying(60) DEFAULT NULL::character varying, base_dn character varying(255) DEFAULT NULL::character varying, attr_login character varying(30) DEFAULT NULL::character varying, attr_firstname character varying(30) DEFAULT NULL::character varying, attr_lastname character varying(30) DEFAULT NULL::character varying, attr_mail character varying(30) DEFAULT NULL::character varying, onthefly_register boolean DEFAULT false NOT NULL, tls boolean DEFAULT false NOT NULL)
  CREATE INDEX wiki_pages_wiki_id_title ON wiki_pages 
  CREATE TABLE versions ( id integer NOT NULL, project_id integer DEFAULT 0 NOT NULL, name character varying(255) NOT NULL, description character varying(255) DEFAULT NULL::character varying, effective_date date, created_on timestamp without time zone, updated_on timestamp without time zone, wiki_page_title character varying(255) DEFAULT NULL::character varying)
  CREATE TABLE custom_fields_trackers ( custom_field_id integer DEFAULT 0 NOT NULL, tracker_id integer DEFAULT 0 NOT NULL)
  CREATE TABLE IF NOT EXISTS `{prefix}custom_fields` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `field_format` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `possible_values` text COLLATE utf8_unicode_ci, `regexp` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `min_length` int(11) NOT NULL DEFAULT '0', `max_length` int(11) NOT NULL DEFAULT '0', `is_required` tinyint(1) NOT NULL DEFAULT '0', `is_for_all` tinyint(1) NOT NULL DEFAULT '0', `is_filter` tinyint(1) NOT NULL DEFAULT '0', `position` int(11) DEFAULT '1', `searchable` tinyint(1) DEFAULT '0', `default_value` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`))
  CREATE TABLE {prefix}custom_fields_trackers ( custom_field_id integer DEFAULT 0 NOT NULL, tracker_id integer DEFAULT 0 NOT NULL)
  INSERT INTO workflows VALUES (18, 1, 4, 3, 3)
  CREATE TABLE IF NOT EXISTS `issue_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL DEFAULT '0', `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `assigned_to_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `issue_categories_project_id` (`project_id`))
  INSERT INTO workflows VALUES (54, 2, 5, 4, 3)
  CREATE INDEX issues_project_id ON issues 
  CREATE TABLE IF NOT EXISTS `wiki_pages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `wiki_id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `created_on` datetime NOT NULL, `protected` tinyint(1) NOT NULL DEFAULT '0', `parent_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `wiki_pages_wiki_id_title` (`wiki_id`,`title`))
  CREATE TABLE IF NOT EXISTS `auth_sources` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `type` varchar(30) NOT NULL DEFAULT '', `name` varchar(60) NOT NULL DEFAULT '', `host` varchar(60) DEFAULT NULL, `port` integer(11) DEFAULT NULL, `account` varchar(255) DEFAULT NULL, `account_password` varchar(60) DEFAULT NULL, `base_dn` varchar(255) DEFAULT NULL, `attr_login` varchar(30) DEFAULT NULL, `attr_firstname` varchar(30) DEFAULT NULL, `attr_lastname` varchar(30) DEFAULT NULL, `attr_mail` varchar(30) DEFAULT NULL, `onthefly_register` tinyinteger(1) NOT NULL DEFAULT '0', `tls` tinyinteger(1) NOT NULL DEFAULT '0')
  INSERT INTO schema_migrations VALUES ('21')
  CREATE TABLE IF NOT EXISTS `wiki_redirects` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `wiki_id` integer(11) NOT NULL, `title` varchar(255) DEFAULT NULL, `redirects_to` varchar(255) DEFAULT NULL, `created_on` datetime NOT NULL)
  INSERT INTO schema_migrations VALUES ('40')
  INSERT INTO workflows VALUES (26, 1, 6, 1, 3)
  CREATE TABLE IF NOT EXISTS `documents` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `project_id` integer(11) NOT NULL DEFAULT '0', `category_id` integer(11) NOT NULL DEFAULT '0', `title` varchar(60) NOT NULL DEFAULT '', `description` text, `created_on` datetime DEFAULT NULL)
  INSERT INTO workflows VALUES (121, 3, 2, 3, 4)
  INSERT INTO workflows VALUES (123, 3, 2, 5, 4)
  CREATE INDEX idx_aros_lft_rght ON `aros` (`lft`, `rght`);
  INSERT INTO schema_migrations VALUES ('57')
  INSERT INTO trackers VALUES (3, 'Support', false, 3, false)
  INSERT INTO schema_migrations VALUES ('19')
  INSERT INTO schema_migrations VALUES ('59')
  INSERT INTO workflows VALUES (15, 1, 3, 6, 3)
  CREATE TABLE enabled_modules ( id integer NOT NULL, project_id integer, name character varying(255) NOT NULL)
  CREATE TABLE projects ( id integer NOT NULL, name character varying(30) NOT NULL, description text, homepage character varying(255) DEFAULT NULL::character varying, is_public boolean DEFAULT true NOT NULL, parent_id integer, projects_count integer DEFAULT 0, created_on timestamp without time zone, updated_on timestamp without time zone, identifier character varying(20) DEFAULT NULL::character varying, status integer DEFAULT 1 NOT NULL)
  INSERT INTO workflows VALUES (144, 3, 3, 4, 5)
  CREATE TABLE IF NOT EXISTS `{prefix}tokens` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT '0', `action` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `value` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `created_on` datetime NOT NULL, PRIMARY KEY (`id`))
  CREATE TABLE ' . $table . ' (id int(11) AUTO_INCREMENT, bool tinyint(1), small_int tinyint(2), primary key(id))
  CREATE INDEX journal_details_journal_id ON journal_details 
  CREATE TABLE documents ( id integer NOT NULL, project_id integer DEFAULT 0 NOT NULL, category_id integer DEFAULT 0 NOT NULL, title character varying(60) NOT NULL, description text, created_on timestamp without time zone)
  CREATE TABLE IF NOT EXISTS `roles` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `name` varchar(30) NOT NULL DEFAULT '', `position` integer(11) DEFAULT '1', `assignable` tinyinteger(1) DEFAULT '1', `builtin` integer(11) NOT NULL DEFAULT '0', `permissions` text )
  INSERT INTO schema_migrations VALUES ('39')
  INSERT INTO workflows VALUES (39, 2, 2, 5, 3)
  INSERT INTO schema_migrations VALUES ('24')
  INSERT INTO tokens VALUES (3, 3, 'feeds', 'Zi1s5C1vyA8TAzMXm2hAAIOD8CveWiT3LSI763Ie', '2009-03-04 23:08:46')
  INSERT INTO schema_migrations VALUES ('48')
  CREATE TABLE repositories ( id integer NOT NULL, project_id integer DEFAULT 0 NOT NULL, url character varying(255) NOT NULL, login character varying(60) DEFAULT NULL::character varying, password character varying(60) DEFAULT NULL::character varying, root_url character varying(255) DEFAULT NULL::character varying, type character varying(255) DEFAULT NULL::character varying)
  CREATE TABLE IF NOT EXISTS `enabled_modules` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `project_id` integer(11) DEFAULT NULL, `name` varchar(255) NOT NULL)
  CREATE TABLE watchers ( id integer NOT NULL, watchable_type character varying(255) NOT NULL, watchable_id integer DEFAULT 0 NOT NULL, user_id integer)
  INSERT INTO roles VALUES (5, 'Reporter', 5, true, 0, '--- - :add_issues- :add_issue_notes- :save_queries- :view_gantt- :view_calendar- :log_time- :view_time_entries- :comment_news- :view_documents- :view_wiki_pages- :view_wiki_edits- :add_messages- :edit_own_messages- :view_files- :browse_repository- :view_changesets')
  INSERT INTO workflows VALUES (57, 2, 6, 2, 3)
  CREATE TABLE IF NOT EXISTS `custom_fields` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `field_format` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `possible_values` text COLLATE utf8_unicode_ci, `regexp` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `min_length` int(11) NOT NULL DEFAULT '0', `max_length` int(11) NOT NULL DEFAULT '0', `is_required` tinyint(1) NOT NULL DEFAULT '0', `is_for_all` tinyint(1) NOT NULL DEFAULT '0', `is_filter` tinyint(1) NOT NULL DEFAULT '0', `position` int(11) DEFAULT '1', `searchable` tinyint(1) DEFAULT '0', `default_value` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`))
  INSERT INTO issue_statuses VALUES (4, 'Feedback', false, true, 4)
  INSERT INTO workflows VALUES (69, 3, 2, 5, 3)
  INSERT INTO enumerations VALUES (8, 'ACTI', 'Design', 1, false)
  CREATE TABLE IF NOT EXISTS `user_preferences` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `user_id` integer(11) NOT NULL DEFAULT '0', `others` text, `hide_mail` tinyinteger(1) DEFAULT '0', `time_zone` varchar(255) DEFAULT NULL)
  INSERT INTO workflows VALUES (63, 3, 1, 4, 3)
  CREATE TABLE IF NOT EXISTS `projects_trackers` ( `project_id` integer(11) NOT NULL DEFAULT '0', `tracker_id` integer(11) NOT NULL DEFAULT '0')
  CREATE TABLE IF NOT EXISTS `{prefix}issue_relations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `issue_from_id` int(11) NOT NULL, `issue_to_id` int(11) NOT NULL, `relation_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `delay` int(11) DEFAULT NULL, PRIMARY KEY (`id`))
  INSERT INTO schema_migrations VALUES ('91')
  INSERT INTO schema_migrations VALUES ('95')
  INSERT INTO workflows VALUES (143, 3, 4, 5, 5)
  INSERT INTO workflows VALUES (135, 2, 1, 5, 5)
  INSERT INTO workflows VALUES (4, 1, 1, 5, 3)
  INSERT INTO workflows VALUES (104, 2, 1, 2, 4)
  INSERT INTO schema_migrations VALUES ('35')
  CREATE TABLE IF NOT EXISTS `{prefix}watchers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `watchable_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `watchable_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`))
  INSERT INTO workflows VALUES (107, 2, 1, 5, 4)
  CREATE INDEX journals_journalized_id ON journals 
  INSERT INTO workflows VALUES (84, 3, 5, 4, 3)
  INSERT INTO workflows VALUES (124, 3, 3, 2, 4)
  INSERT INTO workflows VALUES (128, 3, 4, 3, 4)
  INSERT INTO schema_migrations VALUES ('53')
  INSERT INTO workflows VALUES (139, 2, 3, 4, 5)
  INSERT INTO workflows VALUES (19, 1, 4, 5, 3)
  CREATE TABLE IF NOT EXISTS `tokens` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT '0', `action` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `value` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `created_on` datetime NOT NULL, PRIMARY KEY (`id`))
  CREATE TABLE {prefix}wiki_contents ( id integer NOT NULL, page_id integer NOT NULL, author_id integer, text text, comments character varying(255) DEFAULT NULL::character varying, updated_on timestamp without time zone NOT NULL, version integer NOT NULL)
  INSERT INTO schema_migrations VALUES ('79')
  CREATE TABLE wiki_contents ( id integer NOT NULL, page_id integer NOT NULL, author_id integer, text text, comments character varying(255) DEFAULT NULL::character varying, updated_on timestamp without time zone NOT NULL, version integer NOT NULL)
  INSERT INTO tokens VALUES (2, 1, 'feeds', 'rV5I24UQkA7AImh0FOYM84eNSpDbsOpTFCRcMort', '2009-03-04 23:03:11')
  INSERT INTO schema_migrations VALUES ('54')
  INSERT INTO enumerations VALUES (3, 'IPRI', 'Low', 1, false)
  CREATE TABLE IF NOT EXISTS `changes` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `changeset_id` integer(11) NOT NULL, `action` varchar(1) NOT NULL DEFAULT '', `path` varchar(255) NOT NULL DEFAULT '', `from_path` varchar(255) DEFAULT NULL, `from_revision` varchar(255) DEFAULT NULL, `revision` varchar(255) DEFAULT NULL, `branch` varchar(255) DEFAULT NULL)
  INSERT INTO workflows VALUES (66, 3, 2, 1, 3)
  CREATE INDEX enabled_modules_project_id ON enabled_modules 
  CREATE TABLE IF NOT EXISTS `{prefix}custom_fields_trackers` ( `custom_field_id` int(11) NOT NULL DEFAULT '0', `tracker_id` int(11) NOT NULL DEFAULT '0')
  CREATE TABLE IF NOT EXISTS `repositories` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `project_id` integer(11) NOT NULL DEFAULT '0', `url` varchar(255) NOT NULL DEFAULT '', `login` varchar(60) DEFAULT '', `password` varchar(60) DEFAULT '', `root_url` varchar(255) DEFAULT '', `type` varchar(255) DEFAULT NULL)
  INSERT INTO schema_migrations VALUES ('9')
  INSERT INTO workflows VALUES (5, 1, 1, 6, 3)
  INSERT INTO projects VALUES (1, 'Sample Project', 'Candycane rocks!', '', true, NULL, 0, '2009-03-04 23:09:49', '2009-03-04 23:09:49', 'sampleproject', 1)
  CREATE INDEX idx_aco_id ON `aros_acos` (`aco_id`);
  CREATE INDEX versions_project_id ON versions 
  CREATE TABLE IF NOT EXISTS `settings` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `value` text COLLATE utf8_unicode_ci, `updated_on` datetime DEFAULT NULL, PRIMARY KEY (`id`))
  INSERT INTO schema_migrations VALUES ('33')
  CREATE TABLE wiki_content_versions ( id integer NOT NULL, wiki_content_id integer NOT NULL, page_id integer NOT NULL, author_id integer, data bytea, compression character varying(6) DEFAULT NULL::character varying, comments character varying(255) DEFAULT NULL::character varying, updated_on timestamp without time zone NOT NULL, version integer NOT NULL)
  CREATE TABLE IF NOT EXISTS `{prefix}time_entries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `user_id` int(11) NOT NULL, `issue_id` int(11) DEFAULT NULL, `hours` float NOT NULL, `comments` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `activity_id` int(11) NOT NULL, `spent_on` date NOT NULL, `tyear` int(11) NOT NULL, `tmonth` int(11) NOT NULL, `tweek` int(11) NOT NULL, `created_on` datetime NOT NULL, `updated_on` datetime NOT NULL, PRIMARY KEY (`id`), KEY `time_entries_project_id` (`project_id`), KEY `time_entries_issue_id` (`issue_id`))
  INSERT INTO schema_migrations VALUES ('38')
  INSERT INTO workflows VALUES (21, 1, 5, 1, 3)
  INSERT INTO workflows VALUES (99, 1, 3, 4, 4)
  INSERT INTO workflows VALUES (97, 1, 2, 5, 4)
  CREATE TABLE {prefix}issue_categories ( id integer NOT NULL, project_id integer DEFAULT 0 NOT NULL, name character varying(30) NOT NULL, assigned_to_id integer)
  INSERT INTO workflows VALUES (142, 3, 3, 5, 5)
  SELECT name FROM sqlite_master WHERE type='table' ORDER BY name;
  CREATE TABLE ' . $name . ' (id int(11) AUTO_INCREMENT, bool tinyint(1), small_int tinyint(2), primary key(id))
  CREATE TABLE IF NOT EXISTS `comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `commented_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `commented_id` int(11) NOT NULL DEFAULT '0', `author_id` int(11) NOT NULL DEFAULT '0', `comments` text COLLATE utf8_unicode_ci, `created_on` datetime NOT NULL, `updated_on` datetime NOT NULL, PRIMARY KEY (`id`))
  CREATE TABLE IF NOT EXISTS `journals` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `journalized_id` integer(11) NOT NULL DEFAULT '0', `journalized_type` varchar(30) NOT NULL DEFAULT '', `user_id` integer(11) NOT NULL DEFAULT '0', `notes` text, `created_on` datetime NOT NULL)
  CREATE TABLE IF NOT EXISTS `watchers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `watchable_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `watchable_id` int(11) NOT NULL DEFAULT '0', `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`))
  INSERT INTO workflows VALUES (33, 2, 1, 4, 3)
  INSERT INTO workflows VALUES (37, 2, 2, 3, 3)
  INSERT INTO workflows VALUES (14, 1, 3, 5, 3)
  INSERT INTO schema_migrations VALUES ('20')
  CREATE TABLE IF NOT EXISTS `roles` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `position` int(11) DEFAULT '1', `assignable` tinyint(1) DEFAULT '1', `builtin` int(11) NOT NULL DEFAULT '0', `permissions` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`))
  CREATE TABLE {prefix}documents ( id integer NOT NULL, project_id integer DEFAULT 0 NOT NULL, category_id integer DEFAULT 0 NOT NULL, title character varying(60) NOT NULL, description text, created_on timestamp without time zone)
  CREATE TABLE members ( id integer NOT NULL, user_id integer DEFAULT 0 NOT NULL, project_id integer DEFAULT 0 NOT NULL, role_id integer DEFAULT 0 NOT NULL, created_on timestamp without time zone, mail_notification boolean DEFAULT false NOT NULL)
  CREATE TABLE IF NOT EXISTS `enabled_modules` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`), KEY `enabled_modules_project_id` (`project_id`))
  CREATE TABLE IF NOT EXISTS `versions` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `project_id` integer(11) NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `description` varchar(255) DEFAULT '', `effective_date` date DEFAULT NULL, `created_on` datetime DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `wiki_page_title` varchar(255) DEFAULT NULL)
  CREATE TABLE IF NOT EXISTS `{prefix}auth_sources` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `host` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL, `port` int(11) DEFAULT NULL, `account` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `account_password` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL, `base_dn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `attr_login` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, `attr_firstname` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, `attr_lastname` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, `attr_mail` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, `onthefly_register` tinyint(1) NOT NULL DEFAULT '0', `tls` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`))
  CREATE TABLE IF NOT EXISTS `{prefix}custom_fields_projects` ( `custom_field_id` int(11) NOT NULL DEFAULT '0', `project_id` int(11) NOT NULL DEFAULT '0')
  INSERT INTO workflows VALUES (70, 3, 2, 6, 3)
  CREATE TABLE IF NOT EXISTS `queries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `filters` text COLLATE utf8_unicode_ci, `user_id` int(11) NOT NULL DEFAULT '0', `is_public` tinyint(1) NOT NULL DEFAULT '0', `column_names` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`))
  CREATE TABLE IF NOT EXISTS `queries` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `project_id` integer(11) DEFAULT NULL, `name` varchar(255) NOT NULL DEFAULT '', `filters` text, `user_id` integer(11) NOT NULL DEFAULT '0', `is_public` tinyinteger(1) NOT NULL DEFAULT '0', `column_names` text )
  INSERT INTO schema_migrations VALUES ('74')
  INSERT INTO schema_migrations VALUES ('45')
  INSERT INTO workflows VALUES (24, 1, 5, 4, 3)
  CREATE TABLE {prefix}schema_migrations ( version character varying(255) NOT NULL)
  INSERT INTO enabled_modules VALUES (4, 1, 'documents')
  INSERT INTO workflows VALUES (137, 2, 3, 5, 5)
  SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES
  CREATE TABLE IF NOT EXISTS `journal_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `journal_id` int(11) NOT NULL DEFAULT '0', `property` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `prop_key` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `old_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `journal_details_journal_id` (`journal_id`))
  INSERT INTO workflows VALUES (133, 1, 4, 5, 5)
  CREATE TABLE {prefix}journal_details ( id integer NOT NULL, journal_id integer DEFAULT 0 NOT NULL, property character varying(30) NOT NULL, prop_key character varying(30) NOT NULL, old_value character varying(255) DEFAULT NULL::character varying, value character varying(255) DEFAULT NULL::character varying)
  CREATE TABLE {prefix}attachments ( id integer NOT NULL, container_id integer DEFAULT 0 NOT NULL, container_type character varying(30) NOT NULL, filename character varying(255) NOT NULL, disk_filename character varying(255) NOT NULL, filesize integer DEFAULT 0 NOT NULL, content_type character varying(255) DEFAULT NULL::character varying, digest character varying(40) NOT NULL, downloads integer DEFAULT 0 NOT NULL, author_id integer DEFAULT 0 NOT NULL, created_on timestamp without time zone, description character varying(255) DEFAULT NULL::character varying)
  CREATE TABLE IF NOT EXISTS `enumerations` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `opt` varchar(4) NOT NULL DEFAULT '', `name` varchar(30) NOT NULL DEFAULT '', `position` integer(11) DEFAULT '1', `is_default` tinyinteger(1) NOT NULL DEFAULT '0')
  INSERT INTO schema_migrations VALUES ('11')
  INSERT INTO workflows VALUES (67, 3, 2, 3, 3)
  CREATE TABLE aros_acos ( id INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, aro_id INTEGER(10) UNSIGNED NOT NULL, aco_id INTEGER(10) UNSIGNED NOT NULL, _create CHAR(2) NOT NULL DEFAULT 0, _read CHAR(2) NOT NULL DEFAULT 0, _update CHAR(2) NOT NULL DEFAULT 0, _delete CHAR(2) NOT NULL DEFAULT 0, PRIMARY KEY(id))
  CREATE TABLE IF NOT EXISTS `{prefix}plugin_schema_info` ( `plugin_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `version` int(11) DEFAULT NULL)
  INSERT INTO workflows VALUES (113, 2, 3, 5, 4)
  CREATE TABLE queries ( id integer NOT NULL, project_id integer, name character varying(255) NOT NULL, filters text, user_id integer DEFAULT 0 NOT NULL, is_public boolean DEFAULT false NOT NULL, column_names text)
  INSERT INTO schema_migrations VALUES ('8')
  SELECT title FROM ';
  CREATE TABLE IF NOT EXISTS `custom_fields` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `type` varchar(30) NOT NULL DEFAULT '', `name` varchar(30) NOT NULL DEFAULT '', `field_format` varchar(30) NOT NULL DEFAULT '', `possible_values` text, `regexp` varchar(255) DEFAULT '', `min_length` integer(11) NOT NULL DEFAULT '0', `max_length` integer(11) NOT NULL DEFAULT '0', `is_required` tinyinteger(1) NOT NULL DEFAULT '0', `is_for_all` tinyinteger(1) NOT NULL DEFAULT '0', `is_filter` tinyinteger(1) NOT NULL DEFAULT '0', `position` integer(11) DEFAULT '1', `searchable` tinyinteger(1) DEFAULT '0', `default_value` text )
  CREATE INDEX idx_acos_alias ON `acos` (`alias`);
  CREATE TABLE IF NOT EXISTS `issue_statuses` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `name` varchar(30) NOT NULL DEFAULT '', `is_closed` tinyinteger(1) NOT NULL DEFAULT '0', `is_default` tinyinteger(1) NOT NULL DEFAULT '0', `position` integer(11) DEFAULT '1')
  CREATE TABLE IF NOT EXISTS `boards` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `project_id` integer(11) NOT NULL, `name` varchar(255) NOT NULL DEFAULT '', `description` varchar(255) DEFAULT NULL, `position` integer(11) DEFAULT '1', `topics_count` integer(11) NOT NULL DEFAULT '0', `messages_count` integer(11) NOT NULL DEFAULT '0', `last_message_id` integer(11) DEFAULT NULL)
  INSERT INTO workflows VALUES (76, 3, 4, 1, 3)
  CREATE TABLE IF NOT EXISTS `wikis` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `project_id` integer(11) NOT NULL, `start_page` varchar(255) NOT NULL, `status` integer(11) NOT NULL DEFAULT '1')
  SELECT title, id FROM ';
  CREATE TABLE {prefix}projects ( id integer NOT NULL, name character varying(30) NOT NULL, description text, homepage character varying(255) DEFAULT NULL::character varying, is_public boolean DEFAULT true NOT NULL, parent_id integer, projects_count integer DEFAULT 0, created_on timestamp without time zone, updated_on timestamp without time zone, identifier character varying(20) DEFAULT NULL::character varying, status integer DEFAULT 1 NOT NULL)
  INSERT INTO workflows VALUES (56, 2, 6, 1, 3)
  CREATE INDEX documents_project_id ON documents 
  CREATE TABLE IF NOT EXISTS `custom_values` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `customized_type` varchar(30) NOT NULL DEFAULT '', `customized_id` integer(11) NOT NULL DEFAULT '0', `custom_field_id` integer(11) NOT NULL DEFAULT '0', `value` text )
  CREATE TABLE {prefix}custom_fields_projects ( custom_field_id integer DEFAULT 0 NOT NULL, project_id integer DEFAULT 0 NOT NULL)
  INSERT INTO schema_migrations VALUES ('98')
  CREATE TABLE user_preferences ( id integer NOT NULL, user_id integer DEFAULT 0 NOT NULL, others text, hide_mail boolean DEFAULT false, time_zone character varying(255) DEFAULT NULL::character varying)
  CREATE TABLE {prefix}journals ( id integer NOT NULL, journalized_id integer DEFAULT 0 NOT NULL, journalized_type character varying(30) NOT NULL, user_id integer DEFAULT 0 NOT NULL, notes text, created_on timestamp without time zone NOT NULL)
  CREATE TABLE IF NOT EXISTS `custom_fields_trackers` ( `custom_field_id` integer(11) NOT NULL DEFAULT '0', `tracker_id` integer(11) NOT NULL DEFAULT '0')
  CREATE TABLE IF NOT EXISTS `wiki_pages` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `wiki_id` integer(11) NOT NULL, `title` varchar(255) NOT NULL, `created_on` datetime NOT NULL, `protected` tinyinteger(1) NOT NULL DEFAULT '0', `parent_id` integer(11) DEFAULT NULL)
  CREATE TABLE IF NOT EXISTS `auth_sources` ( `id` int(11) NOT NULL AUTO_INCREMENT, `type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `name` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `host` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL, `port` int(11) DEFAULT NULL, `account` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `account_password` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL, `base_dn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `attr_login` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, `attr_firstname` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, `attr_lastname` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, `attr_mail` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, `onthefly_register` tinyint(1) NOT NULL DEFAULT '0', `tls` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`))
  SELECT title, published FROM ';
  INSERT INTO workflows VALUES (132, 1, 3, 5, 5)
  INSERT INTO workflows VALUES (7, 1, 2, 3, 3)
  INSERT INTO schema_migrations VALUES ('49')
  INSERT INTO workflows VALUES (62, 3, 1, 3, 3)
  INSERT INTO workflows VALUES (59, 2, 6, 4, 3)
  INSERT INTO workflows VALUES (74, 3, 3, 5, 3)
  INSERT INTO workflows VALUES (22, 1, 5, 2, 3)
  INSERT INTO workflows VALUES (31, 2, 1, 2, 3)
  INSERT INTO workflows VALUES (141, 3, 2, 5, 5)
  INSERT INTO schema_migrations VALUES ('3')
  CREATE TABLE i18n (	id int(10) NOT NULL auto_increment,	locale varchar(6) NOT NULL,	model varchar(255) NOT NULL,	foreign_key int(10) NOT NULL,	field varchar(255) NOT NULL,	content mediumtext,	PRIMARY KEY	(id),#	UNIQUE INDEX I18N_LOCALE_FIELD(locale, model, foreign_key, field),#	INDEX I18N_LOCALE_ROW(locale, model, foreign_key),#	INDEX I18N_LOCALE_MODEL(locale, model),#	INDEX I18N_FIELD(model, foreign_key, field),#	INDEX I18N_ROW(model, foreign_key),	INDEX locale (locale),	INDEX model (model),	INDEX row_id (foreign_key),	INDEX field (field))
  CREATE INDEX wikis_project_id ON wikis 
  CREATE TABLE IF NOT EXISTS `news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) DEFAULT NULL, `title` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `summary` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `description` text COLLATE utf8_unicode_ci, `author_id` int(11) NOT NULL DEFAULT '0', `created_on` datetime DEFAULT NULL, `comments_count` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `news_project_id` (`project_id`))
  CREATE INDEX time_entries_issue_id ON time_entries 
  INSERT INTO workflows VALUES (140, 3, 1, 5, 5)
  INSERT INTO issue_statuses VALUES (1, 'New', false, true, 1)
  INSERT INTO schema_migrations VALUES ('18')
  CREATE TABLE ' . $name . ' (id int(11) AUTO_INCREMENT, bool tinyint(1), small_int tinyint(2), primary key(id), KEY `pointless_bool` ( `bool` ))
  CREATE TABLE IF NOT EXISTS `{prefix}custom_values` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customized_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `customized_id` int(11) NOT NULL DEFAULT '0', `custom_field_id` int(11) NOT NULL DEFAULT '0', `value` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`), KEY `custom_values_customized` (`customized_type`,`customized_id`))
  INSERT INTO news VALUES (1, 1, 'Sample News', 'Working fine.', 'Worked*YEAH!!*', 3, '2009-03-20 23:25:45', 0)
  INSERT INTO workflows VALUES (130, 1, 1, 5, 5)
  CREATE TABLE IF NOT EXISTS `{prefix}wikis` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `start_page` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `status` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`), KEY `wikis_project_id` (`project_id`))
  CREATE TABLE {prefix}issue_relations ( id integer NOT NULL, issue_from_id integer NOT NULL, issue_to_id integer NOT NULL, relation_type character varying(255) NOT NULL, delay integer)
  INSERT INTO schema_migrations VALUES ('25')
  CREATE TABLE schema_migrations ( version character varying(255) NOT NULL)
  CREATE TABLE journal_details ( id integer NOT NULL, journal_id integer DEFAULT 0 NOT NULL, property character varying(30) NOT NULL, prop_key character varying(30) NOT NULL, old_value character varying(255) DEFAULT NULL::character varying, value character varying(255) DEFAULT NULL::character varying)
  INSERT INTO workflows VALUES (34, 2, 1, 5, 3)
  CREATE TABLE users ( id integer NOT NULL, login character varying(30) NOT NULL, hashed_password character varying(40) NOT NULL, firstname character varying(30) NOT NULL, lastname character varying(30) NOT NULL, mail character varying(60) NOT NULL, mail_notification boolean DEFAULT true NOT NULL, admin boolean DEFAULT false NOT NULL, status integer DEFAULT 1 NOT NULL, last_login_on timestamp without time zone, language character varying(5) DEFAULT NULL::character varying, auth_source_id integer, created_on timestamp without time zone, updated_on timestamp without time zone, type character varying(255) DEFAULT NULL::character varying)
  CREATE TABLE {prefix}wiki_redirects ( id integer NOT NULL, wiki_id integer NOT NULL, title character varying(255) DEFAULT NULL::character varying, redirects_to character varying(255) DEFAULT NULL::character varying, created_on timestamp without time zone NOT NULL)
  CREATE TABLE IF NOT EXISTS `attachments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `container_id` int(11) NOT NULL DEFAULT '0', `container_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `disk_filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `filesize` int(11) NOT NULL DEFAULT '0', `content_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `digest` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `downloads` int(11) NOT NULL DEFAULT '0', `author_id` int(11) NOT NULL DEFAULT '0', `created_on` datetime DEFAULT NULL, `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`))
  INSERT INTO schema_migrations VALUES ('16')
  CREATE TABLE IF NOT EXISTS `changesets_issues` ( `changeset_id` integer(11) NOT NULL, `issue_id` integer(11) NOT NULL, UNIQUE (`changeset_id`,`issue_id`))
  CREATE TABLE changesets ( id integer NOT NULL, repository_id integer NOT NULL, revision character varying(255) NOT NULL, committer character varying(255) DEFAULT NULL::character varying, committed_on timestamp without time zone NOT NULL, comments text, commit_date date, scmid character varying(255) DEFAULT NULL::character varying, user_id integer)
  INSERT INTO workflows VALUES (52, 2, 5, 2, 3)
  SELECT * FROM ' . $this->Dbo->fullTableName('articles') . ' WHERE 1 = 1';
  INSERT INTO workflows VALUES (68, 3, 2, 4, 3)
  CREATE TABLE IF NOT EXISTS `custom_fields_projects` ( `custom_field_id` int(11) NOT NULL DEFAULT '0', `project_id` int(11) NOT NULL DEFAULT '0')
  INSERT INTO schema_migrations VALUES ('82')
  INSERT INTO schema_migrations VALUES ('1')
  CREATE TABLE issue_relations ( id integer NOT NULL, issue_from_id integer NOT NULL, issue_to_id integer NOT NULL, relation_type character varying(255) NOT NULL, delay integer)
  INSERT INTO workflows VALUES (105, 2, 1, 3, 4)
  INSERT INTO schema_migrations VALUES ('4')
  INSERT INTO schema_migrations VALUES ('27')
  CREATE TABLE {prefix}issues ( id integer NOT NULL, tracker_id integer DEFAULT 0 NOT NULL, project_id integer DEFAULT 0 NOT NULL, subject character varying(255) NOT NULL, description text, due_date date, category_id integer, status_id integer DEFAULT 0 NOT NULL, assigned_to_id integer, priority_id integer DEFAULT 0 NOT NULL, fixed_version_id integer, author_id integer DEFAULT 0 NOT NULL, lock_version integer DEFAULT 0 NOT NULL, created_on timestamp without time zone, updated_on timestamp without time zone, start_date date, done_ratio integer DEFAULT 0 NOT NULL, estimated_hours double precision)
  INSERT INTO workflows VALUES (17, 1, 4, 2, 3)
  INSERT INTO schema_migrations VALUES ('36')
  INSERT INTO schema_migrations VALUES ('52')
  INSERT INTO schema_migrations VALUES ('97')
  INSERT INTO workflows VALUES (6, 1, 2, 1, 3)
  INSERT INTO workflows VALUES (41, 2, 3, 1, 3)
  CREATE TABLE {prefix}versions ( id integer NOT NULL, project_id integer DEFAULT 0 NOT NULL, name character varying(255) NOT NULL, description character varying(255) DEFAULT NULL::character varying, effective_date date, created_on timestamp without time zone, updated_on timestamp without time zone, wiki_page_title character varying(255) DEFAULT NULL::character varying)
  INSERT INTO schema_migrations VALUES ('58')
  INSERT INTO workflows VALUES (100, 1, 3, 5, 4)
  CREATE TABLE IF NOT EXISTS `boards` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `position` int(11) DEFAULT '1', `topics_count` int(11) NOT NULL DEFAULT '0', `messages_count` int(11) NOT NULL DEFAULT '0', `last_message_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `boards_project_id` (`project_id`))
  INSERT INTO workflows VALUES (32, 2, 1, 3, 3)
  INSERT INTO schema_migrations VALUES ('100')
  CREATE TABLE IF NOT EXISTS `changesets_issues` ( `changeset_id` int(11) NOT NULL, `issue_id` int(11) NOT NULL, UNIQUE KEY `changesets_issues_ids` (`changeset_id`,`issue_id`))
  CREATE TABLE IF NOT EXISTS `schema_migrations` ( `version` varchar(255) NOT NULL, UNIQUE (`version`))
  CREATE INDEX time_entries_project_id ON time_entries 
  CREATE TABLE IF NOT EXISTS `{prefix}members` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT '0', `project_id` int(11) NOT NULL DEFAULT '0', `role_id` int(11) NOT NULL DEFAULT '0', `created_on` datetime DEFAULT NULL, `mail_notification` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id`))
  CREATE TABLE IF NOT EXISTS `{prefix}projects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `description` text COLLATE utf8_unicode_ci, `homepage` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `is_public` tinyint(1) NOT NULL DEFAULT '1', `parent_id` int(11) DEFAULT NULL, `projects_count` int(11) DEFAULT '0', `created_on` datetime DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `identifier` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `status` int(11) NOT NULL DEFAULT '1', PRIMARY KEY (`id`))
  CREATE TABLE ' . $this->Dbo->fullTableName($tableName) . ' (id int(11) AUTO_INCREMENT, bool tinyint(1), small_int tinyint(2), primary key(id))
  INSERT INTO workflows VALUES (47, 2, 4, 2, 3)
  CREATE TABLE IF NOT EXISTS `{prefix}boards` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `position` int(11) DEFAULT '1', `topics_count` int(11) NOT NULL DEFAULT '0', `messages_count` int(11) NOT NULL DEFAULT '0', `last_message_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `boards_project_id` (`project_id`))
  INSERT INTO schema_migrations VALUES ('43')
  CREATE TABLE {prefix}wiki_content_versions ( id integer NOT NULL, wiki_content_id integer NOT NULL, page_id integer NOT NULL, author_id integer, data bytea, compression character varying(6) DEFAULT NULL::character varying, comments character varying(255) DEFAULT NULL::character varying, updated_on timestamp without time zone NOT NULL, version integer NOT NULL)
  INSERT INTO enabled_modules VALUES (6, 1, 'wiki')
  INSERT INTO schema_migrations VALUES ('85')
  INSERT INTO workflows VALUES (88, 3, 6, 3, 3)
  INSERT INTO roles VALUES (3, 'Manager', 3, true, 0, '--- - :edit_project- :select_project_modules- :manage_members- :manage_versions- :manage_categories- :add_issues- :edit_issues- :manage_issue_relations- :add_issue_notes- :edit_issue_notes- :edit_own_issue_notes- :move_issues- :delete_issues- :manage_public_queries- :save_queries- :view_gantt- :view_calendar- :view_issue_watchers- :add_issue_watchers- :log_time- :view_time_entries- :edit_time_entries- :edit_own_time_entries- :manage_news- :comment_news- :manage_documents- :view_documents- :manage_files- :view_files- :manage_wiki- :rename_wiki_pages- :delete_wiki_pages- :view_wiki_pages- :view_wiki_edits- :edit_wiki_pages- :delete_wiki_pages_attachments- :protect_wiki_pages- :manage_repository- :browse_repository- :view_changesets- :commit_access- :manage_boards- :add_messages- :edit_messages- :edit_own_messages- :delete_messages- :delete_own_messages')
  INSERT INTO schema_migrations VALUES ('83')
  INSERT INTO schema_migrations VALUES ('96')
  CREATE TABLE IF NOT EXISTS `wiki_content_versions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `wiki_content_id` int(11) NOT NULL, `page_id` int(11) NOT NULL, `author_id` int(11) DEFAULT NULL, `data` blob, `compression` varchar(6) COLLATE utf8_unicode_ci DEFAULT '', `comments` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `updated_on` datetime NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `wiki_content_versions_wcid` (`wiki_content_id`))
  CREATE INDEX wiki_redirects_wiki_id_title ON wiki_redirects 
  SELECT name FROM ' . $this->Dbo->fullTableName('apples') . ' ORDER BY id');
  INSERT INTO workflows VALUES (138, 2, 4, 5, 5)
  INSERT INTO workflows VALUES (44, 2, 3, 5, 3)
  INSERT INTO workflows VALUES (43, 2, 3, 4, 3)
  CREATE TABLE {prefix}user_preferences ( id integer NOT NULL, user_id integer DEFAULT 0 NOT NULL, others text, hide_mail boolean DEFAULT false, time_zone character varying(255) DEFAULT NULL::character varying)
  CREATE TABLE IF NOT EXISTS `{prefix}journal_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `journal_id` int(11) NOT NULL DEFAULT '0', `property` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `prop_key` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `old_value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `value` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`), KEY `journal_details_journal_id` (`journal_id`))
  INSERT INTO schema_migrations VALUES ('93')
  INSERT INTO workflows VALUES (38, 2, 2, 4, 3)
  CREATE INDEX wiki_content_versions_wcid ON wiki_content_versions 
  CREATE TABLE {prefix}workflows ( id integer NOT NULL, tracker_id integer DEFAULT 0 NOT NULL, old_status_id integer DEFAULT 0 NOT NULL, new_status_id integer DEFAULT 0 NOT NULL, role_id integer DEFAULT 0 NOT NULL)
  INSERT INTO workflows VALUES (109, 2, 2, 4, 4)
  INSERT INTO schema_migrations VALUES ('86')
  SELECT color, name FROM ' . $this->Dbo->fullTableName('apples'));
  INSERT INTO workflows VALUES (72, 3, 3, 2, 3)
  CREATE TABLE IF NOT EXISTS `{prefix}news` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) DEFAULT NULL, `title` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `summary` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `description` text COLLATE utf8_unicode_ci, `author_id` int(11) NOT NULL DEFAULT '0', `created_on` datetime DEFAULT NULL, `comments_count` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `news_project_id` (`project_id`))
  CREATE TABLE IF NOT EXISTS `settings` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `name` varchar(30) NOT NULL DEFAULT '', `value` text, `updated_on` datetime DEFAULT NULL)
  CREATE TABLE issues ( id integer NOT NULL, tracker_id integer DEFAULT 0 NOT NULL, project_id integer DEFAULT 0 NOT NULL, subject character varying(255) NOT NULL, description text, due_date date, category_id integer, status_id integer DEFAULT 0 NOT NULL, assigned_to_id integer, priority_id integer DEFAULT 0 NOT NULL, fixed_version_id integer, author_id integer DEFAULT 0 NOT NULL, lock_version integer DEFAULT 0 NOT NULL, created_on timestamp without time zone, updated_on timestamp without time zone, start_date date, done_ratio integer DEFAULT 0 NOT NULL, estimated_hours double precision)
  INSERT INTO workflows VALUES (125, 3, 3, 4, 4)
  INSERT INTO workflows VALUES (96, 1, 2, 4, 4)
  INSERT INTO workflows VALUES (134, 1, 3, 4, 5)
  CREATE TABLE cake_sessions ( id varchar(255) NOT NULL default '', data text, expires int(11) default NULL, PRIMARY KEY (id))
  CREATE TABLE test_uuid_describe (id UUID PRIMARY KEY, name VARCHAR(255))
  INSERT INTO workflows VALUES (28, 1, 6, 3, 3)
  CREATE TABLE ' . $name . ' (id bigint(20) AUTO_INCREMENT, bool tinyint(1), small_int tinyint(2), primary key(id))
  CREATE TABLE IF NOT EXISTS `{prefix}messages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `board_id` int(11) NOT NULL, `parent_id` int(11) DEFAULT NULL, `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `content` text COLLATE utf8_unicode_ci, `author_id` int(11) DEFAULT NULL, `replies_count` int(11) NOT NULL DEFAULT '0', `last_reply_id` int(11) DEFAULT NULL, `created_on` datetime NOT NULL, `updated_on` datetime NOT NULL, `locked` tinyint(1) DEFAULT '0', `sticky` int(11) DEFAULT '0', PRIMARY KEY (`id`), KEY `messages_board_id` (`board_id`), KEY `messages_parent_id` (`parent_id`))
  CREATE TABLE {prefix}watchers ( id integer NOT NULL, watchable_type character varying(255) NOT NULL, watchable_id integer DEFAULT 0 NOT NULL, user_id integer)
  INSERT INTO roles VALUES (1, 'Non member', 1, true, 1, '--- - :add_issues- :add_issue_notes- :save_queries- :view_gantt- :view_calendar- :view_time_entries- :comment_news- :view_documents- :view_wiki_pages- :view_wiki_edits- :add_messages- :view_files- :browse_repository- :view_changesets')
  INSERT INTO users VALUES (3, 'testuser', 'AWESOME', '', 'Anonymous', 'test@example.com', false, false, 0, NULL, 'eng', NULL, '2009-03-04 23:02:30', '2009-03-04 23:02:30', 'TestUser')
  INSERT INTO schema_migrations VALUES ('77')
  CREATE TABLE ' . $name . ' (id int(11) AUTO_INCREMENT, bool tinyint(1), small_int tinyint(2), primary key(id), KEY `pointless_bool` ( `bool` ), KEY `pointless_small_int` ( `small_int` ))
  INSERT INTO enumerations VALUES (4, 'IPRI', 'Normal', 2, true)
  INSERT INTO schema_migrations VALUES ('84')
  CREATE INDEX idx_acos_lft_rght ON `acos` (`lft`, `rght`);
  INSERT INTO schema_migrations VALUES ('5')
  CREATE TABLE news ( id integer NOT NULL, project_id integer, title character varying(60) NOT NULL, summary character varying(255) DEFAULT NULL::character varying, description text, author_id integer DEFAULT 0 NOT NULL, created_on timestamp without time zone, comments_count integer DEFAULT 0 NOT NULL)
  CREATE TABLE ' . $table . ' (id int(11) AUTO_INCREMENT, bool tinyint(1), small_int tinyint(2), primary key(id))
  CREATE INDEX idx_aros_alias ON `aros` (`alias`);
  INSERT INTO workflows VALUES (13, 1, 3, 4, 3)
  CREATE TABLE IF NOT EXISTS `{prefix}issue_statuses` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `is_closed` tinyint(1) NOT NULL DEFAULT '0', `is_default` tinyint(1) NOT NULL DEFAULT '0', `position` int(11) DEFAULT '1', PRIMARY KEY (`id`))
  INSERT INTO roles VALUES (2, 'Anonymous', 2, true, 2, '--- - :view_gantt- :view_calendar- :view_time_entries- :view_documents- :view_wiki_pages- :view_wiki_edits- :view_files- :browse_repository- :view_changesets')
  CREATE TABLE IF NOT EXISTS `{prefix}issue_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL DEFAULT '0', `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `assigned_to_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), KEY `issue_categories_project_id` (`project_id`))
  CREATE TABLE IF NOT EXISTS `users` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `login` varchar(30) NOT NULL DEFAULT '', `hashed_password` varchar(40) NOT NULL DEFAULT '', `firstname` varchar(30) NOT NULL DEFAULT '', `lastname` varchar(30) NOT NULL DEFAULT '', `mail` varchar(60) NOT NULL DEFAULT '', `mail_notification` tinyinteger(1) NOT NULL DEFAULT '1', `admin` tinyinteger(1) NOT NULL DEFAULT '0', `status` integer(11) NOT NULL DEFAULT '1', `last_login_on` datetime DEFAULT NULL, `language` varchar(5) DEFAULT '', `auth_source_id` integer(11) DEFAULT NULL, `created_on` datetime DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `type` varchar(255) DEFAULT NULL)
  CREATE TABLE IF NOT EXISTS `journal_details` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `journal_id` integer(11) NOT NULL DEFAULT '0', `property` varchar(30) NOT NULL DEFAULT '', `prop_key` varchar(30) NOT NULL DEFAULT '', `old_value` varchar(255) DEFAULT NULL, `value` varchar(255) DEFAULT NULL)
  INSERT INTO workflows VALUES (112, 2, 3, 4, 4)
  CREATE INDEX projects_trackers_project_id ON projects_trackers 
  CREATE TABLE IF NOT EXISTS `issue_relations` ( `id` int(11) NOT NULL AUTO_INCREMENT, `issue_from_id` int(11) NOT NULL, `issue_to_id` int(11) NOT NULL, `relation_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `delay` int(11) DEFAULT NULL, PRIMARY KEY (`id`))
  INSERT INTO workflows VALUES (42, 2, 3, 2, 3)
  INSERT INTO workflows VALUES (80, 3, 4, 6, 3)
  CREATE TABLE IF NOT EXISTS `{prefix}user_preferences` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT '0', `others` text COLLATE utf8_unicode_ci, `hide_mail` tinyint(1) DEFAULT '0', `time_zone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`))
  INSERT INTO schema_migrations VALUES ('42')
  INSERT INTO enabled_modules VALUES (1, 1, 'issue_tracking')
  update saved_urls set url = :url  where id = :id
  SELECT * from poo_query < 5 and :seven'), $result);
  INSERT INTO enabled_modules VALUES (3, 1, 'news')
  INSERT INTO workflows VALUES (48, 2, 4, 3, 3)
  INSERT INTO schema_migrations VALUES ('87')
  CREATE TABLE tokens ( id integer NOT NULL, user_id integer DEFAULT 0 NOT NULL, action character varying(30) NOT NULL, value character varying(40) NOT NULL, created_on timestamp without time zone NOT NULL)
  CREATE TABLE IF NOT EXISTS `attachments` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `container_id` integer(11) NOT NULL DEFAULT '0', `container_type` varchar(30) NOT NULL DEFAULT '', `filename` varchar(255) NOT NULL DEFAULT '', `disk_filename` varchar(255) NOT NULL DEFAULT '', `filesize` integer(11) NOT NULL DEFAULT '0', `content_type` varchar(255) DEFAULT '', `digest` varchar(40) NOT NULL DEFAULT '', `downloads` integer(11) NOT NULL DEFAULT '0', `author_id` integer(11) NOT NULL DEFAULT '0', `created_on` datetime DEFAULT NULL, `description` varchar(255) DEFAULT NULL)
  CREATE TABLE IF NOT EXISTS `time_entries` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `project_id` integer(11) NOT NULL, `user_id` integer(11) NOT NULL, `issue_id` integer(11) DEFAULT NULL, `hours` float NOT NULL, `comments` varchar(255) DEFAULT NULL, `activity_id` integer(11) NOT NULL, `spent_on` date NOT NULL, `tyear` integer(11) NOT NULL, `tmonth` integer(11) NOT NULL, `tweek` integer(11) NOT NULL, `created_on` datetime NOT NULL, `updated_on` datetime NOT NULL)
  CREATE TABLE IF NOT EXISTS `issues` ( `id` int(11) NOT NULL AUTO_INCREMENT, `tracker_id` int(11) NOT NULL DEFAULT '0', `project_id` int(11) NOT NULL DEFAULT '0', `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `description` text COLLATE utf8_unicode_ci, `due_date` date DEFAULT NULL, `category_id` int(11) DEFAULT NULL, `status_id` int(11) NOT NULL DEFAULT '0', `assigned_to_id` int(11) DEFAULT NULL, `priority_id` int(11) NOT NULL DEFAULT '0', `fixed_version_id` int(11) DEFAULT NULL, `author_id` int(11) NOT NULL DEFAULT '0', `lock_version` int(11) NOT NULL DEFAULT '0', `created_on` datetime DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `start_date` date DEFAULT NULL, `done_ratio` int(11) NOT NULL DEFAULT '0', `estimated_hours` float DEFAULT NULL, PRIMARY KEY (`id`), KEY `issues_project_id` (`project_id`))
  INSERT INTO schema_migrations VALUES ('69')
  INSERT INTO enumerations VALUES (2, 'DCAT', 'Technical documentation', 2, false)
  INSERT INTO users VALUES (2, '', '', '', 'Anonymous', '', false, false, 0, NULL, 'eng', NULL, '2009-03-04 23:02:30', '2009-03-04 23:02:30', 'AnonymousUser')
  INSERT INTO workflows VALUES (118, 3, 1, 3, 4)
  INSERT INTO schema_migrations VALUES ('88')
  INSERT INTO schema_migrations VALUES ('10')
  INSERT INTO enabled_modules VALUES (8, 1, 'boards')
  INSERT INTO workflows VALUES (35, 2, 1, 6, 3)
  CREATE TABLE IF NOT EXISTS `{prefix}changesets_issues` ( `changeset_id` int(11) NOT NULL, `issue_id` int(11) NOT NULL, UNIQUE KEY `changesets_issues_ids` (`changeset_id`,`issue_id`))
  INSERT INTO workflows VALUES (30, 1, 6, 5, 3)
  CREATE TABLE IF NOT EXISTS `user_preferences` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT '0', `others` text COLLATE utf8_unicode_ci, `hide_mail` tinyint(1) DEFAULT '0', `time_zone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`))
  CREATE TABLE {prefix}enabled_modules ( id integer NOT NULL, project_id integer, name character varying(255) NOT NULL)
  CREATE TABLE attachments ( id integer NOT NULL, container_id integer DEFAULT 0 NOT NULL, container_type character varying(30) NOT NULL, filename character varying(255) NOT NULL, disk_filename character varying(255) NOT NULL, filesize integer DEFAULT 0 NOT NULL, content_type character varying(255) DEFAULT NULL::character varying, digest character varying(40) NOT NULL, downloads integer DEFAULT 0 NOT NULL, author_id integer DEFAULT 0 NOT NULL, created_on timestamp without time zone, description character varying(255) DEFAULT NULL::character varying)
  INSERT INTO roles VALUES (4, 'Developer', 4, true, 0, '--- - :manage_versions- :manage_categories- :add_issues- :edit_issues- :manage_issue_relations- :add_issue_notes- :save_queries- :view_gantt- :view_calendar- :log_time- :view_time_entries- :comment_news- :view_documents- :view_wiki_pages- :view_wiki_edits- :edit_wiki_pages- :delete_wiki_pages- :add_messages- :edit_own_messages- :view_files- :manage_files- :browse_repository- :view_changesets- :commit_access')
  CREATE TABLE IF NOT EXISTS `changesets` ( `id` int(11) NOT NULL AUTO_INCREMENT, `repository_id` int(11) NOT NULL, `revision` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `committer` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `committed_on` datetime NOT NULL, `comments` text COLLATE utf8_unicode_ci, `commit_date` date DEFAULT NULL, `scmid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `user_id` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `changesets_repos_rev` (`repository_id`,`revision`))
  INSERT INTO schema_migrations VALUES ('34')
  CREATE TABLE {prefix}changesets ( id integer NOT NULL, repository_id integer NOT NULL, revision character varying(255) NOT NULL, committer character varying(255) DEFAULT NULL::character varying, committed_on timestamp without time zone NOT NULL, comments text, commit_date date, scmid character varying(255) DEFAULT NULL::character varying, user_id integer)
  CREATE TABLE IF NOT EXISTS `{prefix}roles` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `position` int(11) DEFAULT '1', `assignable` tinyint(1) DEFAULT '1', `builtin` int(11) NOT NULL DEFAULT '0', `permissions` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`))
  INSERT INTO schema_migrations VALUES ('78')
  CREATE TABLE IF NOT EXISTS `{prefix}wiki_content_versions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `wiki_content_id` int(11) NOT NULL, `page_id` int(11) NOT NULL, `author_id` int(11) DEFAULT NULL, `data` blob, `compression` varchar(6) COLLATE utf8_unicode_ci DEFAULT '', `comments` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `updated_on` datetime NOT NULL, `version` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `wiki_content_versions_wcid` (`wiki_content_id`))
  INSERT INTO workflows VALUES (94, 1, 1, 5, 4)
  INSERT INTO schema_migrations VALUES ('73')
  CREATE TABLE IF NOT EXISTS `{prefix}queries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) DEFAULT NULL, `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `filters` text COLLATE utf8_unicode_ci, `user_id` int(11) NOT NULL DEFAULT '0', `is_public` tinyint(1) NOT NULL DEFAULT '0', `column_names` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`))
  INSERT INTO workflows VALUES (49, 2, 4, 5, 3)
  INSERT INTO schema_migrations VALUES ('41')
  CREATE TABLE ' . $name . ' (id int(11) AUTO_INCREMENT, text_field1 text, text_field2 text, primary key(id), KEY `text_index` ( `text_field1`(20), `text_field2`(20) ))
  CREATE TABLE {prefix}custom_values ( id integer NOT NULL, customized_type character varying(30) NOT NULL, customized_id integer DEFAULT 0 NOT NULL, custom_field_id integer DEFAULT 0 NOT NULL, value text)
  CREATE TABLE {prefix}repositories ( id integer NOT NULL, project_id integer DEFAULT 0 NOT NULL, url character varying(255) NOT NULL, login character varying(60) DEFAULT NULL::character varying, password character varying(60) DEFAULT NULL::character varying, root_url character varying(255) DEFAULT NULL::character varying, type character varying(255) DEFAULT NULL::character varying)
  CREATE TABLE journals ( id integer NOT NULL, journalized_id integer DEFAULT 0 NOT NULL, journalized_type character varying(30) NOT NULL, user_id integer DEFAULT 0 NOT NULL, notes text, created_on timestamp without time zone NOT NULL)
  INSERT INTO schema_migrations VALUES ('29')
  INSERT INTO schema_migrations VALUES ('23')
  INSERT INTO workflows VALUES (29, 1, 6, 4, 3)
  CREATE INDEX boards_project_id ON boards 
  SELECT * FROM ' . $this->db->fullTableName('articles');
  INSERT INTO schema_migrations VALUES ('56')
  CREATE INDEX wkfs_role_tracker_old_status ON workflows 
  CREATE TABLE IF NOT EXISTS `comments` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `commented_type` varchar(30) NOT NULL DEFAULT '', `commented_id` integer(11) NOT NULL DEFAULT '0', `author_id` integer(11) NOT NULL DEFAULT '0', `comments` text, `created_on` datetime NOT NULL, `updated_on` datetime NOT NULL)
  CREATE TABLE {$tableName} (id VARCHAR(36) PRIMARY KEY, name VARCHAR, created DATETIME, modified DATETIME)
  INSERT INTO workflows VALUES (90, 3, 6, 5, 3)
  INSERT INTO workflows VALUES (111, 2, 3, 2, 4)
  INSERT INTO schema_migrations VALUES ('55')
  CREATE TABLE IF NOT EXISTS `issue_categories` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `project_id` integer(11) NOT NULL DEFAULT '0', `name` varchar(30) NOT NULL DEFAULT '', `assigned_to_id` integer(11) DEFAULT NULL)
  CREATE TABLE {prefix}queries ( id integer NOT NULL, project_id integer, name character varying(255) NOT NULL, filters text, user_id integer DEFAULT 0 NOT NULL, is_public boolean DEFAULT false NOT NULL, column_names text)
  SELECT id, created FROM ';
  INSERT INTO schema_migrations VALUES ('6')
  INSERT INTO schema_migrations VALUES ('99')
  INSERT INTO issue_statuses VALUES (6, 'Rejected', true, true, 6)
  CREATE INDEX news_project_id ON news 
  CREATE INDEX issue_categories_project_id ON issue_categories 
  INSERT INTO enumerations VALUES (1, 'DCAT', 'User documentation', 1, false)
  CREATE TABLE IF NOT EXISTS `watchers` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `watchable_type` varchar(255) NOT NULL DEFAULT '', `watchable_id` integer(11) NOT NULL DEFAULT '0', `user_id` integer(11) DEFAULT NULL)
  INSERT INTO enabled_modules VALUES (2, 1, 'time_tracking')
  INSERT INTO workflows VALUES (78, 3, 4, 3, 3)
  CREATE INDEX changesets_changeset_id ON changes 
  INSERT INTO schema_migrations VALUES ('80')
  CREATE TABLE IF NOT EXISTS `members` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `user_id` integer(11) NOT NULL DEFAULT '0', `project_id` integer(11) NOT NULL DEFAULT '0', `role_id` integer(11) NOT NULL DEFAULT '0', `created_on` datetime DEFAULT NULL, `mail_notification` tinyinteger(1) NOT NULL DEFAULT '0')
  CREATE TABLE {prefix}wiki_pages ( id integer NOT NULL, wiki_id integer NOT NULL, title character varying(255) NOT NULL, created_on timestamp without time zone NOT NULL, protected boolean DEFAULT false NOT NULL, parent_id integer)
  INSERT INTO schema_migrations VALUES ('44')
  CREATE TABLE IF NOT EXISTS `custom_values` ( `id` int(11) NOT NULL AUTO_INCREMENT, `customized_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `customized_id` int(11) NOT NULL DEFAULT '0', `custom_field_id` int(11) NOT NULL DEFAULT '0', `value` text COLLATE utf8_unicode_ci, PRIMARY KEY (`id`), KEY `custom_values_customized` (`customized_type`,`customized_id`))
  CREATE TABLE custom_fields_projects ( custom_field_id integer DEFAULT 0 NOT NULL, project_id integer DEFAULT 0 NOT NULL)
  INSERT INTO schema_migrations VALUES ('32')
  INSERT INTO workflows VALUES (45, 2, 3, 6, 3)
  INSERT INTO workflows VALUES (27, 1, 6, 2, 3)
  CREATE TABLE IF NOT EXISTS `{prefix}repositories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL DEFAULT '0', `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `login` varchar(60) COLLATE utf8_unicode_ci DEFAULT '', `password` varchar(60) COLLATE utf8_unicode_ci DEFAULT '', `root_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`))
  INSERT INTO schema_migrations VALUES ('2')
  INSERT INTO workflows VALUES (73, 3, 3, 4, 3)
  CREATE TABLE projects_trackers ( project_id integer DEFAULT 0 NOT NULL, tracker_id integer DEFAULT 0 NOT NULL)
  INSERT INTO workflows VALUES (60, 2, 6, 5, 3)
  CREATE TABLE $name (	id INT(11) NOT NULL AUTO_INCREMENT,	phone VARCHAR(10),	limit_date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,	PRIMARY KEY(id))
  CREATE TABLE IF NOT EXISTS `wiki_redirects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `wiki_id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `redirects_to` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `created_on` datetime NOT NULL, PRIMARY KEY (`id`), KEY `wiki_redirects_wiki_id_title` (`wiki_id`,`title`))
  INSERT INTO workflows VALUES (81, 3, 5, 1, 3)
  CREATE TABLE changesets_issues ( changeset_id integer NOT NULL, issue_id integer NOT NULL)
  UPDATE users SET admin = 1  WHERE login = ?
  CREATE TABLE {$table} (\n{$columns}{$indexes})
  INSERT INTO workflows VALUES (119, 3, 1, 4, 4)
  CREATE TABLE IF NOT EXISTS `tokens` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `user_id` integer(11) NOT NULL DEFAULT '0', `action` varchar(30) NOT NULL DEFAULT '', `value` varchar(40) NOT NULL DEFAULT '', `created_on` datetime NOT NULL)
  CREATE TABLE {$tableName} (id CHAR(36) PRIMARY KEY, name VARCHAR, created DATETIME, modified DATETIME)
  INSERT INTO workflows VALUES (20, 1, 4, 6, 3)
  CREATE TABLE IF NOT EXISTS `{prefix}wiki_redirects` ( `id` int(11) NOT NULL AUTO_INCREMENT, `wiki_id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `redirects_to` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `created_on` datetime NOT NULL, PRIMARY KEY (`id`), KEY `wiki_redirects_wiki_id_title` (`wiki_id`,`title`))
  SELECT COUNT(*) FROM $commentsTable WHERE `Article`.`id` = `$commentsTable`.`article_id`) > 5";
  INSERT INTO issue_statuses VALUES (2, 'Assigned', false, true, 2)
  INSERT INTO workflows VALUES (11, 1, 3, 1, 3)
  INSERT INTO schema_migrations VALUES ('90')
  INSERT INTO projects_trackers VALUES (1, 1)
  INSERT INTO workflows VALUES (92, 1, 1, 3, 4)
  INSERT INTO schema_migrations VALUES ('89')
  INSERT INTO workflows VALUES (122, 3, 2, 4, 4)
  CREATE TABLE {prefix}comments ( id integer NOT NULL, commented_type character varying(30) NOT NULL, commented_id integer DEFAULT 0 NOT NULL, author_id integer DEFAULT 0 NOT NULL, comments text, created_on timestamp without time zone NOT NULL, updated_on timestamp without time zone NOT NULL)
  CREATE TABLE IF NOT EXISTS `news` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `project_id` integer(11) DEFAULT NULL, `title` varchar(60) NOT NULL DEFAULT '', `summary` varchar(255) DEFAULT '', `description` text, `author_id` integer(11) NOT NULL DEFAULT '0', `created_on` datetime DEFAULT NULL, `comments_count` integer(11) NOT NULL DEFAULT '0')
  INSERT INTO workflows VALUES (131, 1, 2, 5, 5)
  CREATE TABLE ' . $name . ' (id int(11) AUTO_INCREMENT, text_field text, primary key(id), KEY `text_index` ( `text_field`(20) ))
  INSERT INTO schema_migrations VALUES ('14')
  CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `login` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `hashed_password` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `firstname` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `lastname` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `mail` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `mail_notification` tinyint(1) NOT NULL DEFAULT '1', `admin` tinyint(1) NOT NULL DEFAULT '0', `status` int(11) NOT NULL DEFAULT '1', `last_login_on` datetime DEFAULT NULL, `language` varchar(5) COLLATE utf8_unicode_ci DEFAULT '', `auth_source_id` int(11) DEFAULT NULL, `created_on` datetime DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`))
  CREATE TABLE foo_test (test VARCHAR(255))
  CREATE TABLE IF NOT EXISTS `repositories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `project_id` int(11) NOT NULL DEFAULT '0', `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `login` varchar(60) COLLATE utf8_unicode_ci DEFAULT '', `password` varchar(60) COLLATE utf8_unicode_ci DEFAULT '', `root_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT '', `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`id`))
  INSERT INTO enabled_modules VALUES (7, 1, 'repository')
  INSERT INTO schema_migrations VALUES ('62')
  CREATE TABLE IF NOT EXISTS `wiki_content_versions` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `wiki_content_id` integer(11) NOT NULL, `page_id` integer(11) NOT NULL, `author_id` integer(11) DEFAULT NULL, `data` blob, `compression` varchar(6) DEFAULT '', `comments` varchar(255) DEFAULT '', `updated_on` datetime NOT NULL, `version` integer(11) NOT NULL)
  CREATE TABLE {prefix}wikis ( id integer NOT NULL, project_id integer NOT NULL, start_page character varying(255) NOT NULL, status integer DEFAULT 1 NOT NULL)
  INSERT INTO workflows VALUES (8, 1, 2, 4, 3)
  INSERT INTO workflows VALUES (95, 1, 2, 3, 4)
  CREATE TABLE wikis ( id integer NOT NULL, project_id integer NOT NULL, start_page character varying(255) NOT NULL, status integer DEFAULT 1 NOT NULL)
  SELECT * from poo_query < 5 and :seven';
  CREATE TABLE IF NOT EXISTS `{prefix}trackers` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `is_in_chlog` tinyint(1) NOT NULL DEFAULT '0', `position` int(11) DEFAULT '1', `is_in_roadmap` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`))
  INSERT INTO workflows VALUES (9, 1, 2, 5, 3)
  INSERT INTO workflows VALUES (36, 2, 2, 1, 3)
  INSERT INTO workflows VALUES (136, 2, 2, 5, 5)
  CREATE TABLE IF NOT EXISTS `messages` ( `id` int(11) NOT NULL AUTO_INCREMENT, `board_id` int(11) NOT NULL, `parent_id` int(11) DEFAULT NULL, `subject` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `content` text COLLATE utf8_unicode_ci, `author_id` int(11) DEFAULT NULL, `replies_count` int(11) NOT NULL DEFAULT '0', `last_reply_id` int(11) DEFAULT NULL, `created_on` datetime NOT NULL, `updated_on` datetime NOT NULL, `locked` tinyint(1) DEFAULT '0', `sticky` int(11) DEFAULT '0', PRIMARY KEY (`id`), KEY `messages_board_id` (`board_id`), KEY `messages_parent_id` (`parent_id`))
  CREATE TABLE time_entries ( id integer NOT NULL, project_id integer NOT NULL, user_id integer NOT NULL, issue_id integer, hours double precision NOT NULL, comments character varying(255) DEFAULT NULL::character varying, activity_id integer NOT NULL, spent_on date NOT NULL, tyear integer NOT NULL, tmonth integer NOT NULL, tweek integer NOT NULL, created_on timestamp without time zone NOT NULL, updated_on timestamp without time zone NOT NULL)
  INSERT INTO enabled_modules VALUES (5, 1, 'files')
  CREATE TABLE {prefix}settings ( id integer NOT NULL, name character varying(30) NOT NULL, value text, updated_on timestamp without time zone)
  INSERT INTO workflows VALUES (79, 3, 4, 5, 3)
  INSERT INTO workflows VALUES (75, 3, 3, 6, 3)
  INSERT INTO schema_migrations VALUES ('63')
  CREATE TABLE IF NOT EXISTS `issues` ( `id` integer NOT NULL PRIMARY KEY AUTOINCREMENT, `tracker_id` integer(11) NOT NULL DEFAULT '0', `project_id` integer(11) NOT NULL DEFAULT '0', `subject` varchar(255) NOT NULL DEFAULT '', `description` text, `due_date` date DEFAULT NULL, `category_id` integer(11) DEFAULT NULL, `status_id` integer(11) NOT NULL DEFAULT '0', `assigned_to_id` integer(11) DEFAULT NULL, `priority_id` integer(11) NOT NULL DEFAULT '0', `fixed_version_id` integer(11) DEFAULT NULL, `author_id` integer(11) NOT NULL DEFAULT '0', `lock_version` integer(11) NOT NULL DEFAULT '0', `created_on` datetime DEFAULT NULL, `updated_on` datetime DEFAULT NULL, `start_date` date DEFAULT NULL, `done_ratio` integer(11) NOT NULL DEFAULT '0', `estimated_hours` float DEFAULT NULL)
  INSERT INTO enumerations VALUES (7, 'IPRI', 'Immediate', 5, false)
  INSERT INTO workflows VALUES (110, 2, 2, 5, 4)
  INSERT INTO workflows VALUES (65, 3, 1, 6, 3)
  