-- MySQL dump 9.07
--
-- Host: localhost    Database: facsys
---------------------------------------------------------
-- Server version	4.0.12-log

--
-- Table structure for table 'articles'
--

CREATE TABLE articles (
  codearticle char(5) NOT NULL default '',
  nom char(50) default NULL,
  prix float(6,2) default NULL,
  stock smallint(5) unsigned default NULL,
  idcategorie tinyint(3) unsigned default NULL,
  PRIMARY KEY  (codearticle),
  KEY idcategorie (idcategorie)
) TYPE=MyISAM;

--
-- Dumping data for table 'articles'
--

INSERT INTO articles VALUES ('SHR3','Short court',17.50,NULL,NULL);
INSERT INTO articles VALUES ('BOU89','Bouchon rond',43.00,NULL,NULL);
INSERT INTO articles VALUES ('CAP01','canne a peche',80.40,NULL,NULL);
INSERT INTO articles VALUES ('RAQ01','raquette de squash',62.00,NULL,NULL);
INSERT INTO articles VALUES ('BAL45','Balle de squash debutant',5.00,NULL,NULL);

--
-- Table structure for table 'categories'
--

CREATE TABLE categories (
  idcategorie tinyint(3) unsigned NOT NULL auto_increment,
  nom varchar(30) default NULL,
  description varchar(50) default NULL,
  PRIMARY KEY  (idcategorie)
) TYPE=MyISAM;

--
-- Dumping data for table 'categories'
--

INSERT INTO categories VALUES (1,'peche','les articles de peche');
INSERT INTO categories VALUES (2,'Squash','articles de squash');
INSERT INTO categories VALUES (3,'Habillage pour enfant','du 0 au 16 ans');

--
-- Table structure for table 'clients'
--

CREATE TABLE clients (
  idclient char(6) NOT NULL default '',
  nom char(30) default NULL,
  prenom char(30) default NULL,
  adresse char(50) default NULL,
  codepostal int(5) default NULL,
  ville char(30) default NULL,
  telephone int(10) default NULL,
  PRIMARY KEY  (idclient),
  FULLTEXT KEY iclients (nom,prenom,adresse,ville)
) TYPE=MyISAM;

--
-- Dumping data for table 'clients'
--

INSERT INTO clients VALUES ('DUR001','Durand','Pierre','Rue du menhir',44500,'Nantes',240955689);
INSERT INTO clients VALUES ('BLI034','Blineau','Daniel','La motte',85260,'Herbergement',251429803);
INSERT INTO clients VALUES ('TES23','Tesson','Alain','1 av de la mer',56546,'Saint Florent',NULL);
INSERT INTO clients VALUES ('DUR004','Durand','Sylvain','Palce mayeu',75000,'Paris',109457698);

--
-- Table structure for table 'commandes'
--

CREATE TABLE commandes (
  numcommande int(10) unsigned NOT NULL auto_increment,
  idclient char(6) default NULL,
  date timestamp(14) NOT NULL,
  PRIMARY KEY  (numcommande)
) TYPE=MyISAM;

--
-- Dumping data for table 'commandes'
--

INSERT INTO commandes VALUES (1,'DUR001',20030119154135);
INSERT INTO commandes VALUES (2,'BLI034',20030119154239);

--
-- Table structure for table 'details'
--

CREATE TABLE details (
  numcommande int(10) unsigned NOT NULL default '0',
  numordre tinyint(3) unsigned NOT NULL default '0',
  codearticle char(5) default NULL,
  quantite smallint(5) unsigned default NULL,
  prix float(7,2) NOT NULL default '0.00',
  PRIMARY KEY  (numcommande,numordre)
) TYPE=MyISAM;

--
-- Dumping data for table 'details'
--

INSERT INTO details VALUES (1,1,'CAP01',2,80.40);
INSERT INTO details VALUES (1,2,'BAL45',3,5.00);
INSERT INTO details VALUES (1,3,'RAQ01',1,62.00);
INSERT INTO details VALUES (2,4,'SHR3',1,17.50);

