# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost:3306 Database : sb

# --------------------------------------------------------
#
# Table structure for table 'categor'
#

CREATE TABLE categor (
   name varchar(50),
   id int(10) unsigned zerofill NOT NULL auto_increment,
   PRIMARY KEY (id)
);

#
# Dumping data for table 'categor'
#

INSERT INTO categor VALUES ( 'new', '0000000001');

# --------------------------------------------------------
#
# Table structure for table 'country'
#

CREATE TABLE country (
   name varchar(100),
   id int(10) unsigned zerofill NOT NULL auto_increment,
   PRIMARY KEY (id)
);

#
# Dumping data for table 'country'
#

INSERT INTO country VALUES ( 'Russia', '0000000001');

# --------------------------------------------------------
#
# Table structure for table 'country2'
#

CREATE TABLE country2 (
   id int(11) NOT NULL auto_increment,
   name varchar(150),
   PRIMARY KEY (id)
);

#
# Dumping data for table 'country2'
#

INSERT INTO country2 VALUES ( '1', 'Россия');
INSERT INTO country2 VALUES ( '2', 'Afghanistan');
INSERT INTO country2 VALUES ( '3', 'Albania');
INSERT INTO country2 VALUES ( '4', 'Algeria');
INSERT INTO country2 VALUES ( '5', 'American Samoa');
INSERT INTO country2 VALUES ( '6', 'Andorra');
INSERT INTO country2 VALUES ( '7', 'Angola');
INSERT INTO country2 VALUES ( '8', 'Anguilla');
INSERT INTO country2 VALUES ( '9', 'Antarctica');
INSERT INTO country2 VALUES ( '10', 'Antigua and Barbuda');

# --------------------------------------------------------
#
# Table structure for table 'feedback'
#

CREATE TABLE feedback (
   company_name varchar(250) NOT NULL,
   coun_code varchar(100) NOT NULL,
   area varchar(50) NOT NULL,
   phone varchar(150) NOT NULL,
   fax varchar(150) NOT NULL,
   e_mail varchar(150) NOT NULL,
   country varchar(50) NOT NULL,
   title varchar(10) NOT NULL,
   fst_name varchar(100) NOT NULL,
   lst_name varchar(100) NOT NULL,
   comments text,
   id int(10) unsigned zerofill NOT NULL auto_increment,
   PRIMARY KEY (id)
);

#
# Dumping data for table 'feedback'
#


# --------------------------------------------------------
#
# Table structure for table 'howregular'
#

CREATE TABLE howregular (
   name text,
   id int(10) unsigned NOT NULL auto_increment,
   PRIMARY KEY (id)
);

#
# Dumping data for table 'howregular'
#

INSERT INTO howregular VALUES ( 'Monthly', '1');
INSERT INTO howregular VALUES ( 'Quarterly', '2');
INSERT INTO howregular VALUES ( 'Twice a Year', '3');
INSERT INTO howregular VALUES ( 'Yearly', '4');

# --------------------------------------------------------
#
# Table structure for table 'inquiry'
#

CREATE TABLE inquiry (
   pr_name text,
   pr_description text,
   origin varchar(150) NOT NULL,
   quality text,
   r3 varchar(10) NOT NULL,
   quantity varchar(75) NOT NULL,
   quantaty_ship varchar(75) NOT NULL,
   destination varchar(175) NOT NULL,
   r1 varchar(10) NOT NULL,
   packaging varchar(175) NOT NULL,
   requirements varchar(150) NOT NULL,
   timebase varchar(30) NOT NULL,
   howregular varchar(30) NOT NULL,
   quote varchar(30) NOT NULL,
   ot_quotation varchar(150) NOT NULL,
   delivery varchar(150) NOT NULL,
   deadline varchar(150) NOT NULL,
   payment varchar(175) NOT NULL,
   price_idea text,
   your_comments text,
   firm_id varchar(10) NOT NULL,
   id2 int(10) unsigned zerofill NOT NULL auto_increment,
   Number int(2) DEFAULT '0',
   PRIMARY KEY (id2)
);

#
# Dumping data for table 'inquiry'
#

INSERT INTO inquiry VALUES ( 'gdfgsdfgdfgsdf', 'hfsdtgsldfhjlsfhjfh', 'uweyruy2348ry3ryyu', 'fhuwehfluwdhfui', 'No', 'rwuqehfwei', 'fhuweih3478hfqil', 'fh4oowfhueriwfhweuil', 'Railway', 'fho44o3ifhw', 'hfrq34ofhqweuio', 'Regular shipments', 'Twice a Year', 'CIF destination port', '', 'fhurfhwuier', 'fhjkehfulerui', 'fuirhefruifhi3', 'r3489hfq3489h89', 'fh9845789w34hi9', '1', '0000000001', '1');

# --------------------------------------------------------
#
# Table structure for table 'offer'
#

CREATE TABLE offer (
   pr_name text,
   pr_description text,
   origin varchar(150) NOT NULL,
   quality text,
   r2 varchar(10) NOT NULL,
   quantity varchar(75) NOT NULL,
   howregular varchar(50) NOT NULL,
   ot_quantity varchar(75) NOT NULL,
   quantaty varchar(150) NOT NULL,
   packtype text,
   ot_requirm text,
   price_cond varchar(250) NOT NULL,
   quote varchar(50) NOT NULL,
   ot_quotation varchar(50) NOT NULL,
   pay_cond varchar(150) NOT NULL,
   price_idea text,
   firm_id varchar(10) NOT NULL,
   id2 int(10) unsigned zerofill NOT NULL auto_increment,
   Number int(2) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id2)
);

#
# Dumping data for table 'offer'
#

INSERT INTO offer VALUES ( 'PRODUCT  NAME:1
', 'PRODUCT DESCRIPTION:
', 'COUNTRY  OF ORIGIN:', 'QUALITY / GRADE:
', 'No', 'QUANTITY:', 'Quarterly', 'other', 'QUANTITY:', 'PACK  TYPE:
', 'Certificates, Buyer\'s ', 'PRICE CONDITION:', 'CIF destination port', 'other', 'PAYMENT CONDITION:', 'Your Message', '11', '0000000001', '1');
INSERT INTO offer VALUES ( 'PRODUCT  NAME:1
', 'PRODUCT DESCRIPTION:
', 'COUNTRY  OF ORIGIN:', 'QUALITY / GRADE:
', 'No', 'QUANTITY:', 'Quarterly', 'other', 'QUANTITY:', 'PACK  TYPE:
', 'Certificates, Buyer\'s ', 'PRICE CONDITION:', 'CIF destination port', 'other', 'PAYMENT CONDITION:', 'Your Message', '11', '0000000002', '1');
INSERT INTO offer VALUES ( 'qwer2', 'sdafasf2342134', 'sdafdasf', '', '', '', 'Monthly', '', '', '', '', '', 'FOB PORT', '', '', '', '11', '0000000003', '2');
INSERT INTO offer VALUES ( 'werjweirhyweh iwhfjksdhf slfjsdh sdfjgh ldfghjdfhg dfhlsgdlf ghsdfjlh gjsdlhg djlgh djlsfhg dfjsklh gjdfklghsdfhlg ldsf lsdfghdjlfh gldfjkghjdfklshg lsgjkdh lsh gdfhg', 'PRODUCT DESCRIPTION', 'DESCRIPTION:', 'QUALITY / GRADE:
', 'Yes', 'QUANTITY:', 'Quarterly', '', 'QUANTITY  per shipment', 'PACK  TYPE:
', 'Certificate', 'PRICE CONDITION:', 'CIF destination port', '', 'PAYMENT CONDITION', 'Your Message: rsdfs
', '1', '0000000004', '1');
INSERT INTO offer VALUES ( 'fghgsd sdgfshkadg jsdf asdgfhghkgasdhgfasdhkfasdgkfhasdgfhsadgfhasdgkfasdhgf', 'asdasf', '4324', 'werwerew', '', 'rsda', 'Quarterly', '', 'sdfsdf', 'sdfdsf', 'sdfsdf', 'czxczxc', 'Choose One', '', 'qweqweqw', 'qwedascasdfasfaasdfsdf', '1', '0000000005', '2');

# --------------------------------------------------------
#
# Table structure for table 'pav'
#

CREATE TABLE pav (
   name text,
   id int(10) unsigned NOT NULL auto_increment,
   PRIMARY KEY (id)
);

#
# Dumping data for table 'pav'
#

INSERT INTO pav VALUES ( 'Food and drinks', '1');
INSERT INTO pav VALUES ( 'food', '2');
INSERT INTO pav VALUES ( 'drinks', '3');
INSERT INTO pav VALUES ( 'cars', '4');

# --------------------------------------------------------
#
# Table structure for table 'pav2'
#

CREATE TABLE pav2 (
   id int(11) NOT NULL auto_increment,
   pav int(5) DEFAULT '0' NOT NULL,
   name varchar(150),
   PRIMARY KEY (id)
);

#
# Dumping data for table 'pav2'
#

INSERT INTO pav2 VALUES ( '1', '1', 'Fast Food Equipment');
INSERT INTO pav2 VALUES ( '2', '1', 'Food components');

# --------------------------------------------------------
#
# Table structure for table 'que_form'
#

CREATE TABLE que_form (
   ad_module text,
   pav text,
   otherpav varchar(200) NOT NULL,
   business_categories varchar(50) NOT NULL,
   exporter varchar(10) NOT NULL,
   exp_to varchar(100) NOT NULL,
   exp_from varchar(100) NOT NULL,
   importer varchar(10) NOT NULL,
   imp_to varchar(100) NOT NULL,
   imp_from varchar(100) NOT NULL,
   other varchar(200) NOT NULL,
   year varchar(75) NOT NULL,
   employees varchar(100) NOT NULL,
   turnover varchar(100) NOT NULL,
   member varchar(100) NOT NULL,
   r1 varchar(10) NOT NULL,
   nis_countries varchar(100) NOT NULL,
   benefits text,
   firm_id varchar(10) NOT NULL,
   id2 int(10) unsigned NOT NULL auto_increment,
   pav2 text,
   active int(1) DEFAULT '0' NOT NULL,
   ad_module2 text,
   active2 int(1) DEFAULT '0' NOT NULL,
   PRIMARY KEY (id2)
);

#
# Dumping data for table 'que_form'
#

INSERT INTO que_form VALUES ( 'Please enter information here up to 75 words that will be translated  and represented
on your Electronic Stands in English and Russian  (see example )
', 'drinks;Food and drinks;', '', 'new', 'Exporter', 'msk', 'ptr', 'Importer', 'ptr', 'msk', 'other', '1810', '50', '1000', '1', 'Yes', 'Russia', 'What Benefits is your Company seeking participating in e-Trade Show \"Smal Business Industry\" ', '1', '1', '1;2;', '1', 'fwedsf', '1');

# --------------------------------------------------------
#
# Table structure for table 'quote'
#

CREATE TABLE quote (
   name text,
   id int(10) unsigned NOT NULL auto_increment,
   PRIMARY KEY (id)
);

#
# Dumping data for table 'quote'
#

INSERT INTO quote VALUES ( 'FOB PORT', '1');
INSERT INTO quote VALUES ( 'CIF destination port', '2');
INSERT INTO quote VALUES ( 'C+F Destination port', '3');
INSERT INTO quote VALUES ( 'Ex Factory', '4');

# --------------------------------------------------------
#
# Table structure for table 'registr'
#

CREATE TABLE registr (
   company_name varchar(250) NOT NULL,
   coun_code varchar(100) NOT NULL,
   area varchar(50) NOT NULL,
   phone varchar(150) NOT NULL,
   fax varchar(150) NOT NULL,
   e_mail varchar(150) NOT NULL,
   www_url varchar(150) NOT NULL,
   street varchar(200) NOT NULL,
   city varchar(200) NOT NULL,
   state varchar(150) NOT NULL,
   zip varchar(50) NOT NULL,
   country varchar(50) NOT NULL,
   title varchar(10) NOT NULL,
   fst_name varchar(100) NOT NULL,
   lst_name varchar(100) NOT NULL,
   job_title varchar(75) NOT NULL,
   offer int(1) DEFAULT '0' NOT NULL,
   pass varchar(15) NOT NULL,
   id int(10) unsigned NOT NULL auto_increment,
   N_off int(1) DEFAULT '5',
   N_inq int(1) DEFAULT '5',
   PRIMARY KEY (id)
);

#
# Dumping data for table 'registr'
#

INSERT INTO registr VALUES ( 'Company', '7', '095', '11111', '22222', 'qwe@qwe.com', 'http://qweqwe.com', 'street', 'city', 'state', 'zip', '1', 'Mr.', 'Vasya', 'Pupkin', 'admin', '3', 'q', '1', '5', '5');
INSERT INTO registr VALUES ( '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'q', '2', '5', '5');
INSERT INTO registr VALUES ( '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'q', '3', '5', '5');
INSERT INTO registr VALUES ( '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'q', '4', '5', '5');
INSERT INTO registr VALUES ( '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '0', 'q', '5', '5', '5');

# --------------------------------------------------------
#
# Table structure for table 'sp_form'
#

CREATE TABLE sp_form (
   product_name text,
   introduction text,
   applications text,
   main_char text,
   specification text,
   installing text,
   not_addr text,
   firm_id varchar(10) NOT NULL,
   id2 int(10) unsigned zerofill NOT NULL auto_increment,
   Number int(2) DEFAULT '0',
   PRIMARY KEY (id2)
);

#
# Dumping data for table 'sp_form'
#

INSERT INTO sp_form VALUES ( '1. NAME OF  PRODUCT OR SERVICE:
qweqwe', '2. INTRODUCTION:
', '3. APPLICATIONS:
', '4.1. Main Characteristics:
', '4.2. Specification:
', '4.3. Installing Process:
', '5. Please feel free to write us any additional comments here:
', '1', '0000000001', '1');
INSERT INTO sp_form VALUES ( 'qweqwewqeqwe1234e23', 'e23e32eq2e', 'q23eq23e23qe23', '2q3eq23e3q2e23', 'qe23eq23eq23e23e', 'eq23eqwrq23erq23e', 'eq23eq23eq23e', '1', '0000000002', '2');

# --------------------------------------------------------
#
# Table structure for table 'title'
#

CREATE TABLE title (
   id int(11) NOT NULL auto_increment,
   name varchar(5),
   PRIMARY KEY (id)
);

#
# Dumping data for table 'title'
#

INSERT INTO title VALUES ( '2', 'Mr.');
INSERT INTO title VALUES ( '3', 'Mrs.');
INSERT INTO title VALUES ( '4', 'Miss.');
INSERT INTO title VALUES ( '5', 'Ms.');
INSERT INTO title VALUES ( '6', 'Dr.');
INSERT INTO title VALUES ( '7', 'Prof.');