1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150
|
# --------------------------------------------------------
#
# Structure de la table 'engine'
#
CREATE TABLE engine (
spider_id mediumint(9) DEFAULT '0' NOT NULL,
key_id mediumint(9) DEFAULT '0' NOT NULL,
weight smallint(4) DEFAULT '0' NOT NULL,
KEY key_id (key_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
# --------------------------------------------------------
#
# Structure de la table 'keywords'
#
CREATE TABLE keywords (
key_id int(9) NOT NULL auto_increment,
twoletters char(2) NOT NULL,
keyword varchar(64) NOT NULL,
PRIMARY KEY (key_id),
UNIQUE keyword (keyword),
KEY twoletters (twoletters)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
# --------------------------------------------------------
#
# Structure de la table 'sites'
#
CREATE TABLE sites (
site_id mediumint(9) NOT NULL auto_increment,
site_url varchar(127) NOT NULL,
upddate timestamp(14),
username varchar(32),
password varchar(32),
port smallint(6),
locked tinyint(1) DEFAULT '0' NOT NULL,
stopped tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (site_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
# --------------------------------------------------------
#
# Structure de la table 'spider'
#
CREATE TABLE spider (
spider_id mediumint(9) NOT NULL auto_increment,
file varchar(127) NOT NULL,
first_words mediumtext NOT NULL,
upddate timestamp(14),
md5 varchar(50),
site_id mediumint(9) DEFAULT '0' NOT NULL,
path varchar(127) NOT NULL,
num_words int(11) DEFAULT '1' NOT NULL,
last_modified timestamp(14),
filesize int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (spider_id),
KEY site_id (site_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
# --------------------------------------------------------
#
# Structure de la table 'tempspider'
#
CREATE TABLE tempspider (
file text NOT NULL,
id mediumint(11) NOT NULL auto_increment,
level tinyint(6) DEFAULT '0' NOT NULL,
path text NOT NULL,
site_id mediumint(9) DEFAULT '0' NOT NULL,
indexed tinyint(1) DEFAULT '0' NOT NULL,
upddate timestamp(14),
error tinyint(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
KEY site_id (site_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
# --------------------------------------------------------
#
# Structure de la table 'excludes'
#
CREATE TABLE excludes (
ex_id mediumint(11) NOT NULL auto_increment,
ex_site_id mediumint(9) NOT NULL,
ex_path text NOT NULL,
PRIMARY KEY (ex_id),
KEY ex_site_id (ex_site_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
# --------------------------------------------------------
#
# Structure de la table 'logs'
#
CREATE TABLE logs (
l_id mediumint(9) NOT NULL auto_increment,
l_includes varchar(255) NOT NULL default '',
l_excludes varchar(127) default NULL,
l_num mediumint(9) default NULL,
l_mode char(1) default NULL,
l_ts timestamp(14) NOT NULL,
l_time float default '0' NOT NULL,
PRIMARY KEY (l_id),
KEY l_includes (l_includes),
KEY l_excludes (l_excludes)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
# --------------------------------------------------------
#
# Structure de la table 'clicks'
#
CREATE TABLE clicks (
c_num mediumint(9) NOT NULL,
c_url varchar(255) NOT NULL default '',
c_val varchar(255) NOT NULL default '',
c_time timestamp(14) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
# --------------------------------------------------------
#
# Structure de la table 'site_page'
#
CREATE TABLE site_page (
site_id int(4) NOT NULL,
days int(4) NOT NULL default '0',
links int(4) NOT NULL default '5',
depth int(4) NOT NULL default '5',
PRIMARY KEY (site_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
# --------------------------------------------------------
#
# Structure de la table 'includes'
#
CREATE TABLE includes (
in_id mediumint(11) NOT NULL auto_increment,
in_site_id mediumint(9) NOT NULL,
in_path text NOT NULL,
PRIMARY KEY (in_id),
KEY in_site_id (in_site_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci; |
Partager