#
# Admin Backup module
# Open-Realty version 2.3.4+
# http://www.open-realty.org
#
# Host: 
# Backed Up On: 23 Jul, 2007 at 04:24
# Database : ``
# --------------------------------------------------------
#
# Table structure for table `paycan_addons`
#
DROP TABLE IF EXISTS paycan_addons;
CREATE TABLE `paycan_addons` (
  `addons_version` varchar(15) NOT NULL default '',
  `addons_name` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`addons_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_addons`
#
#
# Table structure for table `paycan_classformelements`
#
DROP TABLE IF EXISTS paycan_classformelements;
CREATE TABLE `paycan_classformelements` (
  `classformelements_id` int(11) NOT NULL auto_increment,
  `class_id` int(11) NOT NULL default '0',
  `listingsformelements_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`classformelements_id`),
  KEY `idx_classformelements_class_id` (`class_id`),
  KEY `idx_classformelements_listingsformelements_id` (`listingsformelements_id`)
) ENGINE=MyISAM AUTO_INCREMENT=131 DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_classformelements`
#
INSERT INTO paycan_classformelements VALUES (1,1,1);
INSERT INTO paycan_classformelements VALUES (2,1,2);
INSERT INTO paycan_classformelements VALUES (3,1,3);
INSERT INTO paycan_classformelements VALUES (4,1,4);
INSERT INTO paycan_classformelements VALUES (5,1,5);
INSERT INTO paycan_classformelements VALUES (6,1,6);
INSERT INTO paycan_classformelements VALUES (7,1,7);
INSERT INTO paycan_classformelements VALUES (8,1,8);
INSERT INTO paycan_classformelements VALUES (117,1,9);
INSERT INTO paycan_classformelements VALUES (10,1,10);
INSERT INTO paycan_classformelements VALUES (11,1,11);
INSERT INTO paycan_classformelements VALUES (12,1,12);
INSERT INTO paycan_classformelements VALUES (13,1,13);
INSERT INTO paycan_classformelements VALUES (14,1,14);
INSERT INTO paycan_classformelements VALUES (15,1,15);
INSERT INTO paycan_classformelements VALUES (16,1,16);
INSERT INTO paycan_classformelements VALUES (17,1,17);
INSERT INTO paycan_classformelements VALUES (18,1,18);
INSERT INTO paycan_classformelements VALUES (19,1,19);
INSERT INTO paycan_classformelements VALUES (20,1,20);
INSERT INTO paycan_classformelements VALUES (21,1,21);
INSERT INTO paycan_classformelements VALUES (22,1,22);
INSERT INTO paycan_classformelements VALUES (23,1,23);
INSERT INTO paycan_classformelements VALUES (130,1,39);
INSERT INTO paycan_classformelements VALUES (129,1,38);
INSERT INTO paycan_classformelements VALUES (128,1,37);
INSERT INTO paycan_classformelements VALUES (127,1,36);
INSERT INTO paycan_classformelements VALUES (126,1,34);
INSERT INTO paycan_classformelements VALUES (125,1,33);
INSERT INTO paycan_classformelements VALUES (124,1,32);
INSERT INTO paycan_classformelements VALUES (123,1,30);
INSERT INTO paycan_classformelements VALUES (122,1,29);
INSERT INTO paycan_classformelements VALUES (121,1,28);
INSERT INTO paycan_classformelements VALUES (120,1,27);
INSERT INTO paycan_classformelements VALUES (119,1,24);
INSERT INTO paycan_classformelements VALUES (118,1,25);
INSERT INTO paycan_classformelements VALUES (116,1,31);
#
# Table structure for table `paycan_classlistingsdb`
#
DROP TABLE IF EXISTS paycan_classlistingsdb;
CREATE TABLE `paycan_classlistingsdb` (
  `classlistingsdb_id` int(11) NOT NULL auto_increment,
  `class_id` int(11) NOT NULL default '0',
  `listingsdb_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`classlistingsdb_id`),
  KEY `idx_classlistingsdb_class_id` (`class_id`),
  KEY `idx_classlistingsdb_listingsdb_id` (`listingsdb_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_classlistingsdb`
#
INSERT INTO paycan_classlistingsdb VALUES (2,1,2);
#
# Table structure for table `paycan_controlpanel`
#
DROP TABLE IF EXISTS paycan_controlpanel;
CREATE TABLE `paycan_controlpanel` (
  `controlpanel_version` varchar(15) NOT NULL default '',
  `controlpanel_basepath` varchar(150) NOT NULL default '',
  `controlpanel_baseurl` varchar(150) NOT NULL default '',
  `controlpanel_admin_name` varchar(45) NOT NULL default '',
  `controlpanel_admin_email` varchar(45) NOT NULL default '',
  `controlpanel_company_name` varchar(45) default NULL,
  `controlpanel_company_location` varchar(45) default NULL,
  `controlpanel_company_logo` varchar(45) default NULL,
  `controlpanel_url_style` smallint(6) NOT NULL default '0',
  `controlpanel_template` varchar(45) NOT NULL default '',
  `controlpanel_admin_template` varchar(45) NOT NULL default '',
  `controlpanel_listing_template` varchar(45) NOT NULL default '',
  `controlpanel_agent_template` varchar(45) NOT NULL default '',
  `controlpanel_search_result_template` varchar(45) NOT NULL default '',
  `controlpanel_lang` char(2) NOT NULL default '',
  `controlpanel_listings_per_page` int(11) NOT NULL default '0',
  `controlpanel_num_featured_listings` int(11) NOT NULL default '0',
  `controlpanel_add_linefeeds` smallint(6) NOT NULL default '0',
  `controlpanel_strip_html` smallint(6) NOT NULL default '0',
  `controlpanel_allowed_html_tags` varchar(45) NOT NULL default '',
  `controlpanel_money_sign` varchar(20) NOT NULL default '',
  `controlpanel_show_no_photo` smallint(6) NOT NULL default '0',
  `controlpanel_number_format_style` int(11) NOT NULL default '0',
  `controlpanel_money_format` int(11) NOT NULL default '0',
  `controlpanel_date_format` int(11) NOT NULL default '0',
  `controlpanel_max_listings_uploads` int(11) NOT NULL default '0',
  `controlpanel_max_listings_upload_size` int(11) NOT NULL default '0',
  `controlpanel_max_listings_upload_width` int(11) NOT NULL default '0',
  `controlpanel_max_user_uploads` int(11) NOT NULL default '0',
  `controlpanel_max_user_upload_size` int(11) NOT NULL default '0',
  `controlpanel_max_user_upload_width` int(11) NOT NULL default '0',
  `controlpanel_max_vtour_uploads` int(11) NOT NULL default '0',
  `controlpanel_max_vtour_upload_size` int(11) NOT NULL default '0',
  `controlpanel_max_vtour_upload_width` int(11) NOT NULL default '0',
  `controlpanel_allowed_upload_extensions` varchar(45) NOT NULL default '',
  `controlpanel_make_thumbnail` smallint(6) NOT NULL default '0',
  `controlpanel_thumbnail_width` int(11) NOT NULL default '0',
  `controlpanel_gd_version` smallint(6) NOT NULL default '0',
  `controlpanel_thumbnail_prog` varchar(20) NOT NULL default '',
  `controlpanel_path_to_imagemagick` varchar(255) NOT NULL default '',
  `controlpanel_resize_img` smallint(6) NOT NULL default '0',
  `controlpanel_jpeg_quality` smallint(6) NOT NULL default '0',
  `controlpanel_use_expiration` smallint(6) NOT NULL default '0',
  `controlpanel_days_until_listings_expire` int(11) NOT NULL default '0',
  `controlpanel_allow_member_signup` smallint(6) NOT NULL default '0',
  `controlpanel_allow_agent_signup` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_active` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_admin` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_feature` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_moderate` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_logview` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_edit_site_config` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_edit_member_template` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_edit_agent_template` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_edit_listing_template` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_canchangeexpirations` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_editpages` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_havevtours` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_num_listings` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_can_export_listings` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_edit_all_users` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_edit_all_listings` smallint(6) NOT NULL default '0',
  `controlpanel_agent_default_edit_property_classes` smallint(6) NOT NULL default '0',
  `controlpanel_moderate_agents` smallint(6) NOT NULL default '0',
  `controlpanel_moderate_members` smallint(6) NOT NULL default '0',
  `controlpanel_moderate_listings` smallint(6) NOT NULL default '0',
  `controlpanel_export_listings` smallint(6) NOT NULL default '0',
  `controlpanel_email_notification_of_new_users` smallint(6) NOT NULL default '0',
  `controlpanel_email_notification_of_new_listings` smallint(6) NOT NULL default '0',
  `controlpanel_allowed_upload_types` varchar(95) NOT NULL default '',
  `controlpanel_configured_langs` varchar(100) NOT NULL default '',
  `controlpanel_email_users_notification_of_new_listings` smallint(6) NOT NULL default '0',
  `controlpanel_configured_show_count` smallint(6) NOT NULL default '0',
  `controlpanel_map_type` varchar(45) NOT NULL default '',
  `controlpanel_map_address` varchar(45) NOT NULL default '',
  `controlpanel_map_address2` varchar(45) NOT NULL default '',
  `controlpanel_map_address3` varchar(45) NOT NULL default '',
  `controlpanel_map_address4` varchar(45) NOT NULL default '',
  `controlpanel_map_city` varchar(45) NOT NULL default '',
  `controlpanel_map_state` varchar(45) NOT NULL default '',
  `controlpanel_map_zip` varchar(45) NOT NULL default '',
  `controlpanel_map_country` varchar(45) NOT NULL default '',
  `controlpanel_wysiwyg_editor` varchar(45) NOT NULL default '',
  `controlpanel_wysiwyg_execute_php` int(11) NOT NULL default '0',
  `controlpanel_number_decimals_number_fields` smallint(6) NOT NULL default '0',
  `controlpanel_number_decimals_price_fields` smallint(6) NOT NULL default '0',
  `controlpanel_automatic_update_check` smallint(6) NOT NULL default '0',
  `controlpanel_search_sortby` varchar(45) NOT NULL default '',
  `controlpanel_search_sorttype` varchar(45) NOT NULL default '',
  `controlpanel_show_listedby_admin` smallint(6) NOT NULL default '0',
  `controlpanel_show_next_prev_listing_page` smallint(6) NOT NULL default '0',
  `controlpanel_multiple_pclass_selection` smallint(6) NOT NULL default '0',
  `controlpanel_seo_default_description` text NOT NULL,
  `controlpanel_seo_default_keywords` text NOT NULL,
  `controlpanel_seo_listing_description` text NOT NULL,
  `controlpanel_seo_listing_keywords` text NOT NULL,
  `controlpanel_seo_default_title` text NOT NULL,
  `controlpanel_seo_listing_title` text NOT NULL,
  `controlpanel_template_listing_sections` text NOT NULL,
  `controlpanel_vtour_template` varchar(45) NOT NULL default '',
  `controlpanel_vtour_width` varchar(45) NOT NULL default '',
  `controlpanel_vtour_height` varchar(45) NOT NULL default '',
  `controlpanel_vt_popup_width` varchar(45) NOT NULL default '',
  `controlpanel_vt_popup_height` varchar(45) NOT NULL default '',
  `controlpanel_vtour_fov` varchar(45) NOT NULL default '',
  `controlpanel_zero_price` smallint(6) NOT NULL default '0',
  `controlpanel_vcard_phone` varchar(45) NOT NULL default '',
  `controlpanel_vcard_fax` varchar(45) NOT NULL default '',
  `controlpanel_vcard_mobile` varchar(45) NOT NULL default '',
  `controlpanel_vcard_address` varchar(45) NOT NULL default '',
  `controlpanel_vcard_city` varchar(45) NOT NULL default '',
  `controlpanel_vcard_state` varchar(45) NOT NULL default '',
  `controlpanel_vcard_zip` varchar(45) NOT NULL default '',
  `controlpanel_vcard_country` varchar(45) NOT NULL default '',
  `controlpanel_vcard_notes` varchar(45) NOT NULL default '',
  `controlpanel_vcard_url` varchar(45) NOT NULL default '',
  `controlpanel_email_information_to_new_users` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`controlpanel_version`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_controlpanel`
#
INSERT INTO paycan_controlpanel VALUES ('2.3.4','/home/paycan/public_html','http://www.paycanmotors.com','Administrator','sales@kheirconsulting.com','Paycan Motors','','title.jpg',1,'paycan','OR','listing_detail_mainjavacolumn.html','view_user_default.html','search_result_default.html','en',10,4,0,0,'<a><b><i><u><br>','$',1,1,1,1,4,150000,400,4,100000,400,15,900000,3000,'jpg,gif,png,egg',1,70,1,'gd','/usr/X11R6/bin/convert',1,100,0,365,0,0,1,0,1,1,1,0,0,0,0,1,1,0,-1,0,0,1,0,0,0,0,0,0,0,'image/pjpeg,image/jpeg,image/gif,image/x-png,application/octet-stream','en',0,1,'google_us','','','','','','','','','fckeditor',1,0,0,0,'price','ASC',0,1,0,'','','','','Used Cars-Kitchener, Waterloo, Cambridge-Paycan Motors','Used Cars-Kitchener, Waterloo, Cambridge-Paycan Motors','headline,top_left,top_right,center,feature1,feature2,bottom_left,bottom_right','vtour_default.html','400','250','800','480','70',1,'','','','','','','','','','',0);
#
# Table structure for table `paycan_en_activitylog`
#
DROP TABLE IF EXISTS paycan_en_activitylog;
CREATE TABLE `paycan_en_activitylog` (
  `activitylog_id` int(11) NOT NULL auto_increment,
  `activitylog_log_date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `userdb_id` int(11) NOT NULL default '0',
  `activitylog_action` varchar(150) NOT NULL default '',
  `activitylog_ip_address` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`activitylog_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_activitylog`
#
INSERT INTO paycan_en_activitylog VALUES (1,'2007-07-20 17:12:00',1,'Created Listing 2','70.49.39.47');
INSERT INTO paycan_en_activitylog VALUES (2,'2007-07-20 17:12:14',1,'Updated Listing 2','70.49.39.47');
INSERT INTO paycan_en_activitylog VALUES (3,'2007-07-20 17:13:50',1,'Deleted Listing 1','70.49.39.47');
INSERT INTO paycan_en_activitylog VALUES (4,'2007-07-20 17:18:50',1,'Updated Listing 2','70.49.39.47');
INSERT INTO paycan_en_activitylog VALUES (5,'2007-07-20 17:19:04',1,'Uploaded Listing Image 2_90_picture115.jpg','70.49.39.47');
#
# Table structure for table `paycan_en_agentformelements`
#
DROP TABLE IF EXISTS paycan_en_agentformelements;
CREATE TABLE `paycan_en_agentformelements` (
  `agentformelements_id` int(11) NOT NULL auto_increment,
  `agentformelements_field_type` varchar(20) NOT NULL default '',
  `agentformelements_field_name` varchar(80) NOT NULL default '',
  `agentformelements_field_caption` varchar(80) NOT NULL default '',
  `agentformelements_default_text` text NOT NULL,
  `agentformelements_field_elements` text NOT NULL,
  `agentformelements_rank` int(11) NOT NULL default '0',
  `agentformelements_required` char(3) NOT NULL default '',
  `agentformelements_display_priv` int(11) NOT NULL default '0',
  PRIMARY KEY  (`agentformelements_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_agentformelements`
#
INSERT INTO paycan_en_agentformelements VALUES (3,'textarea','info','Info','','',10,'No',0);
INSERT INTO paycan_en_agentformelements VALUES (4,'text','phone','Phone','','',1,'No',0);
INSERT INTO paycan_en_agentformelements VALUES (5,'text','mobile','Mobile','','',3,'No',0);
INSERT INTO paycan_en_agentformelements VALUES (6,'text','fax','Fax','','',5,'No',0);
INSERT INTO paycan_en_agentformelements VALUES (7,'url','homepage','Homepage','','',7,'No',0);
#
# Table structure for table `paycan_en_class`
#
DROP TABLE IF EXISTS paycan_en_class;
CREATE TABLE `paycan_en_class` (
  `class_id` int(11) NOT NULL auto_increment,
  `class_name` varchar(80) NOT NULL default '',
  `class_rank` smallint(6) NOT NULL default '0',
  PRIMARY KEY  (`class_id`),
  KEY `idx_class_rank` (`class_rank`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_class`
#
INSERT INTO paycan_en_class VALUES (1,'Default Vehicle Class',1);
#
# Table structure for table `paycan_en_listingsdb`
#
DROP TABLE IF EXISTS paycan_en_listingsdb;
CREATE TABLE `paycan_en_listingsdb` (
  `listingsdb_id` int(11) NOT NULL auto_increment,
  `userdb_id` int(11) NOT NULL default '0',
  `listingsdb_title` varchar(80) NOT NULL default '',
  `listingsdb_expiration` date NOT NULL default '0000-00-00',
  `listingsdb_notes` text NOT NULL,
  `listingsdb_creation_date` date NOT NULL default '0000-00-00',
  `listingsdb_last_modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `listingsdb_hit_count` int(11) NOT NULL default '0',
  `listingsdb_featured` char(3) NOT NULL default '',
  `listingsdb_active` char(3) NOT NULL default '',
  `listingsdb_mlsexport` char(3) NOT NULL default '',
  PRIMARY KEY  (`listingsdb_id`),
  KEY `idx_active` (`listingsdb_active`),
  KEY `idx_user` (`userdb_id`),
  KEY `idx_mlsexport` (`listingsdb_mlsexport`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_listingsdb`
#
INSERT INTO paycan_en_listingsdb VALUES (2,1,'Test Vehicle','2008-07-19','','2007-07-20','2007-07-20 17:18:50',5,'yes','yes','no');
#
# Table structure for table `paycan_en_listingsdbelements`
#
DROP TABLE IF EXISTS paycan_en_listingsdbelements;
CREATE TABLE `paycan_en_listingsdbelements` (
  `listingsdbelements_id` int(11) NOT NULL auto_increment,
  `listingsdbelements_field_name` varchar(80) NOT NULL default '',
  `listingsdbelements_field_value` text NOT NULL,
  `listingsdb_id` int(11) NOT NULL default '0',
  `userdb_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`listingsdbelements_id`),
  KEY `idx_name` (`listingsdbelements_field_name`),
  KEY `idx_value` (`listingsdbelements_field_value`(255)),
  KEY `idx_listing_id` (`listingsdb_id`)
) ENGINE=MyISAM AUTO_INCREMENT=993 DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_listingsdbelements`
#
INSERT INTO paycan_en_listingsdbelements VALUES (992,'full_desc','test vehicle - great buy',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (991,'warranty','No Warranty',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (990,'condition','Certified & E-Tested',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (989,'Options','AM/FM-6 CD||Air Conditioning||Cruise Control||Heated Mirrors',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (986,'intcolor','Beige',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (987,'type','4 Door',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (988,'powereq','Power Antenna||Power Brakes||Power Locks||Power Windows',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (985,'fuel','Gas',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (984,'transmission','Automatic',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (983,'stock','9999',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (982,'Engine','4 Cyl.',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (981,'miles','199',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (980,'Colour','Green',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (979,'make','Taurus',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (978,'model','Ford',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (977,'price','9999',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (976,'year','1999',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (974,'mlsexport','no',2,1);
INSERT INTO paycan_en_listingsdbelements VALUES (975,'or_owner','1',2,1);
#
# Table structure for table `paycan_en_listingsformelements`
#
DROP TABLE IF EXISTS paycan_en_listingsformelements;
CREATE TABLE `paycan_en_listingsformelements` (
  `listingsformelements_id` int(11) NOT NULL auto_increment,
  `listingsformelements_field_type` varchar(20) NOT NULL default '',
  `listingsformelements_field_name` varchar(80) NOT NULL default '',
  `listingsformelements_field_caption` varchar(80) NOT NULL default '',
  `listingsformelements_default_text` text NOT NULL,
  `listingsformelements_field_elements` text NOT NULL,
  `listingsformelements_rank` int(11) NOT NULL default '0',
  `listingsformelements_search_rank` int(11) NOT NULL default '0',
  `listingsformelements_search_result_rank` int(11) NOT NULL default '0',
  `listingsformelements_required` char(3) NOT NULL default '',
  `listingsformelements_location` varchar(15) NOT NULL default '',
  `listingsformelements_display_on_browse` char(3) NOT NULL default '',
  `listingsformelements_searchable` int(11) NOT NULL default '0',
  `listingsformelements_search_type` varchar(50) default NULL,
  `listingsformelements_search_label` varchar(50) default NULL,
  `listingsformelements_search_step` int(11) NOT NULL default '0',
  `listingsformelements_display_priv` int(11) NOT NULL default '0',
  PRIMARY KEY  (`listingsformelements_id`),
  KEY `idx_searchable` (`listingsformelements_searchable`),
  KEY `idx_field_type` (`listingsformelements_field_type`),
  KEY `idx_browse` (`listingsformelements_display_on_browse`),
  KEY `idx_field_name` (`listingsformelements_field_name`),
  KEY `idx_rank` (`listingsformelements_rank`),
  KEY `idx_search_rank` (`listingsformelements_search_rank`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_listingsformelements`
#
INSERT INTO paycan_en_listingsformelements VALUES (31,'checkbox','powereq','Power Equipment','None','None||Power Windows||Power Locks||Power Brakes||Power Antenna||Power Mirrors||Power Driver\'s Seat||Power Steering||Power Passenger Seat||Power Sunroof||Power door(s)',1,0,6,'Yes','feature1','Yes',0,'','',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (9,'number','year','Year','','1980||1981||1982||1983||1984||1985||1986||1987||1988||1989||1990||1991||1992||1993||1994||1995||1996||1997||1998||1999||2000||2001||2002||2003||2004||2005||2006||2007||2008',0,1,1,'Yes','top_left','No',1,'minmax','Year',1,0);
INSERT INTO paycan_en_listingsformelements VALUES (16,'textarea','full_desc','Description','','',2,0,10,'No','top_left','Yes',0,'','',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (18,'price','price','Price','','',0,0,22,'No','top_right','Yes',1,'minmax','Price',2500,0);
INSERT INTO paycan_en_listingsformelements VALUES (25,'text','model','Model','','',0,0,1,'Yes','top_left','No',0,'','Model',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (24,'text','make','Make','','',0,0,1,'Yes','top_left','No',0,'','',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (27,'select','Colour','Colour','Colour','Beige||Black||Blue||Brown||Green||Grey||Jade||Maroon||Red||Silver||Tan||Teal||White||Yellow',0,0,0,'Yes','center','Yes',0,'','',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (28,'number','miles','Mileage','Please Call ','',0,0,0,'No','top_right','No',0,'','',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (29,'text','Engine','Engine','','',0,0,3,'Yes','top_right','Yes',0,'','',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (30,'number','stock','Stock #','','',0,0,0,'Yes','top_right','No',0,'','',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (32,'checkbox','Options','Options','None','None||Air Conditioning||Cruise Control||Tilt Steering||Delayed Wipers||AM/FM Radio||AM/FM Cassette||AM/FM CD||AM/FM-6 CD||Heated Mirrors||Heated Seats||Remote Entry||Tinted Glass||Rear A/C||Sunroof||Security System||Fog Lights||Roof Rack||DVD System||Overhead Console||Quad Captains Chairs||Leather seats||Rear inflator||Rear park aid||4x4||All Wheel Drive||Towing Package||Traction control||Rear Spoiler',1,0,7,'Yes','feature1','Yes',0,'','',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (33,'select','transmission','Trans.','Automatic','Automatic||5-Speed||4-Speed||4-Matic||5-Matic',0,0,2,'Yes','top_right','Yes',0,'','',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (34,'select','fuel','Fuel Type','','Gas||Diesel||Propane||Hybrid',0,0,4,'Yes','','Yes',0,'','',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (36,'option','condition','Condition','','Certified & E-Tested||As-Is',1,0,8,'Yes','','Yes',0,'','',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (37,'option','warranty','Warranty','','No Warranty||7 Month PowerTrain Warranty<BR>Seals and Gaskets Included<BR>Up to 11,000km||Balance of Factory Warranty',1,0,9,'Yes','','Yes',0,'','',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (38,'select','intcolor','Interior','','Beige||Black||Blue||Brown||Charcoal||Green||Grey||Jade||Maroon||Red||Silver||Tan||Teal||White||Yellow',0,0,0,'Yes','','No',0,'','',0,0);
INSERT INTO paycan_en_listingsformelements VALUES (39,'select','type','Type','','2 Door||3 Door||4 Door||5 Door',0,0,0,'Yes','feature1','No',0,'','',0,0);
#
# Table structure for table `paycan_en_listingsimages`
#
DROP TABLE IF EXISTS paycan_en_listingsimages;
CREATE TABLE `paycan_en_listingsimages` (
  `listingsimages_id` int(11) NOT NULL auto_increment,
  `userdb_id` int(11) NOT NULL default '0',
  `listingsimages_caption` varchar(255) NOT NULL default '',
  `listingsimages_file_name` varchar(80) NOT NULL default '',
  `listingsimages_thumb_file_name` varchar(80) NOT NULL default '',
  `listingsimages_description` text NOT NULL,
  `listingsdb_id` int(11) NOT NULL default '0',
  `listingsimages_rank` int(11) NOT NULL default '0',
  `listingsimages_active` char(3) NOT NULL default '',
  PRIMARY KEY  (`listingsimages_id`),
  KEY `idx_images_listing_id` (`listingsdb_id`),
  KEY `idx_images_rank` (`listingsimages_rank`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_listingsimages`
#
INSERT INTO paycan_en_listingsimages VALUES (6,1,'','2_90_picture115.jpg','thumb_2_90_picture115.jpg','',2,1,'yes');
#
# Table structure for table `paycan_en_memberformelements`
#
DROP TABLE IF EXISTS paycan_en_memberformelements;
CREATE TABLE `paycan_en_memberformelements` (
  `memberformelements_id` int(11) NOT NULL auto_increment,
  `memberformelements_field_type` varchar(20) NOT NULL default '',
  `memberformelements_field_name` varchar(80) NOT NULL default '',
  `memberformelements_field_caption` varchar(80) NOT NULL default '',
  `memberformelements_default_text` text NOT NULL,
  `memberformelements_field_elements` text NOT NULL,
  `memberformelements_rank` int(11) NOT NULL default '0',
  `memberformelements_required` char(3) NOT NULL default '',
  PRIMARY KEY  (`memberformelements_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_memberformelements`
#
INSERT INTO paycan_en_memberformelements VALUES (3,'textarea','info','Info','','',10,'No');
INSERT INTO paycan_en_memberformelements VALUES (4,'text','phone','Phone','','',1,'No');
INSERT INTO paycan_en_memberformelements VALUES (5,'text','mobile','Mobile','','',3,'No');
INSERT INTO paycan_en_memberformelements VALUES (6,'text','fax','Fax','','',5,'No');
INSERT INTO paycan_en_memberformelements VALUES (7,'url','homepage','Homepage','','',7,'No');
#
# Table structure for table `paycan_en_pagesmain`
#
DROP TABLE IF EXISTS paycan_en_pagesmain;
CREATE TABLE `paycan_en_pagesmain` (
  `pagesmain_id` int(11) NOT NULL auto_increment,
  `pagesmain_title` varchar(70) NOT NULL default '',
  `pagesmain_date` varchar(20) NOT NULL default '',
  `pagesmain_summary` varchar(255) NOT NULL default '',
  `pagesmain_full` longtext NOT NULL,
  `pagesmain_no_visitors` int(11) NOT NULL default '0',
  `pagesmain_complete` smallint(6) NOT NULL default '0',
  `pagesmain_description` longtext NOT NULL,
  `pagesmain_keywords` longtext NOT NULL,
  PRIMARY KEY  (`pagesmain_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_pagesmain`
#
INSERT INTO paycan_en_pagesmain VALUES (1,'Welcome','17 August 2003','Welcome Page','
  <h1 align=\"center\">Welcome </h1><br />
<center><img width=\"700\" align=\"middle\" alt=\"Paycan Motors Dealship Photo\" src=\"{template_url}/images/paycan_dealership4.jpg\" /></center>
<table border=\"0\">
<tbody><tr>
<td width=\"150\"> <br /></td><td align=\"left\">
<ul><li><strong>Serving Kitchener/Waterloo/Cambridge Since 1988 </strong></li><li><strong>Over 150 Vehicles to Choose From</strong></li><li><strong>Up to 5 Year Extended Warranties available</strong><strong></strong></li><li><strong>UCDA member</strong></li><li><strong>Here for you before and after the sale</strong></li><li><strong>Certified and E-Tested Vehicles<br /></strong></li></ul>
</td><td width=\"150\"> <br /></td>
</tr>
</tbody></table>
<div align=\"left\"><p>Paycan Motor\'s has providing the Kitchener, Waterloo and Cambridge areas with affordable used vehicles since 1988.  We know our cars and get to know our customers.  Come and meet our down to earth staff.  We are <strong>here for you before and after the sale</strong>.</p></div><div align=\"center\">
  </div><p align=\"left\">With <strong>150 to 200 vehicles to choose from</strong> at any given time there is something here for ever type of person and every type of budget.  We are a long standing member with the <strong>UCDA</strong> (Used Car Dealers Association) and our vehicles are sold certified, emission tested and with optional warranties up to 5 years in length.</p>

<center>
<table width=\"95%\" border=\"0\">
<tbody><tr>
<td width=\"50%\" align=\"left\">
<a href=\"http://www.ucda.ca/\" target=\"_blank\"><img border=\"0\" align=\"leftt\" alt=\"Used Car Dealer Association\" src=\"{template_url}/images/ucda2.jpg\" /></a> </td>

<td width=\"50%\" align=\"right\">    <p align=\"left\"><br /></p><div align=\"right\"><a href=\"mailto:sales%40paycanmotors.com\"><img border=\"0\" align=\"right\" src=\"{template_url}/images/email.gif\" /></a></div></td>
</tr>
</tbody></table></center><center>
      <p>{featured_listings_horizontal}</p></center>',0,1,'','');
INSERT INTO paycan_en_pagesmain VALUES (2,'Contact Us','17 August 2003','contact us page','<h1 align=\"center\">Contact Us</h1>
<div align=\"left\">
<p>Thank you for considering Paycan Motors for your vehicle purchase.</p>
<p>Feel free to call or email us. We will be happy to answer any questions you may have.<br />
</p>
</div>
<center>
<table width=\"90%\">
    <tbody>
        <tr>
            <td align=\"center\" width=\"25%\"><img alt=\"Zia - Paycan\" src=\"{template_url}/images/zia2.jpg\" /><br />
            <strong>Zia<br />
            </strong></td>
            <td>
            <div align=\"center\">
            <p><strong><font face=\"Arial\" size=\"4\">144 Victoria Street North<br />
            </font></strong><font size=\"2\">(Near Weber Street)</font><br />
            <font face=\"Arial\" size=\"4\"><strong>Kitchener, Ontario <br />
            Tel. (519) 742-3497<br />
            Cell (519) 570-6463</strong></font></p>
            </div>
            </td>
            <td width=\"25%\">
            <p align=\"center\"><br />
            <a href=\"mailto:sales%40paycanmotors.com\"><img style=\"TEXT-DECORATION: none\" alt=\"\" border=\"0\" src=\"{template_url}/images/email.gif\" /><br />
            Email Us!</a> </p>
            </td>
        </tr>
    </tbody>
</table>
<center>
<table cellspacing=\"1\" cellpadding=\"0\" width=\"140\" border=\"0\">
    <tbody>
        <tr valign=\"top\">
            <td class=\"detailssubheader\" width=\"50\"><strong>Day</strong></td>
            <td class=\"detailssubheader\"><strong>Hours</strong></td>
        </tr>
        <tr valign=\"top\">
            <td bgcolor=\"#dddddd\" colspan=\"2\"><img height=\"2\" alt=\"\" width=\"1\" border=\"0\" src=\"images/blank.gif\" /></td>
        </tr>
        <tr valign=\"top\">
            <td>Mon</td>
            <td>9:00 - 7:30</td>
        </tr>
        <tr valign=\"top\">
            <td bgcolor=\"#dddddd\" colspan=\"2\"><img height=\"1\" alt=\"\" width=\"1\" border=\"0\" src=\"images/blank.gif\" /></td>
        </tr>
        <tr valign=\"top\">
            <td>Tue</td>
            <td>9:00 - 7:30</td>
        </tr>
        <tr valign=\"top\">
            <td bgcolor=\"#dddddd\" colspan=\"2\"><img height=\"1\" alt=\"\" width=\"1\" border=\"0\" src=\"images/blank.gif\" /></td>
        </tr>
        <tr valign=\"top\">
            <td>Wed</td>
            <td>9:00 - 7:30</td>
        </tr>
        <tr valign=\"top\">
            <td bgcolor=\"#dddddd\" colspan=\"2\"><img height=\"1\" alt=\"\" width=\"1\" border=\"0\" src=\"images/blank.gif\" /></td>
        </tr>
        <tr valign=\"top\">
            <td>Thu</td>
            <td>9:00 - 7:30</td>
        </tr>
        <tr valign=\"top\">
            <td bgcolor=\"#dddddd\" colspan=\"2\"><img height=\"1\" alt=\"\" width=\"1\" border=\"0\" src=\"images/blank.gif\" /></td>
        </tr>
        <tr valign=\"top\">
            <td>Fri</td>
            <td>9:00 - 5:00</td>
        </tr>
        <tr valign=\"top\">
            <td bgcolor=\"#dddddd\" colspan=\"2\"><img height=\"1\" alt=\"\" width=\"1\" border=\"0\" src=\"images/blank.gif\" /></td>
        </tr>
        <tr valign=\"top\">
            <td>Sat</td>
            <td>9:30 - 5:00</td>
        </tr>
        <tr valign=\"top\">
            <td bgcolor=\"#dddddd\" colspan=\"2\"><img height=\"1\" alt=\"\" width=\"1\" border=\"0\" src=\"images/blank.gif\" /></td>
        </tr>
        <tr valign=\"top\">
            <td>Sun</td>
            <td>CLOSED</td>
        </tr>
    </tbody>
</table>
</center>
<h1 align=\"center\">Map</h1>
<table cellspacing=\"0\" cellpadding=\"0\" width=\"100%\" border=\"0\">
    <tbody>
        <tr>
            <td align=\"center\" width=\"100%\"><img alt=\"\" width=\"500\" border=\"0\" src=\"{template_url}/images/map.gif\" /></td>
        </tr>
    </tbody>
</table>
</center><br />',0,1,'','');
INSERT INTO paycan_en_pagesmain VALUES (3,'About Us','17 August 2003','About Us Page','<center>
    <h1>About Us</h1>
    <p align=\"left\">Paycan Motors began in 1988 with only 3 vehicles.  Started from a passion for cars since childhood, the business has grown through honesty, hard work, and treating the customer with respect to over 150 vehicles on site.  Paycan Motors has remained family run at the same location they started from, taking pride connecting with the average customer. When you come in and visit, it is still apparent that the owner, Zia, still believes in the philosophy of either \"Doing it right, or don\'t it at all.\"</p>
    <center><img src=\"{template_url}/images/zia.jpg\" width=\"500\" align=\"center\"></center>
    <p align=\"left\">The moto at Paycan Motors is to \"<strong>know your cars, but know your customers even better</strong>.\" This helps to exceed the customer\'s expectations and keeps people coming back.</p>
    <p> </p>
    <p align=\"left\"><br /></p></center>',0,1,'','');
#
# Table structure for table `paycan_en_userdb`
#
DROP TABLE IF EXISTS paycan_en_userdb;
CREATE TABLE `paycan_en_userdb` (
  `userdb_id` int(11) NOT NULL auto_increment,
  `userdb_user_name` varchar(80) NOT NULL default '',
  `userdb_emailaddress` varchar(80) NOT NULL default '',
  `userdb_user_first_name` varchar(100) NOT NULL default '',
  `userdb_user_last_name` varchar(100) NOT NULL default '',
  `userdb_comments` text NOT NULL,
  `userdb_user_password` varchar(50) NOT NULL default '',
  `userdb_is_admin` char(3) NOT NULL default '',
  `userdb_can_edit_site_config` char(3) NOT NULL default '',
  `userdb_can_edit_member_template` char(3) NOT NULL default '',
  `userdb_can_edit_agent_template` char(3) NOT NULL default '',
  `userdb_can_edit_listing_template` char(3) NOT NULL default '',
  `userdb_creation_date` date NOT NULL default '0000-00-00',
  `userdb_can_feature_listings` char(3) NOT NULL default '',
  `userdb_can_view_logs` char(3) NOT NULL default '',
  `userdb_last_modified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `userdb_hit_count` int(11) NOT NULL default '0',
  `userdb_can_moderate` char(3) NOT NULL default '',
  `userdb_can_edit_pages` char(3) NOT NULL default '',
  `userdb_can_have_vtours` char(3) NOT NULL default '',
  `userdb_is_agent` char(3) NOT NULL default '',
  `userdb_active` char(3) NOT NULL default '',
  `userdb_limit_listings` int(11) NOT NULL default '0',
  `userdb_can_edit_expiration` varchar(100) NOT NULL default '',
  `userdb_can_export_listings` varchar(100) NOT NULL default '',
  `userdb_can_edit_all_users` char(3) NOT NULL default '',
  `userdb_can_edit_all_listings` char(3) NOT NULL default '',
  `userdb_can_edit_property_classes` char(3) NOT NULL default '',
  PRIMARY KEY  (`userdb_id`),
  KEY `idx_user_name` (`userdb_user_name`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_userdb`
#
INSERT INTO paycan_en_userdb VALUES (1,'admin','changeme@default.com','Default','Admin','','5f4dcc3b5aa765d61d8327deb882cf99','yes','yes','yes','yes','yes','2002-07-01','yes','yes','2002-07-01 22:38:50',1,'yes','yes','yes','no','yes',-1,'yes','yes','yes','yes','yes');
#
# Table structure for table `paycan_en_userdbelements`
#
DROP TABLE IF EXISTS paycan_en_userdbelements;
CREATE TABLE `paycan_en_userdbelements` (
  `userdbelements_id` int(11) NOT NULL auto_increment,
  `userdbelements_field_name` varchar(80) NOT NULL default '',
  `userdbelements_field_value` text NOT NULL,
  `userdb_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`userdbelements_id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_userdbelements`
#
INSERT INTO paycan_en_userdbelements VALUES (1,'edit_user_name','admin',1);
INSERT INTO paycan_en_userdbelements VALUES (2,'phone','215.850.0710',1);
INSERT INTO paycan_en_userdbelements VALUES (3,'mobile','215.850.0710',1);
INSERT INTO paycan_en_userdbelements VALUES (4,'fax','702.995.6591',1);
INSERT INTO paycan_en_userdbelements VALUES (5,'homepage','http://www.open-realty.org',1);
INSERT INTO paycan_en_userdbelements VALUES (6,'info','I am the system administrator!',1);
#
# Table structure for table `paycan_en_userfavoritelistings`
#
DROP TABLE IF EXISTS paycan_en_userfavoritelistings;
CREATE TABLE `paycan_en_userfavoritelistings` (
  `userfavoritelistings_id` int(11) NOT NULL auto_increment,
  `userdb_id` int(11) NOT NULL default '0',
  `listingsdb_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`userfavoritelistings_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_userfavoritelistings`
#
#
# Table structure for table `paycan_en_userimages`
#
DROP TABLE IF EXISTS paycan_en_userimages;
CREATE TABLE `paycan_en_userimages` (
  `userimages_id` int(11) NOT NULL auto_increment,
  `userdb_id` int(11) NOT NULL default '0',
  `userimages_caption` varchar(255) NOT NULL default '',
  `userimages_file_name` varchar(80) NOT NULL default '',
  `userimages_thumb_file_name` varchar(80) NOT NULL default '',
  `userimages_description` text NOT NULL,
  `userimages_rank` int(11) NOT NULL default '0',
  `userimages_active` char(3) NOT NULL default '',
  PRIMARY KEY  (`userimages_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_userimages`
#
#
# Table structure for table `paycan_en_usersavedsearches`
#
DROP TABLE IF EXISTS paycan_en_usersavedsearches;
CREATE TABLE `paycan_en_usersavedsearches` (
  `usersavedsearches_id` int(11) NOT NULL auto_increment,
  `userdb_id` int(11) NOT NULL default '0',
  `usersavedsearches_title` varchar(255) NOT NULL default '',
  `usersavedsearches_query_string` text NOT NULL,
  `usersavedsearches_last_viewed` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `usersavedsearches_new_listings` smallint(6) NOT NULL default '0',
  `usersavedsearches_notify` char(3) NOT NULL default '',
  PRIMARY KEY  (`usersavedsearches_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_usersavedsearches`
#
#
# Table structure for table `paycan_en_vtourimages`
#
DROP TABLE IF EXISTS paycan_en_vtourimages;
CREATE TABLE `paycan_en_vtourimages` (
  `vtourimages_id` int(11) NOT NULL auto_increment,
  `userdb_id` int(11) NOT NULL default '0',
  `vtourimages_caption` varchar(255) NOT NULL default '',
  `vtourimages_file_name` varchar(80) NOT NULL default '',
  `vtourimages_thumb_file_name` varchar(80) NOT NULL default '',
  `vtourimages_description` text NOT NULL,
  `listingsdb_id` int(11) NOT NULL default '0',
  `vtourimages_rank` int(11) NOT NULL default '0',
  `vtourimages_active` char(3) NOT NULL default '',
  PRIMARY KEY  (`vtourimages_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_en_vtourimages`
#
#
# Table structure for table `paycan_forgot`
#
DROP TABLE IF EXISTS paycan_forgot;
CREATE TABLE `paycan_forgot` (
  `forgot_id` int(10) unsigned NOT NULL auto_increment,
  `forgot_rand` int(10) unsigned NOT NULL default '0',
  `forgot_email` varchar(45) NOT NULL default '',
  `forgot_time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`forgot_id`),
  KEY `idx_forgot_email` (`forgot_email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_forgot`
#
#
# Table structure for table `paycan_zipdist`
#
DROP TABLE IF EXISTS paycan_zipdist;
CREATE TABLE `paycan_zipdist` (
  `zipdist_zipcode` varchar(5) default NULL,
  `zipdist_ziptype` char(1) default NULL,
  `zipdist_cityname` varchar(64) default NULL,
  `zipdist_citytype` char(1) default NULL,
  `zipdist_statename` varchar(64) default NULL,
  `zipdist_stateabbr` char(2) default NULL,
  `zipdist_areacode` char(3) default NULL,
  `zipdist_latitude` decimal(9,6) default NULL,
  `zipdist_longitude` decimal(9,6) default NULL,
  `zipdist_id` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`zipdist_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping data for table `paycan_zipdist`
#