Re: Legacy site syntax not parsing despite version equivalence

[Phil Larragoite]

Hi Peter, thanks a lot for the help. I'm posting the query here and the show create table below, sorry its a bit big.

Query:

$sql = "SELECT .content_revision.*, content_template.machine_name AS template_name, content_template.id AS content_template_id,
content_page.is_sold,
content_page.new_home as new_home,
content_page.css_classes,
site.domain, site.name as site_name, site.id as site_id,
site.facebook_url,
site.google_url,
site.houzz_url,
site.blogspot_url,
site.youtube_url,
site.hours AS site_hours, site.telephone AS site_telephone, site.toll_free_telephone AS site_toll_free_telephone,
site.analytics as site_analytics,
site.machine_name as site_machine_name,
IF(content_revision.id IS NOT NULL, CONCAT_WS('/', site.domain, content_revision.url), '') AS `path`
FROM content_page
LEFT JOIN content_revision ON content_revision.id = content_page.publish_content_revision_id
LEFT JOIN content_template ON content_template.id = content_page.content_template_id
LEFT JOIN site ON site.id = content_page.site_id
WHERE $url AND content_page.site_id = $site_id";



admin_groups
CREATE TABLE `admin_groups` (
`id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL DEFAULT '',
`description` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1 PACK_KEYS=0

admin_groups_site
CREATE TABLE `admin_groups_site` (
`admin_groups_id` int(10) unsigned NOT NULL,
`site_id` int(10) unsigned NOT NULL,
UNIQUE KEY `admin_groups_id` (`admin_groups_id`,`site_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
admin_modules
CREATE TABLE `admin_modules` (
`id` tinyint(3) NOT NULL AUTO_INCREMENT,
`name` varchar(200) NOT NULL DEFAULT '',
`disp_order` tinyint(3) NOT NULL DEFAULT '0',
`icon` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1

admin_pages
CREATE TABLE `admin_pages` (
`id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`filename` varchar(50) NOT NULL DEFAULT '',
`name` varchar(200) NOT NULL DEFAULT '',
`module_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`visibility` enum('visible','hidden') NOT NULL,
`disp_order` int(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=latin1

admin_security
CREATE TABLE `admin_security` (
`page_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`group_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`page_id`,`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

admin_users
CREATE TABLE `admin_users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(200) NOT NULL DEFAULT '',
`password` varchar(200) NOT NULL DEFAULT '',
`first_name` varchar(200) NOT NULL DEFAULT '',
`last_name` varchar(200) NOT NULL DEFAULT '',
`email` varchar(200) NOT NULL DEFAULT '',
`group_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`last_login` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`title` varchar(255) NOT NULL DEFAULT '',
`phone` varchar(255) NOT NULL DEFAULT '',
`ext` varchar(255) NOT NULL DEFAULT '',
`home_phone` varchar(255) NOT NULL DEFAULT '',
`notes` text NOT NULL,
`address1` varchar(255) NOT NULL DEFAULT '',
`address2` varchar(255) NOT NULL DEFAULT '',
`city` varchar(255) NOT NULL DEFAULT '',
`state` varchar(255) NOT NULL DEFAULT '',
`zip` varchar(255) NOT NULL DEFAULT '',
`country` varchar(255) NOT NULL DEFAULT '',
`is_active` enum('N','Y') NOT NULL DEFAULT 'N',
PRIMARY KEY (`id`),
KEY `group_id` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1

content_field
CREATE TABLE `content_field` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`type` enum('short','long','html','image','date','datetime','images','faqs','events','locations','pdf','toggle','events','notifications','reset') COLLATE utf8_unicode_ci NOT NULL,
`editor_options` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`render_options` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`help` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`is_dev_only` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

content_image
CREATE TABLE `content_image` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10780 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
content_page

CREATE TABLE `content_page` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`publish_content_revision_id` int(10) unsigned NOT NULL,
`content_template_id` int(10) unsigned NOT NULL,
`site_id` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`css_classes` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`is_dev_only` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
`is_sold` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`new_home` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
PRIMARY KEY (`id`),
KEY `publish_content_revision_id` (`publish_content_revision_id`),
KEY `content_template_id` (`content_template_id`),
KEY `site_id` (`site_id`),
KEY `name` (`name`),
KEY `descr` (`description`)
) ENGINE=MyISAM AUTO_INCREMENT=671 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

content_pdf
CREATE TABLE `content_pdf` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

content_revision
CREATE TABLE `content_revision` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`content_page_id` int(10) unsigned NOT NULL,
`parent_content_page_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`short_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meta_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meta_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meta_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`is_in_navigation` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
`order_fld` smallint(5) unsigned NOT NULL,
`is_can_expire` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`is_empty` enum('Y','N','NC') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`date_added` datetime NOT NULL,
`date_scheduled` datetime NOT NULL,
`date_expire` datetime NOT NULL,
`is_active` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
`is_sold` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
PRIMARY KEY (`id`),
KEY `content_page_id` (`content_page_id`),
KEY `parent_content_page_id` (`parent_content_page_id`),
KEY `url` (`url`),
KEY `date_expire` (`date_expire`),
KEY `date_scheduled` (`date_scheduled`),
KEY `date_added` (`date_added`),
KEY `is_in_navigation` (`is_in_navigation`),
KEY `user_id` (`user_id`),
KEY `is_can_expire` (`is_can_expire`),
KEY `is_in_navigation_2` (`is_in_navigation`)
) ENGINE=MyISAM AUTO_INCREMENT=6930 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

content_revision_data
CREATE TABLE `content_revision_data` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`content_revision_id` int(10) unsigned NOT NULL,
`content_field_id` int(10) unsigned NOT NULL,
`data` text COLLATE utf8_unicode_ci NOT NULL,
`meta` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`order_fld` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `content_revision_id` (`content_revision_id`,`content_field_id`),
KEY `content_field_id` (`content_field_id`),
KEY `order_fld` (`order_fld`)
) ENGINE=MyISAM AUTO_INCREMENT=26262 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

content_revision_event
CREATE TABLE `content_revision_event` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`content_revision_id` int(10) unsigned NOT NULL,
`event_date` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`content_field_id` int(10) unsigned NOT NULL,
`order_fld` smallint(6) NOT NULL,
PRIMARY KEY (`id`),
KEY `content_revision_id` (`content_revision_id`),
KEY `content_field_id` (`content_field_id`),
KEY `order_fld` (`order_fld`)
) ENGINE=MyISAM AUTO_INCREMENT=46745 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

content_revision_faq
CREATE TABLE `content_revision_faq` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`content_revision_id` int(10) unsigned NOT NULL,
`question` text COLLATE utf8_unicode_ci NOT NULL,
`answer` text COLLATE utf8_unicode_ci NOT NULL,
`content_field_id` int(10) unsigned NOT NULL,
`order_fld` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `order_fld` (`order_fld`),
KEY `content_revision_id` (`content_revision_id`),
KEY `content_field_id` (`content_field_id`)
) ENGINE=MyISAM AUTO_INCREMENT=779 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

content_revision_image
CREATE TABLE `content_revision_image` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`content_revision_id` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meta` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`caption` text COLLATE utf8_unicode_ci NOT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`content_field_id` int(10) unsigned NOT NULL,
`order_fld` tinyint(3) unsigned NOT NULL,
`content_image_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `order_fld` (`order_fld`),
KEY `content_revision_id` (`content_revision_id`),
KEY `content_field_id` (`content_field_id`)
) ENGINE=MyISAM AUTO_INCREMENT=80972 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

content_revision_location
CREATE TABLE `content_revision_location` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`content_revision_id` int(10) unsigned NOT NULL,
`category` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`coords` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
`content_field_id` int(10) unsigned NOT NULL,
`order_fld` smallint(6) NOT NULL,
PRIMARY KEY (`id`),
KEY `content_revision_id` (`content_revision_id`),
KEY `content_field_id` (`content_field_id`),
KEY `order_fld` (`order_fld`)
) ENGINE=MyISAM AUTO_INCREMENT=1543 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

content_revision_notification
CREATE TABLE `content_revision_notification` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`content_revision_id` int(10) unsigned NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`content_field_id` int(10) unsigned NOT NULL,
`order_fld` smallint(6) NOT NULL,
PRIMARY KEY (`id`),
KEY `content_revision_id` (`content_revision_id`),
KEY `content_field_id` (`content_field_id`),
KEY `order_fld` (`order_fld`)
) ENGINE=MyISAM AUTO_INCREMENT=3022 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

content_revision_pdf
CREATE TABLE `content_revision_pdf` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`content_revision_id` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meta` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`caption` text COLLATE utf8_unicode_ci NOT NULL,
`content_field_id` int(10) unsigned NOT NULL,
`order_fld` tinyint(3) unsigned NOT NULL,
`content_pdf_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `order_fld` (`order_fld`),
KEY `content_revision_id` (`content_revision_id`),
KEY `content_field_id` (`content_field_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

content_template
CREATE TABLE `content_template` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`machine_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`is_dev_only` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`is_allow_subpages` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`sub_template_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `machine_name` (`machine_name`)
) ENGINE=MyISAM AUTO_INCREMENT=60 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

content_template_field
CREATE TABLE `content_template_field` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`content_template_id` int(10) unsigned NOT NULL,
`content_field_id` int(10) unsigned NOT NULL,
`category` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`order_fld` smallint(6) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `content_template_id` (`content_template_id`,`content_field_id`),
KEY `category` (`category`),
KEY `order_fld` (`order_fld`)
) ENGINE=MyISAM AUTO_INCREMENT=184 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

email
CREATE TABLE `email` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`to` varchar(255) NOT NULL,
`from` varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`body` text NOT NULL,
`communities` text NOT NULL,
`date_sent` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1115 DEFAULT CHARSET=utf8

email_template
CREATE TABLE `email_template` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`subject` varchar(255) NOT NULL,
`html` text NOT NULL,
`txt` text NOT NULL,
`description` text NOT NULL,
`date_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8

mail_field
CREATE TABLE `mail_field` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`label` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`type` enum('short','long','html','image','date','datetime','images','faqs','events','locations','pdf','toggle') COLLATE utf8_unicode_ci NOT NULL,
`editor_options` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`render_options` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`help` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`is_dev_only` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=117 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

mail_image
CREATE TABLE `mail_image` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`date_added` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1092 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

mail_page
CREATE TABLE `mail_page` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`publish_mail_revision_id` int(10) unsigned NOT NULL,
`mail_template_id` int(10) unsigned NOT NULL,
`site_id` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`css_classes` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`is_dev_only` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
PRIMARY KEY (`id`),
KEY `publish_mail_revision_id` (`publish_mail_revision_id`),
KEY `mail_template_id` (`mail_template_id`),
KEY `site_id` (`site_id`),
KEY `name` (`name`),
KEY `descr` (`description`)
) ENGINE=MyISAM AUTO_INCREMENT=242 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

mail_revision
CREATE TABLE `mail_revision` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mail_page_id` int(10) unsigned NOT NULL,
`parent_mail_page_id` int(10) unsigned NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`short_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meta_title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meta_keywords` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meta_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`is_in_navigation` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
`order_fld` smallint(5) unsigned NOT NULL,
`is_can_expire` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`is_empty` enum('Y','N','NC') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`date_added` datetime NOT NULL,
`date_scheduled` datetime NOT NULL,
`date_expire` datetime NOT NULL,
`is_active` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
PRIMARY KEY (`id`),
KEY `mail_page_id` (`mail_page_id`),
KEY `parent_mail_page_id` (`parent_mail_page_id`),
KEY `url` (`url`),
KEY `date_expire` (`date_expire`),
KEY `date_scheduled` (`date_scheduled`),
KEY `date_added` (`date_added`),
KEY `is_in_navigation` (`is_in_navigation`),
KEY `user_id` (`user_id`),
KEY `is_can_expire` (`is_can_expire`),
KEY `is_in_navigation_2` (`is_in_navigation`)
) ENGINE=MyISAM AUTO_INCREMENT=2406 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

mail_revision_data
CREATE TABLE `mail_revision_data` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mail_revision_id` int(10) unsigned NOT NULL,
`mail_field_id` int(10) unsigned NOT NULL,
`data` text COLLATE utf8_unicode_ci NOT NULL,
`meta` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`order_fld` tinyint(3) unsigned NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `mail_revision_id` (`mail_revision_id`,`mail_field_id`),
KEY `mail_field_id` (`mail_field_id`),
KEY `order_fld` (`order_fld`)
) ENGINE=MyISAM AUTO_INCREMENT=20651 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

mail_revision_image
CREATE TABLE `mail_revision_image` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mail_revision_id` int(10) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`meta` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`caption` text COLLATE utf8_unicode_ci NOT NULL,
`mail_field_id` int(10) unsigned NOT NULL,
`order_fld` tinyint(3) unsigned NOT NULL,
`mail_image_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `order_fld` (`order_fld`),
KEY `mail_revision_id` (`mail_revision_id`),
KEY `mail_field_id` (`mail_field_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3143 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

mail_template
CREATE TABLE `mail_template` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`machine_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`is_dev_only` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`is_allow_subpages` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N',
`sub_template_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `name` (`name`),
KEY `machine_name` (`machine_name`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

mail_template_field
CREATE TABLE `mail_template_field` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`mail_template_id` int(10) unsigned NOT NULL,
`mail_field_id` int(10) unsigned NOT NULL,
`category` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`order_fld` smallint(6) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `mail_template_id` (`mail_template_id`,`mail_field_id`),
KEY `category` (`category`),
KEY `order_fld` (`order_fld`)
) ENGINE=MyISAM AUTO_INCREMENT=192 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

redirect
CREATE TABLE `redirect` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`incoming` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`site_id` int(10) unsigned NOT NULL,
`target` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`code` int(11) NOT NULL DEFAULT '301',
PRIMARY KEY (`id`),
KEY `incoming` (`incoming`),
KEY `site_id` (`site_id`),
KEY `target` (`target`)
) ENGINE=MyISAM AUTO_INCREMENT=138 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

sessions
CREATE TABLE `sessions` (
`session_id` varchar(32) NOT NULL DEFAULT '',
`session_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`session_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`session_value` text NOT NULL,
`ip_address` varchar(16) NOT NULL DEFAULT '',
`user_agent` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

settings
CREATE TABLE `settings` (
`name` varchar(200) NOT NULL DEFAULT '',
`value` text NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1

site
CREATE TABLE `site` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`domain` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`hours` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`telephone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`toll_free_telephone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`machine_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`blogspot_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`facebook_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`google_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`houzz_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`youtube_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`analytics` text COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `machine_name` (`machine_name`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

trade_doc
CREATE TABLE `trade_doc` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`category` enum('Generic Architectural Plans','Generic HVAC Plans','Generic Cabinet Plans','Generic Details') COLLATE utf8_unicode_ci NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`doc` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`order_fld` smallint(6) NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`date_added` datetime NOT NULL,
`trade_job_id` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `category` (`category`),
KEY `order_fld` (`order_fld`),
KEY `user_id` (`user_id`),
KEY `date_added` (`date_added`),
KEY `trade_job_id` (`trade_job_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3353 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

trade_job
CREATE TABLE `trade_job` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`community` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`lot_no` smallint(6) NOT NULL,
`user_id` int(10) unsigned NOT NULL,
`date_added` datetime NOT NULL,
`priority` smallint(6) NOT NULL,
`order_fld` smallint(6) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `date_added` (`date_added`),
KEY `lot_no` (`lot_no`)
) ENGINE=MyISAM AUTO_INCREMENT=756 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
user

CREATE TABLE `user` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`group_id` int(10) unsigned NOT NULL,
`first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`phone` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`mobile_phone` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`home_phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`alt_phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`fax` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`alt_fax` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`city` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`state` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
`zip` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
`is_active` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
`is_show_menu` enum('Y','N') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y',
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`display_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`notes` text COLLATE utf8_unicode_ci NOT NULL,
`date_added` datetime NOT NULL,
`date_modified` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`),
KEY `is_active` (`is_active`),
KEY `date_added` (`date_added`),
KEY `date_modified` (`date_modified`),
KEY `group_id` (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4786 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci