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 47 48 49 50
| -- --------------------------------------------------------------------------------------------------------
-- ------------------------------BASE DE DONNEE : BOUTIQUE-----------------------------------------------
-- --------------------------------------------------------------------------------------------------------
--
-- Structure de la table 'bt_categories'
--
CREATE TABLE 'bt_categories'(
'id' mediumint(8) unsigned NOT NULL auto_increment,
'code' varchar(20) NOT NULL default '',
'libel' varchar(200) NOT NULL default '',
'langue' char(2) NOT NULL default 'fr',
'description' text NOT NULL,
'keywords' text NOT NULL,
PRIMARY KEY ('id'),
KEY 'libel' ('libel'),
KEY 'langue' ('langue'),
KEY 'code' ('code'),
)
ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ---------------------------------------------------------------------------------------------------------
--
-- Structure de la table 'bt_clients'
--
CREATE TABLE 'bt_clients'(
'id' mediumint(8) unsigned NOT NULL auto_increment,
'nom' varchar(50) NOT NULL default '',
'prenom' varchar(50) NOT NULL default '',
'adresse' varchar(150) NOT NULL default '',
'adresse2' varchar(150) NOT NULL default '',
'code_postal' varchar(50) NOT NULL default '',
'ville' varchar(50) NOT NULL default '',
'etat' varchar(50) NOT NULL default '',
'pays' varchar(50) NOT NULL default '',
'code_pays' char(2) NOT NULL default '',
'email' varchar(50) NOT NULL default '',
'tel' varchar(50) NOT NULL default '',
'mot_passe' varchar(50) NOT NULL default '',
PRIMARY KEY ('id'),
KEY 'nom' ('nom'),
KEY 'code_pays' ('code_pays'),
KEY 'email' ('email'),
)
ENGINE=MyISAM DEFAULT CHARSET=latin1; |
Partager