# --------------------------------------------------------
#
# Structure de la table 'dyna_liens'
#

CREATE TABLE dyna_liens (
   id_lien int(11) NOT NULL auto_increment,
   nom_lien varchar(50) NOT NULL,
   url_lien varchar(50) NOT NULL,
   user_mail varchar(35) NOT NULL,
   description longtext NOT NULL,
   date varchar(10) NOT NULL,
   time varchar(5) NOT NULL,
   nb_click int(5) DEFAULT '0' NOT NULL,
   valid bigint(1) DEFAULT '0' NOT NULL,
   name_rub varchar(20) NOT NULL,
   PRIMARY KEY (id_lien),
   UNIQUE id_lien (url_lien)
);


# --------------------------------------------------------
#
# Structure de la table 'dyna_rub'
#

CREATE TABLE dyna_rub (
   id_rub int(2) NOT NULL auto_increment,
   name_rub varchar(20) NOT NULL,
   PRIMARY KEY (id_rub)
);