1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
| CREATE TABLE `clients` (
`numclient` int(10) NOT NULL auto_increment,
`numcat` int(3) unsigned default '1',
`numville` int(6) unsigned default NULL,
`codeclient` varchar(11) default NULL,
`typeclient` int(3) default NULL,
`groupeclient` tinyint(3) unsigned default NULL,
`nomsoc` varchar(150) default NULL,
`adresse` varchar(150) default NULL,
`telephone` varchar(20) default NULL,
`tel2` varchar(20) default NULL,
`tel3` varchar(20) default NULL,
`fax` varchar(20) default NULL,
`titre` varchar(20) default NULL,
`url` varchar(50) default NULL,
`email` varchar(100) default NULL,
`paiement` int(3) unsigned default '0',
`commentaires` mediumtext,
`valide` tinyint(1) unsigned default '1',
`exempfacture` int(5) default NULL,
`numintracomm` varchar(30) default NULL,
`refsociete` varchar(30) default NULL,
`refnumsoc` int(5) default NULL,
PRIMARY KEY (`numclient`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `facture` (
`numid` int(6) unsigned NOT NULL auto_increment,
`datefacture` date default NULL,
`numfacture` int(6) unsigned default NULL,
`numclient` int(5) unsigned default NULL,
`codeclient` varchar(10) default NULL,
`adresse` mediumtext,
`tva` float(5,2) default NULL,
`total` float(10,2) default NULL,
`paiement` tinytext,
`termine` tinyint(1) unsigned default '0',
`regle` tinyint(1) unsigned default '0',
`dateregle` date default NULL,
`adateecheance` date default '0000-00-00',
`modepaiement` varchar(30) default NULL,
PRIMARY KEY (`numid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
Partager