CREATE TABLE `episode` (
`id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
`serie` tinyint(3) unsigned NOT NULL,
`saison` char(1) NOT NULL,
`num_episode` char(2) NOT NULL,
`utilisateur` smallint(5) unsigned NOT NULL,
`date_ajout` datetime NOT NULL,
`nbr_visualisation` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8
-----------------------------------------------------
CREATE TABLE `utilisateur` (
`id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
`pseudo` varchar(20) NOT NULL,
`pass` varchar(40) NOT NULL,
`mail` varchar(50) NOT NULL,
`type` tinyint(3) unsigned NOT NULL,
`en_ligne` varchar(1) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1
----------------------------------------------------
CREATE TABLE `serie` (
`id` tinyint(3) unsigned NOT NULL,
`nom` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
Partager