-- phpMyAdmin SQL Dump -- version 3.2.5 -- http://www.phpmyadmin.net -- -- Serveur: localhost -- Généré le : Jeu 26 Mai 2011 à 11:40 -- Version du serveur: 5.1.47 -- Version de PHP: 5.3.2 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Base de données: `crawler` -- -- -------------------------------------------------------- -- -- Structure de la table `keywords` -- CREATE TABLE IF NOT EXISTS `keywords` ( `name` varchar(30) NOT NULL, `page` int(32) NOT NULL, PRIMARY KEY (`name`,`page`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Structure de la table `page` -- CREATE TABLE IF NOT EXISTS `page` ( `pid` int(32) NOT NULL AUTO_INCREMENT, `url` varchar(255) NOT NULL, `refresh` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`pid`), UNIQUE KEY `url` (`url`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -------------------------------------------------------- -- -- Structure de la table `process` -- CREATE TABLE IF NOT EXISTS `process` ( `process` int(11) NOT NULL, `page` int(11) NOT NULL, `start` int(11) NOT NULL, PRIMARY KEY (`process`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;