# MySQL dump 8.13
#
# Host: localhost    Database: netespion
#--------------------------------------------------------
# Server version	3.23.36

#
# Table structure for table 'BillingInfo'
#

CREATE TABLE BillingInfo (
  id int(11) NOT NULL auto_increment,
  affiliate_id int(11) NOT NULL default '0',
  p_cc_first_name varchar(64) NOT NULL default '',
  p_cc_last_name varchar(64) NOT NULL default '',
  p_cc_type varchar(64) NOT NULL default '',
  p_cc_num varchar(16) NOT NULL default '',
  p_cc_exp varchar(7) NOT NULL default '',
  ts_of_issue timestamp(14) NOT NULL,
  price varchar(8) NOT NULL default '0',
  coupon varchar(32) NOT NULL default '',
  service_type varchar(32) NOT NULL default '',
  paid varchar(64) NOT NULL default 'N',
  amount_returned varchar(8) NOT NULL default '0.0',
  final_amount varchar(8) NOT NULL default '0.0',
  payment_system varchar(16) NOT NULL default '',
  vat_option varchar(64) NOT NULL default '0',
  error_message varchar(255) NOT NULL default '',
  vat_options enum('OUTSIDE_VAT','INSIDEVAT_VAT','INSIDEVAT_NOVAT') default NULL,
  orderID varchar(64) NOT NULL default '',
  trackingID varchar(64) NOT NULL default '',
  email varchar(128) NOT NULL default '',
  first_name varchar(60) NOT NULL default '',
  last_name varchar(60) NOT NULL default '',
  org_name varchar(255) NOT NULL default '',
  address1 varchar(255) NOT NULL default '',
  address2 varchar(255) NOT NULL default '',
  address3 varchar(255) NOT NULL default '',
  city varchar(128) NOT NULL default '',
  state varchar(255) NOT NULL default '',
  postal_code varchar(10) NOT NULL default '',
  country varchar(60) NOT NULL default '',
  phone varchar(64) NOT NULL default '',
  fax varchar(64) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY email (email),
  KEY org_name (org_name),
  KEY last_name (last_name)
) TYPE=MyISAM;

#
# Dumping data for table 'BillingInfo'
#

INSERT INTO BillingInfo VALUES (300771,0,'Elliott','Stambouli','visa','xxxxxxxxxxxxxxxx','01-2004',20030801073718,'1.95','','SpyCop:1\0SpyCop:1','NE','0.0','0.0','LinkPoint','0','Error during Authorisation:',NULL,'20030621122535','','eugeneprosso@yahoo.com','Elliott','Stambouli','Stambouli Inc','Kirikos av. 12','','','Nicosia','Nicosia','34744','CY','972-53-263974','NA');
INSERT INTO BillingInfo VALUES (300770,0,'Elliott','Stambouli','visa','xxxxxxxxxxxxxxxx','01-2004',20030801073718,'1.95','','SpyCop:1\0SpyCop:1','NE','0.0','0.0','LinkPoint','0','Error during Authorisation:',NULL,'20030621122529','','eugeneprosso@yahoo.com','Elliott','Stambouli','Stambouli Inc','Kirikos av. 12','','','Nicosia','Nicosia','34744','CY','972-53-263974','NA');
INSERT INTO BillingInfo VALUES (300769,0,'Elliott','Stambouli','visa','xxxxxxxxxxxxxxxx','01-2004',20030801073718,'1.95','','SpyCop:1\0SpyCop:1','NE','0.0','0.0','LinkPoint','0','Error during Authorisation:',NULL,'20030621122422','','eugeneprosso@yahoo.com','Elliott','Stambouli','Stambouli Inc','Kirikos av. 12','','','Nicosia','Nicosia','34744','CY','972-53-263974','NA');
INSERT INTO BillingInfo VALUES (300768,0,'Elliott','Stambouli','visa','xxxxxxxxxxxxxxxx','01-2004',20030801073718,'1.95','','SpyCop:1\0SpyCop:1','NE','0.0','0.0','LinkPoint','0','Error during Authorisation:',NULL,'20030621122253','','eugeneprosso@yahoo.com','Elliott','Stambouli','Stambouli Inc','Kirikos av. 12','','','Nicosia','Nicosia','34744','CY','972-53-263974','NA');
INSERT INTO BillingInfo VALUES (300767,0,'Elliott','Stambouli','visa','xxxxxxxxxxxxxxxx','01-2004',20030801073718,'1.95','','SpyCop:1\0SpyCop:1','NE','0.0','0.0','LinkPoint','0','Error during Authorisation:',NULL,'20030621122113','','eugeneprosso@yahoo.com','Elliott','Stambouli','Stambouli Inc','Kirikos av. 12','','','Nicosia','Nicosia','34744','CY','972-53-263974','NA');
INSERT INTO BillingInfo VALUES (300765,0,'Elliott','Stambouli','visa','xxxxxxxxxxxxxxxx','11-2005',20030801073718,'30.00','elliott40','SpyCop:3\0SpyCop:3','Y','0.0','0.0','LinkPoint','0','NONE',NULL,'20030608054717','0ee3143e00','elliott@stambouli.org','Elliott','Stambouli','Stambouli Inc','Kirikos av. 12','','','Nicosia','Nicosia','34744','CY','972-53-263974','NA');
INSERT INTO BillingInfo VALUES (300766,0,'Elliott','Stambouli','visa','xxxxxxxxxxxxxxxx','01-2004',20030801073718,'1.95','','SpyCop:1\0SpyCop:1','NE','0.0','0.0','LinkPoint','0','Error during Authorisation:',NULL,'20030621120955','','eugeneprosso@yahoo.com','Elliott','Stambouli','Stambouli Inc','Kirikos av. 12','','','Nicosia','Nicosia','34744','CY','972-53-263974','NA');

#
# Table structure for table 'Countries'
#

CREATE TABLE Countries (
  Acronym char(2) NOT NULL default '',
  Description varchar(100) NOT NULL default '',
  Description_francais varchar(255) NOT NULL default '',
  PRIMARY KEY  (Acronym)
) TYPE=MyISAM;

#
# Dumping data for table 'Countries'
#

INSERT INTO Countries VALUES ('AF','Afghanistan','AFGHANISTAN');
INSERT INTO Countries VALUES ('AL','Albania','ALBANIE');
INSERT INTO Countries VALUES ('DZ','Algeria','ALGERIE');
INSERT INTO Countries VALUES ('AS','American Samoa','SAMOA AMERICAINE');
INSERT INTO Countries VALUES ('AD','Andorra','ANDORRE');
INSERT INTO Countries VALUES ('AO','Angola','ANGOLA');
INSERT INTO Countries VALUES ('AI','Anguilla','ANGUILLA');
INSERT INTO Countries VALUES ('AQ','Antarctica','ANTARTIQUE');
INSERT INTO Countries VALUES ('AG','Antigua And Barbuda','ANTIGUA ET BARBUDA');
INSERT INTO Countries VALUES ('AR','Argentina','ARGENTINE');
INSERT INTO Countries VALUES ('AM','Armenia','ARMENIE');
INSERT INTO Countries VALUES ('AW','Aruba','ARUBA');
INSERT INTO Countries VALUES ('AU','Australia','AUSTRALIE');
INSERT INTO Countries VALUES ('AT','Austria','AUTRICHE');
INSERT INTO Countries VALUES ('AZ','Azerbaijan','AZERBAIDJAN');
INSERT INTO Countries VALUES ('BS','Bahamas','BAHAMAS');
INSERT INTO Countries VALUES ('BH','Bahrain','BAHREIN');
INSERT INTO Countries VALUES ('BD','Bangladesh','BANGLADESH');
INSERT INTO Countries VALUES ('BB','Barbados','BARBADE');
INSERT INTO Countries VALUES ('BY','Belarus','BIELORUSSIE');
INSERT INTO Countries VALUES ('BE','Belgium','BELGIQUE');
INSERT INTO Countries VALUES ('BZ','Belize','BELIZE');
INSERT INTO Countries VALUES ('BJ','Benin','BENIN');
INSERT INTO Countries VALUES ('BM','Bermuda','BERMUDES');
INSERT INTO Countries VALUES ('BT','Bhutan','BHOUTAN');
INSERT INTO Countries VALUES ('BO','Bolivia','BOLIVIE');
INSERT INTO Countries VALUES ('BA','Bosnia Hercegovina','BOSNIE HERZEGOVINE');
INSERT INTO Countries VALUES ('BW','Botswana','BOTSWANA');
INSERT INTO Countries VALUES ('BV','Bouvet Island','');
INSERT INTO Countries VALUES ('BR','Brazil','BRESIL');
INSERT INTO Countries VALUES ('IO','British Indian Ocean Territory','');
INSERT INTO Countries VALUES ('BN','Brunei Darussalam','BRUNEI DARUSSALAM');
INSERT INTO Countries VALUES ('BG','Bulgaria','BULGARIE');
INSERT INTO Countries VALUES ('BF','Burkina Faso','BURKINA FASO');
INSERT INTO Countries VALUES ('BI','Burundi','BURUNDI');
INSERT INTO Countries VALUES ('KH','Cambodia','CAMBODGE');
INSERT INTO Countries VALUES ('CM','Cameroon','CAMEROUN');
INSERT INTO Countries VALUES ('CA','Canada','CANADA');
INSERT INTO Countries VALUES ('CV','Cape Verde','CAP VERT');
INSERT INTO Countries VALUES ('KY','Cayman Islands','ILES CAIMAN');
INSERT INTO Countries VALUES ('CF','Central African Republic','CENTRAFRIQUE');
INSERT INTO Countries VALUES ('TD','Chad','TCHAD');
INSERT INTO Countries VALUES ('CL','Chile','CHILI');
INSERT INTO Countries VALUES ('CN','China','CHINE');
INSERT INTO Countries VALUES ('CX','Christmas Island','ILE CHRISTMAS');
INSERT INTO Countries VALUES ('CC','Cocos (Keeling) Islands','');
INSERT INTO Countries VALUES ('CO','Colombia','COLOMBIE');
INSERT INTO Countries VALUES ('KM','Comoros','COMORES');
INSERT INTO Countries VALUES ('CG','Congo','CONGO');
INSERT INTO Countries VALUES ('CD','Congo, The Democratic Republic Of','REP. DEM. DU CONGO');
INSERT INTO Countries VALUES ('CK','Cook Islands','ILES COOK');
INSERT INTO Countries VALUES ('CR','Costa Rica','COSTA RICA');
INSERT INTO Countries VALUES ('CI','Cote D\'Ivoire','COTE D\'IVOIRE');
INSERT INTO Countries VALUES ('HR','Croatia','CROATIE');
INSERT INTO Countries VALUES ('CU','Cuba','CUBA');
INSERT INTO Countries VALUES ('CY','Cyprus','CHYPRE');
INSERT INTO Countries VALUES ('CZ','Czech Republic','REPUBLIQUE TCHEQUE');
INSERT INTO Countries VALUES ('CS','Czechoslovakia','');
INSERT INTO Countries VALUES ('DK','Denmark','DANEMARK');
INSERT INTO Countries VALUES ('DJ','Djibouti','DJIBOUTI');
INSERT INTO Countries VALUES ('DM','Dominica','DOMINIQUE');
INSERT INTO Countries VALUES ('DO','Dominican Republic','REPUBLIQUE DOMINICAINE');
INSERT INTO Countries VALUES ('TP','East Timor','');
INSERT INTO Countries VALUES ('EC','Ecuador','EQUATEUR');
INSERT INTO Countries VALUES ('EG','Egypt','EGYPTE');
INSERT INTO Countries VALUES ('SV','El Salvador','EL SALVADOR');
INSERT INTO Countries VALUES ('GQ','Equatorial Guinea','GUINEE EQUATORIALE');
INSERT INTO Countries VALUES ('ER','Eritrea','ERYTHREE');
INSERT INTO Countries VALUES ('EE','Estonia','ESTONIE');
INSERT INTO Countries VALUES ('ET','Ethiopia','ETHIOPIE');
INSERT INTO Countries VALUES ('FK','Falkland Islands (Malvinas)','ILES FALKLAND (MALOUINES)');
INSERT INTO Countries VALUES ('FO','Faroe Islands','ILES FEROE');
INSERT INTO Countries VALUES ('FJ','Fiji','FIDJI');
INSERT INTO Countries VALUES ('FI','Finland','FINLANDE');
INSERT INTO Countries VALUES ('FR','France','FRANCE METROPOLITAINE');
INSERT INTO Countries VALUES ('FX','France, Metropolitan','');
INSERT INTO Countries VALUES ('GF','French Guiana','');
INSERT INTO Countries VALUES ('PF','French Polynesia','POLYNESIE FRANCAISE');
INSERT INTO Countries VALUES ('TF','French Southern Territories','TERRES AUSTRALES FRANCAISES');
INSERT INTO Countries VALUES ('GA','Gabon','GABON');
INSERT INTO Countries VALUES ('GM','Gambia','GAMBIE');
INSERT INTO Countries VALUES ('GE','Georgia','GEORGIE');
INSERT INTO Countries VALUES ('DE','Germany','ALLEMAGNE');
INSERT INTO Countries VALUES ('GH','Ghana','GHANA');
INSERT INTO Countries VALUES ('GI','Gibraltar','GIBRALTAR');
INSERT INTO Countries VALUES ('GR','Greece','GRECE');
INSERT INTO Countries VALUES ('GL','Greenland','GROENLAND');
INSERT INTO Countries VALUES ('GD','Grenada','GRENADE');
INSERT INTO Countries VALUES ('GP','Guadeloupe','GUADELOUPE');
INSERT INTO Countries VALUES ('GU','Guam','GUAM');
INSERT INTO Countries VALUES ('GT','Guatemela','GUATEMALA');
INSERT INTO Countries VALUES ('GG','Guernsey','');
INSERT INTO Countries VALUES ('GN','Guinea','GUINEE');
INSERT INTO Countries VALUES ('GW','Guinea-Bissau','GUINEE-BISSAU');
INSERT INTO Countries VALUES ('GY','Guyana','GUYANE FRANCAISE');
INSERT INTO Countries VALUES ('HT','Haiti','HAITI');
INSERT INTO Countries VALUES ('HM','Heard and McDonald Islands','');
INSERT INTO Countries VALUES ('HN','Honduras','HONDURAS');
INSERT INTO Countries VALUES ('HK','Hong Kong','HONG KONG');
INSERT INTO Countries VALUES ('HU','Hungary','HONGRIE');
INSERT INTO Countries VALUES ('IS','Iceland','');
INSERT INTO Countries VALUES ('IN','India','INDE');
INSERT INTO Countries VALUES ('ID','Indonesia','INDONESIE');
INSERT INTO Countries VALUES ('IR','Iran (Islamic Republic Of)','IRAN');
INSERT INTO Countries VALUES ('IQ','Iraq','IRAK');
INSERT INTO Countries VALUES ('IE','Ireland','IRLANDE');
INSERT INTO Countries VALUES ('IM','Isle Of Man','');
INSERT INTO Countries VALUES ('IL','Israel','ISRAEL');
INSERT INTO Countries VALUES ('IT','Italy','ITALIE');
INSERT INTO Countries VALUES ('JM','Jamaica','JAMAIQUE');
INSERT INTO Countries VALUES ('JP','Japan','JAPON');
INSERT INTO Countries VALUES ('JE','Jersey','');
INSERT INTO Countries VALUES ('JO','Jordan','JORDANIE');
INSERT INTO Countries VALUES ('KZ','Kazakhstan','KAZAKHSTAN');
INSERT INTO Countries VALUES ('KE','Kenya','KENYA');
INSERT INTO Countries VALUES ('KI','Kiribati','');
INSERT INTO Countries VALUES ('KP','Korea, Democratic People\'s Republic Of','COREE DU NORD');
INSERT INTO Countries VALUES ('KR','Korea, Republic Of','COREE DU SUD');
INSERT INTO Countries VALUES ('KW','Kuwait','KOWEIT');
INSERT INTO Countries VALUES ('KG','Kyrgyzstan','KYRGYZSTAN');
INSERT INTO Countries VALUES ('LA','Lao People\'s Democratic Republic','LAOS');
INSERT INTO Countries VALUES ('LV','Latvia','');
INSERT INTO Countries VALUES ('LB','Lebanon','LIBAN');
INSERT INTO Countries VALUES ('LS','Lesotho','LESOTHO');
INSERT INTO Countries VALUES ('LR','Liberia','LIBERIA');
INSERT INTO Countries VALUES ('LY','Libyan Arab Jamahiriya','LIBYE');
INSERT INTO Countries VALUES ('LI','Liechtenstein','LIECHTENSTEIN');
INSERT INTO Countries VALUES ('LT','Lithuania','LITHUANIE');
INSERT INTO Countries VALUES ('LU','Luxembourg','LUXEMBOURG');
INSERT INTO Countries VALUES ('MO','Macau','MACAO');
INSERT INTO Countries VALUES ('MK','Macedonia','MACEDOINE');
INSERT INTO Countries VALUES ('MG','Madagascar','MADAGASCAR');
INSERT INTO Countries VALUES ('MW','Malawi','MALAWI');
INSERT INTO Countries VALUES ('MY','Malaysia','MALAiSIE');
INSERT INTO Countries VALUES ('MV','Maldives','MALDIVES');
INSERT INTO Countries VALUES ('ML','Mali','MALI');
INSERT INTO Countries VALUES ('MT','Malta','MALTE');
INSERT INTO Countries VALUES ('MH','Marshall Islands','ILES MARSHALL');
INSERT INTO Countries VALUES ('MQ','Martinique','MARTINIQUE');
INSERT INTO Countries VALUES ('MR','Mauritania','MAURITANIE');
INSERT INTO Countries VALUES ('MU','Mauritius','MAURICE');
INSERT INTO Countries VALUES ('YT','Mayotte','MAYOTTE');
INSERT INTO Countries VALUES ('MX','Mexico','MEXIQUE');
INSERT INTO Countries VALUES ('FM','Micronesia, Federated States Of','MICRONESIE');
INSERT INTO Countries VALUES ('MD','Moldova, Republic Of','REPUBLIQUE DE MOLDAVIE');
INSERT INTO Countries VALUES ('MC','Monaco','MONACO');
INSERT INTO Countries VALUES ('MN','Mongolia','MONGOLIE');
INSERT INTO Countries VALUES ('MS','Montserrat','MONTSERRAT');
INSERT INTO Countries VALUES ('MA','Morocco','MAROC');
INSERT INTO Countries VALUES ('MZ','Mozambique','MOZAMBIQUE');
INSERT INTO Countries VALUES ('MM','Myanmar','MYANMAR');
INSERT INTO Countries VALUES ('NA','Namibia','NAMIBIE');
INSERT INTO Countries VALUES ('NR','Nauru','NAURU');
INSERT INTO Countries VALUES ('NP','Nepal','NEPAL');
INSERT INTO Countries VALUES ('NL','Netherlands','PAYS-BAS');
INSERT INTO Countries VALUES ('AN','Netherlands Antilles','ANTILLES NEERLANDAISES');
INSERT INTO Countries VALUES ('NT','Neutral Zone','');
INSERT INTO Countries VALUES ('NC','New Caledonia','NOUVELLE CALEDONIE');
INSERT INTO Countries VALUES ('NZ','New Zealand','NOUVELLE ZELANDE');
INSERT INTO Countries VALUES ('NI','Nicaragua','NICARAGUA');
INSERT INTO Countries VALUES ('NE','Niger','NIGER');
INSERT INTO Countries VALUES ('NG','Nigeria','NIGERIA');
INSERT INTO Countries VALUES ('NU','Niue','');
INSERT INTO Countries VALUES ('NF','Norfolk Island','ILE NORFOLK');
INSERT INTO Countries VALUES ('MP','Northern Mariana Islands','ILES MARIANNES DU NORD');
INSERT INTO Countries VALUES ('NO','Norway','NORVEGE');
INSERT INTO Countries VALUES ('OM','Oman','OMAN');
INSERT INTO Countries VALUES ('PK','Pakistan','PAKISTAN');
INSERT INTO Countries VALUES ('PW','Palau','PALAU');
INSERT INTO Countries VALUES ('PS','Palestine','');
INSERT INTO Countries VALUES ('PA','Panama','PANAMA');
INSERT INTO Countries VALUES ('PG','Papua New Guinea','PAPOUASIE NOUVELLE GUINEE');
INSERT INTO Countries VALUES ('PY','Paraguay','PARAGUAY');
INSERT INTO Countries VALUES ('PE','Peru','PEROU');
INSERT INTO Countries VALUES ('PH','Philippines','PHILIPPINES');
INSERT INTO Countries VALUES ('PN','Pitcairn','PITCAIRN');
INSERT INTO Countries VALUES ('PL','Poland','POLOGNE');
INSERT INTO Countries VALUES ('PT','Portugal','PORTUGAL');
INSERT INTO Countries VALUES ('PR','Puerto Rico','PORTO RICO');
INSERT INTO Countries VALUES ('QA','Qatar','QATAR');
INSERT INTO Countries VALUES ('RE','Reunion','REUNION');
INSERT INTO Countries VALUES ('RO','Romania','ROUMANIE');
INSERT INTO Countries VALUES ('RU','Russian Federation','RUSSIE');
INSERT INTO Countries VALUES ('RW','Rwanda','RWANDA');
INSERT INTO Countries VALUES ('SH','Saint Helena','ST. HELENE');
INSERT INTO Countries VALUES ('KN','Saint Kitts And Nevis','');
INSERT INTO Countries VALUES ('LC','Saint Lucia','');
INSERT INTO Countries VALUES ('PM','Saint Pierre and Miquelon','ST. PIERRE ET MIQUELON');
INSERT INTO Countries VALUES ('VC','Saint Vincent and The Grenadines','SAINT VINCENT ET GRENADINES');
INSERT INTO Countries VALUES ('WS','Samoa','SAMOA');
INSERT INTO Countries VALUES ('SM','San Marino','SAINT MARIN');
INSERT INTO Countries VALUES ('ST','Sao Tome and Principe','SAO TOME ET PRINCIPE');
INSERT INTO Countries VALUES ('SA','Saudi Arabia','ARABIE SAOUDITE');
INSERT INTO Countries VALUES ('SN','Senegal','SENEGAL');
INSERT INTO Countries VALUES ('SC','Seychelles','SEYCHELLES');
INSERT INTO Countries VALUES ('SL','Sierra Leone','SIERRA LEONE');
INSERT INTO Countries VALUES ('SG','Singapore','SINGAPOUR');
INSERT INTO Countries VALUES ('SK','Slovakia','SLOVAQUIE');
INSERT INTO Countries VALUES ('SI','Slovenia','SLOVENIE');
INSERT INTO Countries VALUES ('SB','Solomon Islands','');
INSERT INTO Countries VALUES ('SO','Somalia','SOMALIE');
INSERT INTO Countries VALUES ('ZA','South Africa','AFRIQUE DU SUD');
INSERT INTO Countries VALUES ('GS','South Georgia and The Sandwich Islands','');
INSERT INTO Countries VALUES ('ES','Spain','ESPAGNE');
INSERT INTO Countries VALUES ('LK','Sri Lanka','SRI LANKA');
INSERT INTO Countries VALUES ('SD','Sudan','SOUDAN');
INSERT INTO Countries VALUES ('SR','Suriname','SURINAM');
INSERT INTO Countries VALUES ('SJ','Svalbard and Jan Mayen Islands','');
INSERT INTO Countries VALUES ('SZ','Swaziland','SWAZILAND');
INSERT INTO Countries VALUES ('SE','Sweden','');
INSERT INTO Countries VALUES ('CH','Switzerland','SUISSE');
INSERT INTO Countries VALUES ('SY','Syrian Arab Republic','SIRYE');
INSERT INTO Countries VALUES ('TW','Taiwan, Province Of China','TAIWAN');
INSERT INTO Countries VALUES ('TJ','Tajikista','TAJIKISTAN');
INSERT INTO Countries VALUES ('TZ','Tanzania, United Republic Of','TANZANIE');
INSERT INTO Countries VALUES ('TH','Thailand','THAILANDE');
INSERT INTO Countries VALUES ('TG','Togo','TOGO');
INSERT INTO Countries VALUES ('TK','Tokelau','');
INSERT INTO Countries VALUES ('TO','Tonga','TONGA');
INSERT INTO Countries VALUES ('TT','Trinidad and Tobago','TRINITE ET TOBAGO');
INSERT INTO Countries VALUES ('TN','Tunisia','TUNISIE');
INSERT INTO Countries VALUES ('TR','Turkey','TURQUIE');
INSERT INTO Countries VALUES ('TM','Turkmenistan','TURKMENISTAN');
INSERT INTO Countries VALUES ('TC','Turks and Caicos Islands','ILES TURKS ET CAIQUES');
INSERT INTO Countries VALUES ('TV','Tuvalu','TUVALU');
INSERT INTO Countries VALUES ('UG','Uganda','OUGANDA');
INSERT INTO Countries VALUES ('UA','Ukraine','UKRAINE');
INSERT INTO Countries VALUES ('AE','United Arab Emirates','EMIRATS ARABES UNIS');
INSERT INTO Countries VALUES ('UK','United Kingdom','ROYAUME UNI');
INSERT INTO Countries VALUES ('US','United States','ETATS UNIS');
INSERT INTO Countries VALUES ('UM','United States Minor Outlying Islands','');
INSERT INTO Countries VALUES ('UY','Uruguay','URUGUAY');
INSERT INTO Countries VALUES ('SU','USSR','');
INSERT INTO Countries VALUES ('UZ','Uzbekistan','OUZBEKISTAN');
INSERT INTO Countries VALUES ('VU','Vanuatu','VANUATU');
INSERT INTO Countries VALUES ('VA','Vatican City State','VATICAN');
INSERT INTO Countries VALUES ('VE','Venezuela','VENEZUELA');
INSERT INTO Countries VALUES ('VN','Vietnam','VIET NAM');
INSERT INTO Countries VALUES ('VG','Virgin Islands (British)','');
INSERT INTO Countries VALUES ('VI','Virgin Islands (U.S.)','');
INSERT INTO Countries VALUES ('WF','Wallis and Futuna Islands','WALLIS ET FUTUNA');
INSERT INTO Countries VALUES ('WG','West Bank and Gaza','');
INSERT INTO Countries VALUES ('EH','Western Sahara','');
INSERT INTO Countries VALUES ('YE','Yemen, Republic of','YEMEN');
INSERT INTO Countries VALUES ('YU','Yugoslavia','YOUGOSLAVIE');
INSERT INTO Countries VALUES ('ZR','Zaire','');
INSERT INTO Countries VALUES ('ZM','Zambia','ZAMBIE');
INSERT INTO Countries VALUES ('ZW','Zimbabwe','ZIMBABWE');

#
# Table structure for table 'Coupons'
#

CREATE TABLE Coupons (
  coupon varchar(32) NOT NULL default '',
  amount decimal(9,2) NOT NULL default '0.00',
  active enum('Y','N') default NULL,
  active_from date NOT NULL default '2001-01-01',
  active_to date NOT NULL default '2001-01-01',
  PRIMARY KEY  (coupon)
) TYPE=MyISAM;

#
# Dumping data for table 'Coupons'
#

INSERT INTO Coupons VALUES ('andy',20.00,'Y','2001-01-01','2004-01-01');
INSERT INTO Coupons VALUES ('elliott',60.00,'Y','2001-01-01','2004-01-01');
INSERT INTO Coupons VALUES ('elliott40',40.00,'Y','2001-01-01','2004-01-01');
INSERT INTO Coupons VALUES ('elliott100',100.00,'Y','2001-01-01','2004-01-01');

#
# Table structure for table 'CreditCompanies'
#

CREATE TABLE CreditCompanies (
  CompanyID int(11) NOT NULL auto_increment,
  Company varchar(128) default '',
  PRIMARY KEY  (CompanyID)
) TYPE=MyISAM;

#
# Dumping data for table 'CreditCompanies'
#

INSERT INTO CreditCompanies VALUES (1,'Visa');
INSERT INTO CreditCompanies VALUES (2,'MasterCard');
INSERT INTO CreditCompanies VALUES (3,'American Express');
INSERT INTO CreditCompanies VALUES (4,'Diners Club');
INSERT INTO CreditCompanies VALUES (5,'EuroCard');
INSERT INTO CreditCompanies VALUES (6,'JCB');
INSERT INTO CreditCompanies VALUES (7,'IsraCard');
INSERT INTO CreditCompanies VALUES (8,'Discover');

#
# Table structure for table 'PaymentSystems'
#

CREATE TABLE PaymentSystems (
  Name varchar(32) NOT NULL default '',
  Priority int(11) NOT NULL default '7',
  ForbiddenVatOption varchar(32) NOT NULL default 'none',
  VatZone text NOT NULL,
  Multicurrency enum('N','Y') default 'Y',
  Active enum('N','Y') default 'Y',
  MaxAmount int(11) NOT NULL default '1000',
  CreditCompanies varchar(255) NOT NULL default '',
  PRIMARY KEY  (Name)
) TYPE=MyISAM;

#
# Dumping data for table 'PaymentSystems'
#

INSERT INTO PaymentSystems VALUES ('WorldPay',1,'none','Afghanistan~17.5:Albania~17.5:Algeria~17.5:American Samoa~17.5:Andorra~17.5:Angola~17.5:Anguilla~17.5:Antarctica~17.5:Antigua And Barbuda~17.5:Argentina~17.5:Armenia~17.5:Aruba~17.5:Australia~17.5:Austria~17.5:Azerbaijan~17.5:Bahamas~17.5:Bahrain~17.5:Bangladesh~17.5:Barbados~17.5:Belarus~17.5:Belgium~17.5:Belize~17.5:Benin~17.5:Bermuda~17.5:Bhutan~17.5:Bolivia~17.5:Bosnia Hercegovina~17.5:Botswana~17.5:Bouvet Island~17.5:Brazil~17.5:British Indian Ocean Territory~17.5:Brunei Darussalam~17.5:Bulgaria~17.5:Burkina Faso~17.5:Burundi~17.5:Cambodia~17.5:Cameroon~17.5:Canada~17.5:Cape Verde~17.5:Cayman Islands~17.5:Central African Republic~17.5:Chad~17.5:Chile~17.5:China~17.5:Christmas Island~17.5:Cocos (Keeling) Islands~17.5:Colombia~17.5:Comoros~17.5:Congo~17.5:Congo, The Democratic Republic Of~17.5:Cook Islands~17.5:Costa Rica~17.5:Croatia~17.5:Cuba~17.5:Cyprus~17.5:Czech Republic~17.5:Denmark~17.5:Djibouti~17.5:Dominica~17.5:Dominican Republic~17.5:East Timor~17.5:Ecuador~17.5:Egypt~17.5:El Salvador~17.5:Equatorial Guinea~17.5:Eritrea~17.5:Estonia~17.5:Ethiopia~17.5:Falkland Islands (Malvinas)~17.5:Faroe Islands~17.5:Fiji~17.5:Finland~17.5:France~17.5:France, Metropolitan~17.5:French Guiana~17.5:French Polynesia~17.5:French Southern Territories~17.5:Gabon~17.5:Gambia~17.5:Georgia~17.5:Germany~17.5:Ghana~17.5:Gibraltar~17.5:Greece~17.5:Greenland~17.5:Grenada~17.5:Guadeloupe~17.5:Guam~17.5:Guatemela~17.5:Guernsey~17.5:Guinea~17.5:Guinea-Bissau~17.5:Guyana~17.5:Haiti~17.5:Heard and McDonald Islands~17.5:Honduras~17.5:Hong Kong~17.5:Hungary~17.5:Iceland~17.5:India~17.5:Indonesia~17.5:Iran (Islamic Republic Of)~17.5:Iraq~17.5:Ireland~17.5:Isle Of Man~17.5:Israel~17.5:Italy~17.5:Jamaica~17.5:Japan~17.5:Jersey~17.5:Jordan~17.5:Kazakhstan~17.5:Kenya~17.5:Kiribati~17.5:Korea, Republic Of~17.5:Kuwait~17.5:Kyrgyzstan~17.5:Latvia~17.5:Lebanon~17.5:Lesotho~17.5:Liberia~17.5:Libyan Arab Jamahiriya~17.5:Liechtenstein~17.5:Lithuania~17.5:Luxembourg~17.5:Macau~17.5:Macedonia~17.5:Madagascar~17.5:Malawi~17.5:Malaysia~17.5:Maldives~17.5:Mali~17.5:Malta~17.5:Marshall Islands~17.5:Martinique~17.5:Mauritania~17.5:Mauritius~17.5:Mayotte~17.5:Mexico~17.5:Micronesia, Federated States Of~17.5:Moldova, Republic Of~17.5:Monaco~17.5:Mongolia~17.5:Montserrat~17.5:Morocco~17.5:Mozambique~17.5:Myanmar~17.5:Namibia~17.5:Nauru~17.5:Nepal~17.5:Netherlands~17.5:Netherlands Antilles~17.5:New Caledonia~17.5:New Zealand~17.5:Nicaragua~17.5:Niger~17.5:Nigeria~17.5:Niue~17.5:Norfolk Island~17.5:Northern Mariana Islands~17.5:Norway~17.5:Oman~17.5:Pakistan~17.5:Palau~17.5:Palestine~17.5:Panama~17.5:Papua New Guinea~17.5:Paraguay~17.5:Peru~17.5:Philippines~17.5:Pitcairn~17.5:Poland~17.5:Portugal~17.5:Puerto Rico~17.5:Qatar~17.5:Reunion~17.5:Romania~17.5:Russian Federation~17.5:Rwanda~17.5:Saint Helena~17.5:Saint Kitts And Nevis~17.5:Saint Lucia~17.5:Saint Pierre and Miquelon~17.5:Saint Vincent and The Grenadines~17.5:Samoa~17.5:San Marino~17.5:Sao Tome and Principe~17.5:Saudi Arabia~17.5:Senegal~17.5:Seychelles~17.5:Sierra Leone~17.5:Singapore~17.5:Slovakia~17.5:Slovenia~17.5:Solomon Islands~17.5:Somalia~17.5:South Africa~17.5:South Georgia and The Sandwich Islands~17.5:Spain~17.5:Sri Lanka~17.5:Sudan~17.5:Suriname~17.5:Svalbard and Jan Mayen Islands~17.5:Swaziland~17.5:Sweden~17.5:Switzerland~17.5:Syrian Arab Republic~17.5:Taiwan, Province Of China~17.5:Tajikista~17.5:Tanzania, United Republic Of~17.5:Thailand~17.5:Togo~17.5:Tokelau~17.5:Tonga~17.5:Trinidad and Tobago~17.5:Tunisia~17.5:Turkey~17.5:Turkmenistan~17.5:Turks and Caicos Islands~17.5:Tuvalu~17.5:Uganda~17.5:Ukraine~17.5:United Arab Emirates~17.5:United Kingdom~17.5:United States~17.5:United States Minor Outlying Islands~17.5:Uruguay~17.5:Uzbekistan~17.5:Vanuatu~17.5:Vatican City State~17.5:Venezuela~17.5:Vietnam~17.5:Virgin Islands (British)~17.5:Virgin Islands (U.S.)~17.5:Wallis and Futuna Islands~17.5:West Bank and Gaza~17.5:Western Sahara~17.5:Yemen, Republic of~17.5:Yugoslavia~17.5:Zaire~17.5:Zambia~17.5:Zimbabwe~17.5','N','Y',2000,'Visa:MasterCard');
INSERT INTO PaymentSystems VALUES ('LinkPoint',5,'none','Israel~18','N','Y',2500,'Visa:MasterCard');

#
# Table structure for table 'Profiles'
#

CREATE TABLE Profiles (
  email varchar(128) NOT NULL default '',
  password varchar(16) NOT NULL default '',
  account_type varchar(16) NOT NULL default 'USER',
  first_name varchar(60) NOT NULL default '',
  last_name varchar(60) NOT NULL default '',
  org_name varchar(255) NOT NULL default '',
  address1 varchar(255) NOT NULL default '',
  address2 varchar(255) NOT NULL default '',
  address3 varchar(255) NOT NULL default '',
  city varchar(128) NOT NULL default '',
  state varchar(128) NOT NULL default '',
  postal_code varchar(10) NOT NULL default '',
  country varchar(60) NOT NULL default '',
  phone varchar(64) NOT NULL default '',
  fax varchar(64) NOT NULL default '',
  cookie varchar(64) NOT NULL default '',
  PRIMARY KEY  (email),
  KEY email (email),
  KEY password (password)
) TYPE=MyISAM;

#
# Dumping data for table 'Profiles'
#


#
# Table structure for table 'Properties'
#

CREATE TABLE Properties (
  Name varchar(30) NOT NULL default '',
  Class enum('OWNER','REGISTRAR','SYSTEM','PRICES') NOT NULL default 'OWNER',
  Value varchar(255) NOT NULL default ''
) TYPE=MyISAM;

#
# Dumping data for table 'Properties'
#

INSERT INTO Properties VALUES ('WorldPay','SYSTEM','999');
INSERT INTO Properties VALUES ('test','PRICES','124');