--
-- Host: abisseesupport.mysql.db    Database: abisseesupport
-- ------------------------------------------------------


--
-- Table structure for table `tagencies`
--

CREATE TABLE `tagencies` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `mail` varchar(100) NOT NULL,
  `ldap_guid` varchar(50) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tagencies`
--

INSERT INTO `tagencies` VALUES (0,'Aucune','','',0);

--
-- Table structure for table `tassets`
--

CREATE TABLE `tassets` (
  `id` int(15) NOT NULL AUTO_INCREMENT,
  `sn_internal` varchar(20) NOT NULL,
  `sn_manufacturer` varchar(40) NOT NULL,
  `sn_indent` varchar(40) NOT NULL,
  `netbios` varchar(30) NOT NULL,
  `description` varchar(500) NOT NULL,
  `type` int(5) NOT NULL,
  `manufacturer` int(5) NOT NULL,
  `model` int(5) NOT NULL,
  `user` int(5) NOT NULL,
  `state` int(5) NOT NULL,
  `department` int(5) NOT NULL,
  `date_install` date NOT NULL,
  `date_stock` date NOT NULL,
  `date_standbye` date NOT NULL,
  `date_recycle` date NOT NULL,
  `date_end_warranty` date NOT NULL,
  `date_last_ping` date NOT NULL,
  `location` int(5) NOT NULL,
  `socket` varchar(50) NOT NULL,
  `technician` int(5) NOT NULL,
  `maintenance` int(10) NOT NULL,
  `virtualization` int(1) NOT NULL,
  `net_scan` int(1) NOT NULL DEFAULT '1',
  `discover_net_scan` int(1) NOT NULL,
  `discover_import_csv` int(1) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `type` (`type`),
  KEY `manufacturer` (`manufacturer`),
  KEY `model` (`model`),
  KEY `user` (`user`),
  KEY `state` (`state`),
  KEY `department` (`department`),
  KEY `location` (`location`),
  KEY `technician` (`technician`),
  KEY `maintenance` (`maintenance`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets`
--

INSERT INTO `tassets` VALUES (0,'','','','Aucun','',0,0,0,0,0,0,'0000-00-00','0000-00-00','0000-00-00','0000-00-00','0000-00-00','0000-00-00',0,'',0,0,0,1,0,0,1);

--
-- Table structure for table `tassets_iface`
--

CREATE TABLE `tassets_iface` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `role_id` int(5) NOT NULL,
  `asset_id` int(10) NOT NULL,
  `netbios` varchar(200) NOT NULL,
  `ip` varchar(45) NOT NULL,
  `mac` varchar(20) NOT NULL,
  `date_ping_ok` datetime NOT NULL,
  `date_ping_ko` datetime NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `asset_id` (`asset_id`),
  KEY `role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_iface`
--


--
-- Table structure for table `tassets_iface_role`
--

CREATE TABLE `tassets_iface_role` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(250) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_iface_role`
--

INSERT INTO `tassets_iface_role` VALUES (1,'LAN',0),(2,'WIFI',0);

--
-- Table structure for table `tassets_location`
--

CREATE TABLE `tassets_location` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_location`
--

INSERT INTO `tassets_location` VALUES (0,'Aucune',0);

--
-- Table structure for table `tassets_manufacturer`
--

CREATE TABLE `tassets_manufacturer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_manufacturer`
--

INSERT INTO `tassets_manufacturer` VALUES (1,'Dell');

--
-- Table structure for table `tassets_model`
--

CREATE TABLE `tassets_model` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `type` int(5) NOT NULL,
  `manufacturer` int(5) NOT NULL,
  `image` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `ip` int(1) NOT NULL,
  `wifi` int(1) NOT NULL,
  `warranty` int(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_model`
--

INSERT INTO `tassets_model` VALUES (1,1,1,'3020.jpg','Optiplex 3020',1,0,3);

--
-- Table structure for table `tassets_network`
--

CREATE TABLE `tassets_network` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `network` varchar(45) NOT NULL,
  `netmask` varchar(45) NOT NULL,
  `scan` int(1) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_network`
--


--
-- Table structure for table `tassets_state`
--

CREATE TABLE `tassets_state` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `order` int(3) NOT NULL,
  `name` varchar(20) NOT NULL,
  `description` varchar(50) NOT NULL,
  `block_ip_search` int(1) NOT NULL,
  `disable` int(1) NOT NULL,
  `display` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_state`
--

INSERT INTO `tassets_state` VALUES (1,1,'Stock','Équipement en stock',0,0,'badge text-75 border-l-3 brc-black-tp8 bgc-info text-white'),(2,2,'Installé','Équipement installé en production',1,0,'badge text-75 border-l-3 brc-black-tp8 bgc-success text-white'),(3,3,'Standbye','Équipement de coté',0,0,'badge text-75 border-l-3 brc-black-tp8 bgc-warning text-white'),(4,4,'Recyclé','Équipement recyclé, jeté',0,0,'badge text-75 border-l-3 brc-black-tp8 bgc-dark text-white');

--
-- Table structure for table `tassets_thread`
--

CREATE TABLE `tassets_thread` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `asset` int(10) NOT NULL,
  `text` varchar(5000) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_thread`
--


--
-- Table structure for table `tassets_type`
--

CREATE TABLE `tassets_type` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `virtualization` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tassets_type`
--

INSERT INTO `tassets_type` VALUES (1,'PC',0);

--
-- Table structure for table `tattachments`
--

CREATE TABLE `tattachments` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) NOT NULL,
  `ticket_id` int(10) NOT NULL,
  `procedure_id` int(10) NOT NULL,
  `asset_id` int(10) NOT NULL,
  `storage_filename` varchar(255) NOT NULL,
  `real_filename` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `procedure_id` (`procedure_id`),
  KEY `asset_id` (`asset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tattachments`
--


--
-- Table structure for table `tavailability`
--

CREATE TABLE `tavailability` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `category` int(5) NOT NULL,
  `subcat` int(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category` (`category`),
  KEY `subcat` (`subcat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tavailability`
--


--
-- Table structure for table `tavailability_dep`
--

CREATE TABLE `tavailability_dep` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `category` int(5) NOT NULL,
  `subcat` int(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category` (`category`),
  KEY `subcat` (`subcat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tavailability_dep`
--


--
-- Table structure for table `tavailability_target`
--

CREATE TABLE `tavailability_target` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `subcat` int(5) NOT NULL,
  `target` float NOT NULL,
  `year` int(4) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `subcat` (`subcat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tavailability_target`
--


--
-- Table structure for table `tcategory`
--

CREATE TABLE `tcategory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number` int(2) NOT NULL,
  `name` varchar(50) NOT NULL,
  `service` int(5) NOT NULL,
  `technician` int(10) NOT NULL,
  `technician_group` int(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `technician` (`technician`),
  KEY `technician_group` (`technician_group`),
  KEY `service` (`service`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tcategory`
--

INSERT INTO `tcategory` VALUES (0,0,'Aucune',0,0,0),(4,0,'INFORMATIQUE',0,0,11),(5,0,'COPIEUR',0,0,0),(6,0,'COMMANDE',0,0,0);

--
-- Table structure for table `tcompany`
--

CREATE TABLE `tcompany` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  `address` varchar(50) NOT NULL,
  `zip` varchar(10) NOT NULL,
  `city` varchar(50) NOT NULL,
  `country` varchar(100) NOT NULL,
  `SIRET` varchar(20) NOT NULL,
  `TVA` varchar(20) NOT NULL,
  `limit_ticket_number` int(5) NOT NULL DEFAULT '0',
  `limit_ticket_days` int(5) NOT NULL,
  `limit_ticket_date_start` date NOT NULL,
  `limit_hour_number` int(5) NOT NULL,
  `limit_hour_days` int(5) NOT NULL,
  `limit_hour_date_start` date NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1120 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tcompany`
--

INSERT INTO `tcompany` VALUES (0,'Aucune','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1,'  HEXADIS SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(2,' BOUTICOURT EMILIEN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(3,' MONSIEUR  VANDYCK  Philippe','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(4,' SOLUSTIL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(5,'1962 SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(6,'5EME ELEMENT IMMOBILIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(7,'A2S TRANSPORTS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(8,'A.BUREAUTIQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(9,'A.C.M','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(10,'A.D.  MAJORIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(11,'A.E.P','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(12,'A.G.C','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(13,'A.L.C.T.E.A.T','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(14,'A.L.C.T.J','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(15,'A.L.C.T.J  OULLINS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(16,'A.L.C.T.J.B.J','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(17,'A.M.P','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(18,'A.O.M.T','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(19,'A.P.3.C','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(20,'A.P.C.CONFECTION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(21,'A.S.C IMMOBILIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(22,'ABR PAYSAGISTE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(23,'ACPR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(24,'ADEOM','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(25,'AEP VIOLAY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(26,'AFFLELOU','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(27,'AG MAXX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(28,'AGIS S.A','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(29,'AGIS SAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(30,'AIDE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(31,'ALAIN LABAUMAZ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(32,'ALBERT DUPEUBLE NETTOYAGE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(33,'ALEX AUTOS NET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(34,'ALEX\' AUTO NET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(35,'ALLIANCE BOIS METAL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(36,'ALPES BOURGOGNE AUTOMOBILES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(37,'ALPES BOURGOGNE AUTOMOBILES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(38,'ALPHA NUMERIC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(39,'Alternup Medical','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(40,'AMALVY  CADRES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(41,'AMAR PATRICK','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(42,'AMBULANCES SIROT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(43,'AMBULANCES ST LAURENTAISE MEDICAL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(44,'ANG AUTOMOBILES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(45,'ANNE SUBTIL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(46,'ANTHONY SEGURA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(47,'APICIL ANIMATION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(48,'APOLY  PRO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(49,'APRAT-VILLAVIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(50,'ARC EN CIEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(51,'ARCAD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(52,'ARCHITECTE GAILLARD GREGOIRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(53,'ARCHITECTE Isabelle MARION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(54,'ARDEKO IMMOBILIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(55,'ARGEOL SELAS ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(56,'ARMAND METAL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(57,'ARVIX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(58,'AS ET FENETRES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(59,'AS PLOMBERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(60,'AS RESINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(61,'AS RESINES PERE ET FILS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(62,'AS.T.RISK','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(63,'ASS.ATHLETIC SPORT TARARE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(64,'ASS.T.RISK','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(65,'ASSOCIATION CULTUELLE LES TEMOINS DE JEHOVAH','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(66,'ASSOCIATION DE LA ROCHE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(67,'ASSOCIATION FANFARE DE TARARE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(68,'ASSOCIATION LA FARANDOLE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(69,'ASSOCIATION LES POETES DU PAYS DU PAYS DE LOIRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(70,'ASSOCIATION LES TEMOINS DE JEHOVAH','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(71,'ASSOCIATION REUSSIR POUR VOUS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(72,'ASSOCIATION TEMOINS DE JEHOVAH','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(73,'ASSOCIATION TEMOINS DE JEHOVAH','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(74,'ASSOCIATION TEMOINS DE JEHOVAH LYON SUD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(75,'ASSOCIATION TEMOINS DE JEHOVAH LYON SUD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(76,'ASSURANCES GAUTHIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(77,'ASSURANCES LELY-CHANAY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(78,'ASSURANCES RAIMBAULT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(79,'AT\'HOME PERSPECTIVES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(80,'ATELIER ARCHITECTURE INTERIEURE - AAI','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(81,'ATELIER DE MONTROTTIER  LOIC PARMENTIER ET ASSOCIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(82,'ATELIER DES BOULANGERS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(83,'ATELIER MACO BOIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(84,'ATI','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(85,'ATI','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(86,'ATRE SERVICES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(87,'AU FIL D\'OR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(88,'AUBERGE DU CHATEAU','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(89,'AUBERGE DU PITAVAL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(90,'AUBONNET & FILS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(91,'AUDIT BUREAU SERVICE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(92,'AUDREY BEYLIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(93,'AUSTEN EDITIONS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(94,'AUTO ECOLE BLEIN ROBELIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(95,'AUTO ECOLE CAP CONDUITE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(96,'AUTO ECOLE SAVOIE BENRABAH','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(97,'AUTOMATEX CABINET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(98,'AUTOMOBILE CLUB','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(99,'AUTOUR DU FROMAGE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(100,'AXAL BUREAUTIQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(101,'AXESSPACK SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(102,'AZAE ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(103,'AZERGUES IMMO/ GUY HOCQUET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(104,'B.B. CONSULTANT cfc','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(105,'B.B.Z  INGIENIERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(106,'B.F.G CADRE DE VIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(107,'B.H MANAGEMENT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(108,'B.H P MANAGEMENT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(109,'B.N.P PARIBAS LEASE GROUP','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(110,'B.S.M   SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(111,'BAKACHE MARIA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(112,'BALDAGO\'S MOTO CLUB','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(113,'BARBERET EXPERT AUTOMOBILES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(114,'BARBET PATRICIA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(115,'BASKET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(116,'BBZ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(117,'BEAUCHAINE ET CIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(118,'BEAUJOLAIS GOURMAND','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(119,'BEE-BIO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(120,'BEL AIR INDUSTRIES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(121,'BEN CHEIK Tahar','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(122,'BENDAOUD Yousef','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(123,'BENJAMIN GAUTHIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(124,'BENOIT LE TAPIS BROSSE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(125,'BENSALAH Karim','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(126,'BERANGERE BOIS SAMIER ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(127,'BERCHOUX PLOMBERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(128,'BERTHET SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(129,'BERTHIER Brigitte','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(130,'BERTHIER Val?rie','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(131,'BERTHOLON ET ASSOCIES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(132,'BERTHOLON SA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(133,'BESSON MARIE-HELENE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(134,'BGI CONTRUCTIONS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(135,'BIDON ARLETTE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(136,'BIDON Arlette','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(137,'BIGEARD JEAN LUC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(138,'BILLOT FREDERIC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(139,'BILLOT GERARD S.A.R.L','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(140,'BLACK SUN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(141,'BLANC ETABLISSEMENT ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(142,'BLANCHOUD EDDY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(143,'BLONDIAUX CHRISTOPHE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(144,'BNP PARIBAS LEASE GROUPE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(145,'BOINON FRANCK','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(146,'BOLLENOT DOMINIQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(147,'BONHEUR ET BIEN-ETRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(148,'BONIN SPORTS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(149,'BONNASSIEUX BRUNO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(150,'BONNASSIEUX M et Me','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(151,'BONNASSIEUX Marie Christine','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(152,'BONNET LUCIEN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(153,'BOUDON Robert','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(154,'BOURGEAY GYPSIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(155,'BOUTET PATRICE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(156,'BOZIN SONIA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(157,'BRAC DE LA PERRIERE M OU ME','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(158,'BRODERIE NOUVELLE GOTTE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(159,'BROTHER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(160,'BRUNAT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(161,'BRUNAT Abel ou christianne','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(162,'BRUNAT SOCIETE  TPF','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(163,'BUITEX RECYCLAGE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(164,'BURNICHON CAROLE ET LIONNEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(165,'BURNICHON GIT HOTEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(166,'C PRO vdi','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(167,'C\' PRO LYON','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(168,'C\'PRO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(169,'C.B.P','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(170,'C.E ENTRAIDE TARARIENNE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(171,'C.G.M','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(172,'C.G.T  GERFLOR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(173,'C.O.R','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(174,'C.P.S AUTOMATISME','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(175,'C.S.A.N','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(176,'CABANE DIDIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(177,'CABINET ASLAND','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(178,'CABINET BERNARD CHANEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(179,'CABINET CHARLES DAVAUX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(180,'CABINET DELAIRE ARCHITECTE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(181,'CABINET DENTAIRE PONCET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(182,'CABINET DES RUY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(183,'CABINET JEAN-CLAUDE JULLIARD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(184,'CABINET OPHTALMOLOGIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(185,'CAFE RESTAURANT LES BONS AMIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(186,'CAILLEUX GERARD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(187,'CALAD AJEF','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(188,'CAMPAGN IMMO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(189,'CAMPAGN\'IMMO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(190,'CAMPAGNE IMMO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(191,'CAMPING DU LAC DES SAPINS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(192,'CAP EXPERTISES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(193,'CAPELLI LUX SA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(194,'CAPELLI SA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(195,'CAPELLI SUISSE SA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(196,'CAR ET FI','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(197,'CARRASCO SERRURERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(198,'CARRAT PIERRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(199,'CARROSSERIE CONDAMIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(200,'CARROSSERIE PETIT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(201,'CARTONNAGES DE LA TURDINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(202,'CATHERINE CORGIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(203,'CECILE CLAVARON','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(204,'CECILE DUTRAIVE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(205,'CELINE BERNARD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(206,'CELLOCOUP','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(207,'CEME-SOTRELEC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(208,'CENIMIC GOBBA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(209,'CENTRE DE LA BUREAUTIQUE 93','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(210,'CENTRE DE RADIOLOGIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(211,'CENTRE HISTOIRE ET ARCHEOLOGIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(212,'CENTRE HOSPITALIER DE TARARE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(213,'CENTRE SOCIAL THOMASSIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(214,'CERAGRO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(215,'CFPL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(216,'CFPL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(217,'CG DES 2 VALLEES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(218,'CG FLUIDES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(219,'CHADIER BEATRICE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(220,'CHADIER CHRISTOPHE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(221,'CHADIER SERVICES ESPACES VERTS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(222,'CHAINE ET TRAME/ TECMODA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(223,'CHAINTREAU Lionel','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(224,'CHAMBE TRANSPORTS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(225,'CHAMBOST  SALAISON','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(226,'CHAMBOST MIREILLE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(227,'CHAMBRE SYND. DEBITANT TABAC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(228,'CHANEL COLETTE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(229,'CHANTAL GELLER ET ASSOCIES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(230,'CHARLES BEATRICE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(231,'CHARLES SIMONE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(232,'CHARNAY Andr','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(233,'CHATEL ROBERT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(234,'CHAUDAT ALAIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(235,'CHAUFFRIAT LOUIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(236,'CHAVEROT G?rard','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(237,'CHERBLANC Jean-Pierre','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(238,'CHERMETTE SAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(239,'CHOCOLATIER PONCEPT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(240,'CIE CAFE CREME','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(241,'CIMER  DISTRIBUTION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(242,'CINEMA  SAIN BEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(243,'CINEMA SAIN BEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(244,'CLAUDE BOUVIER LE BERRE AVOCAT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(245,'CLEO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(246,'CLEP REFERENCEMENT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(247,'CLINIQUE DE L\'YVETTE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(248,'CLUB DE DANSE DE ST PIERRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(249,'CLUB DE NATATION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(250,'CLUB PETANQUE ST PIERROIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(251,'CLUB TARARE HANDBALL CSL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(252,'CLUGNET ENERGIES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(253,'CM-CIC BAIL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(254,'CM-CIC LEASING SOLUTIONS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(255,'CMI','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(256,'COFELY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(257,'COFFRE-SUBTIL SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(258,'COLLECTIF  ELEMENTAIRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(259,'COLLEGE ASA PAULINI','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(260,'COLLEGE DE QUATRE VENTS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(261,'COLLEGE MARIE LAURENCIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(262,'COLLEGE PRIVE  STE THERESE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(263,'COLLEGE SIMONE VEIL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(264,'COM EURO CONCEPT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(265,'COMERA ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(266,'COMITE D\'ENTREPRISE AGIS S.A','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(267,'COMITE D\'ENTREPRISE COMELA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(268,'COMITE D\'ENTREPRISE GERFLOR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(269,'COMITE D\'ENTREPRISE MALERBA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(270,'COMITE D\'ETABLISSEMENT GERFLOR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(271,'COMITE DE LIAISON HOSPITALIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(272,'COMMUNAUTE DE COMMUNES CHAMOUSSE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(273,'COMMUNE VINDRY SUR TURDINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(274,'COMPAGNIE ROANNAISE DE CONSTRUCTION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(275,'COMPTABILITE DES MONTS DU LYONNAIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(276,'COMPTABILITE DES MONTS DU LYONNAIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(277,'COMPTOIR SHERAZADE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(278,'CONCEPT CONDUITE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(279,'CONCEPT VITRE COMMUNICATION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(280,'CONFECTION AUBRUN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(281,'CONFECTION CHIESA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(282,'CONFECTION LES ETOFFES DU SOLEIL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(283,'CONSEIL METHODE ET TECHNIQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(284,'CONTROLE TECHNIQUE DE LA VALLEE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(285,'COOPERATIVE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(286,'COPIEUR SYSTEM','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(287,'COQUARD JEAN PAUL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(288,'COQUARD JEAN-YVES SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(289,'COQUARD MAGAT SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(290,'COQUARD PIERRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(291,'CORDIER PROPRETE SERVICES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(292,'CORE DEVELOPPEMENT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(293,'CORINNE - FONSALAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(294,'CORNOLIER Franck','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(295,'CORRET PIERRE ET GABY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(296,'COTTON LAND','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(297,'COULEUR CARTOUCHES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(298,'COULEUR INDIGO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(299,'Couleurs Des Peintures Du Rhone','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(300,'COUP DE POUCE SECRETARIAT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(301,'COURBET COLETTE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(302,'CREA 2 P','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(303,'CREA DANSE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(304,'CREASTYLE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(305,'CREATION DECO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(306,'CREATION ET DECO ME PROST','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(307,'CREATION LIGOUD DESSEIGNE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(308,'CRECHE LES PETITS MOUSSES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(309,'CREDIT MUTUEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(310,'CREDIT MUTUEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(311,'CREDIT MUTUEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(312,'CREDIT MUTUEL AMPLEPUIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(313,'CREDIT MUTUEL DE CHARBONNIERES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(314,'CREDIT MUTUEL DE TARARE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(315,'CREDIT MUTUEL MONTROND','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(316,'CREDIT MUTUEL ST VICTOR SUR RHIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(317,'CROUZET GUY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(318,'D.2.P BOX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(319,'D.I.T Services','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(320,'D.R.A','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(321,'DAGAND ALAIN PLOMBERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(322,'DAM INNOVATION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(323,'DANIERE HELENE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(324,'DANY STYLE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(325,'DAVRAY ET FILS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(326,'DE ABREU TONIO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(327,'DEBISE DANIELLE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(328,'DEBOURG BRUNO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(329,'DEBOURG NOEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(330,'DECHELETTE - MALLEVAL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(331,'DECOSTARS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(332,'DECOURD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(333,'DECULTIEUX ANDRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(334,'DEMEURES DU LYONNAIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(335,'DEMONT  MARIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(336,'DESCO  JEAN CLAUDE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(337,'DESIGNUP','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(338,'DESPE CONSTRUCTIONS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(339,'DESSAIGNE Jean','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(340,'DEVARTI SRL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(341,'DI ROCCO STEPHANE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(342,'DI STEFANO JEAN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(343,'DIAS AMILCAR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(344,'DIEL EXPERTISE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(345,'DIVERS ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(346,'DIVERS ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(347,'DLF CONSTRUCTION SAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(348,'DMG PRESTATIONS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(349,'DOCTEUR JACQUES Alain','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(350,'DOCTEUR REYNARD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(351,'DR BACIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(352,'DR LAMERANT Pierre','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(353,'DR SALINAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(354,'DSI FRANCE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(355,'DUBESSY Roland','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(356,'DUFOUR Elodie','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(357,'DUFOUR ELODIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(358,'DUGAND-FREDIERE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(359,'DURAND BOUZON PATRICE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(360,'DURDILLY MENUISERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(361,'EARL DUBOST MARTIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(362,'EATICE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(363,'ECAL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(364,'ECB - EXPERTISE ET CONSEIL EN BATIMENT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(365,'ECLISSE INGIENERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(366,'ECOLE  SAINT MARCEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(367,'ECOLE CHAURAN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(368,'ECOLE COTTIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(369,'ECOLE ELEMENTAIRE VOLTAIRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(370,'ECOLE JACQUES PREVERT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(371,'ECOLE MATERNELLE   VOLTAIRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(372,'ECOLE MATERNELLE DU SERROUX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(373,'ECOLE MATERNELLE LA PLAINE ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(374,'ECOLE MATERNELLE RADISSON','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(375,'ECOLE MATERNELLE SAIN BEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(376,'ECOLE MONTESSORI','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(377,'ECOLE MUSIQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(378,'ECOLE PAUL LANGEVIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(379,'ECOLE PRIMAIRE DES 3 COLLINES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(380,'ECOLE PRIMAIRE LA PLAINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(381,'ECOLE PRIMAIRE RADISSON','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(382,'ECOLE PRIVEE LES SAUVAGES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(383,'ECOLE PRIVEE STE EVA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(384,'ECOLE PUBLIQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(385,'ECOLE PUBLIQUE LA PLAINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(386,'ECOLE SAINT EXUPERY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(387,'ECOLE SAINT LOUP','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(388,'ECOLE ST FERREOL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(389,'EDR  SAV','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(390,'EFFICOM','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(391,'EIHF','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(392,'ELAN  SAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(393,'ELYO AGENCE RHONE CENTRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(394,'EMMAUS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(395,'ENERGIES DU RHONE EURL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(396,'ENERGIES DU RHONE EURL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(397,'ENNOBLISSEMENT DU VAL DE RHINS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(398,'ENT BEALEM-PELLEQUER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(399,'ENTRAIDE TARARIENNE ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(400,'EQUIPE STADIUM','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(401,'ERIC CURE RAMONAGE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(402,'ERIC FAVRE WELLNESS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(403,'ERIC GREINER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(404,'ERTHELON JEAN-CLAUDE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(405,'ESPACE AUTOS TARARE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(406,'ESPACE BUREAU CONCEPT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(407,'ESPACE SIGNALETIQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(408,'ESPOIR ET FORMATION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(409,'ESPOIR FORMATION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(410,'ETABLISSEMENT BRUNAT  R.J','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(411,'ETABLISSEMENT DAVRAY ET FILS ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(412,'ETABLISSEMENT GUICHERD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(413,'ETIQPRO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(414,'ETUDE DE MAITRE BIBOST','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(415,'ETUDE DE MAITRE MAURICE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(416,'ETUDE MAITRE GRANGER Michel','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(417,'EVENEMENT CIEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(418,'EVER BLUE SARL 2M','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(419,'F TIRA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(420,'F.B.M','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(421,'F.D.E.R','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(422,'F.D.M.A','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(423,'F.L METAL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(424,'F.L TRANS TRANSPORTS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(425,'F.T.P AUTOMATISMES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(426,'F.V.O PLAST','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(427,'FABIEN DAL VECCHIO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(428,'FABIEN DUPUIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(429,'FABRIQUE DE CADRES AMALVY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(430,'FARID','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(431,'FARJOT  ENTREPRISE TOITURES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(432,'FARJOT CONSTRUCTIONS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(433,'FARJOT Eric E.U.R.L','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(434,'FARJOT TOITURES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(435,'FARJOT TRAVAUX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(436,'FARJOT TRAVAUX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(437,'FAURE M et Mme','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(438,'FERLAY Emilie','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(439,'FERRIERE GEORGES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(440,'FETE EN FOLIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(441,'FILLIOL JACQUELINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(442,'FIMTEX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(443,'FISCAVOC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(444,'FLEUR DE LUPIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(445,'FLEURMAT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(446,'FONTENELLE ELECTRICITE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(447,'FOOTBALL CLUB DE TARARE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(448,'FOOTBALL CLUB ST FORGEUX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(449,'FORCE OUVRIERE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(450,'FOUILLAT Fabienne et Didier','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(451,'FOURNEL SIMONE   BFG CADRE DE VIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(452,'FOYER RESIDENCE LA MADELEINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(453,'FRAISSE SA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(454,'FRANCE CLEMENCON','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(455,'FRANCOBOIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(456,'FRANCOISE LOUISON','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(457,'FRANCOLD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(458,'FRANFITEX SA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(459,'FREDIERE MOTOCULTURE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(460,'FRERES MARISTES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(461,'FRET GLOBAL LOGISTIQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(462,'FROGEPA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(463,'FROGET ANDRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(464,'G2/D2','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(465,'G.H ENERGIE CLIM','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(466,'G.V.R','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(467,'GAEC DU BERTHOU','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(468,'GAEC LEPIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(469,'GAEL GUIGONNAND','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(470,'GALLOTTI','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(471,'GARAGE BELLON EURL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(472,'GARAGE BEYLIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(473,'GARAGE DROUIN SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(474,'GARAGE DU MORTIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(475,'GARAGE DUBOIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(476,'GARAGE DUBOST MARTIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(477,'GARAGE JALABERT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(478,'GARAGE MODERNE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(479,'GARAGE ROUTE DE PARIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(480,'GARAGE SOLY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(481,'GARCIA PHILIPPE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(482,'GEFPLAST','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(483,'GELINEAUD M','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(484,'GEMC ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(485,'GEORGES BERMUDE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(486,'GERIN Mireille','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(487,'GILBERT FAYOLLE ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(488,'GILLES JEANPIERRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(489,'GIMEL Bernard ou Martine','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(490,'GINET TARARE AUTOMOBIL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(491,'GIRARDET P ET SES FILS SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(492,'GIRIN Fr?d?ric','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(493,'GIROUD Ma?onnerie SAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(494,'GIROUD-JANIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(495,'GIT HOTEL ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(496,'GOBBA JEAN PAUL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(497,'GOBBA JEAN VITRERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(498,'GONIN MARIE PIERRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(499,'GONZALEZ JOSEPH','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(500,'GOUJON C?line','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(501,'GRANGE DANIEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(502,'GRANGER HELENE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(503,'GRANJARD ANDRE MONSIEUR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(504,'GREEN SENTINEL SA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(505,'GRENKE LOCATION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(506,'GROS MICHEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(507,'GROUPE JUNET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(508,'GROUPE LAENNEC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(509,'GROUPE NOEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(510,'GROUPE SEDEMAP','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(511,'GROUPE VISIO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(512,'GROUPE-O','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(513,'GT LAQUES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(514,'GUY JACQUEMOT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(515,'GUYOT RENE ET DANIELLE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(516,'GUYOT SAMUEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(517,'GVGM  ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(518,'H.L.B ORFI BEL AIR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(519,'H.R.C CONSULTING','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(520,'HADJILA Soufiane','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(521,'HARMONIE DE TARARE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(522,'HARMONIE/ ECOLE DE MUSIQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(523,'HARMONY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(524,'HENRI GAUTIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(525,'HISTOIRE ET PATRIMOINE DE PONTCHARRA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(526,'HOLMAG','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(527,'HOME STYLE FRANCE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(528,'HORTALA LIONEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(529,'HOTEL/RESTAURANT LE CHATARD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(530,'HT SOLUTIONS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(531,'HUBSTER ANTHONY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(532,'I.T.C International conseils','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(533,'I.X.O.S SOCIETE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(534,'IMMO 2R - PLAZA STEPHANE CHAZAY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(535,'IMMOBILIER CECILE ROBIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(536,'IMMOBILIER CECILE ROBIN ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(537,'IMMOBILIER C?cile Robin','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(538,'IMMOBILIER STEPHANE PLAZZA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(539,'IMMOBILIERE LA TOUR DE SALAVGNY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(540,'IMPRIMERIE BARLERIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(541,'IMPRIMERIE CHAVEROT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(542,'IMPRIMERIE GUIGON','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(543,'IMPRIMERIE PONCET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(544,'IMPRIMERIE RIVIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(545,'IMPRIMERIE XAVIER LAURENT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(546,'IMPRO GROUP','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(547,'IN-VIHOME','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(548,'INDUSCOPIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(549,'INEKOM','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(550,'INOVA CUISINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(551,'INSTITUT LYDIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(552,'INTERIORS 1896','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(553,'ISABELLE BRANCHET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(554,'ISS/C PRO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(555,'IT\'S','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(556,'j.b alarme','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(557,'J.C.N INFORMATIQUE SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(558,'J.D CONTACT AUTOMOBILES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(559,'J.G.LACOMBE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(560,'J.L MACONNERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(561,'JACQUEMOT ENTREPRISE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(562,'JACQUEMOT JEREMY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(563,'JACQUEMOT SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(564,'JANNET JOSIANNE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(565,'JAQUES IMMO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(566,'JAUBERT GAYET-LAPANISSIERES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(567,'JB ALARME','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(568,'JBN  SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(569,'JEAN GOBBA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(570,'JEAN JURDY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(571,'JEAN PAUL GOTTE SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(572,'JEAN YVES DAVALO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(573,'JESUS CARRETERO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(574,'JOLY S.A.R.L','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(575,'JOYET GUY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(576,'JP CONSULTING','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(577,'JULIE LAUTREY NOTAIRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(578,'JUNET BOIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(579,'JUNET PHILIPPE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(580,'JUSTINE JOUVE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(581,'KALI T.P','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(582,'KIT FORET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(583,'KSAVRELOF RENE ET EUNICE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(584,'L \'IMMOBILIER DU LAC DES SAPINS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(585,'L ILOT Z ENFANTS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(586,'L\'ALOUETTE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(587,'L\'APOSTROPHE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(588,'L\'ART DU FEU','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(589,'L\'ART SU SERVICE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(590,'L\'ATELIER BOIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(591,'L.B.I.V','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(592,'L.P.G','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(593,'LA CASCADE DES DELICES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(594,'LA CAVE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(595,'LA CONSTRUCTION ARBRESLOISE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(596,'LA FETE AUX CREPES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(597,'LA FLEURINOISE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(598,'LA FRATERNELLE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(599,'LA LYRE VERANAISE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(600,'LA MAISON COUSUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(601,'LA NUMBA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(602,'LA PASSERELLE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(603,'LA POSTE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(604,'LA VIE CLAIRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(605,'LABORATOIRE 3 CHENES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(606,'LABORATOIRE 3 CHENES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(607,'LABORATOIRE ANALYSE VIOLLET-BELMONT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(608,'LABORATOIRE ANALYSES MEDICALE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(609,'LABORATOIRE SICOBEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(610,'LACROIX MARC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(611,'LAFAY JEAN-JACQUES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(612,'LAFNOUNE NATHACHA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(613,'LAMANNA LOUIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(614,'LAMY  ROBERT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(615,'LANGEVIN Virginie','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(616,'LAPALUD S.A','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(617,'LAURENT MACONNERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(618,'LAURENT SARL PIECES AUTOS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(619,'LAURENT YVONNE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(620,'LAURENT Yvonne et Christian','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(621,'LE CALME DE L\'ETANG','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(622,'LE COMPTOIR DE JOHN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(623,'LE DEEJ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(624,'LE NOUVEAU GARAGE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(625,'LE WINSLOW','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(626,'LEASECOM - CENTRE ADMINISTRATIF','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(627,'LECLERC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(628,'LECLERC VOYAGES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(629,'Les ateliers de la Madeleine','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(630,'LES ATELIERS RAGOT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(631,'LES FIFRES ROANNAIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(632,'LES FRERES MARISTES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(633,'LES NOUVEAUX TEXTILES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(634,'LES PRODUITS DU VAL SOANAN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(635,'LES SEQUOIAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(636,'LES SERRES DU MOULIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(637,'LES TEMOINS DE JEHOVAH','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(638,'LES VIANDES LIMOUSINES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(639,'LES VINS AUJOUX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(640,'LES VOILAGES DU PARC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(641,'LEURS ALEXANDRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(642,'LG TRANS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(643,'LG2M','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(644,'LIBIOS   SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(645,'LINARI SA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(646,'LINDER S.A','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(647,'LM  IMMOBILIER ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(648,'LM INFOS  ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(649,'LOCAVAISSO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(650,'LOISIRS HABITAT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(651,'LOISIRS HABITAT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(652,'LOISIRS HABITAT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(653,'LUCIS BIO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(654,'LUDOTHEQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(655,'LUDOVIC CARTON SAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(656,'Luigi Gallotti','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(657,'LUKORA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(658,'LUNET\'MOD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(659,'LUX HOME EQUIPEMENTS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(660,'LYCEE JULES VERNE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(661,'LYCEE NOTRE DAME DE BEL AIR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(662,'Lyc?e  Ren? CASSIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(663,'LYON NORD IMMOBILIER COQUILLAT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(664,'M ET ME COLLON','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(665,'M OU ME LAURENT CHARLES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(666,'M OU ME PERRET Charles','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(667,'M OU MME LAPIERRE Franck','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(668,'M PERRIER Jean-Claude','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(669,'M\' HELICO VOILAGES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(670,'M. ANGELINI GERARD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(671,'M. MATTHIAS LAFAY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(672,'M. POTET J?rome','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(673,'M. RABANY MARC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(674,'M. RIVAL PASCAL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(675,'M. SIGOURD JEAN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(676,'M. SOLIVELLAS Jacques','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(677,'M. VERRIERE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(678,'M.C AMENAGEMENT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(679,'M.D.A','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(680,'M.I.E','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(681,'M.I.E','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(682,'M.N.C','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(683,'M.R.V BUREAUTIQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(684,'MA?ONNERIE LAURENT Lucien','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(685,'MADAME FILLON','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(686,'Madame GERMAIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(687,'MAILLARDET VALERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(688,'MAIRIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(689,'MAIRIE  D\'ANCY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(690,'MAIRIE  DE TARARE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(691,'MAIRIE  LONGESSAIGNE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(692,'MAIRIE  SAIN BEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(693,'MAIRIE  SAINT LOUP','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(694,'MAIRIE D\'AFFOUX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(695,'MAIRIE DAREIZE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(696,'MAIRIE DE BAGNOLS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(697,'MAIRIE DE JOUX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(698,'MAIRIE DE L\'ARBRESLE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(699,'MAIRIE DE LEGNY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(700,'MAIRIE DE ST CLEMENT SOUS VALSONNE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(701,'MAIRIE DE VIOLAY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(702,'MAIRIE DES OLMES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(703,'MAIRIE DES SAUVAGES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(704,'MAIRIE SAINT GENIS L\'ARGENTIERE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(705,'MAIRIE ST FORGEUX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(706,'MAIRIE ST MARCEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(707,'MAISON D\'ARIANE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(708,'MAISON DE L\'EMPLOI ET DE LA FORMATION ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(709,'MAISON DE LA SALETTE BULLY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(710,'MAISON DE RETRAITE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(711,'MAISON MEDICAL THEIZE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(712,'MAISONS DENYS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(713,'MAITRE KOCHEL JONATHAN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(714,'MAITRE MAURICE Nathalie','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(715,'MAITRE PIBAROT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(716,'MANCUSO CABINET ASSOCIES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(717,'MAPHI EURL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(718,'MARBRERIE SION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(719,'MARBRERIE SION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(720,'Marc olivier GROSS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(721,'MARIE BOURBON','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(722,'MARIE PIERRE PERRIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(723,'MARIELLE TERASSE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(724,'MARIN SA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(725,'MATHELIN APPRETS TEINTURE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(726,'MATHIAS Luc','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(727,'MAURICE RAFFIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(728,'MB DISTRIBUTION ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(729,'MC NEILE NUTRITIONNALS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(730,'ME CHIESA Rolande','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(731,'ME HERERARD   Mireille','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(732,'ME JOUVE Crystelle','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(733,'ME MONTVERNAY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(734,'ME ROCHARD Laurence','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(735,'MECANIQUE ALAIN CHAT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(736,'MECARESSORTS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(737,'MEDECINE DU TRAVAIL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(738,'MEDIATHEQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(739,'MEDICAL TELEMATIC SYSTEM','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(740,'MEDINGER Agnes','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(741,'MEGA STYL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(742,'MELANIE TISSOT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(743,'MELLE BRIGADIERE Suzanne','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(744,'Melle GOTTE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(745,'MENDES Evelyne','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(746,'MENESYS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(747,'MENUISERIE DE ST GERMAIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(748,'MENUISERIE DES GONES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(749,'MENUISERIE DUBOIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(750,'MENUISERIE DURIER BOURRASSAUD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(751,'MENUISERIE ROGER NOYEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(752,'MENUISERIE SECOND MICHEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(753,'MENUISERIE THOMAS YVES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(754,'MENUISERIE TREILLE Alain','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(755,'META','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(756,'METALLION SERVICES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(757,'METEINIER JEROME','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(758,'MEUBLES SUBRIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(759,'MEXX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(760,'MGB','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(761,'MICHEL BURNICHON','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(762,'MICHEL S.A.R.L','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(763,'MILED  YAHIA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(764,'MILLE ET UNE SUCRERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(765,'MISSION LOCALE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(766,'MITSIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(767,'MITTON BLANDINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(768,'MITTON CHRISTOPHE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(769,'MME OU MME LACROIX NICOLAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(770,'MOBISTORE/  MARC GAUBERT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(771,'MOD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(772,'MOLLARD GILBERT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(773,'MONCHANIN MENUISERIE CHARPENTE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(774,'MONCORGE Ets','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(775,'MONDOVELO LES OLMES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(776,'MONSIEUR BRICOLAGE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(777,'MONSIEUR GIRIER JEAN PAUL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(778,'MONSIEUR JC GROSS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(779,'Monsieur MIEL Thierry','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(780,'MONTIBERT SA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(781,'MONTLOUP JEAN MARC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(782,'MONTVERNAY T.P.R.L  SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(783,'MORAU LIONEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(784,'MOUSSA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(785,'MR BACHELARD PHILIPPE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(786,'MR BACOT Philippe','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(787,'MR ET ME DUPERRAY Eric','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(788,'MR ET ME PACHAL Fran?ois','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(789,'MR GOYON G?rard','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(790,'MR NOIRANT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(791,'MR OU ME COMBY Max','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(792,'MRJC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(793,'MUGUET JEAN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(794,'MULTI CLIMA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(795,'MULTITUD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(796,'MUSEE DE LA MINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(797,'MYRIAM CHAMBOST','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(798,'MZ BOIS ET COMPAGNIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(799,'N.J.P','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(800,'NATACHA ROZIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(801,'NATALY B','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(802,'NATHALIE FOURTIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(803,'NEPSOD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(804,'NEVEU PHILIPPE M ET MM','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(805,'NEW BOIS AGENCEMENT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(806,'NEW DAKKAR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(807,'NEXINVEST','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(808,'NEXTEP','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(809,'NODOTEC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(810,'NOIRANT G?raldine','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(811,'NOVAS CONSTRUCTIONS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(812,'NUTI SOPHIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(813,'O.G.E.C LES SAUVAGES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(814,'O.L.B','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(815,'O.T.B.V','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(816,'ODS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(817,'OEDORIA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(818,'OGEC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(819,'OLIVIER UNIVERS IMMOBILIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(820,'OLMIPLAST','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(821,'OMT TRANSPORTS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(822,'ONO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(823,'ONOVO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(824,'OPERATING ASIA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(825,'OPERATING ASIA 2 (OPA2)','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(826,'OPMATIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(827,'OPTIHOME','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(828,'OPTIQUE CHEVALLIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(829,'OPTIQUE GIRAUD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(830,'ORALIA/SOGIMAT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(831,'ORFIS  BEL AIR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(832,'ORFIS  BEL AIR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(833,'ORTHOPEDIE CENTRALE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(834,'OSEOBOIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(835,'OTARIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(836,'P.C.   EXPERTISES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(837,'P.E.E.P ASSOCIATION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(838,'P.L IDENTITE SERVICES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(839,'P.P.M','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(840,'P.V.S','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(841,'PAGAN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(842,'PAILLASSON Gilles','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(843,'PANIER DU LIVRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(844,'PAPMAB ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(845,'PAROISSE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(846,'PAROISSE JEAN XXIII','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(847,'PASTOR GUILLAUME','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(848,'PATISSERIE BOULANGERIE COQUARD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(849,'PATRICE BONHOMME','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(850,'PAXOR S.A','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(851,'PEGGIE BUCHET SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(852,'PEIGNAUD THERESE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(853,'PEREZ PHILIPPE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(854,'PERFORM INGENIERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(855,'PERFORMANCES ADEQUATION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(856,'PERMANENCE NATHALIE SERRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(857,'PERNEY JACQUES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(858,'PERONNET Michel','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(859,'PERRIERE CHRISTIAN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(860,'PETANQUE CLUB','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(861,'PHARMACIE CENTRALE SELARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(862,'PHARMACIE DE L\'AQUEDUC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(863,'PHARMACIE LETIERCE Catherine','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(864,'PHARMACIE PRINCIPALE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(865,'PHARMACIE REPUBLIQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(866,'PHARMACIE VICTOR HUGO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(867,'PHARMACIE VIGAN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(868,'PHILAE DEVELOPPEMENT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(869,'PIERRE FOUCAUD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(870,'PIERRE PIGNARD SAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(871,'PIERREFEU IMMOBILIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(872,'PIGNARD Bernadette','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(873,'PISCINES AQUINOX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(874,'PIVON DUBESSY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(875,'PIZZ ACADEMY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(876,'PLISSON  PATRICK','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(877,'PLOMBERIE LABOURE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(878,'POCACHARD EURL ENTREPRISE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(879,'POLY BT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(880,'POLYTUIL ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(881,'POMPIERS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(882,'PONCET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(883,'PONCET ERIC PLOMBERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(884,'PONSER SERVCES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(885,'PONTCHARRA SPORT BASKET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(886,'POSE RHONE ALPES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(887,'PRADEL Christian','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(888,'PRO FIBRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(889,'PROFIL DOUGLAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(890,'PROTEX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(891,'PROVVEDI INDUSTRIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(892,'PROXI MAG','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(893,'QUICK FLOCK','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(894,'R.A.S.E.L','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(895,'R.C DIFFUSION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(896,'R.C.P','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(897,'R.M.O S.A.R.L','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(898,'R.T.I','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(899,'R.T.I','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(900,'R.T.K','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(901,'RABAIN TECHNOLOGIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(902,'RABANY FRANCOISE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(903,'RAFFIER VALERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(904,'RAFFIN MEDICAL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(905,'RAFFIN STEPHANIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(906,'RAGOT MARIE CLAUDE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(907,'RAGOT STORE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(908,'RAUCH S.A','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(909,'RAUCH S.A SOCIETE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(910,'RB MENUISERIES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(911,'RC AUTO CLEAN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(912,'REALIS\'IMMO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(913,'REALISATION CONCEPTION PRODUCTION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(914,'RECUPERATION D\'UN TIERS SUPPRIME','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(915,'REICHENAUER PHILIPPE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(916,'REMG','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(917,'RENOVMAG EQUIPEMENT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(918,'REPPOP 69','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(919,'RESIDENCE LES TILLEULS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(920,'RESIDENCE MONTVENOUX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(921,'RESSORTS DE LA TURDINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(922,'RESSOURCES U.P','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(923,'RESTAURANT JEAN BROUILLY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(924,'RESTAURANT L\'ARDOISE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(925,'RESTAURANT L\'EVENEMENT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(926,'RHONE ASSISTANCE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(927,'RIBELEC ELECTRICITE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(928,'RICHARD ETABLISSEMENT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(929,'RIGUAL Bernard','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(930,'RISK MANAGEMENT CONSULTANTS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(931,'ROBERT LAURAINE MARIE JOSEE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(932,'ROCHARD CHRISTIAN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(933,'ROCHE S.A.R.L','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(934,'ROCHON HUBERT - PLOMBERIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(935,'ROCLE BY ISABELLA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(936,'ROCLE SA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(937,'RODRIGO-MORATA Val?rie','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(938,'ROLLAND PIERRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(939,'ROLLIN MAITRISE OEUVRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(940,'RONNE Jean-Claude','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(941,'RONY Didier','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(942,'ROSIER JEAN LOUP','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(943,'ROTARY CLUB DU PAYS DE TARARE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(944,'ROUCHON JEAN MARIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(945,'ROUSSILLON PASCAL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(946,'RUIZ STEPHANIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(947,'S.A.R.L FIORELLO/BOUTET ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(948,'S.A.R.L JMMS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(949,'S.A.R.L LEONIMO/ IMMO GROUP','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(950,'S.B.P.E','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(951,'S.C.I  DEMECHE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(952,'S.C.M  DESCHAMPS GONZALES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(953,'S.C.M PONCET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(954,'S.C.P TUDELA ET ASSOCIES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(955,'S.D.F. CAILLARD DUVIVIER MOULA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(956,'S.E.C.A.T','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(957,'S.E.D.R.A','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(958,'S.I.A.B.A','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(959,'S.I.VALSONNAISE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(960,'S.N. A 2C','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(961,'S.O.S EMAUS FAMILLES EMAUS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(962,'S.W.D.L','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(963,'SABLON SOPHIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(964,'SALON COIFFURE MV CREATIF','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(965,'SALVAT MECANIQUE GENERALE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(966,'SAMPLE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(967,'SARCEY DISTRIBUTION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(968,'SARL DUBUIS TONY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(969,'SARL ENTELYS GAZ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(970,'SARL ERIC MARJOLET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(971,'SARL GROUPE ESPACES ET CREATIONS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(972,'SARL IMMO ANSE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(973,'SARL LYON NORD IMMOBILIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(974,'SARL MARIE VALFORT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(975,'SARL NATIONAL IMMOBILIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(976,'SARL PACHOUX NEGOCE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(977,'SARL TEOZ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(978,'SARTOR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(979,'SAS C\'TOP FORMATION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(980,'SAS ENNOVY AGENCEMENT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(981,'SASU  CICORA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(982,'SASU  MAISONS  MARGAUX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(983,'SASU EIHPOS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(984,'SAX AUTOS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(985,'SC IMMO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(986,'SCHLENNINGER ANNE-LAURE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(987,'SCI GOBBA FAUBOURG','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(988,'SCI LE BURIE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(989,'SCI TAR\'ARCHITECT ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(990,'SCIERIE LACHIZE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(991,'SCIERIE LAHIZE SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(992,'SCO2 BOIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(993,'SCT RUGBY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(994,'SECTEUR BOULISTE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(995,'SECURIS-COURS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(996,'SEGURA  PASCAL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(997,'SEGURA Jean-Philippe','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(998,'SEGURA MARION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(999,'SELARL CABINET DR CAROLINE CHAMARD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1000,'SELARL GALLOTTI CHALAYE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1001,'SENSZO/ COLOR','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1002,'SERITEX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1003,'SERRAILLES M ET ME','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1004,'SERRAILLES PEGGY','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1005,'SERRURERIE CHOGNARD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1006,'SERRURERIE PHILIBERT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1007,'SERVICES DE LA TURDINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1008,'SERVICES MENAGERS 3 EN 1','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1009,'SFERE BUREAUTIQUE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1010,'SIGNAMARK','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1011,'SIMON Wielfried','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1012,'SIROT SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1013,'SISTERNE SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1014,'SITA FRANCE ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1015,'SIVELLE Laurent','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1016,'SMC ISLE DE FRANCE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1017,'SMC JOURNET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1018,'SMET M','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1019,'SNC ALTOP','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1020,'SNC JEBANNE ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1021,'SNC ZEPHYR TABAC PRESSE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1022,'SOC. TARARIENNE DE RASAGE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1023,'SOCIETE B10','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1024,'SOCIETE DES GRISONS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1025,'SOCIETE HUMBERT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1026,'SOCIETE METALLURGIQUE DE COURS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1027,'SOCOMI','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1028,'SOCOS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1029,'SODAC ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1030,'SOFRAGEC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1031,'SOGEMED','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1032,'SOLAFI','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1033,'SOLEMAT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1034,'SOLUTION SMART','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1035,'SONNERY Derek','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1036,'SORIANO VALENTIN','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1037,'SOSAV','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1038,'SOSTAD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1039,'SOU DES ECOLES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1040,'SOVAMAX TRADING GMBH DEUTSCHLAND','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1041,'SPBE - ESPACE INFOS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1042,'SPORT 2000','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1043,'ST LOUP DISTRIBUTION ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1044,'ST ROMAIN SERVICES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1045,'ST ROMAIN SERVICES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1046,'STADIUM BOULISTE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1047,'STAR FLAMME','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1048,'STEINER Florence','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1049,'STEPHANE CHANRION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1050,'STET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1051,'STRIX INVESTIGATIONS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1052,'STUDIO BEAUREGARD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1053,'STUDIO DE L\'HACIENDA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1054,'SUBRIN PASCALE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1055,'SUBRIN PHILIPPE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1056,'SWAL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1057,'SYLYGEST','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1058,'SYNCHRONE EC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1059,'SYND INTERCOMMUNAL ASSAIN.','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1060,'SYNDICAT ASSAINISSEMENT DU PAYS DE TARARE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1061,'SYNDICAT INTERCOMMUNAL DES EAUX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1062,'T.F.X','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1063,'T.N.E  EXPRESS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1064,'TABAC PRESSE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1065,'TABAC PRESSE BARNOUIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1066,'TABAC PRESSE DELOFRE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1067,'TABAC PRESSE GIRAUD G?rard','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1068,'TABAC PRESSE PERRAT Jean-Pierre','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1069,'TARARE  MICRO','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1070,'TARARE NETTOYAGE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1071,'TARARE PNEUS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1072,'TEBIB FRANCOIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1073,'TECHNI ELEC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1074,'TECTOIT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1075,'TEINTURERIE THIVEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1076,'TEINTURERIES DE LA TURDINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1077,'TEINTURERIES DE TARARE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1078,'TENTATIONS ET DELICES','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1079,'TERRASSE OLIVIER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1080,'Test','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1081,'THEVENIN DANIEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1082,'THIERRY FROIDURE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1083,'THIERRY NABAILE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1084,'THIMONIER Chrisitne','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1085,'THION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1086,'THION','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1087,'TNE Express','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1088,'TOSHIBA TEC FRANCE IMAGING SYSTEMS SA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1089,'TRANSCOMM','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1090,'TRANSDILIGENCE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1091,'TRANSPORTS BLANC','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1092,'TRANSPORTS BONNARD','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1093,'TRANSPORTS DUPUIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1094,'TRANSPORTS FONSALAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1095,'TRANSPORTS JOUVE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1096,'TRANSPORTS LALOUEL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1097,'TRANSPORTS LIVET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1098,'TRANSPORTS VALOIS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1099,'TRAVAUX S.L.C','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1100,'TRIUMPH ADLER','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1101,'ULTI SERVICE SAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1102,'UN INSTANT ','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1103,'UNION LOCALE CGT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1104,'UNION MUSICALE DE PONTCHARRA SUR TURDINE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1105,'URBAN PARK BY FUN RAMP','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1106,'V.T.H','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1107,'VALANTIN - BERGER - MMA','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1108,'VARRAUX Andr','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1109,'VEDITEX','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1110,'VERNAY PASCAL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1111,'VERNE ET CLET','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1112,'VIADUC PRINT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1113,'VIALLY-CARRIER SARL','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1114,'VILLECOURT SAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1115,'VISION NOUVELLE','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1116,'WHITE MOTOS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1117,'YM CONCEPT','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0),(1118,'YOURI GRAS','','','','','','',0,0,'0000-00-00',0,0,'0000-00-00',0);

--
-- Table structure for table `tcriticality`
--

CREATE TABLE `tcriticality` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `number` int(2) NOT NULL,
  `name` varchar(50) NOT NULL,
  `color` varchar(10) NOT NULL,
  `service` int(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `service` (`service`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tcriticality`
--

INSERT INTO `tcriticality` VALUES (0,0,'Aucune','#B0B0B0',0),(1,0,'Critique','#d15b47',0),(2,1,'Grave','#f89406',0),(3,2,'Moyenne','#f8c806',0),(4,3,'Basse','#82af6f',0);

--
-- Table structure for table `tevents`
--

CREATE TABLE `tevents` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `technician` int(10) NOT NULL,
  `incident` int(10) NOT NULL,
  `date_start` datetime NOT NULL,
  `date_end` datetime NOT NULL,
  `allday` varchar(10) NOT NULL,
  `type` int(1) NOT NULL,
  `title` varchar(150) NOT NULL,
  `classname` varchar(50) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `technician` (`technician`),
  KEY `incident` (`incident`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tevents`
--


--
-- Table structure for table `tgroups`
--

CREATE TABLE `tgroups` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `type` int(1) NOT NULL,
  `service` int(5) NOT NULL,
  `disable` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `service` (`service`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tgroups`
--

INSERT INTO `tgroups` VALUES (0,'Aucun',0,0,1),(11,'INFORMATIQUE',1,0,0),(12,'COPIEURS (Matériel)',1,0,0),(13,'COPIEURS (Scan, Installation)',1,0,0),(14,'COMMANDES',1,0,0);

--
-- Table structure for table `tgroups_assoc`
--

CREATE TABLE `tgroups_assoc` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `group` int(5) NOT NULL,
  `user` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `group` (`group`),
  KEY `user` (`user`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tgroups_assoc`
--

INSERT INTO `tgroups_assoc` VALUES (1,12,10),(2,11,9),(3,11,11),(4,11,7),(5,13,9),(6,13,10),(7,13,7),(8,13,11),(9,14,11),(10,14,7);

--
-- Table structure for table `tincidents`
--

CREATE TABLE `tincidents` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `type` int(3) NOT NULL DEFAULT '0',
  `type_answer` int(10) NOT NULL,
  `technician` int(10) NOT NULL,
  `t_group` int(5) NOT NULL,
  `title` varchar(100) NOT NULL,
  `description` mediumtext NOT NULL,
  `user` int(10) NOT NULL,
  `observer1` int(10) NOT NULL,
  `observer2` int(10) NOT NULL,
  `observer3` int(10) NOT NULL,
  `u_group` int(5) NOT NULL,
  `u_service` int(5) NOT NULL,
  `u_agency` int(5) NOT NULL,
  `sender_service` int(5) NOT NULL,
  `date_create` datetime NOT NULL,
  `date_hope` date NOT NULL,
  `date_res` datetime NOT NULL,
  `date_modif` datetime NOT NULL,
  `state` int(1) NOT NULL,
  `user_validation` int(1) NOT NULL,
  `user_validation_date` date NOT NULL,
  `priority` int(2) NOT NULL,
  `criticality` int(2) NOT NULL,
  `img1` varchar(500) NOT NULL,
  `img2` varchar(500) NOT NULL,
  `img3` varchar(500) NOT NULL,
  `img4` varchar(500) NOT NULL,
  `img5` varchar(500) NOT NULL,
  `time` int(10) NOT NULL,
  `time_hope` int(10) NOT NULL,
  `creator` int(3) NOT NULL,
  `category` int(3) NOT NULL,
  `subcat` int(3) NOT NULL,
  `techread` int(1) NOT NULL DEFAULT '1',
  `techread_date` datetime NOT NULL,
  `userread` int(1) NOT NULL DEFAULT '1',
  `template` int(1) NOT NULL,
  `disable` int(1) NOT NULL,
  `notify` int(1) NOT NULL,
  `place` int(5) NOT NULL,
  `asset_id` int(8) NOT NULL,
  `start_availability` datetime NOT NULL,
  `end_availability` datetime NOT NULL,
  `availability_planned` int(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `state` (`state`),
  KEY `technician` (`technician`),
  KEY `user` (`user`),
  KEY `u_service` (`u_service`),
  KEY `category` (`category`),
  KEY `subcat` (`subcat`),
  KEY `u_agency` (`u_agency`),
  KEY `priority` (`priority`),
  KEY `criticality` (`criticality`),
  KEY `sender_service` (`sender_service`),
  KEY `type` (`type`),
  KEY `t_group` (`t_group`),
  KEY `u_group` (`u_group`),
  KEY `creator` (`creator`),
  KEY `place` (`place`),
  KEY `asset_id` (`asset_id`),
  KEY `type_answer` (`type_answer`),
  KEY `observer1` (`observer1`),
  KEY `observer2` (`observer2`),
  KEY `observer3` (`observer3`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tincidents`
--

INSERT INTO `tincidents` VALUES (2,0,0,10,0,'Problème carte-réseau','\r\n										\r\n										\r\n										\r\n										\r\n										',13,0,0,0,0,0,0,0,'2021-06-28 14:41:42','0000-00-00','2021-07-12 09:24:42','2021-06-28 14:41:42',3,0,'0000-00-00',6,4,'','','','','',1,5,7,5,6,0,'0000-00-00 00:00:00',0,0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(3,0,0,7,0,'Configuration du VPN','\r\n										\r\n										\r\n										\r\n										\r\n										\r\n										\r\n										\r\n										\r\n										',14,0,0,0,0,0,0,0,'2021-06-28 15:24:29','0000-00-00','2021-07-12 09:24:27','2021-06-28 15:24:29',3,0,'0000-00-00',6,4,'','','','','',1,5,7,4,0,1,'2021-07-12 10:57:58',0,0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(25,0,0,9,0,'Demande d\'installation de logiciel','\r\n										\r\n										\r\n										\r\n										',18,0,0,0,0,0,0,0,'2021-07-12 09:35:22','0000-00-00','2021-07-12 09:53:01','2021-07-12 09:35:22',3,0,'0000-00-00',6,4,'','','','','',1,5,12,0,0,1,'2021-07-12 09:53:35',0,0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(27,0,0,7,0,'Problème de récuperation des emails présaisies Outlook','<div>Poste : Isabelle</div><div><br></div><div>Les contacts on disparues (surement après maj)<br></div>\r\n										',19,0,0,0,0,0,0,0,'2021-07-12 10:55:13','0000-00-00','2021-07-12 10:56:23','2021-07-12 10:55:13',3,0,'0000-00-00',6,4,'','','','','',10,5,7,4,0,1,'2021-07-12 10:57:28',0,0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0),(28,0,0,7,0,'Installation Sophos + Liv. pc portable portable + TSE sur son PC','\r\n										\r\n										\r\n										\r\n										',20,0,0,0,0,0,0,0,'2021-07-12 11:05:14','0000-00-00','0000-00-00 00:00:00','2021-07-12 11:05:14',7,0,'0000-00-00',6,4,'','','','','',1,60,7,4,0,1,'2021-07-12 11:15:36',0,0,0,0,0,0,'0000-00-00 00:00:00','0000-00-00 00:00:00',0);

--
-- Table structure for table `tlogs`
--

CREATE TABLE `tlogs` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL,
  `date` datetime NOT NULL,
  `message` varchar(1024) NOT NULL,
  `user` int(10) NOT NULL,
  `ip` varchar(45) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tlogs`
--


--
-- Table structure for table `tmails`
--

CREATE TABLE `tmails` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `incident` int(10) NOT NULL,
  `open` int(1) NOT NULL,
  `close` int(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `incident` (`incident`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tmails`
--


--
-- Table structure for table `tparameters_user_validation_exclusion`
--

CREATE TABLE `tparameters_user_validation_exclusion` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `category` int(5) NOT NULL,
  `subcat` int(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category` (`category`),
  KEY `subcat` (`subcat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tparameters_user_validation_exclusion`
--


--
-- Table structure for table `tplaces`
--

CREATE TABLE `tplaces` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tplaces`
--

INSERT INTO `tplaces` VALUES (0,'Aucun');

--
-- Table structure for table `tplugins`
--

CREATE TABLE `tplugins` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `label` varchar(128) NOT NULL,
  `description` varchar(254) NOT NULL,
  `icon` varchar(64) NOT NULL,
  `version` varchar(10) NOT NULL,
  `enable` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tplugins`
--

INSERT INTO `tplugins` VALUES (1,'availability','Disponibilité','Active le suivi des catégories afin de produire des statistiques de disponibilité','clock','1.2',0);

--
-- Table structure for table `tpriority`
--

CREATE TABLE `tpriority` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `number` int(2) NOT NULL,
  `name` varchar(50) NOT NULL,
  `color` varchar(15) NOT NULL,
  `service` int(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `service` (`service`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tpriority`
--

INSERT INTO `tpriority` VALUES (0,0,'Aucune','#B0B0B0',0),(1,0,'Urgent','#d15b47',0),(2,1,'Très haute','#f89406',0),(3,2,'Haute','#f8c806',0),(4,3,'Moyenne','#e7ef20',0),(5,4,'Basse','#c2c921',0),(6,5,'Très basse','#82af6f',0);

--
-- Table structure for table `tprocedures`
--

CREATE TABLE `tprocedures` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `category` int(5) NOT NULL,
  `subcat` int(5) NOT NULL,
  `name` varchar(100) NOT NULL,
  `text` mediumtext NOT NULL,
  `file1` varchar(30) NOT NULL,
  `company_id` int(5) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category` (`category`),
  KEY `subcat` (`subcat`),
  KEY `company_id` (`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tprocedures`
--


--
-- Table structure for table `tprofiles`
--

CREATE TABLE `tprofiles` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `level` int(10) NOT NULL,
  `img` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tprofiles`
--

INSERT INTO `tprofiles` VALUES (1,'technicien',0,'technician.png'),(2,'utilisateur avec pouvoir',1,'poweruser.png'),(3,'utilisateur',2,'user.png'),(4,'superviseur',3,'supervisor.png'),(5,'administrateur',4,'admin.png');

--
-- Table structure for table `tprojects`
--

CREATE TABLE `tprojects` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tprojects`
--


--
-- Table structure for table `tprojects_task`
--

CREATE TABLE `tprojects_task` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `number` int(3) NOT NULL,
  `project_id` int(5) NOT NULL,
  `ticket_id` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `project_id` (`project_id`),
  KEY `ticket_id` (`ticket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tprojects_task`
--


--
-- Table structure for table `trights`
--

CREATE TABLE `trights` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `profile` int(5) NOT NULL,
  `search` int(1) NOT NULL COMMENT 'Affiche le champ de recherche',
  `task_checkbox` int(1) NOT NULL COMMENT 'Autorise les actions sur la sélection de plusieurs lignes dans la liste des tickets et des équipements',
  `procedure` int(1) NOT NULL COMMENT 'Affiche le menu procédure',
  `procedure_add` int(1) NOT NULL COMMENT 'Droit d''ajouter des procédures',
  `procedure_delete` int(1) NOT NULL COMMENT 'Droit de supprimer des procédures',
  `procedure_modify` int(1) NOT NULL COMMENT 'Modification des procédures',
  `procedure_company` int(1) NOT NULL COMMENT 'Affiche le champ société sur une procédure',
  `procedure_list_company_only` int(1) NOT NULL COMMENT 'Affiche uniquement les procédures de la société rattachée à l''utilisateur',
  `stat` int(1) NOT NULL COMMENT 'Affiche le menu Statistiques',
  `planning` int(1) NOT NULL COMMENT 'Affiche le menu Planning',
  `project` int(1) NOT NULL COMMENT 'Affiche le menu projet',
  `availability` int(1) NOT NULL COMMENT 'Affiche le menu Disponibilité',
  `asset` int(1) NOT NULL COMMENT 'Affiche le menu équipement',
  `asset_net_scan` int(1) NOT NULL COMMENT 'Affiche le bouton de désactivation du scan réseau pour cet équipement',
  `asset_delete` int(1) NOT NULL COMMENT 'Droit de suppression des équipements',
  `asset_virtualization_disp` int(1) NOT NULL COMMENT 'Affiche le champ équipement virtuel',
  `asset_location_disp` int(1) NOT NULL COMMENT 'Affiche le champ localisation sur un équipement',
  `asset_list_department_only` int(1) NOT NULL COMMENT 'Affiche uniquement les équipements du service auquel est rattaché l''utilisateur',
  `asset_list_company_only` int(1) NOT NULL COMMENT 'Affiche uniquement les équipements de la société rattachée à l''utilisateur',
  `asset_list_view_only` int(1) NOT NULL COMMENT 'Affiche uniquement la liste des équipements, sans droit d''éditer une fiche',
  `asset_list_col_location` int(1) NOT NULL COMMENT 'Affiche la colonne localisation dans la liste des tickets',
  `admin` int(1) NOT NULL COMMENT 'Affiche le menu Administration',
  `admin_groups` int(1) NOT NULL COMMENT 'Affiche le menu Administration > Groupes uniquement',
  `admin_lists` int(1) NOT NULL COMMENT 'Affiche le menu Administration > Listes uniquement',
  `admin_lists_category` int(1) NOT NULL COMMENT 'Affiche le menu Administration > Listes > Catégories',
  `admin_lists_subcat` int(1) NOT NULL COMMENT 'Affiche le menu Administration > Listes > Sous-catégories',
  `admin_lists_criticality` int(1) NOT NULL COMMENT 'Affiche le menu Administration > Listes > Criticités',
  `admin_lists_priority` int(1) NOT NULL COMMENT 'Affiche le menu Administration > Listes > Priorité',
  `admin_lists_type` int(1) NOT NULL COMMENT 'Affiche le menu Administration > Listes > Types des tickets',
  `admin_user_profile` int(1) NOT NULL COMMENT 'Droit de modification de profil des utilisateurs',
  `admin_user_view` int(1) NOT NULL COMMENT 'Droit de modification des vues des utilisateurs',
  `admin_backup` int(1) NOT NULL COMMENT 'Affiche menu sauvegarde',
  `dashboard_service_only` int(1) NOT NULL COMMENT 'Affiche uniquement les tickets du ou des services auquel est rattaché l''utilisateur',
  `dashboard_agency_only` int(1) NOT NULL COMMENT 'Affiche uniquement les tickets des agences auxquelles est rattaché l''utilisateur',
  `dashboard_firstname` int(1) NOT NULL COMMENT 'Affiche le prénom dans la colonne demandeur et technicien dans la liste des tickets',
  `dashboard_col_user_service` int(1) NOT NULL COMMENT 'Affiche la colonne service du demandeur dans la liste des tickets',
  `dashboard_col_service` int(1) NOT NULL COMMENT 'Affiche la colonne service dans la liste des tickets',
  `dashboard_col_agency` int(1) NOT NULL COMMENT 'Affiche la colonne agence dans la liste des tickets',
  `dashboard_col_company` int(1) NOT NULL COMMENT 'Affiche la colonne société dans la liste des tickets',
  `dashboard_col_type` int(1) NOT NULL COMMENT 'Affiche la colonne type dans la liste des tickets',
  `dashboard_col_category` int(1) NOT NULL COMMENT 'Affiche la colonne catégorie dans la liste des tickets',
  `dashboard_col_subcat` int(1) NOT NULL COMMENT 'Affiche la colonne sous-catégorie dans la liste des tickets',
  `dashboard_col_asset` int(1) NOT NULL COMMENT 'Affiche la colonne équipement dans la liste des tickets',
  `dashboard_col_criticality` int(1) NOT NULL COMMENT 'Affiche la colonne criticité dans la liste des tickets',
  `dashboard_col_priority` int(1) NOT NULL COMMENT 'Affiche la colonne priorité dans la liste des tickets',
  `dashboard_col_date_create` int(1) NOT NULL COMMENT 'Affiche la colonne date de création dans la liste des tickets',
  `dashboard_col_date_create_hour` int(1) NOT NULL COMMENT 'Affiche l''heure de création du ticket dans la colonne date de création, sur la liste des tickets',
  `dashboard_col_date_hope` int(1) NOT NULL COMMENT 'Affiche la colonne date de résolution estimée dans la liste des tickets',
  `dashboard_col_date_res` int(1) NOT NULL COMMENT 'Affiche la colonne date de résolution dans la liste des tickets',
  `dashboard_col_date_modif` int(11) NOT NULL COMMENT 'Affiche la colonne date de dernière modification dans la liste des tickets',
  `dashboard_col_time` int(1) NOT NULL COMMENT 'Affiche la colonne temps passé dans la liste des tickets',
  `userbar` int(1) NOT NULL COMMENT 'Affiche les propriétés étendue de la barre utilisateur',
  `side` int(1) NOT NULL COMMENT 'Affiche la colonne de gauche',
  `side_open_ticket` int(1) NOT NULL COMMENT 'Affiche le bouton Ouvrir un nouveau ticket',
  `side_asset_create` int(1) NOT NULL COMMENT 'Affiche le bouton ajouter équipement',
  `side_asset_all_state` int(11) NOT NULL COMMENT 'Affiche tous les états des équipements dans le menu de gauche',
  `side_your` int(1) NOT NULL COMMENT 'Affiche la section vos tickets',
  `side_your_not_read` int(1) NOT NULL COMMENT 'Affiche vos tickets non lus',
  `side_your_not_attribute` int(1) NOT NULL COMMENT 'Affiche les tickets non attribués',
  `side_your_meta` int(1) NOT NULL COMMENT 'Affiche le meta état à traiter personnel',
  `side_your_tech_group` int(1) NOT NULL COMMENT 'Affiche les tickets associés à un groupe de technicien dans lequel vous êtes présent',
  `side_your_observer` int(1) NOT NULL COMMENT 'Affiche les tickets sur lesquels vous êtes observateur, dans la section Vos tickets',
  `side_all` int(1) NOT NULL COMMENT 'Affiche la section tous les tickets',
  `side_all_wait` int(1) NOT NULL COMMENT 'Affiche la vue nouveaux tickets dans tous les tickets',
  `side_all_meta` int(1) NOT NULL COMMENT 'Affiche le meta état à traiter pour tous les techniciens',
  `side_all_service_disp` int(1) NOT NULL COMMENT 'Affiche tous les tickets associés aux services de l''utilisateur connecté',
  `side_all_service_edit` int(1) NOT NULL COMMENT 'Permet de modifier tous les tickets associés aux services de l''utilisateur connecté',
  `side_all_agency_disp` int(1) NOT NULL COMMENT 'Affiche tous les tickets associés aux agences de l''utilisateur connecté',
  `side_all_agency_edit` int(1) NOT NULL COMMENT 'Permet de modifier tous les tickets associés aux agences de l''utilisateur connecté',
  `side_company` int(1) NOT NULL DEFAULT '0' COMMENT 'Affiche la section tous les tickets de ma société',
  `side_view` int(1) NOT NULL COMMENT 'Affiche les vues personnelles',
  `ticket_next` int(1) NOT NULL COMMENT 'Affiche les flèches ticket suivant et précédent',
  `ticket_print` int(1) NOT NULL COMMENT 'Impression des tickets',
  `ticket_template` int(1) NOT NULL COMMENT 'Affiche le bouton modèle de ticket',
  `ticket_calendar` int(1) NOT NULL COMMENT 'Planifier un ticket',
  `ticket_event` int(1) NOT NULL COMMENT 'Créer un rappel de ticket',
  `ticket_save` int(1) NOT NULL COMMENT 'Sauvegarde de ticket',
  `ticket_type` int(1) NOT NULL COMMENT 'Modification du type dans le ticket',
  `ticket_type_disp` int(1) NOT NULL COMMENT 'Affiche le champ type dans le ticket',
  `ticket_type_service_limit` int(1) NOT NULL COMMENT 'Affiche uniquement les types associés au service',
  `ticket_type_mandatory` int(1) NOT NULL COMMENT 'Oblige la saisie du champ type dans le ticket',
  `ticket_type_answer_disp` int(1) NOT NULL COMMENT 'Affiche le champ type de réponse sur le ticket',
  `ticket_service` int(1) NOT NULL COMMENT 'Modification du service dans le ticket',
  `ticket_service_disp` int(1) NOT NULL COMMENT 'Affiche le champ service dans le ticket',
  `ticket_service_mandatory` int(11) NOT NULL COMMENT 'Oblige la saisie du champ service',
  `ticket_user` int(1) NOT NULL COMMENT 'Modification du demandeur',
  `ticket_user_disp` int(1) NOT NULL COMMENT 'Affiche le champ utilisateur dans le ticket',
  `ticket_user_actions` int(1) NOT NULL COMMENT 'Affiche les boutons actions pour le demandeur',
  `ticket_user_company` int(1) NOT NULL COMMENT 'Affiche le nom de la société de l''utilisateur dans la liste des utilisateurs sur un ticket',
  `ticket_observer` int(1) NOT NULL COMMENT 'Modification du champ observateur sur le ticket',
  `ticket_observer_disp` int(1) NOT NULL COMMENT 'Affichage du champ observateur sur le ticket',
  `ticket_tech` int(1) NOT NULL COMMENT 'Modification du technicien',
  `ticket_tech_disp` int(1) NOT NULL COMMENT 'Affiche le champ technicien dans le ticket',
  `ticket_tech_service_lock` int(1) NOT NULL COMMENT 'Bloque la modification du champ technicien si la limite par service est activée et qu''il ouvre un ticket pour un autre service ',
  `ticket_tech_mandatory` int(11) NOT NULL COMMENT 'Oblige la saisie du champ technicien',
  `ticket_tech_admin` int(1) NOT NULL COMMENT 'Affiche les administrateurs dans la liste des techniciens sur un ticket.',
  `ticket_tech_super` int(1) NOT NULL COMMENT 'Affiche les superviseurs dans la liste des techniciens sur un ticket',
  `ticket_asset` int(1) NOT NULL COMMENT 'Modification de l''équipement sur un ticket',
  `ticket_asset_disp` int(1) NOT NULL COMMENT 'Affiche le champ équipement dans le ticket',
  `ticket_asset_mandatory` int(1) NOT NULL COMMENT 'Oblige la saisie du champ équipement',
  `ticket_cat` int(1) NOT NULL COMMENT 'Modification des catégories',
  `ticket_cat_disp` int(1) NOT NULL COMMENT 'Affiche le champ catégorie dans le ticket',
  `ticket_cat_actions` int(1) NOT NULL COMMENT 'Affiche les boutons actions pour les catégories',
  `ticket_cat_mandatory` int(1) NOT NULL COMMENT 'Oblige la saisie du champ catégorie',
  `ticket_cat_service_only` int(1) NOT NULL COMMENT 'Active le cloisonnement des catégories en fonction d''un service',
  `ticket_agency` int(1) NOT NULL COMMENT 'Affiche le champ agence dans le ticket',
  `ticket_agency_mandatory` int(1) NOT NULL COMMENT 'Oblige la saisie du champ agence',
  `ticket_sender_service_disp` int(1) NOT NULL COMMENT 'Affiche le champ service du demandeur dans le ticket',
  `ticket_place` int(1) NOT NULL COMMENT 'Modification du lieu',
  `ticket_place_mandatory` int(1) NOT NULL COMMENT 'Oblige la saisie du champ lieu sur le ticket',
  `ticket_title` int(1) NOT NULL COMMENT 'Modification du titre dans le ticket',
  `ticket_title_disp` int(1) NOT NULL COMMENT 'Affiche le champ titre dans le ticket',
  `ticket_title_mandatory` int(1) NOT NULL COMMENT 'Oblige la saisie du champ titre',
  `ticket_description` int(1) NOT NULL COMMENT 'Modification de la description',
  `ticket_description_disp` int(1) NOT NULL COMMENT 'Affiche le champ description dans le ticket',
  `ticket_description_mandatory` int(1) NOT NULL COMMENT 'Oblige la saisie de la description',
  `ticket_description_insert_image` int(1) NOT NULL COMMENT 'Affiche le bouton inserer image sur le champ description',
  `ticket_resolution_disp` int(1) NOT NULL COMMENT 'Affiche le champ resolution dans le ticket',
  `ticket_resolution_insert_image` int(1) NOT NULL COMMENT 'Affiche le bouton inserer image sur le champ résolution',
  `ticket_attachment` int(1) NOT NULL COMMENT 'Ajouter des pièces jointes',
  `ticket_attachment_delete` int(1) NOT NULL COMMENT 'Autorise la suppression de pièce jointe sur un ticket',
  `ticket_date_create` int(1) NOT NULL COMMENT 'Modification de la date de création',
  `ticket_date_create_disp` int(1) NOT NULL COMMENT 'Affiche le champ date de création dans le ticket',
  `ticket_date_hope` int(1) NOT NULL COMMENT 'Modification de la date de résolution estimée',
  `ticket_date_hope_disp` int(1) NOT NULL COMMENT 'Affiche le champ date de résolution estimée dans le ticket',
  `ticket_date_hope_mandatory` int(1) NOT NULL COMMENT 'Oblige la saisie du champ date de résolution estimée',
  `ticket_date_res` int(1) NOT NULL COMMENT 'Modification de la date de résolution dans le ticket',
  `ticket_date_res_disp` int(1) NOT NULL COMMENT 'Affiche le champ date de résolution dans le ticket',
  `ticket_time` int(1) NOT NULL COMMENT 'Modification du temps passé par ticket',
  `ticket_time_disp` int(1) NOT NULL COMMENT 'Affiche le champ temps passé dans le ticket',
  `ticket_time_hope` int(1) NOT NULL COMMENT 'Modification du temps estimé passé par ticket',
  `ticket_time_hope_disp` int(1) NOT NULL COMMENT 'Affiche le champ temps estimé dans le ticket',
  `ticket_priority` int(1) NOT NULL COMMENT 'Modification de la priorité dans le ticket',
  `ticket_priority_disp` int(1) NOT NULL COMMENT 'Affiche le champ priorité dans le ticket',
  `ticket_priority_mandatory` int(1) NOT NULL COMMENT 'Oblige la saisie du champ priorité',
  `ticket_priority_service_limit` int(1) NOT NULL COMMENT 'Affiche uniquement les priorités associées au service',
  `ticket_criticality` int(1) NOT NULL COMMENT 'Modification de la criticité dans le ticket',
  `ticket_criticality_disp` int(1) NOT NULL COMMENT 'Affiche le champ criticité dans le ticket',
  `ticket_criticality_mandatory` int(1) NOT NULL COMMENT 'Oblige la saisie du champ criticité',
  `ticket_criticality_service_limit` int(1) NOT NULL COMMENT 'Affiche uniquement les criticités associées au service',
  `ticket_state` int(1) NOT NULL COMMENT 'Modification du champ état dans le ticket',
  `ticket_state_disp` int(1) NOT NULL COMMENT 'Affiche le champ état dans le ticket',
  `ticket_user_validation` int(1) NOT NULL COMMENT 'Affiche le champ validation demandeur sur les tickets',
  `ticket_availability` int(1) NOT NULL COMMENT 'Modification de la partie disponibilité',
  `ticket_availability_disp` int(1) NOT NULL COMMENT 'Affiche la partie disponibilité',
  `ticket_delete` int(1) NOT NULL COMMENT 'Droit de suppression de tickets',
  `ticket_close` int(1) NOT NULL COMMENT 'Affiche le bouton de clôture dans le ticket',
  `ticket_reopen` int(1) NOT NULL COMMENT 'Affiche le bouton de ré-ouverture sur un ticket résolu',
  `ticket_thread_add` int(1) NOT NULL COMMENT 'Ajouter des réponses',
  `ticket_thread_delete` int(1) NOT NULL COMMENT 'Suppression de ses résolutions',
  `ticket_thread_delete_all` int(11) NOT NULL COMMENT 'Suppression de toutes les résolutions',
  `ticket_thread_edit` int(1) NOT NULL COMMENT 'Modification de ses résolutions',
  `ticket_thread_edit_all` int(1) NOT NULL COMMENT 'Modification de toutes les résolutions',
  `ticket_thread_post` int(1) NOT NULL COMMENT 'Droit de répondre dans les tickets',
  `ticket_thread_private` int(1) NOT NULL COMMENT 'Autorise à passer le message en privé',
  `ticket_thread_private_button` int(1) NOT NULL COMMENT 'Affiche un bouton pour ajouter un message en privé',
  `ticket_save_close` int(1) NOT NULL COMMENT 'Affiche le bouton enregistrer et fermer dans le ticket',
  `ticket_send_mail` int(1) NOT NULL COMMENT 'Affiche le bouton envoyer un mail dans le ticket',
  `ticket_cancel` int(1) NOT NULL COMMENT 'Affiche le bouton annuler dans le ticket',
  `ticket_new_type` int(1) NOT NULL COMMENT 'Modification du type pour les nouveaux tickets',
  `ticket_new_type_disp` int(1) NOT NULL COMMENT 'Affiche le champ type pour les nouveaux tickets',
  `ticket_new_service` int(1) NOT NULL COMMENT 'Modification du service pour les nouveaux tickets',
  `ticket_new_service_disp` int(1) NOT NULL COMMENT 'Affiche le champ service pour les nouveaux tickets',
  `ticket_new_user` int(1) NOT NULL COMMENT 'Modification du demandeur pour les nouveaux tickets',
  `ticket_new_user_disp` int(1) NOT NULL COMMENT 'Affiche le champ demandeur pour les nouveaux tickets',
  `ticket_new_tech_disp` int(1) NOT NULL COMMENT 'Affiche le champ technicien pour les nouveaux tickets',
  `ticket_new_asset_disp` int(1) NOT NULL COMMENT 'Affiche le champ équipement pour les nouveaux tickets',
  `ticket_new_cat` int(1) NOT NULL COMMENT 'Modification de la catégorie pour les nouveaux tickets',
  `ticket_new_cat_disp` int(1) NOT NULL COMMENT 'Affiche le champ catégorie pour les nouveaux tickets',
  `ticket_new_resolution_disp` int(1) NOT NULL COMMENT 'Affiche le champ résolution pour les nouveaux tickets',
  `ticket_new_send` int(1) NOT NULL COMMENT 'Affiche le bouton envoyer pour les nouveaux tickets',
  `ticket_new_save` int(1) NOT NULL COMMENT 'Affiche le bouton sauvegarder sur les nouveaux tickets',
  `user_profil_company` int(1) NOT NULL DEFAULT '2' COMMENT 'Modification de la société sur la fiche utilisateur',
  `user_profil_service` int(1) NOT NULL COMMENT 'Modification du service sur la fiche de l''utilisateur',
  `user_profil_agency` int(1) NOT NULL COMMENT 'Modification de l''agence sur la fiche de l''utilisateur',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `trights`
--

INSERT INTO `trights` VALUES (1,0,2,2,2,2,2,2,0,0,2,2,2,2,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,2,0,2,2,0,2,2,2,2,0,0,0,0,2,2,2,2,2,2,2,2,2,0,0,2,2,2,0,0,0,0,0,2,2,2,2,2,2,2,2,2,2,0,0,2,0,0,2,2,2,2,0,0,2,2,0,0,0,0,0,0,0,2,2,2,0,2,0,0,0,2,0,2,2,0,2,2,0,2,2,2,2,2,2,2,2,2,0,2,2,2,2,2,2,2,2,0,2,2,2,0,2,2,2,2,2,2,2,0,0,2,0,2,2,2,2,2,0,2,2,2,2,2,2,0,2,2,2,0,2,2,2,0,2,2,2,2),(2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,2,0,2,2,2,2,0,0,0,0,0,2,2,0,0,2,0,0,0,0,0,0,2,0,0,0,0,0,2,0,2,2,0,0,0,2,0,0,2,0,0,0,0,0,0,2,0,0,0,0,0,2,0,0,0,0,0,0,0,0,2,0,0,2,0,0,0,0,0,0,2,0,0,2,0,2,2,2,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,2,0,0,0,0,0,0,2,0,2,0,0,2,0,2,0,0,0,0,2,0,0,2,0,0,0,0,0,2,2,0,2,0,2,0,0),(3,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,2,0,2,2,2,2,0,0,0,0,0,2,2,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,2,0,2,2,0,0,0,2,0,0,2,0,0,0,0,0,0,2,0,0,0,0,0,2,0,0,0,0,0,0,0,0,2,0,0,2,0,0,0,0,0,0,2,0,0,2,0,2,2,2,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,2,0,0,0,0,0,0,2,0,2,0,0,0,0,2,0,0,0,0,2,0,0,2,0,0,0,0,0,2,2,0,2,0,2,0,0),(4,3,2,2,2,2,2,2,0,0,2,2,2,2,2,0,2,0,0,0,0,0,0,0,0,2,2,2,2,2,2,0,2,0,0,0,0,0,0,0,2,0,2,2,0,2,2,2,2,0,0,0,0,0,2,2,2,2,2,0,0,2,0,0,2,0,2,0,0,0,0,0,2,2,2,2,2,2,2,2,2,2,0,0,2,0,0,2,2,2,2,0,0,2,2,0,0,0,0,0,0,0,2,2,2,0,2,0,0,0,2,0,2,2,0,2,2,0,2,2,2,2,0,2,2,2,2,0,2,2,2,2,2,2,2,2,0,2,2,2,0,2,2,2,0,2,2,2,0,0,2,0,0,2,0,2,2,0,2,2,2,2,2,2,0,2,2,2,0,2,2,2,0,2,2,2,2),(5,4,2,2,2,2,2,2,0,0,2,2,2,2,2,0,2,0,0,0,0,0,0,2,0,0,0,0,0,0,0,2,2,2,0,0,0,0,0,0,2,0,2,2,0,2,2,2,2,0,0,0,0,2,2,2,2,2,2,2,2,2,0,0,2,2,2,0,0,0,0,0,2,2,2,2,2,2,2,2,2,2,0,0,2,0,0,2,2,2,0,0,0,2,2,0,0,0,0,0,0,0,2,2,2,0,2,0,0,0,2,0,2,2,0,2,2,0,2,2,2,2,2,2,2,2,2,0,2,2,2,2,2,2,2,2,0,2,2,2,0,2,2,2,2,2,2,2,0,0,2,0,2,2,2,2,2,0,2,2,2,2,2,2,0,2,2,2,0,2,2,2,0,2,2,2,2);

--
-- Table structure for table `tservices`
--

CREATE TABLE `tservices` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `ldap_guid` varchar(50) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tservices`
--

INSERT INTO `tservices` VALUES (0,'Aucun','',0);

--
-- Table structure for table `tstates`
--

CREATE TABLE `tstates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number` int(2) NOT NULL,
  `name` varchar(50) NOT NULL,
  `description` varchar(200) NOT NULL,
  `mail_object` varchar(200) NOT NULL,
  `display` varchar(100) NOT NULL,
  `meta` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tstates`
--

INSERT INTO `tstates` VALUES (1,2,'Attente PEC','tickets en attente de prise en charge','Notification d\'ouverture','badge text-75 border-l-3 brc-black-tp8 bgc-primary text-white',1),(2,3,'En cours','tickets en cours de traitement','Notification','badge text-75 border-l-3 brc-black-tp8 bgc-warning text-white',1),(3,6,'Résolu','tickets résolus','Notification de clôture','badge text-75 border-l-3 brc-black-tp8 bgc-success text-white',0),(4,7,'Rejeté','tickets rejetés','Notification de rejet','badge text-75 border-l-3 brc-black-tp8 bgc-dark text-white',0),(5,1,'Non attribué','tickets pas encore associés à un technicien','Notification de déclaration','badge text-75 border-l-3 brc-black-tp8 bgc-danger text-white',0),(6,4,'Attente Retour','tickets en attente d\'éléments de la part du demandeur','Notification d\'attente de retour ','badge text-75 border-l-3 brc-black-tp8 bgc-pink text-white',1),(7,5,'Déplacement planifié','déplacement prévu','','badge text-75 border-l-3 brc-black-tp8 bgc-secondary text-white',1);

--
-- Table structure for table `tsubcat`
--

CREATE TABLE `tsubcat` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `cat` int(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `technician` int(10) NOT NULL,
  `technician_group` int(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `technician` (`technician`),
  KEY `technician_group` (`technician_group`),
  KEY `cat` (`cat`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tsubcat`
--

INSERT INTO `tsubcat` VALUES (0,0,'Aucune',0,0),(4,5,'SCAN/PARAMETRAGE IMPRIMANTE',0,13),(6,5,'MATERIEL',0,12),(7,6,'CONSOMMABLES',0,0),(8,0,'SOPHOS',0,0),(9,0,'SOPHOS',0,0);

--
-- Table structure for table `tsurvey_answers`
--

CREATE TABLE `tsurvey_answers` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `ticket_id` int(10) NOT NULL,
  `question_id` int(5) NOT NULL,
  `answer` varchar(500) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ticket_id` (`ticket_id`),
  KEY `question_id` (`question_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tsurvey_answers`
--


--
-- Table structure for table `tsurvey_questions`
--

CREATE TABLE `tsurvey_questions` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `number` int(5) NOT NULL,
  `type` int(5) NOT NULL COMMENT '1=yes/no,2=text,3=select,4=scale',
  `text` varchar(250) NOT NULL,
  `scale` int(2) NOT NULL,
  `select_1` varchar(100) NOT NULL,
  `select_2` varchar(100) NOT NULL,
  `select_3` varchar(100) NOT NULL,
  `select_4` varchar(100) NOT NULL,
  `select_5` varchar(100) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tsurvey_questions`
--


--
-- Table structure for table `ttemplates`
--

CREATE TABLE `ttemplates` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `incident` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `incident` (`incident`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ttemplates`
--


--
-- Table structure for table `tthreads`
--

CREATE TABLE `tthreads` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `ticket` int(10) NOT NULL,
  `date` datetime NOT NULL,
  `author` int(10) NOT NULL,
  `text` mediumtext NOT NULL,
  `type` int(1) NOT NULL,
  `tech1` int(5) NOT NULL,
  `tech2` int(5) NOT NULL,
  `group1` int(5) NOT NULL,
  `group2` int(5) NOT NULL,
  `user` int(5) NOT NULL,
  `state` int(1) NOT NULL,
  `private` tinyint(1) NOT NULL DEFAULT '0',
  `dest_mail` varchar(150) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ticket` (`ticket`),
  KEY `author` (`author`),
  KEY `tech1` (`tech1`),
  KEY `tech2` (`tech2`),
  KEY `group1` (`group1`),
  KEY `group2` (`group2`),
  KEY `user` (`user`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tthreads`
--

INSERT INTO `tthreads` VALUES (2,2,'2021-06-28 14:43:45',7,'',1,7,0,0,0,0,0,0,''),(3,2,'2021-06-28 15:20:25',7,'',5,0,0,0,0,0,2,0,''),(4,2,'2021-06-28 15:20:25',7,'Déplacement nécéssaire, planifié mecredi pour 15h<br>',0,0,0,0,0,0,0,0,''),(5,3,'2021-06-28 15:25:22',7,'',1,7,0,0,0,0,0,0,''),(6,3,'2021-06-28 15:25:22',7,'',5,0,0,0,0,0,6,0,''),(7,3,'2021-06-28 15:25:34',7,'Message laissé, attente rappel<br>',0,0,0,0,0,0,0,0,''),(8,2,'2021-06-28 15:29:01',7,'',5,0,0,0,0,0,7,0,''),(46,3,'2021-07-12 09:24:27',7,'',4,0,0,0,0,0,0,0,''),(47,2,'2021-07-12 09:24:42',7,'',4,0,0,0,0,0,0,0,''),(48,2,'2021-07-12 09:25:02',7,'Soucis au niveau de la carte mère de l\'imprimante<br>',0,0,0,0,0,0,0,0,''),(49,25,'2021-07-12 09:44:47',12,'',1,9,0,0,0,0,0,0,''),(50,25,'2021-07-12 09:44:53',0,'',3,0,0,0,0,0,0,0,'f.augros@abisse-bureautique.fr'),(51,25,'2021-07-12 09:45:47',1,'',5,0,0,0,0,0,2,0,''),(52,25,'2021-07-12 09:53:01',1,'Redirection vers le prestataire téléphonie<br>',0,0,0,0,0,0,0,0,''),(53,25,'2021-07-12 09:53:01',1,'',4,0,0,0,0,0,0,0,''),(54,25,'2021-07-12 09:53:07',0,'',3,0,0,0,0,0,0,0,'f.augros@abisse-bureautique.fr'),(55,27,'2021-07-12 10:56:15',7,'',1,7,0,0,0,0,0,0,''),(56,27,'2021-07-12 10:56:23',7,'',4,0,0,0,0,0,0,0,''),(57,27,'2021-07-12 10:57:28',7,'<div>Résolu en trouvant le %appdata% de Outlook avec le fichier pst</div><div>Puis ouverture avec nk2edit et enregistrement<br></div>',0,0,0,0,0,0,0,0,''),(58,2,'2021-07-12 11:02:52',7,'',2,7,10,0,0,0,0,0,''),(59,28,'2021-07-12 11:06:41',7,'',1,7,0,0,0,0,0,0,''),(60,28,'2021-07-12 11:15:36',7,'',5,0,0,0,0,0,7,0,'');

--
-- Table structure for table `ttime`
--

CREATE TABLE `ttime` (
  `id` int(2) NOT NULL AUTO_INCREMENT,
  `min` int(100) NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ttime`
--

INSERT INTO `ttime` VALUES (1,1,'1m'),(2,5,'5m'),(3,10,'10m'),(4,30,'30m'),(5,60,'1h'),(6,180,'3h'),(7,300,'5h'),(8,480,'1j'),(9,960,'2j'),(10,2400,'1s');

--
-- Table structure for table `ttypes`
--

CREATE TABLE `ttypes` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `service` int(5) NOT NULL,
  `user_validation` int(1) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `service` (`service`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ttypes`
--

INSERT INTO `ttypes` VALUES (0,'Aucun',0,0),(1,'Demande',0,0),(2,'Incident',0,0);

--
-- Table structure for table `ttypes_answer`
--

CREATE TABLE `ttypes_answer` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `disable` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ttypes_answer`
--

INSERT INTO `ttypes_answer` VALUES (0,'Aucune',0);

--
-- Table structure for table `tusers_agencies`
--

CREATE TABLE `tusers_agencies` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `agency_id` int(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `agency_id` (`agency_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tusers_agencies`
--


--
-- Table structure for table `tusers_services`
--

CREATE TABLE `tusers_services` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `service_id` int(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `service_id` (`service_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tusers_services`
--


--
-- Table structure for table `tusers_tech`
--

CREATE TABLE `tusers_tech` (
  `id` int(5) NOT NULL AUTO_INCREMENT,
  `user` int(10) NOT NULL,
  `tech` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `tech` (`tech`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tusers_tech`
--


--
-- Table structure for table `tviews`
--

CREATE TABLE `tviews` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL,
  `name` varchar(100) NOT NULL,
  `category` int(5) NOT NULL,
  `subcat` int(5) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `category` (`category`),
  KEY `subcat` (`subcat`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tviews`
--



