CREATE TABLE `account_authorizations` (
  `id` int(11) NOT NULL auto_increment,
  `account_id` int(11) default NULL,
  `expires_at` datetime default NULL,
  `payment_id` int(11) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `accounts` (
  `id` int(11) NOT NULL auto_increment,
  `party_id` int(11) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `expires_at` datetime default NULL,
  `options` text,
  `master` tinyint(1) NOT NULL default '0',
  `title` varchar(255) default NULL,
  `last_paid_at` datetime default NULL,
  `payment_plan_id` int(8) default NULL,
  `confirmation_token_expires_at` datetime default NULL,
  `confirmation_token` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `asset_authorizations` (
  `id` int(11) NOT NULL auto_increment,
  `attachment_id` int(11) NOT NULL,
  `email` varchar(255) default NULL,
  `name` varchar(255) default NULL,
  `expires_at` datetime default NULL,
  `private_key` varchar(255) default NULL,
  `url_hash` varchar(255) NOT NULL default '',
  `cookie_hash` varchar(255) default NULL,
  `cookie_instantiation_count` int(11) NOT NULL default '0',
  `download_count` int(11) NOT NULL default '0',
  `unauthorized_access_attempts_count` int(11) NOT NULL default '0',
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `account_id` int(11) default NULL,
  `type` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `by_cookie_hash` (`cookie_hash`),
  UNIQUE KEY `by_url_hash_and_email` (`url_hash`,`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `assets` (
  `id` int(11) NOT NULL auto_increment,
  `account_id` int(11) default NULL,
  `owner_id` int(11) default NULL,
  `parent_id` int(11) default NULL,
  `content_type` varchar(255) default NULL,
  `filename` varchar(255) default NULL,
  `thumbnail` varchar(255) default NULL,
  `size` int(11) default NULL,
  `width` int(11) default NULL,
  `height` int(11) default NULL,
  `title` varchar(255) default NULL,
  `description` text,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `type` varchar(255) default NULL,
  `email_id` int(11) default NULL,
  `archive_id` int(11) default NULL,
  `folder_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `index_assets_on_account_id_and_filename` (`account_id`,`filename`),
  KEY `index_assets_on_account_id_and_title` (`account_id`,`title`),
  KEY `index_assets_on_parent_id_and_thumbnail` (`parent_id`,`thumbnail`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `assignees` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL default '',
  `event_id` int(11) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `party_id` int(11) default NULL,
  `completed_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `task_ref` (`event_id`),
  KEY `staff_member_ref` (`party_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `attachments` (
  `id` int(11) NOT NULL auto_increment,
  `asset_id` int(11) default NULL,
  `email_id` int(11) default NULL,
  `uuid` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `authorizations` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(255) default NULL,
  `object_type` varchar(255) default NULL,
  `object_id` int(11) default NULL,
  `group_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `by_type_and_object_and_group` (`type`,`object_type`,`object_id`,`group_id`),
  KEY `by_type_and_group` (`type`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `breadcrumbs` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(255) NOT NULL,
  `display_name` varchar(255) NOT NULL,
  `updated_at` datetime NOT NULL,
  `target_id` int(11) default NULL,
  `target_type` varchar(255) default NULL,
  `owner_id` int(11) default NULL,
  `icon` varchar(30) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `cached_feed_items` (
  `id` int(11) NOT NULL auto_increment,
  `content` text,
  `summary` text,
  `published_at` datetime default NULL,
  `link` varchar(255) default NULL,
  `title` varchar(255) default NULL,
  `feed_item_id` varchar(255) default NULL,
  `cached_feed_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `cached_feeds` (
  `id` int(11) NOT NULL auto_increment,
  `href` varchar(255) default NULL,
  `title` varchar(255) default NULL,
  `link` varchar(255) default NULL,
  `feed_data` text,
  `feed_data_type` varchar(255) default NULL,
  `http_headers` text,
  `last_retrieved` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `configurations` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(40) NOT NULL default '',
  `name` varchar(60) NOT NULL default '',
  `group_name` varchar(60) default NULL,
  `description` varchar(240) default NULL,
  `product_category_id` int(11) default NULL,
  `product_id` int(11) default NULL,
  `int_value` int(11) default NULL,
  `float_value` float default NULL,
  `str_value` varchar(240) default NULL,
  `party_id` int(11) default NULL,
  `account_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `by_account_id_and_name` (`account_id`,`name`),
  UNIQUE KEY `by_account_id_and_group_name_and_name` (`account_id`,`group_name`,`name`),
  KEY `product_category_id` (`product_category_id`),
  KEY `product_id` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `contact_requests` (
  `id` int(11) NOT NULL auto_increment,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `completed_at` datetime default NULL,
  `name` varchar(80) default NULL,
  `email` varchar(80) default NULL,
  `phone` varchar(30) default NULL,
  `time_to_call` varchar(80) default NULL,
  `subject` varchar(80) default NULL,
  `body` text,
  `account_id` int(11) default NULL,
  `party_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `contact_requests_created_at_index` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `contact_routes` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(60) NOT NULL,
  `position` int(11) NOT NULL default '0',
  `routable_type` varchar(255) default NULL,
  `routable_id` int(11) default NULL,
  `name` varchar(255) NOT NULL,
  `number` varchar(255) default NULL,
  `extension` varchar(255) default NULL,
  `email_address` varchar(255) default NULL,
  `url` varchar(255) default NULL,
  `line1` varchar(255) default NULL,
  `line2` varchar(255) default NULL,
  `line3` varchar(255) default NULL,
  `city` varchar(255) default NULL,
  `state` varchar(255) default NULL,
  `zip` varchar(255) default NULL,
  `country` varchar(255) default NULL,
  `account_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `by_routable_position` (`routable_type`,`routable_id`,`position`),
  KEY `by_type_routable_position` (`type`,`routable_type`,`routable_id`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `denied_permissions` (
  `permission_id` int(11) default NULL,
  `party_id` int(11) default NULL,
  UNIQUE KEY `by_perm_party` (`permission_id`,`party_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `domains` (
  `id` int(11) NOT NULL auto_increment,
  `account_id` int(11) default NULL,
  `name` varchar(255) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `email_accounts` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `type` varchar(255) default NULL,
  `server` varchar(255) default NULL,
  `port` int(11) NOT NULL,
  `username` varchar(255) default NULL,
  `password` varchar(255) default NULL,
  `last_queried_at` varchar(255) default NULL,
  `created_at` varchar(255) default NULL,
  `updated_at` varchar(255) default NULL,
  `account_id` int(8) default NULL,
  `party_id` int(8) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `email_labels` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `account_id` int(11) default NULL,
  `party_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `emails` (
  `id` int(11) NOT NULL auto_increment,
  `subject` varchar(255) default NULL,
  `body` text,
  `scheduled_at` datetime default NULL,
  `sent_at` datetime default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `released_at` datetime default NULL,
  `bad_recipient_count` int(11) default NULL,
  `generate_password` tinyint(1) NOT NULL default '0',
  `unique_id_listing` varchar(255) default NULL,
  `received_at` datetime default NULL,
  `inline_attachments` tinyint(1) NOT NULL default '0',
  `about_type` varchar(255) default NULL,
  `about_id` int(11) default NULL,
  `account_id` int(11) default NULL,
  `message_id` varchar(255) NOT NULL default '',
  `type` varchar(255) default NULL,
  `return_to_url` varchar(255) default NULL,
  `tags_to_remove` varchar(255) default NULL,
  `opt_out_url` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `by_unique_id_listing` (`unique_id_listing`),
  KEY `by_scheduled_sent_released` (`scheduled_at`,`sent_at`,`released_at`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `emails_filters` (
  `filter_id` int(11) default NULL,
  `email_id` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `employees_schedules` (
  `employee_id` int(11) default NULL,
  `schedule_id` int(11) default NULL,
  KEY `employee_id` (`employee_id`),
  KEY `schedule_id` (`schedule_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `engine_schema_info` (
  `engine_name` varchar(255) default NULL,
  `version` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `entries` (
  `id` int(11) NOT NULL auto_increment,
  `content` text,
  `summary` text,
  `published_at` datetime default NULL,
  `link` varchar(255) default NULL,
  `title` varchar(255) default NULL,
  `feed_id` int(11) default NULL,
  `account_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `by_account_id_and_feed_id` (`account_id`,`feed_id`),
  KEY `by_account_id_and_published_at` (`account_id`,`published_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `estimate_lines` (
  `id` int(11) NOT NULL auto_increment,
  `position` int(11) default '0',
  `estimate_id` int(11) NOT NULL default '0',
  `product_id` int(11) default NULL,
  `quantity` int(11) default '0',
  `unit_price` int(11) default '0',
  `comment` varchar(240) default NULL,
  `type` varchar(20) default NULL,
  `estimate_section_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `product_id` (`product_id`),
  KEY `by_estimate_position` (`estimate_id`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `estimate_sections` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(255) default NULL,
  `estimate_id` int(11) NOT NULL,
  `product_id` int(11) default NULL,
  `description` text,
  `length` int(11) default NULL,
  `quantity` int(11) default NULL,
  `width` int(11) default NULL,
  `height` int(11) default NULL,
  `size` varchar(20) default NULL,
  `wrap_style` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `estimates` (
  `id` int(11) NOT NULL auto_increment,
  `company_name` varchar(60) default NULL,
  `last_name` varchar(40) default NULL,
  `first_name` varchar(40) default NULL,
  `email` varchar(80) default NULL,
  `short_description` varchar(40) default NULL,
  `description` text,
  `roof_walking_allowed` int(11) default '0',
  `roof_slope` varchar(20) default NULL,
  `roof_material` varchar(20) default NULL,
  `number_of_floors` int(11) default '0',
  `number_of_sides` int(11) default '0',
  `lot_style` varchar(12) default NULL,
  `building_style` varchar(40) default NULL,
  `measurement_option` varchar(8) default NULL,
  `no_supplies` int(11) default '0',
  `no_labor` int(11) default '0',
  `contact_method` varchar(20) default NULL,
  `call_time` varchar(20) default NULL,
  `default_light_style_id` int(11) default NULL,
  `default_light_color` varchar(20) default NULL,
  `base_price` int(11) default '0',
  `fst_active` int(11) default NULL,
  `fst_name` varchar(6) default NULL,
  `fst_rate` int(11) default NULL,
  `pst_active` int(11) default NULL,
  `pst_name` varchar(6) default NULL,
  `pst_rate` int(11) default NULL,
  `transport_fee` int(11) default NULL,
  `long_cord_product_id` int(11) default NULL,
  `med_cord_product_id` int(11) default NULL,
  `short_cord_product_id` int(11) default NULL,
  `roof_lines` int(11) default '0',
  `roof_lines_length` int(11) default '0',
  `roof_lines_product_id` int(11) default NULL,
  `roof_top` int(11) default '0',
  `roof_top_length` int(11) default '0',
  `roof_top_product_id` int(11) default NULL,
  `eaves` int(11) default '0',
  `eaves_length` int(11) default '0',
  `eaves_product_id` int(11) default NULL,
  `flat_pct` int(11) default '0',
  `moderate_pct` int(11) default '0',
  `steep_pct` int(11) default '0',
  `number_of_peaks` int(11) default '0',
  `windows` int(11) default '0',
  `windows_qty` int(11) default '0',
  `windows_avg_width` int(11) default '0',
  `windows_avg_height` int(11) default '0',
  `windows_product_id` int(11) default NULL,
  `garage_doors` int(11) default '0',
  `garage_doors_qty` int(11) default '0',
  `garage_doors_avg_width` int(11) default '0',
  `garage_doors_avg_height` int(11) default '0',
  `garage_doors_product_id` int(11) default NULL,
  `fences_and_gates` int(11) default '0',
  `fences_and_gates_length` int(11) default '0',
  `fences_and_gates_product_id` int(11) default NULL,
  `bushes` int(11) default '0',
  `bushes_qty` int(11) default '0',
  `bushes_size` varchar(20) default NULL,
  `bushes_product_id` int(11) default NULL,
  `trees` int(11) default '0',
  `trees_qty` int(11) default '0',
  `trees_size` varchar(20) default NULL,
  `trees_wrap_style` varchar(20) default NULL,
  `trees_product_id` int(11) default NULL,
  `paths` int(11) default '0',
  `paths_length` int(11) default '0',
  `paths_product_id` int(11) default NULL,
  `garlands` int(11) default '0',
  `garlands_length` int(11) default '0',
  `garlands_product_id` int(11) default NULL,
  `wreaths` int(11) default '0',
  `wreaths_qty` int(11) default '0',
  `wreaths_product_id` int(11) default NULL,
  `inflatables` int(11) default '0',
  `inflatables_qty` int(11) default '0',
  `inflatables_product_id` int(11) default NULL,
  `ropelight_sculptures` int(11) default '0',
  `ropelight_sculptures_qty` int(11) default '0',
  `ropelight_sculptures_product_id` int(11) default '0',
  `animate` int(11) default '0',
  `animate_product_id` int(11) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `stage` varchar(20) default NULL,
  `billing_customer_id` int(11) default NULL,
  `phone_location` varchar(20) default NULL,
  `phone_number` varchar(20) default NULL,
  `picture_id` int(11) default NULL,
  `equipment_fee` int(11) NOT NULL default '0',
  `apply_federal_tax_on_products` tinyint(1) NOT NULL default '0',
  `apply_federal_tax_on_labor` tinyint(1) NOT NULL default '0',
  `apply_provincial_tax_on_products` tinyint(1) NOT NULL default '0',
  `apply_provincial_tax_on_labor` tinyint(1) NOT NULL default '0',
  `shipping_fee` int(11) default NULL,
  `shipping_method` varchar(255) default NULL,
  `notes` text,
  `static` tinyint(1) NOT NULL default '0',
  `billing_phone_id` int(11) default NULL,
  `billing_address_id` int(11) default NULL,
  `onsite_customer_id` int(11) default NULL,
  `onsite_phone_id` int(11) default NULL,
  `onsite_address_id` int(11) default NULL,
  `uuid` varchar(40) default NULL,
  `last_updated_by_id` int(11) default NULL,
  `account_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `by_uuid` (`uuid`),
  KEY `estimates_customer_id_index` (`billing_customer_id`),
  KEY `by_updated_at` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `events` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(40) default NULL,
  `owner_id` int(11) NOT NULL default '0',
  `scheduled_date` date default NULL,
  `scheduled_time` time default NULL,
  `duration_in_minutes` int(11) default NULL,
  `subject` varchar(255) NOT NULL default '',
  `body` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `reference_id` int(11) default NULL,
  `occured_at` datetime default NULL,
  `account_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `by_date_time` (`scheduled_date`,`scheduled_time`),
  KEY `by_owner_date_time` (`owner_id`,`scheduled_date`,`scheduled_time`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `feeds` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(255) default NULL,
  `account_id` int(11) default NULL,
  `label` varchar(255) default NULL,
  `description` text,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `refreshed_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `index_feeds_on_refreshed_at` (`refreshed_at`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `feeds_parties` (
  `party_id` int(11) default NULL,
  `feed_id` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `filter_lines` (
  `id` int(11) NOT NULL auto_increment,
  `field` varchar(40) default NULL,
  `operator` varchar(40) default NULL,
  `value` varchar(255) default NULL,
  `exclude` tinyint(1) default NULL,
  `filter_id` int(8) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `filters` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `description` varchar(255) default NULL,
  `party_id` int(11) default NULL,
  `account_id` int(11) default NULL,
  `email_label_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `folders` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) default NULL,
  `lft` int(11) default NULL,
  `rgt` int(11) default NULL,
  `updated_at` datetime default NULL,
  `total_size` int(11) default '0',
  `name` varchar(255) NOT NULL default '',
  `account_id` int(11) default NULL,
  `private` tinyint(1) default '0',
  `owner_id` int(11) default NULL,
  `description` text,
  `inherit` tinyint(1) default '0',
  `pass_on_attr` tinyint(1) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `forum_categories` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL,
  `description` varchar(255) default NULL,
  `account_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `forum_posts` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  `topic_id` int(11) default NULL,
  `body` text,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `forum_id` int(11) default NULL,
  `account_id` int(11) default NULL,
  `forum_category_id` int(8) default NULL,
  `rendered_body` text,
  PRIMARY KEY  (`id`),
  KEY `index_posts_on_user_id` (`user_id`),
  KEY `index_posts_on_topic_id` (`topic_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `forum_topics` (
  `id` int(11) NOT NULL auto_increment,
  `forum_id` int(11) default NULL,
  `user_id` int(11) default NULL,
  `title` varchar(255) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `hits` int(11) default '0',
  `sticky` int(11) default '0',
  `posts_count` int(11) default '0',
  `replied_at` datetime default NULL,
  `locked` tinyint(1) default '0',
  `replied_by` int(11) default NULL,
  `last_post_id` int(11) default NULL,
  `account_id` int(11) default NULL,
  `forum_category_id` int(8) default NULL,
  PRIMARY KEY  (`id`),
  KEY `index_topics_on_forum_id` (`forum_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `forums` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `description` varchar(255) default NULL,
  `topics_count` int(11) default '0',
  `posts_count` int(11) default '0',
  `position` int(11) default NULL,
  `account_id` int(11) default NULL,
  `forum_category_id` int(8) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `fulltext_rows` (
  `id` int(11) NOT NULL auto_increment,
  `account_id` int(11) default NULL,
  `subject_id` int(11) default NULL,
  `subject_type` varchar(255) default NULL,
  `subject_updated_at` datetime default NULL,
  `weight` int(11) default NULL,
  `label` varchar(255) default NULL,
  `body` text,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `by_account_weight_subject` (`account_id`,`weight`,`subject_id`,`subject_type`),
  KEY `by_account_weight_updated_subject` (`account_id`,`weight`,`subject_updated_at`,`subject_id`,`subject_type`),
  FULLTEXT KEY `by_label_body` (`label`,`body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE `futures` (
  `id` int(11) NOT NULL auto_increment,
  `type` varchar(255) default NULL,
  `account_id` int(11) default NULL,
  `owner_id` int(11) default NULL,
  `status` varchar(255) default 'unstarted',
  `autoclean` tinyint(1) default '0',
  `args` text,
  `results` text,
  `result_url` varchar(255) default NULL,
  `started_at` datetime default NULL,
  `ended_at` datetime default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `interval` int(11) default NULL,
  `scheduled_at` datetime default NULL,
  `system` tinyint(1) default '0',
  `progress` int(11) NOT NULL default '0',
  `priority` int(11) default '100',
  PRIMARY KEY  (`id`),
  KEY `by_account_status_scheduled_created` (`account_id`,`status`,`scheduled_at`,`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `geopositions` (
  `id` int(11) NOT NULL auto_increment,
  `zip` varchar(255) default NULL,
  `zip_type` varchar(255) default NULL,
  `city_name` varchar(255) default NULL,
  `city_type` varchar(255) default NULL,
  `state_name` varchar(255) default NULL,
  `state_abbr` varchar(255) default NULL,
  `area_code` varchar(255) default NULL,
  `latitude` float default NULL,
  `longitude` float default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `imports` (
  `id` int(11) NOT NULL auto_increment,
  `account_id` int(8) NOT NULL,
  `party_id` int(11) NOT NULL,
  `csv` text,
  `import_errors` text,
  `imported_lines` text,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `filename` varchar(255) default NULL,
  `force` tinyint(1) default NULL,
  `mappings` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `interests` (
  `id` int(11) NOT NULL auto_increment,
  `party_id` int(11) default NULL,
  `listing_id` int(11) default NULL,
  `note` text,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `invoice_lines` (
  `id` int(11) NOT NULL auto_increment,
  `invoice_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `type` varchar(255) NOT NULL default '',
  `product_id` int(11) default NULL,
  `quantity` int(11) NOT NULL,
  `unit_price` int(11) NOT NULL,
  `comment` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  KEY `invoice_lines_invoice_id_index` (`invoice_id`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `invoices` (
  `id` int(11) NOT NULL auto_increment,
  `customer_id` int(11) NOT NULL,
  `no` int(11) NOT NULL,
  `date` date NOT NULL,
  `notes` text,
  `description` text,
  `deposit_amount` int(11) default NULL,
  `transport_fee` int(11) default NULL,
  `equipment_fee` int(11) default NULL,
  `shipping_fee` int(11) default NULL,
  `shipping_method` varchar(255) default NULL,
  `apply_federal_tax_on_products` tinyint(1) NOT NULL default '0',
  `apply_provincial_tax_on_products` tinyint(1) NOT NULL default '0',
  `apply_federal_tax_on_labor` tinyint(1) NOT NULL default '0',
  `apply_provincial_tax_on_labor` tinyint(1) NOT NULL default '0',
  `pst_active` tinyint(1) NOT NULL default '0',
  `pst_name` varchar(255) NOT NULL default '',
  `pst_rate` int(11) NOT NULL,
  `fst_active` tinyint(1) NOT NULL default '0',
  `fst_name` varchar(255) NOT NULL default '',
  `fst_rate` int(11) NOT NULL,
  `picture_id` int(11) default NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `phone_number` varchar(32) NOT NULL default '',
  `paid_in_full` tinyint(1) NOT NULL default '0',
  `voided_at` datetime default NULL,
  `voided_by_id` int(11) default NULL,
  `account_id` int(11) default NULL,
  `status` varchar(40) default NULL,
  PRIMARY KEY  (`id`),
  KEY `invoices_no_index` (`no`),
  KEY `invoices_customer_id_index` (`customer_id`),
  KEY `invoices_date_index` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `items` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) default NULL,
  `creator_id` int(11) default NULL,
  `title` varchar(255) default NULL,
  `slug` varchar(255) default NULL,
  `position` int(11) default NULL,
  `body` text,
  `behavior` varchar(40) default 'plain_text',
  `uuid` varchar(36) default NULL,
  `published_at` datetime default NULL,
  `status` varchar(20) default 'draft',
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `account_id` int(11) default NULL,
  `layout_id` int(11) default NULL,
  `type` varchar(255) default NULL,
  `fullslug` varchar(255) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `by_guid` (`uuid`),
  KEY `by_parent_position` (`account_id`,`parent_id`,`position`),
  KEY `by_account_status_fullslug` (`account_id`,`status`,`fullslug`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `job_slots_teams` (
  `job_slot_id` int(11) NOT NULL default '0',
  `team_id` int(11) NOT NULL default '0',
  KEY `team_id` (`team_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `layouts` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL,
  `body` text,
  `content_type` varchar(255) NOT NULL default 'text/html',
  `encoding` varchar(255) NOT NULL default 'UTF-8',
  `author_id` int(11) NOT NULL,
  `updated_at` datetime default NULL,
  `account_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_categories` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `description` varchar(200) default '',
  `account_id` int(11) default NULL,
  `parent_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `link_categories_links` (
  `link_category_id` int(11) default NULL,
  `link_id` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `links` (
  `id` int(11) NOT NULL auto_increment,
  `picture_id` int(11) default NULL,
  `title` varchar(240) NOT NULL default '',
  `description` text,
  `address` varchar(240) NOT NULL default '',
  `active_on` date default NULL,
  `inactive_on` date default NULL,
  `updated_at` datetime default NULL,
  `account_id` int(11) default NULL,
  `reciprocal` tinyint(1) default '0',
  `reciprocal_address` varchar(255) default NULL,
  `approved` tinyint(1) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `listings` (
  `id` int(11) NOT NULL auto_increment,
  `address_id` int(11) NOT NULL default '0',
  `realtor_id` int(11) default NULL,
  `mls_no` varchar(12) default NULL,
  `fireplace` tinyint(1) NOT NULL default '0',
  `central_ac` tinyint(1) NOT NULL default '0',
  `pool` tinyint(1) NOT NULL default '0',
  `waterfront` tinyint(1) NOT NULL default '0',
  `workshop` tinyint(1) NOT NULL default '0',
  `house_size` float NOT NULL default '0',
  `house_size_unit` varchar(255) NOT NULL default '',
  `lot_size` float NOT NULL default '0',
  `lot_size_unit` varchar(255) NOT NULL default '',
  `features` text,
  `description` text,
  `price` int(11) default NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `uuid` varchar(255) default NULL,
  `public` tinyint(1) NOT NULL default '1',
  `account_id` int(11) default NULL,
  `external_id` varchar(255) default NULL,
  `raw_property_data` text,
  `extras` text,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `by_account_ext_id` (`account_id`,`external_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `mappers` (
  `id` int(11) NOT NULL auto_increment,
  `account_id` int(8) default NULL,
  `mappings` text,
  `name` varchar(63) default NULL,
  `description` varchar(255) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `memberships` (
  `party_id` int(11) default NULL,
  `group_id` int(11) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `migrations_info` (
  `id` int(11) NOT NULL default '0',
  `created_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE `parties` (
  `id` int(11) NOT NULL auto_increment,
  `company_name` varchar(60) default NULL,
  `last_name` varchar(40) default NULL,
  `middle_name` varchar(40) default NULL,
  `first_name` varchar(40) default NULL,
  `honorific` varchar(20) default NULL,
  `notes` text,
  `referal` text,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `archived_at` datetime default NULL,
  `login` varchar(32) default NULL,
  `password_hash` varchar(40) default NULL,
  `website_url` varchar(240) default NULL,
  `dropship_email` varchar(120) default NULL,
  `send_email_on_order` tinyint(1) NOT NULL default '0',
  `order_type` varchar(30) default NULL,
  `climbing_experience` varchar(20) default NULL,
  `rope_work_safety_gear_experience` varchar(20) default NULL,
  `outdoor_gear` tinyint(1) NOT NULL default '0',
  `vehicle_type` varchar(20) default NULL,
  `vehicle_roof_rack` tinyint(1) NOT NULL default '0',
  `team_manager` tinyint(1) NOT NULL default '0',
  `staff_agreement_date` datetime default NULL,
  `staff_agreement_version` int(11) default NULL,
  `on_tour` tinyint(1) NOT NULL default '0',
  `allow_mail_in` tinyint(1) NOT NULL default '0',
  `uuid` varchar(255) default NULL,
  `display_name` varchar(255) NOT NULL default '',
  `posts_count` int(11) NOT NULL default '0',
  `token` varchar(255) default NULL,
  `position` varchar(255) default NULL,
  `account_id` int(11) default NULL,
  `superuser` tinyint(1) NOT NULL default '0',
  `signature` text,
  `password_salt` varchar(40) default NULL,
  `token_expires_at` datetime default NULL,
  `last_logged_in_at` datetime default NULL,
  `created_by_id` int(11) default NULL,
  `updated_by_id` int(11) default NULL,
  `referred_by_id` int(11) default NULL,
  `confirmation_token` varchar(255) default NULL,
  `confirmation_token_expires_at` datetime default NULL,
  `avatar_id` int(11) default NULL,
  `forum_alias` varchar(255) default NULL,
  `timezone` varchar(255) default 'America/Vancouver',
  `birthdate` date default NULL,
  `biography` text,
  `date_format` varchar(255) default '%Y-%m-%d',
  `time_format` varchar(255) default '%H:%M',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `parties_login_index` (`login`,`password_hash`),
  UNIQUE KEY `index_parties_on_token` (`token`),
  KEY `customers_company_name_index` (`company_name`,`last_name`,`first_name`,`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `party_pictures` (
  `id` int(11) NOT NULL auto_increment,
  `description` text,
  `style` varchar(20) NOT NULL default '',
  `party_id` int(11) default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `destroyed_at` datetime default NULL,
  `picture_id` int(11) default NULL,
  `public` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `customer_ref` (`party_id`),
  KEY `party_pictures_public_index` (`public`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `payment_plans` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) default NULL,
  `description` varchar(255) default NULL,
  `duration_in_seconds` int(8) default NULL,
  `amount_in_cents` int(8) default NULL,
  `disabled_at` datetime default NULL,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `payments` (
  `id` int(11) NOT NULL auto_increment,
  `reason` varchar(60) default NULL,
  `amount` int(11) default NULL,
  `status` varchar(40) default NULL,
  `external_txn_id` varchar(60) default NULL,
  `ever_failed` tinyint(1) NOT NULL default '0',
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `type` varchar(40) default NULL,
  `payable_id` int(11) default NULL,
  `payable_type` varchar(255) NOT NULL default '',
  `account_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  KEY `by_invoice_timeline` (`created_at`),
  KEY `by_timeline` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `permission_sets` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `parent_id` int(11) default NULL,
  `created_at` datetime default NULL,
  `created_by_id` int(11) default NULL,
  `updated_at` datetime default NULL,
  `updated_by_id` int(11) default NULL,
  `account_id` int(11) NOT NULL,
  `type` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `permissions` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(80) default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `permissions_name_index` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `pictures` (
  `id` int(11) NOT NULL auto_increment,
  `mime_type` varchar(32) NOT NULL default '',
  `size` int(11) NOT NULL default '0',
  `filename` varchar(96) NOT NULL default '',
  `geometry` varchar(12) NOT NULL default '',
  `public` tinyint(1) NOT NULL default '0',
  `data` blob,
  `title` varchar(120) default NULL,
  `description` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `account_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `product_categories` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(60) default NULL,
  `parent_id` int(11) default NULL,
  `picture_id` int(11) default NULL,
  `account_id` int(11) default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `parent_id` (`parent_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `product_categories_products` (
  `product_id` int(11) NOT NULL default '0',
  `product_category_id` int(11) NOT NULL default '0',
  UNIQUE KEY `product_categories_products_product_id_index` (`product_id`,`product_category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `products` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(80) default '',
  `unit_price` int(11) NOT NULL default '0',
  `base_length` int(11) NOT NULL default '0',
  `product_no` varchar(60) default NULL,
  `description` text,
  `supplier_id` int(11) default NULL,
  `destroyed_at` datetime default NULL,
  `sku` varchar(40) default NULL,
  `barcode` varchar(40) default NULL,
  `availability` varchar(40) default NULL,
  `available_on` date default NULL,
  `last_ordered_on` date default NULL,
  `instock` int(11) NOT NULL default '0',
  `sale_price` int(11) NOT NULL default '0',
  `sale_starts_on` date default NULL,
  `sale_ends_on` date default NULL,
  `wholesale_price` int(11) NOT NULL default '0',
  `destroyed` tinyint(1) NOT NULL default '0',
  `picture_id` int(11) default NULL,
  `account_id` int(11) default NULL,
  `most_recent_supplier_name` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `recipients` (
  `id` int(11) NOT NULL auto_increment,
  `email_id` int(11) default NULL,
  `party_id` int(11) default NULL,
  `sent_at` datetime default NULL,
  `read_at` datetime default NULL,
  `address` varchar(255) default NULL,
  `extras` text,
  `generated_subject` varchar(255) default NULL,
  `generated_body` text,
  `account_id` int(11) default NULL,
  `name` varchar(512) default NULL,
  `type` varchar(255) default NULL,
  `recipient_builder_id` int(11) default NULL,
  `recipient_builder_type` varchar(255) default NULL,
  `tag_syntax` varchar(255) default NULL,
  `uuid` varchar(40) default NULL,
  PRIMARY KEY  (`id`),
  KEY `by_party_type_email` (`party_id`,`type`,`email_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `referrals` (
  `id` int(11) NOT NULL auto_increment,
  `account_id` int(11) default NULL,
  `email_id` int(11) default NULL,
  `parent_id` int(11) default NULL,
  `party_id` int(11) default NULL,
  `uuid` varchar(255) default NULL,
  `created_at` datetime default NULL,
  `referral_url` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `rets_metadatas` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `version` varchar(20) default NULL,
  `date` date default NULL,
  `values` longtext,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `index_rets_metadatas_on_name_and_date_and_version` (`name`,`date`,`version`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `roles` (
  `roleable_id` int(11) default NULL,
  `permission_id` int(11) NOT NULL default '0',
  `roleable_type` varchar(255) default NULL,
  `id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `by_role_perm` (`roleable_type`,`roleable_id`,`permission_id`),
  UNIQUE KEY `by_perm_role` (`permission_id`,`roleable_type`,`roleable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `search_lines` (
  `id` int(11) NOT NULL auto_increment,
  `subject_name` varchar(40) default NULL,
  `subject_option` varchar(40) default NULL,
  `subject_value` varchar(40) default NULL,
  `subject_exclude` tinyint(1) default NULL,
  `priority` int(8) default NULL,
  `search_id` int(8) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `searches` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(40) default NULL,
  `description` varchar(200) default NULL,
  `party_id` int(8) default NULL,
  `account_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `sessions` (
  `id` int(11) NOT NULL auto_increment,
  `sessid` varchar(32) NOT NULL default '',
  `data` text,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `sessid` (`sessid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `sort_lines` (
  `id` int(11) NOT NULL auto_increment,
  `order_name` varchar(40) default NULL,
  `order_mode` varchar(5) default NULL,
  `priority` int(8) default NULL,
  `search_id` int(8) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `taggings` (
  `id` int(11) NOT NULL auto_increment,
  `tag_id` int(11) NOT NULL,
  `taggable_type` varchar(255) NOT NULL default '',
  `taggable_id` int(11) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `taggings_tag_id_index` (`tag_id`,`taggable_type`,`taggable_id`),
  UNIQUE KEY `taggings_taggable_type_index` (`taggable_type`,`taggable_id`,`tag_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `tags` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(80) NOT NULL default '',
  `account_id` int(11) default NULL,
  `system` tinyint(1) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `by_account_name` (`account_id`,`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `teams` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(40) NOT NULL default '',
  `account_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `templates` (
  `id` int(11) NOT NULL auto_increment,
  `subject` varchar(255) default NULL,
  `body` text,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `party_id` int(11) default NULL,
  `account_id` int(11) default NULL,
  `label` varchar(255) default NULL,
  `description` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `testimonials` (
  `id` int(11) NOT NULL auto_increment,
  `party_id` int(11) NOT NULL,
  `testified_on` date NOT NULL,
  `body` text,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `approved_at` datetime default NULL,
  `rejected_at` datetime default NULL,
  `account_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `views` (
  `id` int(11) NOT NULL auto_increment,
  `listing_id` int(11) default NULL,
  `position` int(11) default NULL,
  `name` varchar(255) default NULL,
  `description` text,
  `asset_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO migrations_info VALUES
(0, NOW()),
(1, NOW()),
(2, NOW()),
(3, NOW()),
(4, NOW()),
(5, NOW()),
(6, NOW()),
(7, NOW()),
(8, NOW()),
(9, NOW()),
(10, NOW()),
(11, NOW()),
(12, NOW()),
(13, NOW()),
(14, NOW()),
(15, NOW()),
(16, NOW()),
(17, NOW()),
(18, NOW()),
(19, NOW()),
(20, NOW()),
(21, NOW()),
(22, NOW()),
(23, NOW()),
(24, NOW()),
(25, NOW()),
(26, NOW()),
(27, NOW()),
(28, NOW()),
(29, NOW()),
(30, NOW()),
(31, NOW()),
(32, NOW()),
(33, NOW()),
(34, NOW()),
(35, NOW()),
(36, NOW()),
(37, NOW()),
(38, NOW()),
(39, NOW()),
(40, NOW()),
(41, NOW()),
(42, NOW()),
(43, NOW()),
(44, NOW()),
(45, NOW()),
(46, NOW()),
(47, NOW()),
(48, NOW()),
(49, NOW()),
(50, NOW()),
(51, NOW()),
(52, NOW()),
(53, NOW()),
(54, NOW()),
(55, NOW()),
(56, NOW()),
(57, NOW()),
(58, NOW()),
(59, NOW()),
(60, NOW()),
(61, NOW()),
(62, NOW()),
(63, NOW()),
(64, NOW()),
(65, NOW()),
(66, NOW()),
(67, NOW()),
(68, NOW()),
(69, NOW()),
(70, NOW()),
(71, NOW()),
(72, NOW()),
(73, NOW()),
(74, NOW()),
(75, NOW()),
(76, NOW()),
(77, NOW()),
(78, NOW()),
(79, NOW()),
(80, NOW()),
(81, NOW()),
(82, NOW()),
(83, NOW()),
(84, NOW()),
(85, NOW()),
(86, NOW()),
(87, NOW()),
(88, NOW()),
(89, NOW()),
(90, NOW()),
(91, NOW()),
(92, NOW()),
(93, NOW()),
(94, NOW()),
(95, NOW()),
(96, NOW()),
(97, NOW()),
(98, NOW()),
(99, NOW()),
(100, NOW()),
(101, NOW()),
(102, NOW()),
(103, NOW()),
(104, NOW()),
(105, NOW()),
(106, NOW()),
(107, NOW()),
(108, NOW()),
(109, NOW()),
(110, NOW()),
(111, NOW()),
(112, NOW()),
(113, NOW()),
(114, NOW()),
(115, NOW()),
(116, NOW()),
(117, NOW()),
(118, NOW()),
(119, NOW()),
(120, NOW()),
(121, NOW()),
(122, NOW()),
(123, NOW()),
(124, NOW()),
(125, NOW()),
(126, NOW()),
(127, NOW()),
(128, NOW()),
(129, NOW()),
(130, NOW()),
(131, NOW()),
(132, NOW()),
(133, NOW()),
(134, NOW()),
(135, NOW()),
(136, NOW()),
(137, NOW()),
(138, NOW()),
(139, NOW()),
(140, NOW()),
(141, NOW()),
(142, NOW()),
(143, NOW()),
(144, NOW()),
(145, NOW()),
(146, NOW()),
(147, NOW()),
(148, NOW()),
(149, NOW()),
(150, NOW()),
(151, NOW()),
(152, NOW()),
(153, NOW()),
(154, NOW()),
(155, NOW()),
(156, NOW()),
(157, NOW()),
(158, NOW()),
(159, NOW()),
(160, NOW()),
(161, NOW()),
(162, NOW()),
(163, NOW()),
(164, NOW()),
(165, NOW()),
(166, NOW()),
(167, NOW()),
(168, NOW()),
(169, NOW()),
(170, NOW()),
(171, NOW()),
(172, NOW()),
(173, NOW()),
(174, NOW()),
(175, NOW()),
(176, NOW()),
(177, NOW()),
(178, NOW()),
(183, NOW()),
(184, NOW()),
(185, NOW()),
(186, NOW()),
(187, NOW()),
(188, NOW()),
(189, NOW()),
(190, NOW()),
(191, NOW()),
(192, NOW()),
(193, NOW()),
(194, NOW()),
(195, NOW()),
(196, NOW()),
(197, NOW()),
(198, NOW()),
(199, NOW()),
(200, NOW()),
(201, NOW()),
(202, NOW()),
(203, NOW()),
(204, NOW()),
(205, NOW()),
(206, NOW()),
(207, NOW()),
(208, NOW()),
(209, NOW()),
(210, NOW()),
(211, NOW()),
(212, NOW()),
(213, NOW()),
(214, NOW()),
(215, NOW()),
(216, NOW()),
(217, NOW()),
(220, NOW()),
(221, NOW()),
(222, NOW()),
(223, NOW()),
(224, NOW()),
(225, NOW()),
(226, NOW()),
(227, NOW()),
(228, NOW()),
(229, NOW()),
(230, NOW()),
(231, NOW()),
(233, NOW()),
(234, NOW()),
(235, NOW()),
(236, NOW()),
(238, NOW()),
(239, NOW()),
(240, NOW()),
(241, NOW()),
(242, NOW()),
(243, NOW()),
(244, NOW()),
(245, NOW()),
(246, NOW()),
(247, NOW()),
(248, NOW()),
(249, NOW()),
(250, NOW()),
(251, NOW()),
(252, NOW()),
(253, NOW()),
(254, NOW()),
(255, NOW()),
(256, NOW()),
(257, NOW()),
(258, NOW()),
(259, NOW()),
(260, NOW()),
(261, NOW()),
(262, NOW()),
(263, NOW()),
(264, NOW()),
(265, NOW()),
(266, NOW()),
(267, NOW()),
(268, NOW()),
(269, NOW()),
(270, NOW()),
(271, NOW()),
(272, NOW()),
(273, NOW()),
(274, NOW()),
(275, NOW()),
(276, NOW()),
(277, NOW()),
(278, NOW()),
(279, NOW()),
(280, NOW()),
(281, NOW()),
(282, NOW()),
(283, NOW()),
(284, NOW()),
(285, NOW()),
(288, NOW()),
(289, NOW()),
(290, NOW()),
(291, NOW()),
(292, NOW()),
(293, NOW()),
(294, NOW()),
(295, NOW()),
(296, NOW()),
(297, NOW()),
(298, NOW()),
(299, NOW()),
(300, NOW()),
(301, NOW()),
(302, NOW()),
(303, NOW()),
(304, NOW()),
(305, NOW()),
(306, NOW()),
(307, NOW()),
(308, NOW()),
(309, NOW()),
(310, NOW()),
(311, NOW()),
(312, NOW()),
(313, NOW()),
(314, NOW()),
(315, NOW()),
(316, NOW()),
(317, NOW()),
(318, NOW()),
(319, NOW()),
(320, NOW()),
(321, NOW()),
(322, NOW()),
(323, NOW()),
(324, NOW()),
(325, NOW()),
(326, NOW()),
(327, NOW()),
(328, NOW()),
(329, NOW()),
(330, NOW()),
(331, NOW()),
(332, NOW()),
(333, NOW()),
(334, NOW()),
(335, NOW()),
(336, NOW()),
(337, NOW()),
(338, NOW()),
(339, NOW()),
(340, NOW()),
(341, NOW()),
(342, NOW()),
(343, NOW()),
(344, NOW()),
(345, NOW()),
(346, NOW()),
(347, NOW()),
(348, NOW()),
(349, NOW()),
(350, NOW()),
(351, NOW()),
(352, NOW()),
(353, NOW()),
(354, NOW()),
(355, NOW()),
(356, NOW()),
(357, NOW()),
(358, NOW()),
(359, NOW()),
(360, NOW()),
(361, NOW()),
(362, NOW()),
(363, NOW()),
(364, NOW()),
(365, NOW()),
(366, NOW()),
(367, NOW()),
(368, NOW()),
(369, NOW()),
(370, NOW()),
(371, NOW()),
(372, NOW()),
(373, NOW()),
(374, NOW()),
(375, NOW()),
(376, NOW()),
(377, NOW()),
(378, NOW()),
(379, NOW()),
(380, NOW()),
(381, NOW()),
(382, NOW()),
(383, NOW()),
(384, NOW()),
(385, NOW()),
(386, NOW()),
(387, NOW()),
(388, NOW()),
(389, NOW()),
(390, NOW()),
(391, NOW()),
(392, NOW()),
(393, NOW()),
(394, NOW()),
(395, NOW()),
(396, NOW()),
(397, NOW()),
(398, NOW()),
(399, NOW()),
(400, NOW()),
(401, NOW()),
(402, NOW()),
(403, NOW()),
(404, NOW()),
(405, NOW()),
(406, NOW()),
(407, NOW()),
(408, NOW()),
(409, NOW()),
(410, NOW()),
(411, NOW()),
(412, NOW()),
(413, NOW()),
(414, NOW()),
(415, NOW()),
(416, NOW()),
(417, NOW()),
(418, NOW()),
(419, NOW()),
(420, NOW()),
(421, NOW()),
(422, NOW()),
(423, NOW()),
(424, NOW()),
(425, NOW()),
(426, NOW()),
(427, NOW()),
(428, NOW()),
(429, NOW()),
(430, NOW()),
(431, NOW()),
(432, NOW()),
(433, NOW()),
(434, NOW()),
(435, NOW()),
(436, NOW()),
(437, NOW()),
(438, NOW()),
(439, NOW()),
(440, NOW()),
(441, NOW()),
(442, NOW()),
(443, NOW()),
(444, NOW()),
(445, NOW()),
(446, NOW()),
(447, NOW()),
(448, NOW()),
(449, NOW()),
(450, NOW()),
(451, NOW()),
(452, NOW()),
(453, NOW()),
(454, NOW()),
(455, NOW()),
(456, NOW()),
(457, NOW()),
(458, NOW()),
(459, NOW()),
(460, NOW()),
(461, NOW()),
(462, NOW()),
(463, NOW()),
(464, NOW()),
(465, NOW()),
(466, NOW()),
(467, NOW()),
(468, NOW()),
(469, NOW()),
(470, NOW()),
(471, NOW()),
(472, NOW()),
(473, NOW()),
(474, NOW()),
(475, NOW()),
(476, NOW()),
(477, NOW()),
(478, NOW()),
(479, NOW()),
(480, NOW()),
(481, NOW()),
(482, NOW()),
(483, NOW()),
(484, NOW()),
(485, NOW()),
(486, NOW()),
(487, NOW()),
(488, NOW()),
(489, NOW()),
(490, NOW()),
(491, NOW()),
(492, NOW()),
(493, NOW()),
(494, NOW()),
(495, NOW()),
(496, NOW()),
(497, NOW()),
(498, NOW()),
(499, NOW()),
(500, NOW()),
(501, NOW()),
(502, NOW()),
(503, NOW()),
(1194303544, NOW()),
(1194389268, NOW()),
(1194541329, NOW()),
(1194642318, NOW()),
(1194977575, NOW()),
(1194977696, NOW()),
(1195053869, NOW()),
(1195065109, NOW()),
(1195076235, NOW()),
(1195078845, NOW()),
(1195088830, NOW()),
(1195089879, NOW()),
(1195160385, NOW()),
(1195245638, NOW()),
(1195246350, NOW()),
(1195246868, NOW()),
(1195246883, NOW()),
(1195246897, NOW()),
(1195247059, NOW()),
(1195592880, NOW()),
(1195593051, NOW()),
(1195593083, NOW()),
(1195593100, NOW()),
(1195676377, NOW()),
(1195693793, NOW()),
(1195842729, NOW()),
(1196104083, NOW()),
(1196104316, NOW()),
(1196126337, NOW()),
(1196202714, NOW()),
(1196293481, NOW()),
(1196294310, NOW()),
(1196383700, NOW()),
(1196384099, NOW()),
(1196453673, NOW()),
(1196707482, NOW()),
(1196711884, NOW()),
(1196725419, NOW()),
(1196804862, NOW()),
(1196898929, NOW()),
(1196988416, NOW()),
(1196989587, NOW()),
(1197091688, NOW()),
(1197326223, NOW()),
(1197487765, NOW()),
(1197682185, NOW());