Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- --------------------------------------------------------
- --
- -- Structure de la table `type`
- --
- CREATE TABLE TYPE
- (
- TypeCode INT(11),
- Nom VARCHAR(11) NOT NULL,
- PRIMARY KEY (TypeCode)
- )
- ENGINE=InnoDB;
- CREATE TABLE categorie
- (
- CodeCategorie INT(5),
- Nom VARCHAR(50) NOT NULL,
- TypeCode INT(50) NOT NULL,
- PRIMARY KEY (CodeCategorie),
- FOREIGN KEY (TypeCode) REFERENCES TYPE(TypeCode)
- )
- ENGINE=InnoDB;
- -- --------------------------------------------------------
- --
- -- Structure de la table `produit`
- --
- CREATE TABLE produit
- (
- REF INT(11),
- Nom VARCHAR(50) NOT NULL,
- Marque VARCHAR(50) NOT NULL,
- Prix DECIMAL(6,2) NOT NULL,
- Description VARCHAR(250) NOT NULL,
- Garantie CHAR(5) NOT NULL,
- CodeCategorie INT(5) NOT NULL,
- PRIMARY KEY (REF),
- FOREIGN KEY (CodeCategorie) REFERENCES categorie(CodeCategorie)
- )
- ENGINE=InnoDB;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement