# phpMyAdmin MySQL-Dump # version 2.2.1-dev # http://phpwizard.net/phpMyAdmin/ # http://phpmyadmin.sourceforge.net/ (download page) # # Serveur: members-free-php11.fr.db.lyceu.net:3310 # Généré le : Mercredi 21 Mai 2004 à 18:44 # Version du serveur: 3.23.33 # Version de PHP: 4.3.2 # Base de données: `shubyman_db` # -------------------------------------------------------- # # Structure de la table `wiklink_folder` # CREATE TABLE wiklink_folder ( folder_id smallint(6) unsigned NOT NULL auto_increment, folder_name char(24) NOT NULL default '', folder_modify datetime default NULL, folder_nbItem smallint(6) NOT NULL default '0', folder_desc char(48) NOT NULL default '', folder_parent smallint(6) NOT NULL default '0', PRIMARY KEY (folder_id), KEY folder_id (folder_id) ) TYPE=MyISAM; # # Contenu de la table `wiklink_folder` # INSERT INTO wiklink_folder VALUES (1,'Trucs a la con...','2003-12-20 02:12:58',8,'Des sites a la cons...',''); INSERT INTO wiklink_folder VALUES (2,'Informatique & co','2003-12-20 02:12:13',3,'Electricité automatique et informatique',''); INSERT INTO wiklink_folder VALUES (3,'Pratique','2003-12-20 02:12:28',3,'Des services qu\'ils sont bien a utiliser',''); INSERT INTO wiklink_folder VALUES (4,'Licences logicielles','2003-12-23 12:12:48',4,'-',2); INSERT INTO wiklink_folder VALUES (5,'Programmation web','2004-01-02 07:01:42',5,'Html js php css xml ...',2); INSERT INTO wiklink_folder VALUES (6,'Ecriture','2004-01-10 08:01:44',12,'Idees de mises en pages... etc...',''); INSERT INTO wiklink_folder VALUES (7,'Encyclopédie','2004-01-22 02:01:45',1,'Tout sur tout',''); INSERT INTO wiklink_folder VALUES (8,'Profs des bozarts...','2004-02-19 02:02:41',3,'Sites des profs? :-s :-d',''); INSERT INTO wiklink_folder VALUES (9,'Web-radios','2004-02-22 02:02:59',3,'-',''); # -------------------------------------------------------- # # Structure de la table `wiklink_site` # CREATE TABLE wiklink_site ( site_id smallint(6) NOT NULL auto_increment, site_name char(24) NOT NULL default '', site_modify datetime NOT NULL default '0000-00-00 00:00:00', site_folder smallint(6) NOT NULL default '0', site_desc char(48) NOT NULL default '', site_url char(200) NOT NULL default '', site_author char(100) default NULL, site_hit smallint(6) NOT NULL default '0', PRIMARY KEY (site_id), KEY site_id (site_id), FULLTEXT KEY site_url (site_url) ) TYPE=MyISAM; # # Contenu de la table `wiklink_site` # INSERT INTO wiklink_site VALUES (1,'Yugop','2003-12-19 11:12:49','','Anims shockwave/flash','http://www.yugop.com','purpan-1-82-66-210-37.fbx.proxad.net',5); INSERT INTO wiklink_site VALUES (3,'Processing.net','2003-12-19 11:12:21','','Anims en processing (langage gratuit)','http://www.Proce55ing.net','purpan-1-82-66-210-37.fbx.proxad.net',6); INSERT INTO wiklink_site VALUES (4,'Madchat.org','2003-12-19 11:12:59','','Hack/demo/securité...','http://www.madchat.org','purpan-1-82-66-210-37.fbx.proxad.net',7); INSERT INTO wiklink_site VALUES (5,'Kochonland.com','2003-12-20 02:12:27',1,'Eleve toi même ton cochon','http://www.kochonland.com','purpan-1-82-66-210-37.fbx.proxad.net',3); INSERT INTO wiklink_site VALUES (6,'Electronique electricité','2003-12-20 02:12:28',2,'Electronique electricité','http://pedagogie.ac-aix-marseille.fr/disciplines/sti/genelec/cours/bts.htm','toulouse-2-62-147-67-144.dial.proxad.net',3); INSERT INTO wiklink_site VALUES (7,'Jetable.org','2003-12-20 02:12:38',3,'Redirection d\'email','http://www.jetable.org','purpan-1-82-66-210-37.fbx.proxad.net',6); INSERT INTO wiklink_site VALUES (8,'Tribune libre','2003-12-23 08:12:43',4,'Gpl lpl mpl bsd... laquelle choisir ?','http://www.oreilly.fr/divers/tribune-libre/index.html','nas-cbv-10-62-147-122-211.dial.proxad.net',4); INSERT INTO wiklink_site VALUES (9,'License art libre','2003-12-23 12:12:42',4,'License inspirée de gpl mais pour l\'art','http://www.artlibre.org','purpan-1-82-66-210-37.fbx.proxad.net',2); INSERT INTO wiklink_site VALUES (10,'License pub. multimédia','2003-12-23 12:12:11',4,'License publique multimédia...','http://www.http://www.videontv.org/licence/','purpan-1-82-66-210-37.fbx.proxad.net',2); INSERT INTO wiklink_site VALUES (11,'Deviant art','2003-12-23 01:12:34','','Graphisme lié au software, skins etc...','http://www.deviantart.com','purpan-1-82-66-210-37.fbx.proxad.net',4); INSERT INTO wiklink_site VALUES (12,'All the web','2003-12-27 06:12:33',3,'Alternative a l\'omnipresent google','http://www.alltheweb.com','purpan-1-82-66-210-37.fbx.proxad.net',3); INSERT INTO wiklink_site VALUES (13,'Nainwak\'s world','2003-12-28 12:12:30',1,'Nain de jardin youpiiiiiii :)','http://www.nainwak.com','purpan-1-82-66-210-37.fbx.proxad.net',3); INSERT INTO wiklink_site VALUES (14,'Copyleft','2004-01-01 07:01:50',4,'Copyleft - comparatif des licenses','http://wiki.artlibre.org/index.php/ComparatifDeLicences','purpan-1-82-66-210-37.fbx.proxad.net',2); INSERT INTO wiklink_site VALUES (15,'Selfhtml','2004-01-02 07:01:53',5,'Html xhtml js css php cgi/perl','http://selfhtml.selfhtml.com.fr/index.htm','toulouse-2-62-147-114-73.dial.proxad.net',3); INSERT INTO wiklink_site VALUES (16,'Php.net','2004-01-02 07:01:49',5,'The php site','http://www.php.net','toulouse-2-62-147-114-73.dial.proxad.net',2); INSERT INTO wiklink_site VALUES (17,'Forum','2004-01-04 05:01:57','','Pour mettre des commentaires a propos des liens','http://membres.lycos.fr/shubyman/phpBB2/viewforum.php?f=2','purpan-1-82-66-210-37.fbx.proxad.net',9); INSERT INTO wiklink_site VALUES (18,'Wanagro.com','2004-01-05 02:01:57',1,'Site non officiel du groland :)','http://www.wanagro.com/','purpan-1-82-66-210-37.fbx.proxad.net',3); INSERT INTO wiklink_site VALUES (20,'Archive.org','2004-01-10 01:01:02','','Voir le forum...','http://www.archive.org','purpan-1-82-66-210-37.fbx.proxad.net',2); INSERT INTO wiklink_site VALUES (21,'Arteroids','2004-03-09 12:03:38',6,'Asteroids avec des mots','http://www.theremediproject.com/projects/issue11/andrewsarteroids/','AToulouse-206-1-21-23.w81-248.abo.wanadoo.fr',10); INSERT INTO wiklink_site VALUES (22,'Toxi.co.uk','2004-01-10 08:01:02','','Wouah putain! des trucs en director, demo, art..','http://www.toxi.co.uk/','purpan-1-82-66-210-37.fbx.proxad.net',6); INSERT INTO wiklink_site VALUES (23,'Robotstats','2004-01-26 08:01:37',5,'Analyse des visites de googlebot et autres','http://www.robotstats.com/','purpan-1-82-66-210-37.fbx.proxad.net',2); INSERT INTO wiklink_site VALUES (24,'Wikipédia','2004-01-22 02:01:30',7,'Encyclopédie libre !','http://fr.wikipedia.org','darkstar.ipbs.fr',1); INSERT INTO wiklink_site VALUES (25,'Topfx','2004-01-23 08:01:10',1,'Voir le website mixmaster :)','http://www.topfx.com','purpan-1-82-66-210-37.fbx.proxad.net',4); INSERT INTO wiklink_site VALUES (26,'Tonk.org','2004-01-26 01:01:22','','Graphisme-web?','http://tonk.org','purpan-1-82-66-210-37.fbx.proxad.net',7); INSERT INTO wiklink_site VALUES (27,'Hyphen press','2004-02-04 05:02:25',6,'-','http://www.hyphenpress.co.uk','AToulouse-206-1-26-180.w81-249.abo.wanadoo.fr',6); INSERT INTO wiklink_site VALUES (28,'Our type','2004-02-04 05:02:08',6,'-','http://www.ourtype.com','AToulouse-206-1-26-180.w81-249.abo.wanadoo.fr',5); INSERT INTO wiklink_site VALUES (29,'Pampa type','2004-02-04 05:02:35',6,'-','http://www.pampatype.com','AToulouse-206-1-26-180.w81-249.abo.wanadoo.fr',5); INSERT INTO wiklink_site VALUES (30,'Public lettering','2004-02-04 06:02:17',6,'-','http://www.publiclettering.org.uk','AToulouse-206-1-26-180.w81-249.abo.wanadoo.fr',5); INSERT INTO wiklink_site VALUES (31,'Abstract machine','2004-02-04 06:02:48',6,'-','http://www.abstractmachine.net','AToulouse-206-1-26-180.w81-249.abo.wanadoo.fr',2); INSERT INTO wiklink_site VALUES (32,'Perdu.com','2004-02-10 04:02:36',1,'Super connu, mais toujours tres bon je trouve :)','http://www.perdu.com','purpan-1-82-66-210-37.fbx.proxad.net',3); INSERT INTO wiklink_site VALUES (33,'Keyboard network led','2004-02-14 02:02:55',1,'Le traffic internet sur ton clavier :-d','http://www.xcat-industries.nl/softwareinfo.php?software=43','purpan-1-82-66-210-37.fbx.proxad.net',1); INSERT INTO wiklink_site VALUES (34,'Philippe fauré','2004-02-18 07:02:03',8,'-','http://sites.myhomepage.org/faurephilippe/','purpan-1-82-66-210-37.fbx.proxad.net',2); INSERT INTO wiklink_site VALUES (35,'Dominique crepet','2004-02-18 07:02:45',8,'-','http://www.saveurs.sympatico.ca/dcc/camember/crepet.htm','purpan-1-82-66-210-37.fbx.proxad.net',2); INSERT INTO wiklink_site VALUES (36,'Pierre nogues','2004-02-18 07:02:21',8,'Celui la est vrai :)','http://docadhoc.free.fr/','purpan-1-82-66-210-37.fbx.proxad.net',3); INSERT INTO wiklink_site VALUES (37,'Textfiles.com','2004-02-18 08:02:19',6,'-','http://www.textfiles.com','purpan-1-82-66-210-37.fbx.proxad.net',2); INSERT INTO wiklink_site VALUES (38,'X-stream radio','2004-02-22 02:02:02',9,'Radio electronica','http://xstreamradio.free.fr/','purpan-1-82-66-210-37.fbx.proxad.net',2); INSERT INTO wiklink_site VALUES (39,'Erreur 404','2004-02-22 02:02:24',9,'Radio 404, contre la soupe fm !','http://www.erreur404.org','purpan-1-82-66-210-37.fbx.proxad.net',8); INSERT INTO wiklink_site VALUES (40,'Ombilikal','2004-02-22 02:02:39',9,'Radio jungle toulousaine','http://ombilikal.org/','purpan-1-82-66-210-37.fbx.proxad.net',3); INSERT INTO wiklink_site VALUES (41,'Bashcomp','2004-02-23 12:02:14',1,'****** de pc de *****!!!!!!!! ‰Ô*£‰@#é','http://www.funnyheck.com/bashcomp.html','purpan-1-82-66-210-37.fbx.proxad.net',6); INSERT INTO wiklink_site VALUES (42,'Eyrolles.com','2004-02-24 08:02:22','','Devenez beau, et riche grace a ms-office...','http://www.eyrolles.com/Entreprise/Livre/9782212282962/Devenez_beau_riche_et_intelligent_avec_PowerPoint_Excel_et_Word.php','purpan-1-82-66-210-37.fbx.proxad.net',1); INSERT INTO wiklink_site VALUES (43,'Anonymes.net','2004-02-25 09:02:53','','Video/flash (la v1 est presque mieux que la 2)','http://www.anonymes.net/','purpan-1-82-66-210-37.fbx.proxad.net',1); INSERT INTO wiklink_site VALUES (44,'D2b.org','2004-02-25 09:02:21','','Groupe de ? toulousain','http://www.d2b.org','purpan-1-82-66-210-37.fbx.proxad.net',2); INSERT INTO wiklink_site VALUES (45,'Hoaxbuster','2004-02-25 09:02:42',3,'Info. sur les hoax et autres canulars sur le net','http://www.hoaxbuster.com/','purpan-1-82-66-210-37.fbx.proxad.net',''); INSERT INTO wiklink_site VALUES (46,'Png transparency test','2004-02-26 10:02:16',5,'Determine how your browser handles png transpare','http://entropymine.com/jason/testbed/pngtrans/','darkstar.ipbs.fr',2); INSERT INTO wiklink_site VALUES (47,'Fjällyoghurt','2004-02-26 07:02:28',1,'Anime ta vache !! enorme !!','http://farfar.2038.com/cow2/english/loader.html','purpan-1-82-66-210-37.fbx.proxad.net',8); INSERT INTO wiklink_site VALUES (48,'Irt','2004-02-27 02:02:36',5,'Internet related technology','http://www.irt.org','AToulouse-206-1-14-177.w81-50.abo.wanadoo.fr',2); INSERT INTO wiklink_site VALUES (49,'Action tank.org','2004-03-05 03:03:05',6,'Nathalie bookchin','http://action-tank.org/','AToulouse-206-1-24-249.w81-249.abo.wanadoo.fr',2); INSERT INTO wiklink_site VALUES (50,'Http://www.yhchang.com/','2004-03-05 03:03:52',6,'-','http://www.yhchang.com/','AToulouse-206-1-24-249.w81-249.abo.wanadoo.fr',6); INSERT INTO wiklink_site VALUES (51,'East gate','2004-03-05 04:03:56',6,'Portail us sur l\'hypertexte','http://eastgate.com/','AToulouse-206-1-24-249.w81-249.abo.wanadoo.fr',1); INSERT INTO wiklink_site VALUES (52,'Charabia','2004-03-05 04:03:50',6,'Générateurs de textes','http://www.charabia.net/','AToulouse-206-1-24-249.w81-249.abo.wanadoo.fr',1); INSERT INTO wiklink_site VALUES (53,'Born magazine','2004-03-05 04:03:07',6,'Art and literature collaboration','http://www.bornmagazine.org/','AToulouse-206-1-24-249.w81-249.abo.wanadoo.fr',4); # -------------------------------------------------------- # # Structure de la table `wiklink_user` # CREATE TABLE wiklink_user ( user_id smallint(6) NOT NULL auto_increment, user_url char(100) NOT NULL default '', user_date datetime NOT NULL default '0000-00-00 00:00:00', user_delete smallint(6) NOT NULL default '0', user_add smallint(6) NOT NULL default '0', PRIMARY KEY (user_id), KEY user_id (user_id) ) TYPE=MyISAM; # # Contenu de la table `wiklink_user` # INSERT INTO wiklink_user VALUES (29,'AToulouse-206-1-14-177.w81-50.abo.wanadoo.fr','2004-02-27 10:02:17','',1); INSERT INTO wiklink_user VALUES (28,'purpan-1-82-66-210-37.fbx.proxad.net','2004-02-26 07:02:28','',1); INSERT INTO wiklink_user VALUES (27,'darkstar.ipbs.fr','2004-02-26 10:02:16','',1); INSERT INTO wiklink_user VALUES (26,'purpan-1-82-66-210-37.fbx.proxad.net','2004-02-25 09:02:42','',3); INSERT INTO wiklink_user VALUES (25,'purpan-1-82-66-210-37.fbx.proxad.net','2004-02-24 08:02:22','',3); INSERT INTO wiklink_user VALUES (24,'toulouse-2-62-147-114-14.dial.proxad.net','2004-02-22 09:02:19','',1); INSERT INTO wiklink_user VALUES (23,'purpan-1-82-66-210-37.fbx.proxad.net','2004-02-22 02:02:02','',5); INSERT INTO wiklink_user VALUES (18,'purpan-1-82-66-210-37.fbx.proxad.net','2004-01-26 01:01:22','',8); INSERT INTO wiklink_user VALUES (17,'purpan-1-82-66-210-37.fbx.proxad.net','2004-01-23 08:01:10','',8); INSERT INTO wiklink_user VALUES (16,'darkstar.ipbs.fr','2004-01-22 02:01:30','',1); INSERT INTO wiklink_user VALUES (22,'purpan-1-82-66-210-37.fbx.proxad.net','2004-02-18 07:02:17','',8); INSERT INTO wiklink_user VALUES (21,'purpan-1-82-66-210-37.fbx.proxad.net','2004-02-14 02:02:55','',8); INSERT INTO wiklink_user VALUES (20,'purpan-1-82-66-210-37.fbx.proxad.net','2004-02-10 04:02:36','',8); INSERT INTO wiklink_user VALUES (19,'AToulouse-206-1-26-180.w81-249.abo.wanadoo.fr','2004-02-04 05:02:25','',5); INSERT INTO wiklink_user VALUES (30,'AToulouse-206-1-24-249.w81-249.abo.wanadoo.fr','2004-03-05 03:03:05','',5);