Mlam main page |
|
CREATE TABLE users ( user_id bigint(20) NOT NULL auto_increment, nom varchar(50) NOT NULL default '', pass varchar(100) NOT NULL, acces tinyint(4) NOT NULL default '0', PRIMARY KEY (user_id) ); |
INSERT INTO users VALUES ( '1', 'admin', 'yep', '0'); |
CREATE TABLE film ( film_id bigint(20) unsigned NOT NULL auto_increment, title varchar(50) NOT NULL default '', year year(4) default NULL, imdb_id bigint(20) unsigned default NULL, commentaire text, img_film varchar(200) default NULL, PRIMARY KEY (film_id) ); |
CREATE TABLE dvd ( dvd_id bigint(20) unsigned NOT NULL auto_increment, dvd_film_id bigint(20) unsigned default NULL, comment char(50) default NULL, PRIMARY KEY (dvd_id) ); |
CREATE TABLE zone ( zone_id bigint(20) unsigned NOT NULL auto_increment, zone char(20) NOT NULL default '', PRIMARY KEY (zone_id) ); CREATE TABLE dvd_zone ( link_id bigint(20) unsigned NOT NULL auto_increment, dvd_link_id bigint(20) unsigned NOT NULL default '0', zone_link_id bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (link_id) ); |
|