-- http://www.phpmyadmin.net
--




--
-- Database: `voxappeabasone`
--

-- --------------------------------------------------------

--
-- Table structure for table `supplier`
--

CREATE TABLE IF NOT EXISTS `supplier` (
  `Number` int(6) unsigned zerofill NOT NULL auto_increment,
  `Surname` varchar(30) character set utf8 collate utf8_unicode_ci NOT NULL,
  `Name` varchar(30) character set utf8 collate utf8_unicode_ci NOT NULL,
  `Username` varchar(20) character set utf8 collate utf8_unicode_ci NOT NULL,
  `Userpass` varchar(12) character set utf8 collate utf8_unicode_ci NOT NULL,
  `email` varchar(30) character set utf8 collate utf8_unicode_ci NOT NULL,
  `email2` varchar(30) character set utf8 collate utf8_unicode_ci NOT NULL,
  `email3` varchar(30) character set utf8 collate utf8_unicode_ci NOT NULL,
  `Natlang` enum('Afrikaans','Albanian','Armenian','Arabic','Azarian','Balochi','Basque','Bengali','Berber','Bosnian','Breton','Bulgaria','Cambodian','Catalan','Chinese (Mandarin)','Chinese (traditional)','Corsican','Croatian','Czech','Danish','Dari','Dutch','English','UK English','US English','Estonian','Farsi','Finnish','Flemish (Belgian)','French','German','Greek','Gujarati','Hebrew','Hindi','Hungarian','Indonesian','Icelandic','Irish','Italian','Japanese','Kabyle','Kazakh','Khmer','Korean','Kurdish','Latvian','Lithuanian','Macedonian','Malay','Malagasy','Norwegian','Pashto','Persian','Polish','Portugese (Portugal)','Portugese (Brazil)','Punjabi','Romanian','Russian','Scots Gaelic','Serbian','Slovakian','Slovenian','Spanish','Castilian Spanish','S. Am. Spanish','Swahili','Swedish','Tamil','Thai','Turkish','Ukrainian','Urdu','Vietnamese','Walloon','Zulu','other') character set utf8 collate utf8_unicode_ci NOT NULL,
  `Natlang2` enum('Afrikaans','Albanian','Armenian','Arabic','Azarian','Balochi','Basque','Bengali','Berber','Bosnian','Breton','Bulgaria','Cambodian','Catalan','Chinese (Mandarin)','Chinese (traditional)','Corsican','Croatian','Czech','Danish','Dari','Dutch','English','UK English','US English','Estonian','Farsi','Finnish','Flemish (Belgian)','French','German','Greek','Gujarati','Hebrew','Hindi','Hungarian','Indonesian','Icelandic','Irish','Italian','Japanese','Kabyle','Kazakh','Khmer','Korean','Kurdish','Latvian','Lithuanian','Macedonian','Malay','Malagasy','Norwegian','Pashto','Persian','Polish','Portugese (Portugal)','Portugese (Brazil)','Punjabi','Romanian','Russian','Scots Gaelic','Serbian','Slovakian','Slovenian','Spanish','Castilian Spanish','S. Am. Spanish','Swahili','Swedish','Tamil','Thai','Turkish','Ukrainian','Urdu','Vietnamese','Walloon','Zulu','other') character set utf8 collate utf8_unicode_ci NOT NULL,
  `ComLang` enum('English','Français','Español') NOT NULL default 'Français',
  `tel` varchar(20) NOT NULL,
  `teltype` enum('land','mob','web') NOT NULL default 'land',
  `tel2` varchar(20) NOT NULL,
  `teltype2` enum('land','mob','web') NOT NULL default 'mob',
  `tel3` varchar(20) NOT NULL,
  `teltype3` enum('land','mob','web') NOT NULL default 'web',
  `fax` varchar(20) NOT NULL,
  `country` varchar(30) NOT NULL,
  `adr1` varchar(50) NOT NULL,
  `adr2` varchar(50) NOT NULL,
  `adr3` varchar(50) NOT NULL,
  `cp` varchar(15) NOT NULL,
  `url` varchar(60) NOT NULL,
  `sex` enum('M','F') NOT NULL,
  `age` enum('<24','25-34','35-44','45-54','55-64','>65','noage') NOT NULL,
  `currency` enum('€','US$','UK£') NOT NULL default '€',
  `skill1` enum('translation','proofreading','editing','writing','voiceover','subtitling','localisation','consecutive interpreting','simultaneous interpreting','liaison interpreting','DTP','transcription','copywriting','audio/video tech','other') NOT NULL,
  `src1` enum('Afrikaans','Albanian','Armenian','Arabic','Azarian','Balochi','Basque','Bengali','Berber','Bosnian','Breton','Bulgaria','Cambodian','Catalan','Chinese (Mandarin)','Chinese (traditional)','Corsican','Croatian','Czech','Danish','Dari','Dutch','English','UK English','US English','Estonian','Farsi','Finnish','Flemish (Belgian)','French','German','Greek','Gujarati','Hebrew','Hindi','Hungarian','Indonesian','Icelandic','Irish','Italian','Japanese','Kabyle','Kazakh','Khmer','Korean','Kurdish','Latvian','Lithuanian','Macedonian','Malay','Malagasy','Norwegian','Pashto','Persian','Polish','Portugese (Portugal)','Portugese (Brazil)','Punjabi','Romanian','Russian','Scots Gaelic','Serbian','Slovakian','Slovenian','Spanish','Castilian Spanish','S. Am. Spanish','Swahili','Swedish','Tamil','Thai','Turkish','Ukrainian','Urdu','Vietnamese','Walloon','Zulu','other') NOT NULL,
  `tgt1` enum('Afrikaans','Albanian','Armenian','Arabic','Azarian','Balochi','Basque','Bengali','Berber','Bosnian','Breton','Bulgaria','Cambodian','Catalan','Chinese (Mandarin)','Chinese (traditional)','Corsican','Croatian','Czech','Danish','Dari','Dutch','English','UK English','US English','Estonian','Farsi','Finnish','Flemish (Belgian)','French','German','Greek','Gujarati','Hebrew','Hindi','Hungarian','Indonesian','Icelandic','Irish','Italian','Japanese','Kabyle','Kazakh','Khmer','Korean','Kurdish','Latvian','Lithuanian','Macedonian','Malay','Malagasy','Norwegian','Pashto','Persian','Polish','Portugese (Portugal)','Portugese (Brazil)','Punjabi','Romanian','Russian','Scots Gaelic','Serbian','Slovakian','Slovenian','Spanish','Castilian Spanish','S. Am. Spanish','Swahili','Swedish','Tamil','Thai','Turkish','Ukrainian','Urdu','Vietnamese','Walloon','Zulu','other') NOT NULL,
  `tarif1` decimal(10,0) unsigned NOT NULL,
  `skill2` enum('translation','proofreading','editing','writing','voiceover','subtitling','localisation','consecutive interpreting','simultaneous interpreting','liaison interpreting','DTP','transcription','copywriting','audio/video tech','other') NOT NULL,
  `src2` enum('Afrikaans','Albanian','Armenian','Arabic','Azarian','Balochi','Basque','Bengali','Berber','Bosnian','Breton','Bulgaria','Cambodian','Catalan','Chinese (Mandarin)','Chinese (traditional)','Corsican','Croatian','Czech','Danish','Dari','Dutch','English','UK English','US English','Estonian','Farsi','Finnish','Flemish (Belgian)','French','German','Greek','Gujarati','Hebrew','Hindi','Hungarian','Indonesian','Icelandic','Irish','Italian','Japanese','Kabyle','Kazakh','Khmer','Korean','Kurdish','Latvian','Lithuanian','Macedonian','Malay','Malagasy','Norwegian','Pashto','Persian','Polish','Portugese (Portugal)','Portugese (Brazil)','Punjabi','Romanian','Russian','Scots Gaelic','Serbian','Slovakian','Slovenian','Spanish','Castilian Spanish','S. Am. Spanish','Swahili','Swedish','Tamil','Thai','Turkish','Ukrainian','Urdu','Vietnamese','Walloon','Zulu','other') NOT NULL,
  `tgt2` enum('Afrikaans','Albanian','Armenian','Arabic','Azarian','Balochi','Basque','Bengali','Berber','Bosnian','Breton','Bulgaria','Cambodian','Catalan','Chinese (Mandarin)','Chinese (traditional)','Corsican','Croatian','Czech','Danish','Dari','Dutch','English','UK English','US English','Estonian','Farsi','Finnish','Flemish (Belgian)','French','German','Greek','Gujarati','Hebrew','Hindi','Hungarian','Indonesian','Icelandic','Irish','Italian','Japanese','Kabyle','Kazakh','Khmer','Korean','Kurdish','Latvian','Lithuanian','Macedonian','Malay','Malagasy','Norwegian','Pashto','Persian','Polish','Portugese (Portugal)','Portugese (Brazil)','Punjabi','Romanian','Russian','Scots Gaelic','Serbian','Slovakian','Slovenian','Spanish','Castilian Spanish','S. Am. Spanish','Swahili','Swedish','Tamil','Thai','Turkish','Ukrainian','Urdu','Vietnamese','Walloon','Zulu','other') NOT NULL,
  `tarif2` decimal(10,0) unsigned NOT NULL,
  `skill3` enum('translation','proofreading','editing','writing','voiceover','subtitling','localisation','consecutive interpreting','simultaneous interpreting','liaison interpreting','DTP','transcription','copywriting','audio/video tech','other') NOT NULL,
  `src3` enum('Afrikaans','Albanian','Armenian','Arabic','Azarian','Balochi','Basque','Bengali','Berber','Bosnian','Breton','Bulgaria','Cambodian','Catalan','Chinese (Mandarin)','Chinese (traditional)','Corsican','Croatian','Czech','Danish','Dari','Dutch','English','UK English','US English','Estonian','Farsi','Finnish','Flemish (Belgian)','French','German','Greek','Gujarati','Hebrew','Hindi','Hungarian','Indonesian','Icelandic','Irish','Italian','Japanese','Kabyle','Kazakh','Khmer','Korean','Kurdish','Latvian','Lithuanian','Macedonian','Malay','Malagasy','Norwegian','Pashto','Persian','Polish','Portugese (Portugal)','Portugese (Brazil)','Punjabi','Romanian','Russian','Scots Gaelic','Serbian','Slovakian','Slovenian','Spanish','Castilian Spanish','S. Am. Spanish','Swahili','Swedish','Tamil','Thai','Turkish','Ukrainian','Urdu','Vietnamese','Walloon','Zulu','other') NOT NULL,
  `tgt3` enum('Afrikaans','Albanian','Armenian','Arabic','Azarian','Balochi','Basque','Bengali','Berber','Bosnian','Breton','Bulgaria','Cambodian','Catalan','Chinese (Mandarin)','Chinese (traditional)','Corsican','Croatian','Czech','Danish','Dari','Dutch','English','UK English','US English','Estonian','Farsi','Finnish','Flemish (Belgian)','French','German','Greek','Gujarati','Hebrew','Hindi','Hungarian','Indonesian','Icelandic','Irish','Italian','Japanese','Kabyle','Kazakh','Khmer','Korean','Kurdish','Latvian','Lithuanian','Macedonian','Malay','Malagasy','Norwegian','Pashto','Persian','Polish','Portugese (Portugal)','Portugese (Brazil)','Punjabi','Romanian','Russian','Scots Gaelic','Serbian','Slovakian','Slovenian','Spanish','Castilian Spanish','S. Am. Spanish','Swahili','Swedish','Tamil','Thai','Turkish','Ukrainian','Urdu','Vietnamese','Walloon','Zulu','other') NOT NULL,
  `tarif3` decimal(10,0) unsigned NOT NULL,
  `tarifunit1` enum('word','hour','day','half-day','minute a/v','act','other') NOT NULL,
  `tarifunit2` enum('word','hour','day','half-day','minute a/v','act','other') NOT NULL,
  `tarifunit3` enum('word','hour','day','half-day','minute a/v','act','other') NOT NULL,
  `fields` enum('Food/farming','Arts','Automobile','Commerce','Communication','Data processing','General','Legal','Literature','Marine','Medical/pharmaceutical','Publishing','Sworn','Technical','Tourism','Writing','Other') NOT NULL,
  `nofields` set('Food/farming','Arts','Automobile','Commerce','Communication','Data processing','General','Legal','Literature','Marine','Medical/pharmaceutical','Publishing','Sworn','Technical','Tourism','Writing','Other') NOT NULL,
  `date` date NOT NULL,
  `updated` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  UNIQUE KEY `Number` (`Number`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `supplier`
--

INSERT INTO `supplier` (`Number`, `Surname`, `Name`, `Username`, `Userpass`, `email`, `email2`, `email3`, `Natlang`, `Natlang2`, `ComLang`, `tel`, `teltype`, `tel2`, `teltype2`, `tel3`, `teltype3`, `fax`, `country`, `adr1`, `adr2`, `adr3`, `cp`, `url`, `sex`, `age`, `currency`, `skill1`, `src1`, `tgt1`, `tarif1`, `skill2`, `src2`, `tgt2`, `tarif2`, `skill3`, `src3`, `tgt3`, `tarif3`, `tarifunit1`, `tarifunit2`, `tarifunit3`, `fields`, `nofields`, `date`, `updated`) VALUES
(000001, 'SOLAN', 'Kevin', 'Solan', '96mar14', 'info@voxappeal.com', 'info@traduisons.com', '', 'English', 'French', 'English', '0223301365', 'land', '0670980005', 'mob', 'traduisons', 'web', '0299785051', 'FRANCE', '6 sq des hautes ourmes', '', '', '35200', 'www.voxappeal.com/', 'M', '45-54', '€', 'audio/video tech', '', '', 35, 'subtitling', 'French', 'English', 7, 'translation', 'French', 'English', 1, 'hour', 'minute a/v', 'word', 'General', 'Legal,Medical/pharmaceutical', '2008-11-19', '2008-11-19 17:54:28');
