[Gambas-user] Laurus -Laurus_dump.sql for mySQL 4.0.24
Charlie Reinl
Karl.Reinl at ...9...
Mon Sep 5 21:19:49 CEST 2005
Salut ,
for all who use older mySql Servers (me 4.0.24 ) and here the modified
Laurus_dump.sql
Amicalment
Charlie
-------------- next part --------------
-- MySQL dump 10.9
--
-- Host: localhost Database: Laurus
-- ------------------------------------------------------
-- Server version 4.1.10a
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
--
-- Table structure for table `Fiches_Art01`
--
DROP TABLE IF EXISTS `Fiches_Art01`;
CREATE TABLE `Fiches_Art01` (
`art_code` varchar(15) NOT NULL default '',
`art_design` varchar(30) default NULL,
`art_fam` varchar(5) default NULL,
`art_four` varchar(8) default NULL,
`art_cequ` varchar(15) default NULL,
`art_cbarre` varchar(15) default NULL,
`art_cfour` varchar(15) default NULL,
`art_pbht` double default NULL,
`art_tr` double default NULL,
`art_paht` double default NULL,
`art_coef` double default NULL,
`art_pvht` double default NULL,
`art_tva` double default NULL,
`art_pvttc` double default NULL,
`art_cdarr` varchar(4) default NULL,
`art_pvar` double default NULL,
`art_dec` char(1) default NULL,
PRIMARY KEY (`art_code`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Art01`
--
/*!40000 ALTER TABLE `Fiches_Art01` DISABLE KEYS */;
LOCK TABLES `Fiches_Art01` WRITE;
INSERT INTO `Fiches_Art01` VALUES ('01','DESHERBANT','01','401001','','','',35,2.35,34.18,2.106,71.98,1,75.94,'0,05',NULL,'0'),('02','PELLE','02','401001','','','',2.26,2.31,2.21,2.14,4.73,2,5.66,'0,01',NULL,'0');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Art01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Bl01`
--
DROP TABLE IF EXISTS `Fiches_Bl01`;
CREATE TABLE `Fiches_Bl01` (
`Numbl` char(6) NOT NULL default '',
`Type` char(1) default NULL,
`Cdclibl` char(8) default NULL,
`Cvclibl` char(9) default NULL,
`Nmclibl` char(25) default NULL,
`Pnmclibl` char(25) default NULL,
`Adr1bl` char(25) default NULL,
`Adr2bl` char(25) default NULL,
`Cpbl` char(5) default NULL,
`Villebl` char(25) default NULL,
`Datebl` date default NULL,
`Rmobl` char(6) default NULL,
`Rartbl` char(5) default NULL,
`Exobl` tinyint(4) default NULL,
PRIMARY KEY (`Numbl`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Bl01`
--
/*!40000 ALTER TABLE `Fiches_Bl01` DISABLE KEYS */;
LOCK TABLES `Fiches_Bl01` WRITE;
INSERT INTO `Fiches_Bl01` VALUES ('000001','B','411001','Gaec','LES TOUCHES','','LES TOUCHES','','87000','LIMOGES','2005-07-22','0,00','0,00',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Bl01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Cli01`
--
DROP TABLE IF EXISTS `Fiches_Cli01`;
CREATE TABLE `Fiches_Cli01` (
`Cli_Code` int(8) NOT NULL default '0',
`Cli_Col` char(1) default NULL,
`Cli_Rs_Soc` varchar(9) default NULL,
`Cli_Nom` varchar(25) default NULL,
`Cli_Pnm` varchar(15) default NULL,
`Cli_Adr1` varchar(25) default NULL,
`Cli_Adr2` varchar(25) default NULL,
`Cli_Cd_Ptl` varchar(5) default NULL,
`Cli_Ville` varchar(25) default NULL,
`Cli_Email` varchar(30) default NULL,
`Cli_Tel_Bur` varchar(16) default NULL,
`Cli_Tel_Dom` varchar(16) default NULL,
`Cli_Tel_Poste` varchar(16) default NULL,
`Cli_Pble` varchar(16) default NULL,
`Cli_Fx1` varchar(16) default NULL,
`Cli_Fx2` varchar(16) default NULL,
`Cli_Plaf_Ecrs` varchar(10) default NULL,
`Cli_Cd_Bq` varchar(5) default NULL,
`Cli_Cd_Gch` varchar(5) default NULL,
`Cli_Dmln` varchar(30) default NULL,
`Cli_Cle_Rib` char(2) default NULL,
`Cli_Num_Cpt` varchar(10) default NULL,
`Cli_Dom` varchar(25) default NULL,
`Cli_Cd_Ent` char(1) default NULL,
`Cli_Cd_Acc` char(1) default NULL,
`Cli_Ref_Tir` varchar(10) default NULL,
`Cli_Id_Tva` varchar(13) default NULL,
`Cli_Cd_Soc` char(2) default NULL,
`Cli_Cd_Cli` varchar(16) default NULL,
`Cli_Co_Vtl` varchar(255) default NULL,
`Cli_Rlvc` tinyint(4) default NULL,
`Cli_Rlvf` tinyint(4) default NULL,
`Cli_Dt_Rlc` date default NULL,
`Cli_Nm_Int` varchar(25) default NULL,
`Cli_Obs` varchar(255) default NULL,
`Cli_Collectif` varchar(8) default NULL,
`Cli_Rmo` varchar(6) default NULL,
`Cli_Rart` varchar(6) default NULL,
`Cli_Exo` tinyint(4) default NULL,
PRIMARY KEY (`Cli_Code`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Cli01`
--
/*!40000 ALTER TABLE `Fiches_Cli01` DISABLE KEYS */;
LOCK TABLES `Fiches_Cli01` WRITE;
INSERT INTO `Fiches_Cli01` VALUES (411001,NULL,'Gaec','LES TOUCHES','','LES TOUCHES','','87000','LIMOGES','','','','','','','','','','','','','',NULL,'','','','',NULL,NULL,NULL,0,0,NULL,NULL,'','411000','0,00','0,00',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Cli01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Cli_Vtl01`
--
DROP TABLE IF EXISTS `Fiches_Cli_Vtl01`;
CREATE TABLE `Fiches_Cli_Vtl01` (
`Code` char(8) NOT NULL default '',
`Code_Vtl` char(8) NOT NULL default '',
`Intitule_Vtl` char(25) default NULL,
PRIMARY KEY (`Code`,`Code_Vtl`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Cli_Vtl01`
--
/*!40000 ALTER TABLE `Fiches_Cli_Vtl01` DISABLE KEYS */;
LOCK TABLES `Fiches_Cli_Vtl01` WRITE;
INSERT INTO `Fiches_Cli_Vtl01` VALUES ('411001','707100','VENTES 19.60'),('411001','707000','VENTES 5.50');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Cli_Vtl01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Commentaires01`
--
DROP TABLE IF EXISTS `Fiches_Commentaires01`;
CREATE TABLE `Fiches_Commentaires01` (
`Numcom` char(2) NOT NULL default '',
`Intitule` char(90) default NULL,
PRIMARY KEY (`Numcom`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Commentaires01`
--
/*!40000 ALTER TABLE `Fiches_Commentaires01` DISABLE KEYS */;
LOCK TABLES `Fiches_Commentaires01` WRITE;
INSERT INTO `Fiches_Commentaires01` VALUES ('1','GARANTIE 6 MOIS PIECES ET MAIN D\'OEUVRE'),('2','GARANTIE 1 AN PIECES ET MAIN D\'OEUVRE');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Commentaires01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Comptes01`
--
DROP TABLE IF EXISTS `Fiches_Comptes01`;
CREATE TABLE `Fiches_Comptes01` (
`compte_cc` int(11) NOT NULL default '0',
`intitule_cc` varchar(25) default NULL,
`type_cc` char(1) default NULL,
`tresor_cc` int(11) default NULL,
`coll` int(11) default NULL,
`coll_cc` varchar(8) default NULL,
`cent_cc` int(11) default NULL,
`comptr_cc` int(11) default NULL,
`code_tvente` char(1) default NULL,
`taux_tvente` varchar(5) default NULL,
`gen_tv` int(11) default NULL,
`code_tachat` char(1) default NULL,
`taux_tachat` varchar(5) default NULL,
`gen_ta` int(11) default NULL,
`solde` double NOT NULL default '0',
`soldep` double NOT NULL default '0',
PRIMARY KEY (`compte_cc`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Comptes01`
--
/*!40000 ALTER TABLE `Fiches_Comptes01` DISABLE KEYS */;
LOCK TABLES `Fiches_Comptes01` WRITE;
INSERT INTO `Fiches_Comptes01` VALUES (401000,'COLLECTIF FOURNISSEUR','B',NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(411000,'COLLECTIF CLIENT','B',NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(445700,'TVA COLLECTEE','B',0,0,NULL,1,0,'','',0,'','',0,0,0),(445600,'TVA SUR ACHAT','B',NULL,0,NULL,1,0,'','',0,'','',0,0,0),(606000,'ACHAT 5.50','G',0,0,NULL,0,0,'','',0,'1','5.50',1,0,0),(707000,'VENTES 5.50','G',0,0,NULL,0,0,'1','5.50',1,'','',0,0,0),(707100,'VENTES 19.60','G',0,0,NULL,0,0,'2','19.60',1,'','',0,0,0),(607000,'ACHAT 19.60','G',0,0,NULL,0,0,'','',0,'2','19.60',1,0,0),(411001,'LES TOUCHES','C',NULL,0,'411000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(401001,'LIRETTE','F',NULL,0,'401000',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0),(512000,'BANQUE','B',1,0,NULL,0,1,'','',0,'','',0,0,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Comptes01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Fam01`
--
DROP TABLE IF EXISTS `Fiches_Fam01`;
CREATE TABLE `Fiches_Fam01` (
`code_fam` varchar(5) NOT NULL default '',
`libell_fam` varchar(30) default NULL,
`compt_fam` varchar(8) default NULL,
`coef_fam` double default NULL,
`cdtva_fam` varchar(8) default NULL,
`txtva_fam` double default NULL,
PRIMARY KEY (`code_fam`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Fam01`
--
/*!40000 ALTER TABLE `Fiches_Fam01` DISABLE KEYS */;
LOCK TABLES `Fiches_Fam01` WRITE;
INSERT INTO `Fiches_Fam01` VALUES ('01','JARDINAGE 5.50','707000',2.25,'1',5.5),('02','JARDINAGE 19.60','707100',2.25,'2',19.6),('03','MAIN D\'OEUVRE','707100',1.5,'2',19.6);
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Fam01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Four01`
--
DROP TABLE IF EXISTS `Fiches_Four01`;
CREATE TABLE `Fiches_Four01` (
`Fo_Code` int(8) NOT NULL default '0',
`Fo_Col` char(1) default NULL,
`Fo_Rs_Soc` varchar(9) default NULL,
`Fo_Nom` varchar(25) default NULL,
`Fo_Pnm` varchar(15) default NULL,
`Fo_Adr1` varchar(25) default NULL,
`Fo_Adr2` varchar(25) default NULL,
`Fo_Cd_Ptl` varchar(5) default NULL,
`Fo_Ville` varchar(25) default NULL,
`Fo_Email` varchar(30) default NULL,
`Fo_Tel_Std` varchar(30) default NULL,
`Fo_Tel_Bur` varchar(16) default NULL,
`Fo_Tel_Post` varchar(16) default NULL,
`Fo_Pble` varchar(16) default NULL,
`Fo_Fx1` varchar(16) default NULL,
`Fo_Fx2` varchar(16) default NULL,
`Fo_Plaf_Ecrs` varchar(10) default NULL,
`Fo_Obs` varchar(255) default NULL,
`Fo_Cd_Bq` varchar(5) default NULL,
`Fo_Cd_Gch` varchar(5) default NULL,
`Fo_Cle_Rib` char(2) default NULL,
`Fo_Num_Cpt` varchar(10) default NULL,
`Fo_Dom` varchar(25) default NULL,
`Fo_Id_Tva` varchar(13) default NULL,
`Fo_Cd_Soc` char(2) default NULL,
`Fo_Site` varchar(35) default NULL,
`Fo_Cd_Cli` varchar(16) default NULL,
`Fo_Co_Vtl` varchar(255) default NULL,
`Fo_Collectif` varchar(8) default NULL,
PRIMARY KEY (`Fo_Code`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Four01`
--
/*!40000 ALTER TABLE `Fiches_Four01` DISABLE KEYS */;
LOCK TABLES `Fiches_Four01` WRITE;
INSERT INTO `Fiches_Four01` VALUES (401001,'F','EURL','LIRETTE','','38 RUE DES ALBERTS','','69000','LYON','','','','','','','',NULL,'','','','','','','',NULL,'','',NULL,'401000');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Four01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Four_Vtl01`
--
DROP TABLE IF EXISTS `Fiches_Four_Vtl01`;
CREATE TABLE `Fiches_Four_Vtl01` (
`Code` char(8) NOT NULL default '',
`Code_Vtl` char(8) NOT NULL default '',
`Intitule_Vtl` char(25) default NULL,
PRIMARY KEY (`Code`,`Code_Vtl`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Four_Vtl01`
--
/*!40000 ALTER TABLE `Fiches_Four_Vtl01` DISABLE KEYS */;
LOCK TABLES `Fiches_Four_Vtl01` WRITE;
INSERT INTO `Fiches_Four_Vtl01` VALUES ('401001','606000','ACHAT 5.50'),('401001','607000','ACHAT 19.60');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Four_Vtl01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_HistoFac01`
--
DROP TABLE IF EXISTS `Fiches_HistoFac01`;
CREATE TABLE `Fiches_HistoFac01` (
`Numfac` char(10) NOT NULL default '',
`Cdclifac` char(8) default NULL,
`Cvclifac` char(9) default NULL,
`Nmclifac` char(25) default NULL,
`Pnmclifac` char(25) default NULL,
`Adr1fac` char(25) default NULL,
`Adr2fac` char(25) default NULL,
`Cpfac` char(5) default NULL,
`Villefac` char(25) default NULL,
`Datefac` date default NULL,
`Rmofac` char(6) default NULL,
`Rartfac` char(5) default NULL,
`Exofac` tinyint(4) default NULL,
`Totfac` char(10) default NULL,
PRIMARY KEY (`Numfac`),
KEY `Cdclifac` (`Cdclifac`),
KEY `Nmclifac` (`Nmclifac`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_HistoFac01`
--
/*!40000 ALTER TABLE `Fiches_HistoFac01` DISABLE KEYS */;
LOCK TABLES `Fiches_HistoFac01` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_HistoFac01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_HistoLigfac01`
--
DROP TABLE IF EXISTS `Fiches_HistoLigfac01`;
CREATE TABLE `Fiches_HistoLigfac01` (
`Num_Ligfac` varchar(10) NOT NULL default '',
`Numlig_Ligfac` varchar(6) NOT NULL default '',
`Code_Ligfac` varchar(15) default NULL,
`Libel_Ligfac` varchar(30) default NULL,
`Fam_Ligfac` varchar(5) default NULL,
`Pu_Ligfac` varchar(10) default NULL,
`Qte_Ligfac` varchar(6) default NULL,
`Brut_Ligfac` varchar(10) default NULL,
`Rem_Ligfac` varchar(6) default NULL,
`Netht_Ligfac` varchar(10) default NULL,
`Tx_Ligfac` char(1) default NULL,
`Nettc_Ligfac` varchar(10) default NULL,
`Typel_Ligfac` char(1) default NULL,
`Tm_Ligfac` char(1) default NULL,
`Com_Ligfac` varchar(82) default NULL,
PRIMARY KEY (`Num_Ligfac`,`Numlig_Ligfac`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_HistoLigfac01`
--
/*!40000 ALTER TABLE `Fiches_HistoLigfac01` DISABLE KEYS */;
LOCK TABLES `Fiches_HistoLigfac01` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_HistoLigfac01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Libelles01`
--
DROP TABLE IF EXISTS `Fiches_Libelles01`;
CREATE TABLE `Fiches_Libelles01` (
`Num` char(2) NOT NULL default '',
`Intitule` char(30) default NULL,
PRIMARY KEY (`Num`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Libelles01`
--
/*!40000 ALTER TABLE `Fiches_Libelles01` DISABLE KEYS */;
LOCK TABLES `Fiches_Libelles01` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Libelles01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Ligbl01`
--
DROP TABLE IF EXISTS `Fiches_Ligbl01`;
CREATE TABLE `Fiches_Ligbl01` (
`Num_Ligbl` varchar(6) NOT NULL default '',
`Numlig_Ligbl` varchar(6) NOT NULL default '',
`Code_Ligbl` varchar(15) default NULL,
`Libel_Ligbl` varchar(30) default NULL,
`Fam_Ligbl` varchar(5) default NULL,
`Pu_Ligbl` varchar(10) default NULL,
`Dec_Ligbl` char(1) default NULL,
`Qte_Ligbl` varchar(6) default NULL,
`Brut_Ligbl` varchar(10) default NULL,
`Rem_Ligbl` varchar(6) default NULL,
`Netht_Ligbl` varchar(10) default NULL,
`Tx_Ligbl` char(1) default NULL,
`Nettc_Ligbl` varchar(10) default NULL,
`Typel_Ligbl` char(1) default NULL,
`Tm_Ligbl` char(1) default NULL,
`Com_Ligbl` varchar(82) default NULL,
PRIMARY KEY (`Num_Ligbl`,`Numlig_Ligbl`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Ligbl01`
--
/*!40000 ALTER TABLE `Fiches_Ligbl01` DISABLE KEYS */;
LOCK TABLES `Fiches_Ligbl01` WRITE;
INSERT INTO `Fiches_Ligbl01` VALUES ('000001','0003','02','PELLE','02','4,73','0','1,00','4,73','0,00','4,73','2','5,66','A',NULL,NULL),('000001','0001','04','REGLAGE LANCEUR','02','28,00','','1.00','35,00','0,00','35,00','0','35,00','M',NULL,NULL),('000001','0002','2',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'C',NULL,'GARANTIE 1 AN PIECES ET MAIN D\'OEUVRE');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Ligbl01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Mo01`
--
DROP TABLE IF EXISTS `Fiches_Mo01`;
CREATE TABLE `Fiches_Mo01` (
`Mo_Code` char(15) NOT NULL default '',
`Mo_Design` char(30) default NULL,
`Mo_Fam` char(5) default NULL,
`Mo_Four` int(8) default NULL,
`Mo_Txcd` char(2) default NULL,
`Mo_TxHt` float default NULL,
`Mo_Tva` float default NULL,
`Mo_TempMont` char(1) default NULL,
`Mo_Montant` float default NULL,
PRIMARY KEY (`Mo_Code`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Mo01`
--
/*!40000 ALTER TABLE `Fiches_Mo01` DISABLE KEYS */;
LOCK TABLES `Fiches_Mo01` WRITE;
INSERT INTO `Fiches_Mo01` VALUES ('01','MO T1','03',401001,'01',25.5,2,'T',0),('02','MO T2','03',401001,'02',28,2,'T',0),('03','MO T3','03',401001,'03',32,2,'T',0),('04','REGLAGE LANCEUR','03',401001,'02',28,2,'M',35);
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Mo01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Mvt01`
--
DROP TABLE IF EXISTS `Fiches_Mvt01`;
CREATE TABLE `Fiches_Mvt01` (
`Jour` char(2) default NULL,
`Numero` int(6) NOT NULL default '0',
`Compte` char(8) NOT NULL default '',
`Collectif` tinyint(4) default NULL,
`Intitule` char(30) default NULL,
`Dte` date default NULL,
`Datee` date default NULL,
`Numdoc` char(10) NOT NULL default '',
`Numlot` char(10) NOT NULL default '',
`Libelle` char(30) default NULL,
`Montantd` float default NULL,
`Montantc` float default NULL,
`Validee` tinyint(1) default NULL,
`Provisoire` tinyint(1) default NULL,
`Tresorerie` tinyint(1) default NULL,
`Pointee` tinyint(1) default NULL,
`Nrlv` int(8) default NULL,
`Lettree` tinyint(1) default NULL,
`Cloturee` tinyint(1) default NULL,
`Relance` int(1) default NULL,
PRIMARY KEY (`Numero`,`Compte`,`Numdoc`,`Numlot`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Mvt01`
--
/*!40000 ALTER TABLE `Fiches_Mvt01` DISABLE KEYS */;
LOCK TABLES `Fiches_Mvt01` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Mvt01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Mvt101`
--
DROP TABLE IF EXISTS `Fiches_Mvt101`;
CREATE TABLE `Fiches_Mvt101` (
`Jour` char(2) default NULL,
`Numero` int(6) NOT NULL default '0',
`Compte` char(8) NOT NULL default '',
`Collectif` tinyint(4) default NULL,
`Intitule` char(30) default NULL,
`Dte` date default NULL,
`Datee` date default NULL,
`Numdoc` char(10) NOT NULL default '',
`Numlot` char(10) NOT NULL default '',
`Libelle` char(30) default NULL,
`Montantd` float default NULL,
`Montantc` float default NULL,
`Validee` tinyint(1) default NULL,
`Provisoire` tinyint(1) default NULL,
`Tresorerie` tinyint(1) default NULL,
`Pointee` tinyint(1) default NULL,
`Nrlv` int(8) default NULL,
`Lettree` tinyint(1) default NULL,
`Cloturee` tinyint(1) default NULL,
PRIMARY KEY (`Numero`,`Compte`,`Numdoc`,`Numlot`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Mvt101`
--
/*!40000 ALTER TABLE `Fiches_Mvt101` DISABLE KEYS */;
LOCK TABLES `Fiches_Mvt101` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Mvt101` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Mvt201`
--
DROP TABLE IF EXISTS `Fiches_Mvt201`;
CREATE TABLE `Fiches_Mvt201` (
`Jour` char(2) default NULL,
`Numero` int(6) NOT NULL default '0',
`Compte` char(8) NOT NULL default '',
`Collectif` tinyint(4) default NULL,
`Intitule` char(30) default NULL,
`Dte` date default NULL,
`Datee` date default NULL,
`Numdoc` char(10) NOT NULL default '',
`Numlot` char(10) NOT NULL default '',
`Libelle` char(30) default NULL,
`Montantd` float default NULL,
`Montantc` float default NULL,
`Validee` tinyint(1) default NULL,
`Provisoire` tinyint(1) default NULL,
`Tresorerie` tinyint(1) default NULL,
`Pointee` tinyint(1) default NULL,
`Nrlv` int(8) default NULL,
`Lettree` tinyint(1) default NULL,
`Cloturee` tinyint(1) default NULL,
PRIMARY KEY (`Numero`,`Compte`,`Numdoc`,`Numlot`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Mvt201`
--
/*!40000 ALTER TABLE `Fiches_Mvt201` DISABLE KEYS */;
LOCK TABLES `Fiches_Mvt201` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Mvt201` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Mvt301`
--
DROP TABLE IF EXISTS `Fiches_Mvt301`;
CREATE TABLE `Fiches_Mvt301` (
`Jour` char(2) default NULL,
`Numero` int(6) NOT NULL default '0',
`Compte` char(8) NOT NULL default '',
`Collectif` tinyint(4) default NULL,
`Intitule` char(30) default NULL,
`Dte` date default NULL,
`Datee` date default NULL,
`Numdoc` char(10) NOT NULL default '',
`Numlot` char(10) NOT NULL default '',
`Libelle` char(30) default NULL,
`Montantd` float default NULL,
`Montantc` float default NULL,
`Validee` tinyint(1) default NULL,
`Provisoire` tinyint(1) default NULL,
`Tresorerie` tinyint(1) default NULL,
`Pointee` tinyint(1) default NULL,
`Nrlv` int(8) default NULL,
`Lettree` tinyint(1) default NULL,
`Cloturee` tinyint(1) default NULL,
PRIMARY KEY (`Numero`,`Compte`,`Numdoc`,`Numlot`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Mvt301`
--
/*!40000 ALTER TABLE `Fiches_Mvt301` DISABLE KEYS */;
LOCK TABLES `Fiches_Mvt301` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Mvt301` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Mvt401`
--
DROP TABLE IF EXISTS `Fiches_Mvt401`;
CREATE TABLE `Fiches_Mvt401` (
`Jour` char(2) default NULL,
`Numero` int(6) NOT NULL default '0',
`Compte` char(8) NOT NULL default '',
`Collectif` tinyint(4) default NULL,
`Intitule` char(30) default NULL,
`Dte` date default NULL,
`Datee` date default NULL,
`Numdoc` char(10) NOT NULL default '',
`Numlot` char(10) NOT NULL default '',
`Libelle` char(30) default NULL,
`Montantd` float default NULL,
`Montantc` float default NULL,
`Validee` tinyint(1) default NULL,
`Provisoire` tinyint(1) default NULL,
`Tresorerie` tinyint(1) default NULL,
`Pointee` tinyint(1) default NULL,
`Nrlv` int(8) default NULL,
`Lettree` tinyint(1) default NULL,
`Cloturee` tinyint(1) default NULL,
PRIMARY KEY (`Numero`,`Compte`,`Numdoc`,`Numlot`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Mvt401`
--
/*!40000 ALTER TABLE `Fiches_Mvt401` DISABLE KEYS */;
LOCK TABLES `Fiches_Mvt401` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Mvt401` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Mvt501`
--
DROP TABLE IF EXISTS `Fiches_Mvt501`;
CREATE TABLE `Fiches_Mvt501` (
`Jour` char(2) default NULL,
`Numero` int(6) NOT NULL default '0',
`Compte` char(8) NOT NULL default '',
`Collectif` tinyint(4) default NULL,
`Intitule` char(30) default NULL,
`Dte` date default NULL,
`Datee` date default NULL,
`Numdoc` char(10) NOT NULL default '',
`Numlot` char(10) NOT NULL default '',
`Libelle` char(30) default NULL,
`Montantd` float default NULL,
`Montantc` float default NULL,
`Validee` tinyint(1) default NULL,
`Provisoire` tinyint(1) default NULL,
`Tresorerie` tinyint(1) default NULL,
`Pointee` tinyint(1) default NULL,
`Nrlv` int(8) default NULL,
`Lettree` tinyint(1) default NULL,
`Cloturee` tinyint(1) default NULL,
PRIMARY KEY (`Numero`,`Compte`,`Numdoc`,`Numlot`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Mvt501`
--
/*!40000 ALTER TABLE `Fiches_Mvt501` DISABLE KEYS */;
LOCK TABLES `Fiches_Mvt501` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Mvt501` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Parametres01`
--
DROP TABLE IF EXISTS `Fiches_Parametres01`;
CREATE TABLE `Fiches_Parametres01` (
`dteclec` date default NULL,
`dteclec1` date default NULL,
`dteclec2` date default NULL,
`dteclec3` date default NULL,
`dteclec4` date default NULL,
`dteclec5` date default NULL,
`dtepp` date default NULL,
`dtepec` date default NULL,
`dtepc` date default NULL,
`dtetdec` date default NULL,
`dtefedec` date default NULL,
`cptrplus` char(8) default NULL,
`cptrmoins` char(8) default NULL,
`jdr` char(2) default NULL,
`cptrsplus` char(8) default NULL,
`cptrsmoins` char(8) default NULL,
`numecriture` int(6) default NULL,
`Dnc` int(8) default NULL,
`Dnbon` char(8) default NULL,
`Dnfac` char(5) default NULL,
`Dndevis` char(8) default NULL,
`Jrnal` char(2) default NULL,
`Dnf` int(8) default NULL
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Parametres01`
--
/*!40000 ALTER TABLE `Fiches_Parametres01` DISABLE KEYS */;
LOCK TABLES `Fiches_Parametres01` WRITE;
INSERT INTO `Fiches_Parametres01` VALUES ('2005-07-31','2004-07-31','2003-07-31','2002-07-31','2001-07-31','2000-07-31',NULL,NULL,'2005-07-31','2005-06-30','2005-06-30','758000','658000','10','120000','121000',4,411001,'000001','1','0','70',401001);
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Parametres01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Relances01`
--
DROP TABLE IF EXISTS `Fiches_Relances01`;
CREATE TABLE `Fiches_Relances01` (
`Compte` char(8) NOT NULL default '',
`Intitule` char(30) default NULL,
`Dte` char(10) default NULL,
`Numdoc` char(10) NOT NULL default '',
`Numlot` char(10) default NULL,
`Libelle` char(30) default NULL,
`Montantd` float default NULL,
`Montantc` float default NULL,
PRIMARY KEY (`Compte`,`Numdoc`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Relances01`
--
/*!40000 ALTER TABLE `Fiches_Relances01` DISABLE KEYS */;
LOCK TABLES `Fiches_Relances01` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Relances01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Societes`
--
DROP TABLE IF EXISTS `Fiches_Societes`;
CREATE TABLE `Fiches_Societes` (
`Cd_sc` char(2) NOT NULL default '',
`Type_sc` char(6) default NULL,
`Int_sc` char(25) default NULL,
`Adr1_sc` char(25) default NULL,
`Adr2_sc` char(25) default NULL,
`Cp_sc` char(5) default NULL,
`Burdis_sc` char(25) default NULL,
`Email_sc` char(30) default NULL,
`Rcs_sc` char(12) default NULL,
`Villerc_sc` char(15) default NULL,
`Siret_sc` char(15) default NULL,
`Tvaintra_sc` char(15) default NULL,
`Cap_sc` char(10) default NULL,
`Ape_sc` char(5) default NULL,
PRIMARY KEY (`Cd_sc`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Societes`
--
/*!40000 ALTER TABLE `Fiches_Societes` DISABLE KEYS */;
LOCK TABLES `Fiches_Societes` WRITE;
INSERT INTO `Fiches_Societes` VALUES ('01','SA','Laurus','','','','','','','','','','','');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Societes` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Tvaac01`
--
DROP TABLE IF EXISTS `Fiches_Tvaac01`;
CREATE TABLE `Fiches_Tvaac01` (
`Code_tva` char(1) NOT NULL default '',
`Taux_tva` char(5) NOT NULL default '',
`Cc_tva` char(8) NOT NULL default '',
PRIMARY KEY (`Code_tva`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Tvaac01`
--
/*!40000 ALTER TABLE `Fiches_Tvaac01` DISABLE KEYS */;
LOCK TABLES `Fiches_Tvaac01` WRITE;
INSERT INTO `Fiches_Tvaac01` VALUES ('1','5.50','445600'),('2','19.60','445600');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Tvaac01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Tvaav01`
--
DROP TABLE IF EXISTS `Fiches_Tvaav01`;
CREATE TABLE `Fiches_Tvaav01` (
`Code_tva` char(1) NOT NULL default '',
`Taux_tva` char(5) NOT NULL default '',
`Cc_tva` char(8) NOT NULL default '',
PRIMARY KEY (`Code_tva`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Tvaav01`
--
/*!40000 ALTER TABLE `Fiches_Tvaav01` DISABLE KEYS */;
LOCK TABLES `Fiches_Tvaav01` WRITE;
INSERT INTO `Fiches_Tvaav01` VALUES ('1','5.50','445700'),('2','19.60','445700');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Tvaav01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Txt_Relances01`
--
DROP TABLE IF EXISTS `Fiches_Txt_Relances01`;
CREATE TABLE `Fiches_Txt_Relances01` (
`Niveau` int(1) NOT NULL default '0',
`Libell1` text,
`Libell2` text,
PRIMARY KEY (`Niveau`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Txt_Relances01`
--
/*!40000 ALTER TABLE `Fiches_Txt_Relances01` DISABLE KEYS */;
LOCK TABLES `Fiches_Txt_Relances01` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Txt_Relances01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_Txtmo01`
--
DROP TABLE IF EXISTS `Fiches_Txtmo01`;
CREATE TABLE `Fiches_Txtmo01` (
`Code_Txtmo` char(2) NOT NULL default '',
`Tx_Txtmo` float default NULL,
`Libell_Txtmo` char(25) default NULL,
`Compt_Txtmo` char(8) default NULL,
PRIMARY KEY (`Code_Txtmo`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_Txtmo01`
--
/*!40000 ALTER TABLE `Fiches_Txtmo01` DISABLE KEYS */;
LOCK TABLES `Fiches_Txtmo01` WRITE;
INSERT INTO `Fiches_Txtmo01` VALUES ('01',25.5,'MO T1','707100'),('02',28,'MO T2','707100'),('03',32,'MO T3','707100');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_Txtmo01` ENABLE KEYS */;
--
-- Table structure for table `Fiches_journaux01`
--
DROP TABLE IF EXISTS `Fiches_journaux01`;
CREATE TABLE `Fiches_journaux01` (
`Code_jo` char(2) NOT NULL default '',
`Libelle_jo` char(15) default NULL,
`Type_jo` char(2) NOT NULL default '',
`Cde_banque` char(8) default NULL,
PRIMARY KEY (`Code_jo`)
) TYPE=MyISAM;
--
-- Dumping data for table `Fiches_journaux01`
--
/*!40000 ALTER TABLE `Fiches_journaux01` DISABLE KEYS */;
LOCK TABLES `Fiches_journaux01` WRITE;
INSERT INTO `Fiches_journaux01` VALUES ('10','A NOUVEAU','OD',''),('70','VENTES','VE',''),('60','ACHATS','AC',''),('50','BANQUE','TR','512000');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Fiches_journaux01` ENABLE KEYS */;
--
-- Table structure for table `Totalisation`
--
DROP TABLE IF EXISTS `Totalisation`;
CREATE TABLE `Totalisation` (
`Compte` char(8) NOT NULL default '',
`Intitule` char(25) default NULL,
`Totalht` char(25) default NULL,
`Totaltva` char(25) default NULL,
`Codetva` char(1) default NULL,
PRIMARY KEY (`Compte`)
) TYPE=MyISAM;
--
-- Dumping data for table `Totalisation`
--
/*!40000 ALTER TABLE `Totalisation` DISABLE KEYS */;
LOCK TABLES `Totalisation` WRITE;
INSERT INTO `Totalisation` VALUES ('411001','LES TOUCHES','40,66',NULL,NULL),('707100','VENTES 19.60','39,73',NULL,'2'),('445700','TVA COLLECTEE',NULL,'0,93','2');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Totalisation` ENABLE KEYS */;
--
-- Table structure for table `Totalisation01`
--
DROP TABLE IF EXISTS `Totalisation01`;
CREATE TABLE `Totalisation01` (
`Compte` char(8) NOT NULL default '',
`Intitule` char(25) default NULL,
`Totalht` char(25) default NULL,
`Totaltva` char(25) default NULL,
`Codetva` char(1) default NULL,
PRIMARY KEY (`Compte`)
) TYPE=MyISAM;
--
-- Dumping data for table `Totalisation01`
--
/*!40000 ALTER TABLE `Totalisation01` DISABLE KEYS */;
LOCK TABLES `Totalisation01` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `Totalisation01` ENABLE KEYS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
More information about the User
mailing list