# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Serveur: localhost Base de données: top50
# --------------------------------------------------------

#
# Structure de la table 'top'
#

DROP TABLE IF EXISTS top;
CREATE TABLE top_si (
   num int(9) DEFAULT '0' NOT NULL AUTO_INCREMENT,
   nom longtext NOT NULL,
   description longtext NOT NULL,
   urlsite longtext NOT NULL,
   urlband longtext,
   email longtext NOT NULL,
   mdp longtext NOT NULL,
   hitsin int(9) DEFAULT '0' NOT NULL,
   hitsout int(9) DEFAULT '0' NOT NULL,
   PRIMARY KEY (num)
);


CREATE TABLE top_ip (
   num_ip int(9) DEFAULT '0' NOT NULL,
   val_ip longtext NOT NULL,
   PRIMARY KEY (num_ip)
);

CREATE TABLE top_cl (
   num_cl int(9) DEFAULT '1' NOT NULL,
   PRIMARY KEY (num_cl)
);

INSERT INTO top_ip (num_ip,val_ip) VALUES ('1','0.0.0.0');
INSERT INTO top_ip (num_ip,val_ip) VALUES ('2','0.0.0.0');
INSERT INTO top_ip (num_ip,val_ip) VALUES ('3','0.0.0.0');
INSERT INTO top_ip (num_ip,val_ip) VALUES ('4','0.0.0.0');
INSERT INTO top_ip (num_ip,val_ip) VALUES ('5','0.0.0.0');

INSERT INTO top_cl (num_cl) VALUES ('1');