CREATE TABLE `groupemarchandise` (
  `No` int(11) NOT NULL default '0',
  `Description` varchar(64) NOT NULL default '',
  PRIMARY KEY  (`No`)
);

CREATE TABLE `lieuxstoquage` (
`Id` varchar( 9 ) NOT NULL default '',
`Description` varchar( 64 ) NOT NULL default '',
PRIMARY KEY ( `Id` )
);

CREATE TABLE `fournisseurs` (
  `Id` int(11) NOT NULL auto_increment,
  `NoClient` int(11) NOT NULL default '0',
  `Description` varchar(128) NOT NULL default '',
  PRIMARY KEY  (`Id`)
);

ALTER TABLE `articles` ADD `Fourniseur` INT(11) NULL AFTER `Type` ;

ALTER TABLE `articles` ADD `Packages` VARCHAR( 64 ) NULL AFTER `QuantiteMaximum` ;

INSERT INTO `fonction` ( `NoGroupe` , `NoFonction` , `Description` , `Type` , `Sous_Type` , `Extra` )
VALUES (
'1', '12', 'Commande stock', '1', '12', NULL
);
