1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
| --
-- Table structure for table `COMMANDE_BL`
--
DROP TABLE IF EXISTS `COMMANDE_BL`;
CREATE TABLE `COMMANDE_BL` (
`ID_COMMANDE_BL` int(11) NOT NULL auto_increment,
`BL_COMMANDE` varchar(255) NOT NULL default '',
`DATE_BL_COMMANDE` datetime NOT NULL default '0000-00-00 00:00:00',
`COMMENTAIRE_COMMANDE_BL` text NOT NULL,
`id_ligne` int(11) NOT NULL default '0',
`QTE_RECU` int(11) NOT NULL default '0',
`EXPORT_RECU` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`ID_COMMANDE_BL`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `COMMANDE_BL`
--
/*!40000 ALTER TABLE `COMMANDE_BL` DISABLE KEYS */;
LOCK TABLES `COMMANDE_BL` WRITE;
INSERT INTO `COMMANDE_BL` VALUES (1,'TESTAUTO','2005-09-01 00:00:00','',43535,50,0),(2,'','2005-09-01 00:00:00','',43540,2,0),(3,'','2005-09-15 00:00:00','',43540,0,0),(4,'110831','2005-09-05 00:00:00','',43551,1,0),(5,'101097','2005-08-03 00:00:00','',43551,1,0),(6,'701','2005-09-15 00:00:00','',43540,1,0),(7,'','2005-09-23 00:00:00','',43540,1,0),(8,'701','2005-10-03 00:00:00','',43540,1,0),(9,'136175','2005-10-04 00:00:00','',43548,0,0),(10,'91028','2005-10-06 00:00:00','',43551,1,0),(11,'','2005-10-13 00:00:00','',43548,0,0),(12,'','2005-11-13 00:00:00','',43548,0,0),(13,'','2005-11-13 00:00:00','',43551,0,0),(14,'','2005-11-04 00:00:00','',43551,1,0),(15,'701','2005-11-15 00:00:00','',43540,4,0),(16,'701','2005-11-17 00:00:00','',43540,1,0),(17,'','2005-12-01 00:00:00','',43540,0,0),(18,'VA3002/1JAN2006','2006-01-03 00:00:00','',45495,1,0),(19,'701/23012006','2006-01-23 00:00:00','',45495,1,0),(20,'701/02022006','2006-02-06 00:00:00','',45495,1,0),(21,'701/16022006','2006-02-16 00:00:00','',45495,1,0),(22,'701/02032006','2006-03-02 00:00:00','',45495,1,0),(23,'','2006-03-15 00:00:00','',45495,0,0),(24,'701 DU 16032006','2006-03-20 00:00:00','',46894,1,0),(25,'701 DU 16032006','2006-03-20 00:00:00','',46895,1,0),(26,'80139261','2006-04-04 00:00:00','',47352,5,0),(27,'80142370','2006-04-12 00:00:00','',47352,5,0),(28,'CC3879','2006-03-28 00:00:00','',48269,1,0),(29,'CC3879','2006-03-28 00:00:00','',48270,1,0),(30,'VA2995','2006-04-11 00:00:00','',48269,1,0),(31,'CC3878','2006-04-11 00:00:00','',48270,1,0),(32,'0604255011','2006-05-05 00:00:00','',48269,1,0),(33,'0604255011','2006-05-05 00:00:00','',48270,1,0),(34,'CC3876','2006-05-09 00:00:00','Echeance du 15/05/06',48270,1,0),(35,'VA2993','2006-05-09 00:00:00','Echeance du 15/05/2006',48269,1,0),(36,'ED1932','2006-05-30 00:00:00','',48269,1,0),(37,'ED1934','2006-05-30 00:00:00','Echeance du 30/05/06',48270,1,0),(38,'FA1081','2006-06-15 00:00:00','Juin 1/2',49236,1,0),(39,'FA1082','2006-06-06 00:00:00','JUIN 1/2',49237,1,0),(40,'FA1080','2006-06-19 00:00:00','Juin 2/2',49236,1,0),(41,'FA1079','2006-06-19 00:00:00','JUIN 2/2',49237,1,0),(42,'GB0527','2006-07-03 00:00:00','Juillet 1/2',49236,1,0),(43,'GB0526','2006-07-03 00:00:00','JUILLET 1/2',49237,1,0),(44,'GB0539','2006-07-11 00:00:00','Juillet 2/2',49236,1,0),(45,'GB0541','2006-07-11 00:00:00','Juillet 2/2',49237,1,0),(46,'GB0538','2006-07-27 00:00:00','',49236,1,0),(47,'GB0540','2006-07-27 00:00:00','',49237,1,0),(48,'','2006-08-03 00:00:00','',49237,0,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `COMMANDE_BL` ENABLE KEYS */; |
Partager