# ---------------------------------------------------------- # # structur for table 'hits_affiliates' # DROP TABLE IF EXISTS hits_affiliates;#%% CREATE TABLE hits_affiliates ( refid varchar(30) NOT NULL, pass varchar(20) NOT NULL, company varchar(100) NOT NULL, title varchar(5) NOT NULL, firstname varchar(40) NOT NULL, lastname varchar(40) NOT NULL, website varchar(100) NOT NULL, email varchar(100) NOT NULL, payableto varchar(100) NOT NULL, street varchar(100) NOT NULL, town varchar(100) NOT NULL, county varchar(100) NOT NULL, postcode varchar(20) NOT NULL, country varchar(100) NOT NULL, phone varchar(30) NOT NULL, fax varchar(30) NOT NULL, date varchar(40) DEFAULT '01/01/2002' NOT NULL, PRIMARY KEY (refid) );#%% # # data for table 'hits_affiliates' # INSERT INTO hits_affiliates VALUES ('hitchman','brian1','Hitchman IT Solutions Ltd.','Mr.','Ian','Hitchman','www.hitchman.co.uk','ian@hitchman.co.uk','Ian Hitchman','60b Alexandra Road','Great Wakering','Essex','SS3 0HW','United Kingdom','01702218524','1234567890','26/10/2003');#%% # ---------------------------------------------------------- # # structur for table 'hits_affiliates_sales' # DROP TABLE IF EXISTS hits_affiliates_sales;#%% CREATE TABLE hits_affiliates_sales ( id int(10) NOT NULL auto_increment, logdate varchar(8) NOT NULL, timestamp int(11) DEFAULT '0' NOT NULL, refid varchar(255) NOT NULL, ipaddress varchar(20) NOT NULL, payment float(6,2) DEFAULT '0.00' NOT NULL, customer varchar(255) NOT NULL, oid int(10) DEFAULT '0' NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_affiliates_sales' # INSERT INTO hits_affiliates_sales VALUES ('4','2005-07','1121182233','ianhitchman','127.0.0.1','0.00','','126359');#%% # ---------------------------------------------------------- # # structur for table 'hits_affiliates_settings' # DROP TABLE IF EXISTS hits_affiliates_settings;#%% CREATE TABLE hits_affiliates_settings ( id int(3) NOT NULL auto_increment, affiliates_on int(1) DEFAULT '0' NOT NULL, payment_percentage int(3) DEFAULT '10' NOT NULL, currency varchar(50) DEFAULT 'GBP' NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_affiliates_settings' # INSERT INTO hits_affiliates_settings VALUES ('1','1','5','GBP');#%% # ---------------------------------------------------------- # # structur for table 'hits_banners' # DROP TABLE IF EXISTS hits_banners;#%% CREATE TABLE hits_banners ( id int(10) NOT NULL auto_increment, filename varchar(255) NOT NULL, alt varchar(255), name varchar(255) NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_banners' # INSERT INTO hits_banners VALUES ('1','banner1.gif','An example banner! Click here to visit our demo site.','Small example banner');#%% INSERT INTO hits_banners VALUES ('2','banner2.gif','Click to visit Hitchman IT Solutions Ltd.','Small Button Banner');#%% # ---------------------------------------------------------- # # structur for table 'hits_bespoke_order_days' # DROP TABLE IF EXISTS hits_bespoke_order_days;#%% CREATE TABLE hits_bespoke_order_days ( letter char(3) NOT NULL, days int(3) DEFAULT '0' NOT NULL, description varchar(255) NOT NULL );#%% # # data for table 'hits_bespoke_order_days' # INSERT INTO hits_bespoke_order_days VALUES ('f','3','Fresh Produce Boxes');#%% INSERT INTO hits_bespoke_order_days VALUES ('x','3','Fresh Produce Extras');#%% INSERT INTO hits_bespoke_order_days VALUES ('g','2','Grocery');#%% INSERT INTO hits_bespoke_order_days VALUES ('h','4','Household');#%% INSERT INTO hits_bespoke_order_days VALUES ('d','3','Drinks');#%% INSERT INTO hits_bespoke_order_days VALUES ('c','2','Chilled');#%% # ---------------------------------------------------------- # # structur for table 'hits_config' # DROP TABLE IF EXISTS hits_config;#%% CREATE TABLE hits_config ( config_id int(10) unsigned NOT NULL auto_increment, title varchar(255), keywords text, description text, url varchar(255), header longtext, footer longtext, menu_horiz_bool int(1) DEFAULT '0' NOT NULL, menu_vert_bool int(1) DEFAULT '0' NOT NULL, use_access_restrictions int(1) DEFAULT '0' NOT NULL, non_user_full_access int(1) DEFAULT '1' NOT NULL, non_user_group int(10) DEFAULT '0' NOT NULL, users_instant_signup_bool int(1) DEFAULT '0' NOT NULL, users_require_activation_bool int(1) DEFAULT '0' NOT NULL, users_default_group_id varchar(12) DEFAULT '(No Group)' NOT NULL, email_friend_template varchar(8) DEFAULT 'default' NOT NULL, email_friend_html longtext NOT NULL, email_friend_intro_text longtext NOT NULL, email_friend_subject varchar(255) NOT NULL, email_friend_allow_greetings_bool int(1) DEFAULT '1' NOT NULL, email_friend_join_list_bool int(1) DEFAULT '1' NOT NULL, email_friend_overide_url varchar(255) NOT NULL, PRIMARY KEY (config_id) );#%% # # data for table 'hits_config' # INSERT INTO hits_config VALUES ('1','Hitchman Content Management System (HCMS) Demonstration Site','Keywords here','Description here','http://www.your-url-here.com','','(c) 2004 Hitchman IT Solutions Ltd. All rights reserved. Site built & maintained by Hitchman IT Solutions Ltd.','1','1','0','1','7','1','0','(No Group)','html','[content] ','Dear [name], [sender] thought you might like to take a look at this site: [url]. The following personal greeting was also added: [greeting]','[name] - check this out!','1','1','');#%% # ---------------------------------------------------------- # # structur for table 'hits_contact' # DROP TABLE IF EXISTS hits_contact;#%% CREATE TABLE hits_contact ( id int(10) unsigned NOT NULL auto_increment, tel varchar(255), fax varchar(255), address text, email varchar(255), enabled_tel int(1) DEFAULT '1' NOT NULL, enabled_fax int(1) DEFAULT '1' NOT NULL, enabled_address int(1) DEFAULT '1' NOT NULL, enabled_email int(1) DEFAULT '1' NOT NULL, intro longtext, link_to_map int(1) DEFAULT '0' NOT NULL, multimap int(1) DEFAULT '0' NOT NULL, show_directions int(1) DEFAULT '0' NOT NULL, postcode varchar(10), map_image varchar(255) DEFAULT '(No Image)' NOT NULL, directions longtext, enabled_form int(1) DEFAULT '1' NOT NULL, business_name varchar(255) NOT NULL, web_address varchar(255) NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_contact' # INSERT INTO hits_contact VALUES ('1','01702 123456','01702 123456','Address line one, Address line two, Address line three, SS1 1AB','ian@hitchman.co.uk','1','1','1','1','','1','1','0','SS3 9QY','(No Image)','From the Airport, join the M4 West. Take 1st Exit, signposted M25 North. Follow M25 North and leave at Junction 21, signposted M1 North... etc... etc...','1','Hitchman IT Solutions ltd.','www.hitchman.co.uk');#%% # ---------------------------------------------------------- # # structur for table 'hits_directory' # DROP TABLE IF EXISTS hits_directory;#%% CREATE TABLE hits_directory ( id int(11) NOT NULL auto_increment, header_text longtext, header_title longtext, header_image varchar(255), header_align varchar(255), footer_text longtext, footer_title longtext, footer_image varchar(255), footer_align varchar(255), field1 varchar(255), field2 varchar(255), field3 varchar(255), field4 varchar(255), field5 varchar(255), field6 varchar(255), field7 varchar(255), field8 varchar(255), header_image_align varchar(255) DEFAULT 'left', footer_image_align varchar(255) DEFAULT 'left', sort varchar(8) DEFAULT 'manual' NOT NULL, no_items_per_page int(4) DEFAULT '0' NOT NULL, view varchar(10), PRIMARY KEY (id) );#%% # # data for table 'hits_directory' # INSERT INTO hits_directory VALUES ('1','We hope that you find this directory useful. If you notice any mistakes, please e-mail us at [e]','','(No Image)','left','If you would like to be included in this directory, please call us on [t].','Add Your Business','(No Image)','left','Features','Doors','Year','Breed','Type','','','','left','left','ascend','2',NULL);#%% # ---------------------------------------------------------- # # structur for table 'hits_directory_categories' # DROP TABLE IF EXISTS hits_directory_categories;#%% CREATE TABLE hits_directory_categories ( id int(10) NOT NULL auto_increment, enabled int(1) DEFAULT '1' NOT NULL, parent_id int(10) DEFAULT '0' NOT NULL, description varchar(255) DEFAULT 'Main (Root)' NOT NULL, order_by int(10) DEFAULT '0' NOT NULL, catheader longtext, image varchar(255) DEFAULT '(No Image)' NOT NULL, image_border int(1) DEFAULT '0' NOT NULL, meta_description longtext, meta_keywords longtext, meta_title longtext, advanced_search_serialized longtext, PRIMARY KEY (id) );#%% # # data for table 'hits_directory_categories' # INSERT INTO hits_directory_categories VALUES ('1','1','0','Main Categories','1',NULL,'(No Image)','0',NULL,NULL,NULL,'');#%% INSERT INTO hits_directory_categories VALUES ('72','1','1','New','1',NULL,'(No Image)','0',NULL,NULL,NULL,'a:3:{s:6:\"field1\";s:8:\"dropdown\";s:6:\"field2\";s:8:\"freetext\";s:7:\"subcats\";s:1:\"1\";}');#%% INSERT INTO hits_directory_categories VALUES ('75','1','72','New Category','1',NULL,'(No Image)','0',NULL,NULL,NULL,NULL);#%% INSERT INTO hits_directory_categories VALUES ('76','1','72','cxxc','2',NULL,'(No Image)','0',NULL,NULL,NULL,NULL);#%% # ---------------------------------------------------------- # # structur for table 'hits_directory_items' # DROP TABLE IF EXISTS hits_directory_items;#%% CREATE TABLE hits_directory_items ( directory_id int(10) NOT NULL auto_increment, short_description longtext, long_description_1 longtext, long_description_2 longtext, long_description_3 longtext, long_description_4 longtext, long_description_5 longtext, details_popup int(1) DEFAULT '0' NOT NULL, tab_title_2 varchar(100) NOT NULL, tab_title_3 varchar(100) NOT NULL, tab_title_4 varchar(100) NOT NULL, tab_title_5 varchar(100) NOT NULL, image_2 varchar(255) DEFAULT '(No Image)' NOT NULL, image_3 varchar(255) DEFAULT '(No Image)' NOT NULL, image_4 varchar(255) DEFAULT '(No Image)' NOT NULL, image_5 varchar(255) DEFAULT '(No Image)' NOT NULL, custom_code_2 longtext, custom_code_3 longtext, custom_code_4 longtext, custom_code_5 longtext, enabled int(1) DEFAULT '1' NOT NULL, position int(5) DEFAULT '0' NOT NULL, address_1 varchar(100), address_2 varchar(100), address_3 varchar(100), county varchar(50), postcode varchar(10), tel varchar(50), fax varchar(50), email varchar(255), web_url varchar(255), field1 varchar(255), field2 varchar(255), field3 varchar(255), field4 varchar(255), field5 varchar(255), field6 varchar(255), field7 varchar(255), field8 varchar(255), image_main_thumb varchar(255), image_main_large varchar(255), image_border int(1) DEFAULT '0' NOT NULL, link_to_page varchar(255), cat_id int(10) DEFAULT '0' NOT NULL, weight varchar(10), layout varchar(50) NOT NULL, priority int(1) DEFAULT '0' NOT NULL, PRIMARY KEY (directory_id) );#%% # # data for table 'hits_directory_items' # INSERT INTO hits_directory_items VALUES ('139','New Listing','','','','','','0','','','','','(No Image)','(No Image)','(No Image)','(No Image)','','','','','1','1','','','','','','','','','','','','','','','','','','(No Image)','','0','','1','','','0');#%% INSERT INTO hits_directory_items VALUES ('145','New Listing','',NULL,NULL,NULL,NULL,'0','','','','','(No Image)','(No Image)','(No Image)','(No Image)',NULL,NULL,NULL,NULL,'1','1','','','','','','','','','','','','','','','','','','(No Image)','(No Image)','0','','72',NULL,'','0');#%% # ---------------------------------------------------------- # # structur for table 'hits_download_categories' # DROP TABLE IF EXISTS hits_download_categories;#%% CREATE TABLE hits_download_categories ( id int(9) NOT NULL auto_increment, description varchar(255) NOT NULL, order_by int(9) DEFAULT '0' NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_download_categories' # INSERT INTO hits_download_categories VALUES ('14','blah','1');#%% # ---------------------------------------------------------- # # structur for table 'hits_download_files' # DROP TABLE IF EXISTS hits_download_files;#%% CREATE TABLE hits_download_files ( id int(9) NOT NULL auto_increment, cat_id int(9) DEFAULT '0' NOT NULL, description longtext NOT NULL, file_name varchar(255) NOT NULL, order_by int(9) DEFAULT '0' NOT NULL, mime varchar(50), PRIMARY KEY (id) );#%% # # data for table 'hits_download_files' # INSERT INTO hits_download_files VALUES ('29','14','asdad','alumaflex breather certification.pdf','1','application/pdf');#%% INSERT INTO hits_download_files VALUES ('30','14','dssahdsf ','alumaflex insulation DS.pdf','2','application/pdf');#%% INSERT INTO hits_download_files VALUES ('31','14','hgfds','alumaflex dwg 03.pdf','3','application/pdf');#%% # ---------------------------------------------------------- # # structur for table 'hits_events_categories' # DROP TABLE IF EXISTS hits_events_categories;#%% CREATE TABLE hits_events_categories ( cat_id int(10) NOT NULL auto_increment, description varchar(255) DEFAULT 'Events' NOT NULL, meta_description longtext NOT NULL, meta_keywords longtext NOT NULL, meta_title longtext NOT NULL, PRIMARY KEY (cat_id) );#%% # # data for table 'hits_events_categories' # INSERT INTO hits_events_categories VALUES ('1','Local Events','','','');#%% INSERT INTO hits_events_categories VALUES ('10','New Category','','','');#%% # ---------------------------------------------------------- # # structur for table 'hits_events_events' # DROP TABLE IF EXISTS hits_events_events;#%% CREATE TABLE hits_events_events ( event_id int(10) NOT NULL auto_increment, cat_id int(10) DEFAULT '0' NOT NULL, short_description longtext NOT NULL, long_description longtext NOT NULL, start_timestamp int(11) DEFAULT '0' NOT NULL, end_timestamp int(11) DEFAULT '0' NOT NULL, time varchar(20) NOT NULL, enabled int(1) DEFAULT '1' NOT NULL, image_main_thumb varchar(255) DEFAULT '(No Image)' NOT NULL, image_main_large varchar(255) DEFAULT '(No Image)' NOT NULL, image_border int(1) DEFAULT '0' NOT NULL, link_to_page varchar(255) NOT NULL, link_text varchar(255) DEFAULT 'More...' NOT NULL, reply_bool int(1) DEFAULT '0' NOT NULL, reply_email varchar(255) NOT NULL, event_postcode varchar(10), PRIMARY KEY (event_id) );#%% # # data for table 'hits_events_events' # INSERT INTO hits_events_events VALUES ('7','10','Meeting at Bob\'s','dfsfds','1118012400','1118012400','12pm-3pm','1','badmunkyian4.jpg','(No Image)','0','','More...','0','',NULL);#%% INSERT INTO hits_events_events VALUES ('37','1','Meeting at Bob\'s','lksakd jdaslk jakdsj akds jlksad jlkads kjaskd jakds lal sadlkasdkl jasd jsakdj lksaj dlkasd asd iabds iuahsdcxmz,zmnx sm,wnd ausnd asdhiuqwhbcz dhsljb akjhdb ksdjhv kaj dh vau vqwhvd jhksa d','1122418800','1122937200','','1','cimages.jpg','terminator.jpg','1','sidepage','More...','0','',NULL);#%% INSERT INTO hits_events_events VALUES ('34','1','Meeting at Dave\'s','','1120172400','1120431600','','1','(No Image)','(No Image)','0','','More...','1','ian@tessmarka.co.uk',NULL);#%% INSERT INTO hits_events_events VALUES ('35','1','Meeting at Frank\'s','lksakd jdaslk jakdsj akds jlksad jlkads kjaskd jakds lal sadlkasdkl jasd jsakdj lksaj dlkasd asd iabds iuahsdcxmz,zmnx sm,wnd ausnd asdhiuqwhbcz dhsljb akjhdb ksdjhv kaj dh vau vqwhvd jhksa d','1122764400','1122764400','8.00-9.00pm','1','cimages.jpg','terminator.jpg','0','sidepage','More...','0','',NULL);#%% INSERT INTO hits_events_events VALUES ('38','1','Meeting at Barry\'s','lksakd jdaslk jakdsj akds jlksad jlkads kjaskd jakds lal sadlkasdkl jasd jsakdj lksaj dlkasd asd iabds iuahsdcxmz,zmnx sm,wnd ausnd asdhiuqwhbcz dhsljb akjhdb ksdjhv kaj dh vau vqwhvd jhksa d','1122418800','1122418800','','1','cimages.jpg','terminator.jpg','1','sidepage','More...','0','ian@hitchman.co.uk',NULL);#%% INSERT INTO hits_events_events VALUES ('39','1','New Event','','1122418800','1122418800','','1','(No Image)','(No Image)','0','','More...','0','ian@hitchman.co.uk',NULL);#%% INSERT INTO hits_events_events VALUES ('40','1','New Event','','1122418800','1122418800','','1','(No Image)','(No Image)','0','','More...','0','ian@hitchman.co.uk',NULL);#%% INSERT INTO hits_events_events VALUES ('41','1','New Event','','1136764800','1136764800','','1','(No Image)','(No Image)','0','','More...','0','ian@hitchman.co.uk',NULL);#%% # ---------------------------------------------------------- # # structur for table 'hits_file_library' # DROP TABLE IF EXISTS hits_file_library;#%% CREATE TABLE hits_file_library ( id int(11) NOT NULL auto_increment, filename varchar(255) NOT NULL, mime varchar(50) NOT NULL, fileid varchar(50) NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_file_library' # # ---------------------------------------------------------- # # structur for table 'hits_files' # DROP TABLE IF EXISTS hits_files;#%% CREATE TABLE hits_files ( id int(10) unsigned NOT NULL auto_increment, heading text, textalign varchar(10) DEFAULT 'left' NOT NULL, type varchar(10) NOT NULL, content longtext, topalign varchar(10) DEFAULT 'left' NOT NULL, topimage varchar(255) DEFAULT '(No Image)', PRIMARY KEY (id) );#%% # # data for table 'hits_files' # INSERT INTO hits_files VALUES ('1','Information Repository','left','header','This page demonstrates a facility you may like to provide for your customers. For example, you could allow them to download catalogues, price lists or information files. Any of the files can be protected with a username/password so that only selected customers can access them. The following files can be freely downloaded. If you experience any problems, please e-mail us: #e.','right','download.jpg');#%% INSERT INTO hits_files VALUES ('2','Disclaimer','left','footer','Please note that we remain the copyright owners of all files published here. You are free to download and distribute, but we accept no responsibility for any misuse, or damage relating to these files.','left','(No Image)');#%% # ---------------------------------------------------------- # # structur for table 'hits_forms' # DROP TABLE IF EXISTS hits_forms;#%% CREATE TABLE hits_forms ( field_id int(11) NOT NULL auto_increment, form_id int(10) DEFAULT '0' NOT NULL, name varchar(30), description varchar(255), type enum('form','text','email','textarea','select','checkbox','radio','file') DEFAULT 'text', options longtext, required_bool enum('1','0') DEFAULT '0', position int(11) DEFAULT '0', maxlength int(6), PRIMARY KEY (field_id) );#%% # # data for table 'hits_forms' # INSERT INTO hits_forms VALUES ('1','1','tradeenquiries','Trade Enquiries','form','','0','1',NULL);#%% INSERT INTO hits_forms VALUES ('2','1','','Full Name','text','','1','1',NULL);#%% INSERT INTO hits_forms VALUES ('3','1','','Address','textarea','','0','2',NULL);#%% INSERT INTO hits_forms VALUES ('4','1','','Country','select','United Kingdom United States Other - Europe Other - World','1','3',NULL);#%% INSERT INTO hits_forms VALUES ('5','1','','Subscribe to mailing list','checkbox','checked','0','4',NULL);#%% INSERT INTO hits_forms VALUES ('6','1','','Gender','radio','Male Female Unknown','0','5',NULL);#%% INSERT INTO hits_forms VALUES ('8','2','testform','testform','form','','0','1',NULL);#%% INSERT INTO hits_forms VALUES ('25','1',NULL,'testy','select','fghfgh fgf','1','6',NULL);#%% INSERT INTO hits_forms VALUES ('26','3','blah','dsfsd','form',NULL,'0','1',NULL);#%% INSERT INTO hits_forms VALUES ('27','2',NULL,'Name','text','','1','1',NULL);#%% INSERT INTO hits_forms VALUES ('28','2',NULL,'Address','textarea','','1','2',NULL);#%% INSERT INTO hits_forms VALUES ('29','4','blah','blah','form',NULL,'0','1',NULL);#%% INSERT INTO hits_forms VALUES ('34','4',NULL,'df','select','','0','1',NULL);#%% # ---------------------------------------------------------- # # structur for table 'hits_forum_forums' # DROP TABLE IF EXISTS hits_forum_forums;#%% CREATE TABLE hits_forum_forums ( forum_id int(10) NOT NULL auto_increment, description varchar(255) NOT NULL, long_description longtext, PRIMARY KEY (forum_id) );#%% # # data for table 'hits_forum_forums' # INSERT INTO hits_forum_forums VALUES ('5','General Chat','Talk about anything here');#%% # ---------------------------------------------------------- # # structur for table 'hits_forum_posts' # DROP TABLE IF EXISTS hits_forum_posts;#%% CREATE TABLE hits_forum_posts ( post_id int(11) NOT NULL auto_increment, post_threadid int(11) DEFAULT '0' NOT NULL, post_body text NOT NULL, post_time int(11), post_posterid varchar(255), post_postername varchar(30) NOT NULL, post_posteremail varchar(40) NOT NULL, post_posterurl varchar(40) NOT NULL, PRIMARY KEY (post_id) );#%% # # data for table 'hits_forum_posts' # INSERT INTO hits_forum_posts VALUES ('73','29','test','1121165324','ianhitchman','','','');#%% # ---------------------------------------------------------- # # structur for table 'hits_forum_settings' # DROP TABLE IF EXISTS hits_forum_settings;#%% CREATE TABLE hits_forum_settings ( allowed_posts varchar(10) DEFAULT 'both' NOT NULL, instant_signup int(1) DEFAULT '1' NOT NULL );#%% # # data for table 'hits_forum_settings' # INSERT INTO hits_forum_settings VALUES ('members','0');#%% # ---------------------------------------------------------- # # structur for table 'hits_forum_topics' # DROP TABLE IF EXISTS hits_forum_topics;#%% CREATE TABLE hits_forum_topics ( topic_id int(11) NOT NULL auto_increment, forum_id int(10) DEFAULT '1' NOT NULL, topic_title varchar(50) NOT NULL, topic_timestamp int(11) DEFAULT '0', topic_lastpost int(11), topic_posterid varchar(255), topic_postername varchar(30) NOT NULL, topic_posteremail varchar(40) NOT NULL, topic_closed enum('1','0') DEFAULT '0' NOT NULL, PRIMARY KEY (topic_id) );#%% # # data for table 'hits_forum_topics' # INSERT INTO hits_forum_topics VALUES ('29','5','test','1121165324','1121165324','ianhitchman','','','0');#%% # ---------------------------------------------------------- # # structur for table 'hits_gallery' # DROP TABLE IF EXISTS hits_gallery;#%% CREATE TABLE hits_gallery ( id int(11) NOT NULL auto_increment, type varchar(20) DEFAULT 'auto' NOT NULL, no_rows int(10) DEFAULT '9' NOT NULL, no_cols int(10) DEFAULT '3' NOT NULL, filetype varchar(10) DEFAULT '.jpg' NOT NULL, header longtext, PRIMARY KEY (id) );#%% # # data for table 'hits_gallery' # INSERT INTO hits_gallery VALUES ('1','manual','3','3','.jpg','');#%% # ---------------------------------------------------------- # # structur for table 'hits_gallery_cats' # DROP TABLE IF EXISTS hits_gallery_cats;#%% CREATE TABLE hits_gallery_cats ( gallery_cat_id int(10) NOT NULL auto_increment, parent_id int(10) DEFAULT '0' NOT NULL, description varchar(255) NOT NULL, order_by int(10) DEFAULT '0' NOT NULL, catheader longtext, image varchar(255) DEFAULT '(No Image)' NOT NULL, image_border int(1) DEFAULT '0' NOT NULL, enabled int(1) DEFAULT '1', PRIMARY KEY (gallery_cat_id) );#%% # # data for table 'hits_gallery_cats' # INSERT INTO hits_gallery_cats VALUES ('1','0','Top Level','0',NULL,'(No Image)','0','0');#%% # ---------------------------------------------------------- # # structur for table 'hits_gallery_manual' # DROP TABLE IF EXISTS hits_gallery_manual;#%% CREATE TABLE hits_gallery_manual ( id int(10) unsigned NOT NULL auto_increment, library_id int(10) DEFAULT '1' NOT NULL, description longtext, usemap varchar(5) DEFAULT 'false' NOT NULL, order_by int(10), thumb varchar(255), large_image varchar(255) DEFAULT '(No Image)' NOT NULL, catid int(5) DEFAULT '1' NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_gallery_manual' # # ---------------------------------------------------------- # # structur for table 'hits_gallerycats' # DROP TABLE IF EXISTS hits_gallerycats;#%% CREATE TABLE hits_gallerycats ( id int(11) NOT NULL auto_increment, description varchar(50), PRIMARY KEY (id) );#%% # # data for table 'hits_gallerycats' # # ---------------------------------------------------------- # # structur for table 'hits_library' # DROP TABLE IF EXISTS hits_library;#%% CREATE TABLE hits_library ( id int(10) unsigned NOT NULL auto_increment, image varchar(255), alt text, folder_id int(10) DEFAULT '1' NOT NULL, postcard_bool int(1) DEFAULT '0' NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_library' # # ---------------------------------------------------------- # # structur for table 'hits_library_folders' # DROP TABLE IF EXISTS hits_library_folders;#%% CREATE TABLE hits_library_folders ( id int(10) NOT NULL auto_increment, parent_id int(10) DEFAULT '1' NOT NULL, description varchar(255) DEFAULT 'New Folder' NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_library_folders' # INSERT INTO hits_library_folders VALUES ('1','0','Images');#%% # ---------------------------------------------------------- # # structur for table 'hits_library_settings' # DROP TABLE IF EXISTS hits_library_settings;#%% CREATE TABLE hits_library_settings ( id int(3) NOT NULL auto_increment, small_width int(4) DEFAULT '200' NOT NULL, small_height int(4) DEFAULT '200' NOT NULL, large_width int(4) DEFAULT '550' NOT NULL, large_height int(4) DEFAULT '500' NOT NULL, thumb_width int(4) DEFAULT '150' NOT NULL, thumb_height int(4) DEFAULT '150' NOT NULL, icon_width int(4) DEFAULT '90' NOT NULL, icon_height int(4) DEFAULT '90' NOT NULL, shrink_only int(1) DEFAULT '1' NOT NULL, jpg_compression int(3) DEFAULT '70' NOT NULL, small_suffix varchar(255) DEFAULT '_small', thumb_suffix varchar(255) DEFAULT '_thumb', icon_suffix varchar(255) DEFAULT '_icon', large_suffix varchar(255) DEFAULT '_large', PRIMARY KEY (id) );#%% # # data for table 'hits_library_settings' # INSERT INTO hits_library_settings VALUES ('1','200','200','550','500','130','130','120','120','0','80','_small','_thumb','_icon','_large');#%% # ---------------------------------------------------------- # # structur for table 'hits_local_delivery_days' # DROP TABLE IF EXISTS hits_local_delivery_days;#%% CREATE TABLE hits_local_delivery_days ( local_id int(11) NOT NULL auto_increment, postcode_prefix varchar(6), delivery_day varchar(10), PRIMARY KEY (local_id) );#%% # # data for table 'hits_local_delivery_days' # INSERT INTO hits_local_delivery_days VALUES ('6','SS3','Monday');#%% # ---------------------------------------------------------- # # structur for table 'hits_mailing_list' # DROP TABLE IF EXISTS hits_mailing_list;#%% CREATE TABLE hits_mailing_list ( id int(11) NOT NULL auto_increment, email varchar(255), fullname varchar(255), PRIMARY KEY (id) );#%% # # data for table 'hits_mailing_list' # INSERT INTO hits_mailing_list VALUES ('23','ian@hitchman.co.uk',NULL);#%% # ---------------------------------------------------------- # # structur for table 'hits_main' # DROP TABLE IF EXISTS hits_main;#%% CREATE TABLE hits_main ( id int(10) unsigned NOT NULL auto_increment, page varchar(50) DEFAULT 'about' NOT NULL, position int(10) DEFAULT '0' NOT NULL, content text, topimage text, imagealt varchar(255), imagecaption varchar(255), border int(2) DEFAULT '0' NOT NULL, bottomimage text, heading text, topalign varchar(10) DEFAULT 'left', bottomalign varchar(10), textalign varchar(10) DEFAULT 'left', wrap enum('1','0') DEFAULT '1' NOT NULL, usetable varchar(255) NOT NULL, image_link varchar(255) DEFAULT 'no_link', image_popup varchar(255), link_page varchar(255), link_url varchar(255), image_border int(1) DEFAULT '0' NOT NULL, image_caption varchar(255) NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_main' # INSERT INTO hits_main VALUES ('49','termsconditions','1','

Legal Notices

THE VIEWLONDON WEB SITE (\"Site\") - Terms and Conditions for use of the Site.

Please ensure that you read carefully through the following terms and conditions before using this Site.

1 Application and Termination
1.1 By accessing this Site you agree to be bound by these terms and conditions and all other applicable laws. If you do not agree to be bound by these terms and conditions then please do not use this Site.
1.2 These terms and conditions:
1.2.1 Apply to you upon your accessing this Site.
1.2.2 May be changed or terminated by Viewlondon without notice, for any reason and at any time. You agree that Viewlondon has no obligation to inform you of these changes and that it is your responsibility to establish whether the terms and conditions have been so changed. If you disagree with any changes then you must stop using this Site immediately.

1.3 The provisions in these terms and conditions relating to disclaimer, copyright, trademark, limitation of liability, indemnity, hypertext links, severance and law and jurisdiction shall survive any termination.

2 Disclaimer
2.1 This Site and the materials, products and services in this Site are provided on an \"as is\" and \"as available\" basis.
2.2 To the full extent permitted at law Viewlondon makes no (and expressly disclaims all) representations or warranties, express or implied in respect of this Site or its contents or the contents, advice and opinions of any Hypertext Link or third party contributor to this Site, including, but not limited to, implied warranties as to quality, accuracy, adequacy, usefulness, timeliness, reliability, merchantability and fitness for a particular purpose and non infringement of the contents of this Site or any goods or services purchased or obtained or any transactions entered into by you through this Site.
2.3 Viewlondon does not represent or warrant that the material or any of the functions contained in this Site or the contents of any hypertext link or any comments, advice or opinions by any third party contributor to this Site will be uninterrupted, accurate, complete or that current defects will be corrected, or that this Site or the server that makes the Site available are free of viruses or other harmful components.

3 Copyright
3.1 You agree that all copyright, trademarks and other intellectual property rights in the material or content of this Site shall remain at all times vested in Viewlondon or its licensors.
3.2 You agree that the content of this Site is made available for you in your personal capacity and for your personal use only, and not for any commercial use. You agree that you may only download the content of this Site onto one computer hard drive, but not for commercial use, and that any other use of the content of the Site is strictly prohibited.
3.3 You agree that you will neither solely or jointly with or on behalf of any other third party directly or indirectly copy, reproduce, transmit, distribute, publish, display, commercially exploit or create derivative works of the content of this Site.
3.4 You agree that you will not change in any way any proprietary notices from material down loaded from this Site by you for your non commercial personal use.
3.5 You agree that by the act of posting materials onto this Site you grant Viewlondon and any licensors an irrevocable, perpetual, royalty free worldwide licence to use the said materials in any manner which Viewlondon sees fit. The licence will include broadcasting, editing, copying, distributing and otherwise transmitting the material.

4 Trademarks
The trade marks and logos and service marks used and displayed on this Site are, unless otherwise specified, the trademarks of Viewlondon. No rights are granted to use any of them without the written permission of Viewlondon.

5 Limitation of Liability
5.1 With the exception of death or personal injury resulting from the negligence of Viewlondon and to the fullest extent permitted by law you agree that Viewlondon shall not be liable in negligence, contract, tort, statutory duty or in any other way for any of the following:
5.1.1 Any loss or damage caused of whatever nature arising directly or indirectly from or in any way related with the Site, or
5.1.2 Your reliance or use of any information or material obtained either directly or indirectly from the use of this Site, or
5.1.3 Any purchases or orders that you make for goods and/or services either indirectly or directly through this Site, including any damage for loss of profits or loss of business without limitation, or
5.1.4 Any other consequential or pecuniary loss in any way related to the use of this Site.

5.2 Condition 5.1 shall apply even if Viewlondon have been advised of the possibility of such loss or damage.
5.3 You acknowledge that any dealings, bookings or purchases of goods or services made with a third party by you through this Site shall be subject to the terms and conditions of that third party and that Viewlondon will not be a party to or in any way responsible for or liable to you in respect of any transactions between you and that third party.
5.4 You agree that it is your sole responsibility to evaluate any goods or services offered by this Site or by any third parties via this Site.
5.5 Viewlondon is unable and therefore does not make any representations or warranties as to the security of information that you pass to any third parties as a result of using this Site either directly or indirectly.
5.6 You acknowledge that Viewlondon has no control over the information which can be accessed by this Site or which can be accessed by any other web site which you access as a result of using this Site.
5.7 You acknowledge that Viewlondon does not know or examine the use to which you or other users put this Site or the nature of the information you or other users are sending or uploading.
5.8 Viewlondon therefore excludes all liability of whatever kind and to the fullest extent permitted by law (this includes libel, breach of confidence, invasion of privacy, negligence and all intellectual property infringements) for the transmission or reception of information which can be accessed by this Site of whatever nature by about or to you.

6 Notice
6.1 Viewlondon may serve notice upon you by any of the following means:
6.1.1 Electronic mail
6.1.2 A general notice on the Site
6.1.3 Notice in writing delivered by first class mail to the address which you have provided for us.


7 Hypertext Links
7.1 Viewlondon may provide a link from its own Site to other web sites. Furthermore Viewlondon may direct electronic mails to persons chosen by you, however you agree that Viewlondon has no control over these Electronic mails or Hypertext Links (or any other third party link) and that you use these links or forwarding mechanisms entirely at your own risk.
7.2 You agree that Viewlondon has no responsibility or liability for the content or any policies of any Hypertext Links (or any other third party link) as mentioned in 7.1 above.

8 Use of the Site
If this Site contains bulletin boards, chat rooms, or other message or communication facilities (collectively \"Forums\"), you agree to use the Forums only to send and receive messages and material that are proper and related to the particular Forum. By way of example, and not as a limitation, you agree that when using a Forum, you shall not do any of the following:
8.1 Defame, abuse, harass, stalk, threaten, or otherwise violate the legal rights (such as rights of privacy and publicity) of others.
8.2 Publish, post, distribute, or disseminate any defamatory, infringing, obscene, indecent, or unlawful material or information.
8.3 Upload files that contain software or other material protected by intellectual property laws (or by rights of privacy of publicity) unless you own or control the rights there to or have received all necessary consents.
8.4 Upload files that contain viruses, corrupted files, or any other similar software or programs that may damage the operation of another\'s computer.
8.5 Delete any author attributions, legal notices, or proprietary designations or labels in any file that is uploaded.
8.6 Falsify the origin or source of software or other material contained in a file that is uploaded.
8.7 Advertise or offer to sell any goods or services or conduct or forward surveys, contests, or chain letters.
8.8 Download any file posted by another user of a Forum that you know, or reasonably should know, cannot be legally distributed in such manner. You acknowledge that all Forums are public and not private communications. Further, you acknowledge that chats, postings, conferences, and other communications by other users are not endorsed by Viewlondon, and such communications shall not be considered reviewed, screened, or approved by Viewlondon. Viewlondon reserves the right for any reason to remove without notice any contents of the Forums received from users, including without limitation bulletin board postings. Viewlondon reserves the right to deny in its sole discretion any user access to this Site or any portion thereof without notice.

9 Indemnity
You agree to keep Viewlondon indemnified against all actions, claims, costs, expenses (including all legal costs) and damages brought against or suffered by Viewlondon arising out of any breach of these terms and conditions or any activity relating to your use of the Site (including negligent or wrongful conduct) by you or any other person accessing the Site using your name or any other name with which you have registered under this Site.

10 Persons under the age of 18
10.1 If you are under 18 years of age you agree that you have had your parents permission to send any information to us about yourself or anyone else over the internet.
10.2 Viewlondon make no representations or warranties to the effect that the contents of this Site are suitable for people under the age of 18.

11 Severance
If any of these terms and conditions shall in whole or in part be held to any extent to be illegal or unenforceable under any enactment or rule of law such provision shall to the extent required be severed from the terms and conditions and rendered ineffective as far as possible without modifying the remaining provisions of this agreement and shall not in any way affect any other circumstances or the validity or enforcement of these terms and conditions.

12 Law and Jurisdiction
These terms and conditions shall be governed by and construed in all respects in accordance with English law and the parties irrevocably agree that the courts of England and Wales shall have exclusive jurisdiction in respect of any dispute, suit, action, arbitration or proceedings which may arise out of or in connection with these terms and conditions provided that Viewlondon has the right at it\'s sole discretion to commence and pursue proceedings in any other jurisdiction or jurisdictions whether concurrently or not.

','(No Image)','','','0',NULL,'','left',NULL,'left','1','(No Table)','no_link','Copy of SML.gif','157','www.','0','');#%% INSERT INTO hits_main VALUES ('58','sidepage','1','asdkjh kasd kjsad kjhsakdjh askdh asd hidsaiujhdsaiu wiujhks dwsaiujkjhdwa kjhewakjcsfdmjn fdsiu dkjh dikudkjhsddskj','(No Image)','','','0',NULL,'heading','left',NULL,'left','1','(No Table)','link_map','(No Image)','197','www.','0','');#%% INSERT INTO hits_main VALUES ('85','sidepage','2','sdfsd fsdf sdf sdf sdf sdf sdf sdf sdf sdfsd sKIDHFKJSH D Ksfdh ksfd','(No Image)','',NULL,'0',NULL,'another heading','left',NULL,'left','1','(No Table)','no_link','088026a.jpg','113','www.','0','');#%% INSERT INTO hits_main VALUES ('159','about','1','this is a test page','(No Image)','','','0',NULL,'','right',NULL,'left','1','(No Table)','no_link','BLOKE.GIF','197','www.','0','');#%% INSERT INTO hits_main VALUES ('157','home','1','Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur.','xd-dv170.jpg','','','0',NULL,'','right',NULL,'left','1','(No Table)','no_link','xd-dv170.jpg','197','www.','0','');#%% INSERT INTO hits_main VALUES ('158','home','2','Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur.','(No Image)','','','0',NULL,'testheading','right',NULL,'','1','(No Table)','no_link','0d_3.jpg','197','www.','0','');#%% INSERT INTO hits_main VALUES ('160','cookies','1','

Our shopping and membership systems require you to have cookies enabled on your browser.

What is a cookie?
Cookies are harmless pieces of information stored on your computer. They may contain information such as the username you use when visiting a particular site, or keep track of the number of times you have visited a site. Cookies can only be read by you, or the web site that created the cookie in the first place.

Why do you use cookies?
We use cookies to store a unique identity code for your basket . This allows us to securely keep track of the items in your basket, so that you can easily recommence your order if anything goes wrong half way through the shopping process. It also enables you to store items in your basket from different merchants who use the same shopping system. We also use cookies to enable us to provide a members only area. Cookies enable you to stay logged in whilst you browse the members-only areas.

This hasn\'t been a problem with other sites...
Most websites don\'t use cookies as they are \'static\', ie they just display information. Most \'dynamic\' sites where the information changes according to the choices you make on the website use cookies to store information about you. Nearly all shopping sites and other highly functional websites use cookies. The exceptions are those sites (e.g. eBay, online banks and some very large shopping sites) where membership is usually required before you can purchase. With these sites the information normally stored in a cookie is stored against the customer\'s account on the webserver instead... and this is arguably a greater privacy issue than cookies!

Are cookies a security risk?
No, they are not. Some people believe that they are, however, this is a common misconception, propagated largely by an ill-informed press. In reality, the worst security risk you are likely to face from cookies is that a website owner will be able to \'tag\' your browser when you enter their site and find out how often you visit and, perhaps, what pages you like to look at. You may see this as an invasion of your privacy, but it is hardly a security risk. That website owner still cannot access any information about you, except what you knowingly give them by filling in forms. What\'s more, cookies can generally only be accessed by the web server that set them. So, you still have control over what information you give out, and to whom.

I\'ve been told that cookies are spyware. Is this true?
No. Cookies are NOT spyware. Cookies are information sent by the server to the browser to be stored in a text file on the user\'s hard drive. Cookies can not: be viruses; steal credit card information; steal banking information; or see what software you have on your computer. A cookie is just a file with textual information set by the server. As explained above, the most a cookie can do is to pass information between pages within a single website/domain. Some companies use this to provide targeted adverts and/or popups.

The main reason some people object to cookies being used is that they provide an indication (to people who have direct access to your PC) to which websites you have visited, but then again, so do the temporary Internet files that your browser generates. If you have been browsing websites that you don\'t potentially want others to know about, simply delete the temporary files and cookies once you have finished (under tools, internet options).

Do cookies take up space on my hard-drive?
Yes, but it\'s only a tiny amount and your browser will limit the size of your cookies folder automatically. Also, bear in mind that every webpage you visit is stored temporarily in your browser\'s cache directory and, depending on your system settings, this can occupy several MegaBytes. Cookies, however, usually won\'t occupy more than, say 100 Bytes. As a rough guide, that\'s about 1/400 th of the size of an average webpage and 1/50,000 th of the size of an average cache directory.

What should I do to enable cookies?
To use the shopping system on our site, you must ensure that your computer will accept cookies. Most internet browsers (for example Microsoft Internet Explorer) will allow you selectively allow and disallow cookies. If you use Internet Explorer, then you can enable cookies by:
1: Go to the \'Tools\' menu
2: Click on \'Internet Options\'
3: Click \'Privacy\'
4: Move the slider to a lower setting.

I\'ve updated my settings, but it\'s still not working...
If you have enabled cookies, and you still cannot use our shopping system, then please do one of the following:
1: Ensure that your firewall, anti-spyware and other security software are not blocking all cookies.
2: Try updating/reinstalling Internet Explorer or installing another browser such as Mozilla Firefox.
3: Try using a different computer - another computer may be setup differently and will allow you to use the shopping basket.

','(No Image)','','','0',NULL,'','right',NULL,'left','1','(No Table)','no_link','xd-dv170.jpg','197','www.','0','');#%% INSERT INTO hits_main VALUES ('161','privacypolicy','1','

The following statement explains our policy regarding the personal information we collect about you.

  1. Statement of intent
  2. Information on visitors
  3. What is a cookie?
  4. Submitting personal information
  5. Access to your personal information
  6. Users 16 and under
  7. How to find and control your cookies
  8. How do you know which sites use cookies?
  9. How to see your cookie code
','(No Image)','','','0',NULL,'','right',NULL,'left','1','(No Table)','no_link','xd-dv170.jpg','197','www.','0','');#%% INSERT INTO hits_main VALUES ('162','privacypolicy','2','

From time to time, you may be asked to submit personal information about yourself (e.g. name and email address etc) in order to receive or use services on our website. Such services include newsletters, competitions, \"Alert Email\", live chats, message boards and membership (e.g. for support services).

By entering your details in the fields requested, you enable [b] to provide you with the services you select. Whenever you provide such personal information, we will treat that information in accordance with this policy. Our services are designed to give you the information that you want to receive. [b] will act in accordance with current legislation and aim to meet current Internet best practice.

[Top]

','(No Image)','','','0',NULL,'1. Statement of Intent','right',NULL,'left','1','(No Table)','no_link','xd-dv170.jpg','197','www.','0','');#%% INSERT INTO hits_main VALUES ('163','privacypolicy','3','

During the course of any visit to [w], the pages you see, along with something called a cookie, are downloaded to your computer (see point 3 for more on this). Most, if not all, websites do this, because cookies allow the website publisher to do useful things like find out whether the computer (and probably its user) has visited the site before. This is done on a repeat visit by checking to see, and finding, the cookie left there on the last visit.

Any information that is supplied by cookies can help us to provide you with a better service and assists us to analyse the profile of our visitors. For example: if on a previous visit you went to, say, the Search Engine pages, then we might find this out from your cookie and highlight Search Engine information on a second visit. We also use cookies to provide functions such as Shopping Carts and the information held in the shopping cart is held in a cookie on your PC.

We do not gather or use personal information from our website other than to use for despatching goods and invoices or for making contact with you as the result of an enquiry or support request. We do not pass on any personal information to other companies unless we are specifically instructed to do so by you.

We do not use cookies or spyware to gather information for use in marketing or any other activity from that stated above.

[Top]

','(No Image)','','','0',NULL,'2. Information on Visitors','right',NULL,'left','1','(No Table)','no_link','xd-dv170.jpg','197','www.','0','');#%% INSERT INTO hits_main VALUES ('164','privacypolicy','4','

When you enter a site your computer will automatically be issued with a cookie. Cookies are text files that identify your computer to our server. Cookies in themselves do not identify the individual user, just the computer used. Many sites do this whenever a user visits their site in order to track traffic flows.

Cookies themselves only record those areas of the site that have been visited by the computer in question, and for how long. Users have the opportunity to set their computers to accept all cookies, to notify them when a cookie is issued, or not to receive cookies at any time. The last of these, of course, means that certain personalised services cannot then be provided to that user.

NB: Even if you haven\'t set your computer to reject cookies you can still browse our site anonymously until such time as you attempt to purchase products or register for services.

[Top]

','(No Image)','','','0',NULL,'3. What is a Cookie? ','right',NULL,'left','1','(No Table)','no_link','xd-dv170.jpg','197','www.','0','');#%% INSERT INTO hits_main VALUES ('165','privacypolicy','5','


When you supply any personal information to [b] (e.g. for purchase, services or support membership) we have legal obligations towards you in the way we deal with that data. We must collect the information fairly, that is, we must explain how we will use it (see the notices on particular webpages that let you know why we are requesting the information) and tell you if we want to pass the information on to anyone else. In general, any information you provide to us will only be used within [b] and by its service providers. It will never be supplied to anyone outside [b] without first obtaining your consent, unless we are obliged or permitted by law to disclose it. Also, if you post or send offensive or inappropriate content anywhere on or to [w] or otherwise engage in any disruptive behaviour on our website, and we consider such behaviour to be serious and/or repeated, we can use whatever information that is available to us about you to stop such behaviour. This may include informing relevant third parties such as your employer, school or e-mail provider about the content and your behaviour.

We will hold your personal information on our systems for as long as you use the service you have requested, and remove it in the event that the purpose has been met, or, in the case of support membership you no longer wish to continue your registration as a member. For safety reasons, however, [b] may store messaging transcript data (including message content, member names, times and dates) arising from the use of services such as our forum for a period of six months. Where personal information is held for people who are not yet registered but have taken part in other services (e.g. competitions), that information will be held only as long as necessary to ensure that the service is run smoothly. We will ensure that all personal information supplied is held securely, in accordance with the Data Protection Act 1998.

If you are notified on a [b] site that your information may be used to allow us to contact you for \"service administration purposes\", this means that we may contact you for a number of purposes related to the service you have signed up for. For example, we may wish to provide you with password reminders or notify you that the particular service has been suspended for maintenance. We will not contact you for promotional purposes, such as notifying you of improvements to the service or new services on our website unless you specifically agree to be contacted for such purposes at the time you submit your information on the site, or at a later time if you sign up specifically to receive such promotional information.

[Top]

','(No Image)','','','0',NULL,'4. Use and storage of your personal information','right',NULL,'left','1','(No Table)','no_link','xd-dv170.jpg','197','www.','0','');#%% INSERT INTO hits_main VALUES ('166','privacypolicy','6','


You have the right to request a copy of the personal information [b] about you and to have any inaccuracies corrected. (We charge 10 for information requests.) Please address requests to:

Data Protection
[b]
[a]

[Top]

','(No Image)','','','0',NULL,'5. Access to your personal information','right',NULL,'left','1','(No Table)','no_link','xd-dv170.jpg','197','www.','0','');#%% INSERT INTO hits_main VALUES ('167','privacypolicy','7','

If you are aged 16 or under, please get your parent/guardian\'s permission beforehand whenever you provide personal information to any of our websites. Users without this consent are not allowed to provide us with personal information.

[Top]

','(No Image)','','','0',NULL,'6. Users 16 and under','right',NULL,'left','1','(No Table)','no_link','xd-dv170.jpg','197','www.','0','');#%% INSERT INTO hits_main VALUES ('168','privacypolicy','8','

If you\'re using Netscape 6.0
On your Task Bar, click:
Edit, then
Preferences
Click on Advanced
Click on Cookies

If you\'re using Internet Explorer 6.0
Choose Tools, then
Internet Options
Click the Privacy Tab
Click on Custom Level
Click on the \'Advanced\' button
Check the \'override automatic cookie handing\' box and select Accept, Block or Prompt for action as appropriate.

If you\'re using Internet Explorer 5.0 or 5.5
Choose Tools, then
Internet Options
Click the Security tab
Click on Custom Level
Scroll down to the sixth option to see how cookies are handled by IE5 and change to Accept, Disable, or Prompt for action as appropriate.

If you\'re using Internet Explorer 4.0
Choose View, then
Internet Options
Click the Advanced tab
Scroll down to the yellow exclamation icon under Security and choose one of the three options to regulate your use of cookies.

In Internet Explorer 3.0
You can View, Options, Advanced, then click on the button that says Warn before Accepting Cookies.

If you\'re using Netscape Communicator 4.0
On your Task Bar, click:
Edit, then
Preferences
Click on Advanced
Set your options in the box that says Cookies.

[Top]

','(No Image)','','','0',NULL,'7. How to find and control your cookies','right',NULL,'left','1','(No Table)','no_link','xd-dv170.jpg','197','www.','0','');#%% INSERT INTO hits_main VALUES ('169','privacypolicy','9','

If you\'re using Netscape 6.0
On your Task Bar, click:
Edit, then
Preferences
Click on Advanced
Click on Cookies
Click the View Cookies button

If you\'re using Internet Explorer 5.0 or 6.0
Choose Tools, then
Internet Options
Click the General tab
Click Settings
View Files

If you\'re using Internet Explorer 4.0
On your Task Bar, click:
View, then
Internet Options
Under the tab General (the default tab) click
Settings
View Files.

Internet Explorer 3.0
On your Task Bar, click:
View
Options
Advanced
View Files.

Netscape Communicator 4.0
Netscape bundles all cookies into one file on your hard drive. You\'ll need to find the file, which it calls Cookie.txt on Windows machines.

[Top]

','(No Image)','','','0',NULL,'8. How do you know which of the sites you\'ve visited use cookies?','right',NULL,'left','1','(No Table)','no_link','xd-dv170.jpg','197','www.','0','');#%% INSERT INTO hits_main VALUES ('170','privacypolicy','10','


Just click on a cookie to open it. You\'ll see a short string of text and numbers. The numbers are your identification card, which can only be seen by the server that gave you the cookie.

[b] 2002-[y]
[a]

[Top]

','(No Image)','','','0',NULL,'9. How do you see your cookie code?','right',NULL,'left','1','(No Table)','no_link','xd-dv170.jpg','197','www.','0','');#%% # ---------------------------------------------------------- # # structur for table 'hits_menu_items' # DROP TABLE IF EXISTS hits_menu_items;#%% CREATE TABLE hits_menu_items ( menu_id int(11) NOT NULL auto_increment, menu_hv enum('h','v') DEFAULT 'v' NOT NULL, position int(10) DEFAULT '0' NOT NULL, parent_id int(10) DEFAULT '0' NOT NULL, label varchar(255), link_page varchar(255) NOT NULL, link_cat varchar(15) NOT NULL, link_url longtext, new_window_bool enum('1','0') DEFAULT '0' NOT NULL, PRIMARY KEY (menu_id) );#%% # # data for table 'hits_menu_items' # INSERT INTO hits_menu_items VALUES ('145','v','1','0','Home','home','','','0');#%% INSERT INTO hits_menu_items VALUES ('148','v','4','0','Parts & Accessories','(No Link)','','','0');#%% INSERT INTO hits_menu_items VALUES ('146','v','2','0','About Us','about','','','0');#%% INSERT INTO hits_menu_items VALUES ('147','v','3','0','Vehicle Range','(No Link)','','','0');#%% INSERT INTO hits_menu_items VALUES ('150','v','5','0','News','news','','','0');#%% INSERT INTO hits_menu_items VALUES ('158','v','7','0','Contact Us','contact','','','0');#%% INSERT INTO hits_menu_items VALUES ('152','v','6','0','Gallery','gallery','','','0');#%% INSERT INTO hits_menu_items VALUES ('155','h','1','0','Terms & Conditions','termsconditions','','','0');#%% INSERT INTO hits_menu_items VALUES ('153','h','2','0','Privacy Policy','(No Link)','','','0');#%% # ---------------------------------------------------------- # # structur for table 'hits_news' # DROP TABLE IF EXISTS hits_news;#%% CREATE TABLE hits_news ( id int(10) unsigned NOT NULL auto_increment, content text, image text, heading text, imagealign varchar(10), textalign varchar(10), date varchar(50), issue_id int(11) DEFAULT '0' NOT NULL, order_by int(11) DEFAULT '1' NOT NULL, enabled int(1) DEFAULT '1' NOT NULL, extended int(1) DEFAULT '0' NOT NULL, extended_link_text varchar(255) DEFAULT 'More...', reply_form int(1) DEFAULT '0' NOT NULL, multimap int(1) DEFAULT '0' NOT NULL, multimap_postcode varchar(10), PRIMARY KEY (id) );#%% # # data for table 'hits_news' # INSERT INTO hits_news VALUES ('7','sdfsdfsdf lorem test lorem test','(No Image)','testy testyy','left','left','September 30, 2005','0','999999999','1','1','More...','1','0','');#%% # ---------------------------------------------------------- # # structur for table 'hits_news_articles' # DROP TABLE IF EXISTS hits_news_articles;#%% CREATE TABLE hits_news_articles ( news_article_id int(11) NOT NULL auto_increment, news_cat_id int(11) DEFAULT '0' NOT NULL, content longtext NOT NULL, image varchar(255) NOT NULL, text_align varchar(6) DEFAULT 'left' NOT NULL, image_align varchar(6) DEFAULT 'left' NOT NULL, timestamp int(11) DEFAULT '0' NOT NULL, subheading varchar(255) NOT NULL, position int(11) DEFAULT '0' NOT NULL, enabled_bool int(1) DEFAULT '1' NOT NULL, extended_bool int(1) DEFAULT '0' NOT NULL, extended_link_text varchar(255) NOT NULL, PRIMARY KEY (news_article_id) );#%% # # data for table 'hits_news_articles' # # ---------------------------------------------------------- # # structur for table 'hits_news_categories' # DROP TABLE IF EXISTS hits_news_categories;#%% CREATE TABLE hits_news_categories ( news_cat_id int(11) NOT NULL auto_increment, news_parent_id varchar(11) DEFAULT '1' NOT NULL, description longtext NOT NULL, sort varchar(11) NOT NULL, position int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (news_cat_id) );#%% # # data for table 'hits_news_categories' # INSERT INTO hits_news_categories VALUES ('27','1','Local News','','1');#%% INSERT INTO hits_news_categories VALUES ('28','1','International News','','2');#%% INSERT INTO hits_news_categories VALUES ('30','27','New Category','','1');#%% INSERT INTO hits_news_categories VALUES ('1','0','News','ascending','0');#%% # ---------------------------------------------------------- # # structur for table 'hits_notices' # DROP TABLE IF EXISTS hits_notices;#%% CREATE TABLE hits_notices ( notice_id int(10) NOT NULL auto_increment, notice_type varchar(100) NOT NULL, notice_description varchar(100) NOT NULL, notice_content longtext NOT NULL, PRIMARY KEY (notice_id) );#%% # # data for table 'hits_notices' # INSERT INTO hits_notices VALUES ('1','signup_intro','Introduction to user signup form','Please use the form below to open a new account:');#%% INSERT INTO hits_notices VALUES ('2','error_1','Login details incorrect','You have entered an invalid username or password. Please check your details and try again.');#%% INSERT INTO hits_notices VALUES ('3','error_2','Upload is incorrect file type','The uploaded file is not a permitted file type. File was not uploaded.');#%% INSERT INTO hits_notices VALUES ('4','error_3','Problem creating directory when uploading file','An error occurred whilst creating the upload directory (possibly a permissions problem).');#%% INSERT INTO hits_notices VALUES ('5','error_4','Problem copying upload file from temp directory','An error occurred whilst trying to copy the uploaded file (possibly a permissions problem).');#%% INSERT INTO hits_notices VALUES ('6','error_5','No shipping scheme selected','No shipping scheme was selected - please choose choose from the drop-down selection before proceeding.');#%% INSERT INTO hits_notices VALUES ('7','mailing_subscribe','Feedback when adding email address to mailing list','Thank you - your e-mail address has been added to our mailing list.');#%% INSERT INTO hits_notices VALUES ('8','mailing_unsubscribe','Feedback when removing email address from mailing list','Thank you. Your e-mail address has been removed from our mailing list.');#%% INSERT INTO hits_notices VALUES ('9','error_6','When using forgotten password feature, and email entered is not recognised','The email address you entered is not currently associated with a user account. Please try again, or contact us for assistance.

');#%% INSERT INTO hits_notices VALUES ('10','password_reset','When using forgotten password feature, and password is successfully reset.','Your password has been reset. Please check the email address you supplied for your new login details.');#%% # ---------------------------------------------------------- # # structur for table 'hits_sections' # DROP TABLE IF EXISTS hits_sections;#%% CREATE TABLE hits_sections ( type varchar(50), enabled int(1) DEFAULT '1' NOT NULL, order_by int(11), description varchar(100), id int(10) unsigned NOT NULL auto_increment, subpage varchar(5) DEFAULT '0' NOT NULL, meta_keywords longtext, meta_description longtext, meta_title longtext, gateway int(1) DEFAULT '0', PRIMARY KEY (id) );#%% # # data for table 'hits_sections' # INSERT INTO hits_sections VALUES ('termsconditions','1','17','Terms & Conditions','66','1','','','','0');#%% INSERT INTO hits_sections VALUES ('sidepage','1','20','Side Page','204','1',NULL,NULL,NULL,'0');#%% INSERT INTO hits_sections VALUES ('contact','1','8','Contact Us','203','0','','','','0');#%% INSERT INTO hits_sections VALUES ('news','1','8','News','212','0',NULL,NULL,NULL,'0');#%% INSERT INTO hits_sections VALUES ('gallery','1','7','Gallery','211','0',NULL,NULL,NULL,'0');#%% INSERT INTO hits_sections VALUES ('about','1','2','About Us','197','0','','','','0');#%% INSERT INTO hits_sections VALUES ('home','1','1','Home','196','0','ddd','','','0');#%% INSERT INTO hits_sections VALUES ('news_7','1',NULL,'testy test','226','news',NULL,NULL,NULL,'0');#%% INSERT INTO hits_sections VALUES ('cookies','1','21','Cookies','227','1',NULL,NULL,NULL,'0');#%% INSERT INTO hits_sections VALUES ('privacypolicy','1','22','Privacy Policy','228','1',NULL,NULL,NULL,'0');#%% # ---------------------------------------------------------- # # structur for table 'hits_shipping_schemes' # DROP TABLE IF EXISTS hits_shipping_schemes;#%% CREATE TABLE hits_shipping_schemes ( id int(11) NOT NULL auto_increment, shipping_title varchar(100), shipping_available varchar(15) DEFAULT 'variable' NOT NULL, shipping_limit varchar(10), shipping_price_limit float(7,2) DEFAULT '0.00' NOT NULL, shipping_method varchar(8) DEFAULT 'weight' NOT NULL, shipping_add varchar(8) DEFAULT 'fixed' NOT NULL, shipping_range1 varchar(10), shipping_range2_lower varchar(10), shipping_range2_upper varchar(10), shipping_range3_lower varchar(10), shipping_range3_upper varchar(10), shipping_range4_lower varchar(10), shipping_range4_upper varchar(10), shipping_range5_lower varchar(10), shipping_range5_upper varchar(10), shipping_range6_lower varchar(10), shipping_range6_upper varchar(10), shipping_range7_lower varchar(10), shipping_range7_upper varchar(10), shipping_range8_lower varchar(10), shipping_range8_upper varchar(10), shipping_range9_lower varchar(10), shipping_range9_upper varchar(10), shipping_range10_lower varchar(10), shipping_range10_upper varchar(10), shipping_range11_lower varchar(10), shipping_range11_upper varchar(10), shipping_range12_lower varchar(10), shipping_range12_upper varchar(10), shipping_range13_lower varchar(10), shipping_range13_upper varchar(10), shipping_range14_lower varchar(10), shipping_range14_upper varchar(10), shipping_range15_lower varchar(10), shipping_range15_upper varchar(10), shipping_range16_lower varchar(10), shipping_range16_upper varchar(10), shipping_range17_lower varchar(10), shipping_range17_upper varchar(10), shipping_range18_lower varchar(10), shipping_range18_upper varchar(10), shipping_range19_lower varchar(10), shipping_range19_upper varchar(10), shipping_range20_lower varchar(10), shipping_range20_upper varchar(10), shipping_range5 varchar(10), shipping_add1 varchar(10), shipping_add2 varchar(10), shipping_add3 varchar(10), shipping_add4 varchar(10), shipping_add5 varchar(10), shipping_add6 varchar(10), shipping_add7 varchar(10), shipping_add8 varchar(10), shipping_add9 varchar(10), shipping_add10 varchar(10), shipping_add11 varchar(10), shipping_add12 varchar(10), shipping_add13 varchar(10), shipping_add14 varchar(10), shipping_add15 varchar(10), shipping_add16 varchar(10), shipping_add17 varchar(10), shipping_add18 varchar(10), shipping_add19 varchar(10), shipping_add20 varchar(10), taxable int(1) DEFAULT '0' NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_shipping_schemes' # INSERT INTO hits_shipping_schemes VALUES ('1','Standard Postage','price_not','100','20.00','price','fixed','20','20','50','50','100','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','0','2.50','5.00','10.00','','','','','','','','','','','','','','','','','','1');#%% INSERT INTO hits_shipping_schemes VALUES ('2','Express delivery','1','','0.00','weight','percent','10','10','20','20','30','','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','10','8','5','','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0');#%% INSERT INTO hits_shipping_schemes VALUES ('3','Next-day delivery','1','','0.00','weight','fixed','10','10','20','20','30','30','40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','100','80','50','20','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0');#%% INSERT INTO hits_shipping_schemes VALUES ('8','New scheme','variable',NULL,'0.00','weight','fixed',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0');#%% # ---------------------------------------------------------- # # structur for table 'hits_shopping' # DROP TABLE IF EXISTS hits_shopping;#%% CREATE TABLE hits_shopping ( id int(11) NOT NULL auto_increment, enabled_ordering enum('1','0') DEFAULT '1' NOT NULL, require_signup enum('1','0') DEFAULT '0' NOT NULL, enabled_bookings enum('1','0') DEFAULT '0' NOT NULL, allow_regular_orders enum('1','0') DEFAULT '0' NOT NULL, allow_payment_choice enum('1','0') DEFAULT '0' NOT NULL, last_processed_regular_orders_time int(11), header_text longtext, header_title longtext, header_image varchar(255), header_align varchar(255), footer_text longtext, footer_title longtext, footer_image varchar(255), footer_align varchar(255), field1 varchar(255), field2 varchar(255), field3 varchar(255), field4 varchar(255), field5 varchar(255), field6 varchar(255), field7 varchar(255), field8 varchar(255), header_image_align varchar(255) DEFAULT 'left', footer_image_align varchar(255) DEFAULT 'left', paypal varchar(75), shipping varchar(12) DEFAULT 'noshipping' NOT NULL, tax enum('1','0') DEFAULT '0' NOT NULL, tax_rate varchar(6) DEFAULT '17.5' NOT NULL, show_tax enum('1','0') DEFAULT '0' NOT NULL, vat_reg_no varchar(50), shipping_fixed_amount varchar(8), allow_local_free_delivery enum('1','0') DEFAULT '0' NOT NULL, order_method varchar(15) DEFAULT 'provider' NOT NULL, sort_cat varchar(8) DEFAULT 'manual' NOT NULL, no_products_per_page int(5) DEFAULT '0' NOT NULL, sort varchar(8) DEFAULT 'manual' NOT NULL, payment_provider varchar(20) DEFAULT 'paypal', epdq_uid varchar(50), epdq_pw varchar(100), worldpay_uid varchar(150), worldpay_futurepay_id varchar(100), worldpay_futurepay_pw varchar(100), protx_uid varchar(25) DEFAULT 'testvendor', protx_vpsprotocol varchar(6) DEFAULT '2.21', protx_txtype varchar(12) DEFAULT 'PAYMENT', protx_pw varchar(50) DEFAULT 'testvendor', hits_uid varchar(30) DEFAULT '1', hits_pw varchar(50) DEFAULT '11579553', protx_currencycode char(3) DEFAULT 'GBP', allow_international enum('1','0') DEFAULT '0' NOT NULL, enable_vouchers enum('1','0') DEFAULT '0' NOT NULL, sellers_enabled enum('1','0') DEFAULT '0' NOT NULL, rate_gbp varchar(6) DEFAULT '1' NOT NULL, rate_usd varchar(6) DEFAULT '0.57' NOT NULL, rate_eur varchar(6) DEFAULT '0.66' NOT NULL, display varchar(10) DEFAULT 'normal' NOT NULL, opt_in int(1) DEFAULT '0' NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_shopping' # INSERT INTO hits_shopping VALUES ('1','1','1','0','1','0','1133363190','Welcome to our online store! If you cannot find what you are looking for or need assistance in purchasing any of our products please contact us on [t] or e-mail us at [e]. We will endeavour to respond to all email enquiries within 24 hours. ','','(No Image)','left','If you have any questions about any of our products, please call our sales team on [t].','','(No Image)','left','Price','RRP','Dimensions','Features','','','','','left','left','ian@lank.co.uk','calculate','0','17.5','0','123456789','1','0','provider','manual','0','ascend','protx','hitchman','','111809','112457','oimgfogm596y53','testvendor','2.21','PAYMENT','testvendor','1','11579553','GBP','1','1','1','','0.53','0.64','normal','1');#%% # ---------------------------------------------------------- # # structur for table 'hits_shopping_booking_orders' # DROP TABLE IF EXISTS hits_shopping_booking_orders;#%% CREATE TABLE hits_shopping_booking_orders ( id int(11) NOT NULL auto_increment, first_name varchar(255) NOT NULL, surname varchar(255) NOT NULL, telephone_day varchar(50) NOT NULL, telephone_evening varchar(50) NOT NULL, email varchar(120) NOT NULL, preferred_contact varchar(20) NOT NULL, checkoid int(10) DEFAULT '0' NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_shopping_booking_orders' # # ---------------------------------------------------------- # # structur for table 'hits_shopping_bookings' # DROP TABLE IF EXISTS hits_shopping_bookings;#%% CREATE TABLE hits_shopping_bookings ( id int(11) NOT NULL auto_increment, pid int(11) DEFAULT '0' NOT NULL, sid varchar(255) NOT NULL, booking_id int(10) DEFAULT '0' NOT NULL, lower int(11) DEFAULT '0' NOT NULL, upper int(11) DEFAULT '0' NOT NULL, status varchar(15) DEFAULT 'unavailable' NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_shopping_bookings' # INSERT INTO hits_shopping_bookings VALUES ('174','1','','0','1122159600','0','unavailable');#%% INSERT INTO hits_shopping_bookings VALUES ('175','1','','0','1122246000','0','unavailable');#%% INSERT INTO hits_shopping_bookings VALUES ('176','1','','0','1122332400','0','unavailable');#%% INSERT INTO hits_shopping_bookings VALUES ('177','1','','0','1122418800','0','unavailable');#%% INSERT INTO hits_shopping_bookings VALUES ('178','1','','0','1122505200','0','unavailable');#%% INSERT INTO hits_shopping_bookings VALUES ('179','1','','0','1122591600','0','unavailable');#%% INSERT INTO hits_shopping_bookings VALUES ('180','1','','0','1122678000','0','unavailable');#%% # ---------------------------------------------------------- # # structur for table 'hits_shopping_categories' # DROP TABLE IF EXISTS hits_shopping_categories;#%% CREATE TABLE hits_shopping_categories ( id int(10) NOT NULL auto_increment, parent_id int(10) DEFAULT '0' NOT NULL, description varchar(255) DEFAULT 'Main (Root)' NOT NULL, order_by int(10) DEFAULT '0' NOT NULL, catheader longtext, image varchar(255) DEFAULT '(No Image)' NOT NULL, image_border enum('1','0') DEFAULT '0' NOT NULL, enabled enum('1','0') DEFAULT '1', meta_description longtext, meta_keywords longtext, meta_title longtext, advanced_search_serialized longtext, PRIMARY KEY (id) );#%% # # data for table 'hits_shopping_categories' # INSERT INTO hits_shopping_categories VALUES ('1','0','Main Categories','1','','(No Image)','0','1','','','','');#%% # ---------------------------------------------------------- # # structur for table 'hits_shopping_discounts' # DROP TABLE IF EXISTS hits_shopping_discounts;#%% CREATE TABLE hits_shopping_discounts ( id int(11) NOT NULL auto_increment, code varchar(50) DEFAULT '1' NOT NULL, condition varchar(10) DEFAULT 'qty' NOT NULL, condition_qty int(10) DEFAULT '3' NOT NULL, condition_amount float(7,2) DEFAULT '10.00' NOT NULL, action varchar(10) DEFAULT 'reduction' NOT NULL, action_reduction varchar(10) DEFAULT '25' NOT NULL, action_method varchar(10) DEFAULT 'percentage' NOT NULL, action_free int(5) DEFAULT '1' NOT NULL, free_gift_id int(10), PRIMARY KEY (id) );#%% # # data for table 'hits_shopping_discounts' # INSERT INTO hits_shopping_discounts VALUES ('40','2','qty','2','10.00','reduction','25','percentage','1',NULL);#%% # ---------------------------------------------------------- # # structur for table 'hits_shopping_dropdown_items' # DROP TABLE IF EXISTS hits_shopping_dropdown_items;#%% CREATE TABLE hits_shopping_dropdown_items ( id int(10) NOT NULL auto_increment, product_id int(10), dd_id int(10), content varchar(255), PRIMARY KEY (id) );#%% # # data for table 'hits_shopping_dropdown_items' # # ---------------------------------------------------------- # # structur for table 'hits_shopping_dropdown_on' # DROP TABLE IF EXISTS hits_shopping_dropdown_on;#%% CREATE TABLE hits_shopping_dropdown_on ( id int(10) NOT NULL auto_increment, product_id int(10), dd_id int(10), PRIMARY KEY (id) );#%% # # data for table 'hits_shopping_dropdown_on' # # ---------------------------------------------------------- # # structur for table 'hits_shopping_dropdowns' # DROP TABLE IF EXISTS hits_shopping_dropdowns;#%% CREATE TABLE hits_shopping_dropdowns ( id int(10) NOT NULL auto_increment, title varchar(200), PRIMARY KEY (id) );#%% # # data for table 'hits_shopping_dropdowns' # # ---------------------------------------------------------- # # structur for table 'hits_shopping_features' # DROP TABLE IF EXISTS hits_shopping_features;#%% CREATE TABLE hits_shopping_features ( id int(10) NOT NULL auto_increment, pid int(10) DEFAULT '0' NOT NULL, fid int(10) DEFAULT '0' NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_shopping_features' # # ---------------------------------------------------------- # # structur for table 'hits_shopping_features_list' # DROP TABLE IF EXISTS hits_shopping_features_list;#%% CREATE TABLE hits_shopping_features_list ( id int(10) NOT NULL auto_increment, description varchar(255) NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_shopping_features_list' # INSERT INTO hits_shopping_features_list VALUES ('19','sdfgh');#%% # ---------------------------------------------------------- # # structur for table 'hits_shopping_orders' # DROP TABLE IF EXISTS hits_shopping_orders;#%% CREATE TABLE hits_shopping_orders ( oid int(11) NOT NULL auto_increment, checkoid int(6) DEFAULT '123456' NOT NULL, regular_id int(11) DEFAULT '0' NOT NULL, shipping float(6,2) DEFAULT '0.00' NOT NULL, vat float(6,2) DEFAULT '0.00' NOT NULL, total float(6,2) DEFAULT '0.00' NOT NULL, shipping_method_id int(10) DEFAULT '0' NOT NULL, shipping_method varchar(200) NOT NULL, free_delivery enum('1','0') DEFAULT '0' NOT NULL, payment_options varchar(15), archive enum('1','0') DEFAULT '0' NOT NULL, card_processed varchar(20) DEFAULT 'awaiting_payment' NOT NULL, card_error varchar(255) NOT NULL, card_protx_VPSTxID varchar(100), card_protx_AVSCV2 varchar(100), paypal_txn_id varchar(255), date_time varchar(100) DEFAULT '0' NOT NULL, timestamp int(11) DEFAULT '0' NOT NULL, username varchar(255), salutation varchar(8) DEFAULT 'Other' NOT NULL, firstname varchar(255) NOT NULL, surname varchar(255) NOT NULL, email varchar(255) NOT NULL, tel_day varchar(255) NOT NULL, tel_eve varchar(255) NOT NULL, address longtext NOT NULL, postcode varchar(10) NOT NULL, country varchar(40) NOT NULL, delivery_instructions longtext, delivery_salutation varchar(8) DEFAULT 'Other' NOT NULL, delivery_firstname varchar(255), delivery_surname varchar(255), delivery_address longtext, delivery_postcode varchar(10), delivery_country varchar(40), voucher_code varchar(100) NOT NULL, voucher_discount varchar(12) NOT NULL, discount varchar(12) NOT NULL, sent_emails enum('1','0') DEFAULT '0' NOT NULL, PRIMARY KEY (oid), UNIQUE oid (oid) );#%% # # data for table 'hits_shopping_orders' # INSERT INTO hits_shopping_orders VALUES ('1','662597','0','2.50','0.00','22.49','1','Standard Postage','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'November 30, 2005, 2:46 pm','1133361987','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('2','927825','0','2.50','0.00','22.49','1','','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'November 30, 2005, 2:49 pm','1133362154','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('3','16937','0','2.50','0.00','44.47','0','','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'November 30, 2005, 2:50 pm','1133362239','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('4','207672','0','2.50','0.00','44.47','0','','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'November 30, 2005, 2:53 pm','1133362429','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('5','30944','0','2.50','0.00','73.46','0','','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'November 30, 2005, 3:02 pm','1133362964','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('6','99151','0','2.50','0.00','73.46','0','','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'November 30, 2005, 3:02 pm','1133362973','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('7','943939','0','2.50','0.00','22.49','1','Standard Postage','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'December 9, 2005, 5:08 pm','1134148087','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('8','53771','0','2.50','0.00','22.49','1','Standard Postage','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'December 9, 2005, 5:08 pm','1134148107','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('9','334991','0','2.50','0.00','22.49','1','Standard Postage','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'December 20, 2005, 2:04 pm','1135087457','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('10','190551','0','2.50','0.00','12.50','1','Standard Postage','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'December 20, 2005, 11:45 pm','1135122327','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('11','501434','0','2.50','0.00','12.50','1','','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'December 20, 2005, 11:48 pm','1135122522','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('12','210266','0','2.50','0.00','12.50','1','','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'December 20, 2005, 11:48 pm','1135122531','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('13','255310','0','2.50','0.00','12.50','1','','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'December 21, 2005, 12:04 am','1135123484','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('14','418853','0','2.50','0.00','12.50','1','','0','pay','0','payment_received','','','','','December 21, 2005, 12:06 am','1135123599','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','1');#%% INSERT INTO hits_shopping_orders VALUES ('15','252258','0','2.50','0.00','12.50','1','Standard Postage','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'December 21, 2005, 11:23 am','1135164210','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('16','166961','0','2.50','0.00','12.50','1','Standard Postage','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'December 21, 2005, 11:32 am','1135164726','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('17','662963','0','2.50','0.00','12.50','1','','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'December 21, 2005, 11:41 am','1135165313','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('18','22094','0','2.50','0.00','12.50','1','Standard Postage','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'December 21, 2005, 11:56 am','1135166200','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% INSERT INTO hits_shopping_orders VALUES ('19','164794','0','2.50','0.00','12.50','1','Standard Postage','0','pay','0','awaiting_payment','',NULL,NULL,NULL,'December 21, 2005, 12:02 pm','1135166522','ianhitchman','Other','','','','','','','','',NULL,'Other',NULL,NULL,NULL,NULL,NULL,'','','0.00','0');#%% # ---------------------------------------------------------- # # structur for table 'hits_shopping_orders_items' # DROP TABLE IF EXISTS hits_shopping_orders_items;#%% CREATE TABLE hits_shopping_orders_items ( id int(11) NOT NULL auto_increment, oid int(10) DEFAULT '0' NOT NULL, pid int(10), description varchar(255) NOT NULL, dd longtext NOT NULL, price float(6,2) DEFAULT '0.00' NOT NULL, qty int(10) DEFAULT '1' NOT NULL, fileid varchar(50) DEFAULT '(No File)' NOT NULL, uploaded_file_name varchar(255) NOT NULL, customvars varchar(255) NOT NULL, PRIMARY KEY (id), KEY pid (pid), KEY oid (oid) );#%% # # data for table 'hits_shopping_orders_items' # INSERT INTO hits_shopping_orders_items VALUES ('8344','126360','6','Video Capture Card (Colour: Blue)','(Colour: Blue)','10.20','1','(No File)','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8345','126361','6','Video Capture Card (Colour: Blue)','(Colour: Blue)','39.00','1','(No File)','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8346','126361','6','Video Capture Card','','39.00','2','(No File)','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8347','4','170','Trout','','10.99','1','','collage_small.jpg','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8348','4','174','Pike','','19.99','1','','PICTURE 1.jpg','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8349','4','175','Pikey Pike','','10.99','1','','puzzle_large.jpg','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8350','5','174','Pike','','19.99','1','','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8351','5','175','Pikey Pike','','10.99','1','','PICTURE 2.jpg','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8352','5','174','Pike','','19.99','1','','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8353','5','174','Pike','','19.99','1','','puzzle_small.jpg','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8354','6','174','Pike','','19.99','1','','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8355','6','175','Pikey Pike','','10.99','1','','PICTURE 2.jpg','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8356','6','174','Pike','','19.99','1','','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8357','6','174','Pike','','19.99','1','','puzzle_small.jpg','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8358','7','174','Pike','','19.99','1','','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8359','8','174','Pike','','19.99','1','','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8360','9','174','Pike','','19.99','1','','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8361','10','179','Monkey','','10.00','1','(No File)','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8362','11','179','Monkey','','10.00','1','(No File)','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8363','12','179','Monkey','','10.00','1','(No File)','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8364','13','179','Monkey','','10.00','1','(No File)','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8365','14','179','Monkey','','10.00','1','(No File)','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8366','15','179','Monkey','','10.00','1','(No File)','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8367','16','179','Monkey','','10.00','1','(No File)','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8368','18','179','Monkey','','10.00','1','(No File)','','');#%% INSERT INTO hits_shopping_orders_items VALUES ('8369','19','179','Monkey','','10.00','1','(No File)','','');#%% # ---------------------------------------------------------- # # structur for table 'hits_shopping_products' # DROP TABLE IF EXISTS hits_shopping_products;#%% CREATE TABLE hits_shopping_products ( id int(5) NOT NULL auto_increment, sid varchar(255), short_description longtext, long_description longtext, enabled enum('1','0') DEFAULT '1' NOT NULL, position int(5) DEFAULT '0' NOT NULL, field1 float(7,2), field2 varchar(255), field3 varchar(255), field4 varchar(255), field5 varchar(255), field6 varchar(255), field7 varchar(255), field8 varchar(255), image_main_thumb varchar(255), extra_image_1 varchar(255) NOT NULL, extra_image_1_large varchar(255) NOT NULL, extra_image_2 varchar(255) NOT NULL, extra_image_2_large varchar(255) NOT NULL, extra_image_3 varchar(255) NOT NULL, extra_image_3_large varchar(255) NOT NULL, extra_image_4 varchar(255) NOT NULL, extra_image_4_large varchar(255) NOT NULL, image_main_large varchar(255), image_border enum('1','0') DEFAULT '0' NOT NULL, splash_new enum('1','0') DEFAULT '0' NOT NULL, cat_id int(10) DEFAULT '0' NOT NULL, weight varchar(20) DEFAULT '1' NOT NULL, override_vat enum('1','0') DEFAULT '0' NOT NULL, vat_rate varchar(7) DEFAULT '0' NOT NULL, vat_applies enum('1','0') DEFAULT '1' NOT NULL, fileid varchar(255), is_extra enum('1','0') DEFAULT '0' NOT NULL, extra_products enum('1','0') DEFAULT '0' NOT NULL, extra_view varchar(10), free_text enum('1','0') DEFAULT '0' NOT NULL, usetable varchar(255) DEFAULT '(No Table)' NOT NULL, discount_code varchar(50), popup_page_id varchar(10) DEFAULT '0', layout varchar(15) NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_shopping_products' # INSERT INTO hits_shopping_products VALUES ('182',NULL,'New Product',NULL,'1','999999999','0.00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'(No Image)','','','','','','','','',NULL,'0','0','1','1','0','0','1',NULL,'0','0',NULL,'0','(No Table)',NULL,'0','');#%% # ---------------------------------------------------------- # # structur for table 'hits_shopping_regular_items' # DROP TABLE IF EXISTS hits_shopping_regular_items;#%% CREATE TABLE hits_shopping_regular_items ( reg_item_id int(11) NOT NULL auto_increment, regular_id int(11) DEFAULT '0' NOT NULL, pid int(11) DEFAULT '0' NOT NULL, dd varchar(255) NOT NULL, qty int(5) DEFAULT '0' NOT NULL, PRIMARY KEY (reg_item_id) );#%% # # data for table 'hits_shopping_regular_items' # # ---------------------------------------------------------- # # structur for table 'hits_shopping_regular_orders' # DROP TABLE IF EXISTS hits_shopping_regular_orders;#%% CREATE TABLE hits_shopping_regular_orders ( regular_id int(11) NOT NULL auto_increment, username varchar(255) NOT NULL, frequency varchar(15) DEFAULT 'Weekly' NOT NULL, weekly_day varchar(10) DEFAULT 'Monday' NOT NULL, monthly_date int(2) DEFAULT '1' NOT NULL, yearly_date int(11), start_time int(11) DEFAULT '0' NOT NULL, last_order_time int(11) DEFAULT '0' NOT NULL, last_order_id int(11) DEFAULT '0' NOT NULL, shipping_method_id varchar(11) NOT NULL, free_delivery enum('1','0') DEFAULT '0' NOT NULL, active int(1) DEFAULT '0' NOT NULL, status varchar(255), worldpay_futurepay_id int(100) DEFAULT '0' NOT NULL, PRIMARY KEY (regular_id) );#%% # # data for table 'hits_shopping_regular_orders' # # ---------------------------------------------------------- # # structur for table 'hits_shopping_sellers' # DROP TABLE IF EXISTS hits_shopping_sellers;#%% CREATE TABLE hits_shopping_sellers ( refid varchar(30) NOT NULL, pass varchar(100) NOT NULL, active enum('1','0') DEFAULT '0' NOT NULL, company varchar(100) NOT NULL, title varchar(5) NOT NULL, firstname varchar(40) NOT NULL, lastname varchar(40) NOT NULL, website varchar(100) NOT NULL, email varchar(100) NOT NULL, street varchar(100) NOT NULL, town varchar(100) NOT NULL, county varchar(100) NOT NULL, postcode varchar(20) NOT NULL, country varchar(100) NOT NULL, phone varchar(30) NOT NULL, fax varchar(30) NOT NULL, date varchar(40) DEFAULT '01/01/2002' NOT NULL, PRIMARY KEY (refid) );#%% # # data for table 'hits_shopping_sellers' # INSERT INTO hits_shopping_sellers VALUES ('ianhitchman','537baffe2a42f2a69d2b2c84b4bc4c47','1','','Mr.','Ian','Hitchman','','ian@hitchman.co.uk','60b Alexandra Road','Great Wakering','Essex','SS3 0HW','United Kingdom','','','09/01/2005');#%% # ---------------------------------------------------------- # # structur for table 'hits_shopping_user_prices' # DROP TABLE IF EXISTS hits_shopping_user_prices;#%% CREATE TABLE hits_shopping_user_prices ( up_id int(11) NOT NULL auto_increment, username varchar(255), pid int(11) DEFAULT '0' NOT NULL, price float(7,2) DEFAULT '0.00' NOT NULL, min_qty int(10) DEFAULT '0' NOT NULL, PRIMARY KEY (up_id) );#%% # # data for table 'hits_shopping_user_prices' # # ---------------------------------------------------------- # # structur for table 'hits_shopping_vouchers' # DROP TABLE IF EXISTS hits_shopping_vouchers;#%% CREATE TABLE hits_shopping_vouchers ( id int(10) NOT NULL auto_increment, code varchar(100) NOT NULL, amount varchar(10) DEFAULT '0.00' NOT NULL, method varchar(11) DEFAULT 'percentage' NOT NULL, once_only enum('1','0') DEFAULT '0' NOT NULL, expires enum('1','0') DEFAULT '0' NOT NULL, expiry_date int(10) DEFAULT '0' NOT NULL, valid_on_sale_items enum('1','0') DEFAULT '0' NOT NULL, valid enum('1','0') DEFAULT '1' NOT NULL, PRIMARY KEY (id) );#%% # # data for table 'hits_shopping_vouchers' # INSERT INTO hits_shopping_vouchers VALUES ('3','qwerty','10','percentage','0','0','1072915200','0','1');#%% # ---------------------------------------------------------- # # structur for table 'hits_user_group_accesses' # DROP TABLE IF EXISTS hits_user_group_accesses;#%% CREATE TABLE hits_user_group_accesses ( access_id int(10) NOT NULL auto_increment, group_id int(10) DEFAULT '0' NOT NULL, section_type varchar(100) NOT NULL, cat_id varchar(100) NOT NULL, permissions varchar(6), PRIMARY KEY (access_id) );#%% # # data for table 'hits_user_group_accesses' # INSERT INTO hits_user_group_accesses VALUES ('12','7','forum','',NULL);#%% INSERT INTO hits_user_group_accesses VALUES ('11','7','_all_standard_pages','',NULL);#%% INSERT INTO hits_user_group_accesses VALUES ('10','7','contact','',NULL);#%% INSERT INTO hits_user_group_accesses VALUES ('9','1','_all_standard_pages','',NULL);#%% INSERT INTO hits_user_group_accesses VALUES ('14','7','news','',NULL);#%% INSERT INTO hits_user_group_accesses VALUES ('15','7','gallery','',NULL);#%% INSERT INTO hits_user_group_accesses VALUES ('16','7','directory','',NULL);#%% INSERT INTO hits_user_group_accesses VALUES ('17','7','directory','1',NULL);#%% INSERT INTO hits_user_group_accesses VALUES ('18','7','shopping','',NULL);#%% INSERT INTO hits_user_group_accesses VALUES ('19','7','shopping','1',NULL);#%% INSERT INTO hits_user_group_accesses VALUES ('20','7','shopping','72',NULL);#%% INSERT INTO hits_user_group_accesses VALUES ('21','7','shopping','73',NULL);#%% INSERT INTO hits_user_group_accesses VALUES ('23','7','shopping','74',NULL);#%% # ---------------------------------------------------------- # # structur for table 'hits_user_group_members' # DROP TABLE IF EXISTS hits_user_group_members;#%% CREATE TABLE hits_user_group_members ( assign_id int(10) NOT NULL auto_increment, username varchar(100) DEFAULT '0' NOT NULL, group_id int(10) DEFAULT '0' NOT NULL, PRIMARY KEY (assign_id) );#%% # # data for table 'hits_user_group_members' # INSERT INTO hits_user_group_members VALUES ('7','ianhitchman','1');#%% INSERT INTO hits_user_group_members VALUES ('8','ianhitchman','7');#%% INSERT INTO hits_user_group_members VALUES ('10','sssss','12');#%% # ---------------------------------------------------------- # # structur for table 'hits_user_groups' # DROP TABLE IF EXISTS hits_user_groups;#%% CREATE TABLE hits_user_groups ( group_id int(10) NOT NULL auto_increment, description varchar(50) NOT NULL, PRIMARY KEY (group_id) );#%% # # data for table 'hits_user_groups' # INSERT INTO hits_user_groups VALUES ('1','Member');#%% INSERT INTO hits_user_groups VALUES ('7','Guest');#%% # ---------------------------------------------------------- # # structur for table 'hits_user_profiles' # DROP TABLE IF EXISTS hits_user_profiles;#%% CREATE TABLE hits_user_profiles ( username varchar(255) NOT NULL, password varchar(255) NOT NULL, cp_user_bool int(1) DEFAULT '0' NOT NULL, firstname varchar(255) NOT NULL, surname varchar(255) NOT NULL, salutation varchar(10) NOT NULL, email varchar(255), additional_email varchar(255), website varchar(255), tel_day varchar(30) NOT NULL, tel_eve varchar(30) NOT NULL, tel_mobile varchar(30), fax varchar(30), address varchar(255) NOT NULL, postcode varchar(12) NOT NULL, country varchar(100) NOT NULL, delivery_instructions longtext NOT NULL, delivery_salutation varchar(10) NOT NULL, delivery_firstname varchar(255) NOT NULL, delivery_surname varchar(255) NOT NULL, delivery_address varchar(255) NOT NULL, delivery_postcode varchar(12) NOT NULL, delivery_country varchar(100) NOT NULL, forum_avatar varchar(255), forum_signature longtext, enabled enum('1','0') DEFAULT '1' NOT NULL, business varchar(255), PRIMARY KEY (username), UNIQUE username_2 (username) );#%% # # data for table 'hits_user_profiles' # INSERT INTO hits_user_profiles VALUES ('ianhitchman','537baffe2a42f2a69d2b2c84b4bc4c47','0','Ian','Hitchman','Mr.','ian@hitchman.co.uk','','','01702 535260','','07764485844','','60b Alexandra Road','SS3 0HW','United Kingdom','Leave around the back','Mr.','Fred','Bloggs','123 Somewhere','123AAC','United Kingdom','ianhitchman.jpg','This is my signature - hope you like it','1',NULL);#%%