Base de données

• crossdict, dict sont vides
• links est vide
• qcache, qinfo, qtrack sont vides

• server contient les urls saisies dans indexer.conf

Description des champs :

+------------+---------+------+-----+---------+-------+
| Field      | Type    | Null | Key | Default | Extra |
+------------+---------+------+-----+---------+-------+
| rec_id     | int(11) | NO   | PRI | NULL    |       |
| enabled    | int(11) | NO   |     | 0       |       |
| url        | blob    | NO   | UNI | NULL    |       |
| tag        | text    | NO   | MUL | NULL    |       |
| category   | int(11) | NO   | MUL | 0       |       |
| command    | char(1) | NO   | MUL | S       |       |
| ordre      | int(11) | NO   | MUL | 0       |       |
| parent     | int(11) | NO   | MUL | 0       |       |
| weight     | float   | NO   |     | 1       |       |
| pop_weight | float   | NO   |     | 0       |       |
+------------+---------+------+-----+---------+-------+

tables server et srvinfo

pour visualiser le contenu d'un blob de la table server :

SELECT CAST(url as CHAR(10000)) FROM server

pour visualiser le contenu d'un blob de la table url

 SELECT CAST(url as CHAR(10000)) 
 FROM url 
 where rec_id=11

ou

SELECT word, CAST(intag AS CHAR(10000) CHARACTER SET utf8)  
FROM bdict
WHERE INSTR(word,'Arbonne')>0
ORDER BY word

Description des champs :

• url_id
• state
• intag??

SELECT 
CAST(intag00 as CHAR(10000)) as intag00 ,
CAST(intag01 as CHAR(10000)) as intag01 ,
CAST(intag02 as CHAR(10000)) as intag02 ,
CAST(intag03 as CHAR(10000)) as intag03 ,
CAST(intag04 as CHAR(10000)) as intag04 ,
CAST(intag05 as CHAR(10000)) as intag05 ,
CAST(intag06 as CHAR(10000)) as intag06 ,
CAST(intag07 as CHAR(10000)) as intag07 ,
CAST(intag08 as CHAR(10000)) as intag08 ,
CAST(intag09 as CHAR(10000)) as intag09 ,
CAST(intag0A as CHAR(10000)) as intag0A ,
CAST(intag0B as CHAR(10000)) as intag0B ,
CAST(intag0C as CHAR(10000)) as intag0C ,
CAST(intag0D as CHAR(10000)) as intag0D ,
CAST(intag0E as CHAR(10000)) as intag0E ,
CAST(intag0F as CHAR(10000)) as intag0F ,
CAST(intag10 as CHAR(10000)) as intag10 ,
CAST(intag11 as CHAR(10000)) as intag11 ,
CAST(intag12 as CHAR(10000)) as intag12 ,
CAST(intag13 as CHAR(10000)) as intag13 ,
CAST(intag14 as CHAR(10000)) as intag14 ,
CAST(intag15 as CHAR(10000)) as intag15 ,
CAST(intag16 as CHAR(10000)) as intag16 ,
CAST(intag17 as CHAR(10000)) as intag17 ,
CAST(intag18 as CHAR(10000)) as intag18 ,
CAST(intag19 as CHAR(10000)) as intag19 ,
CAST(intag1A as CHAR(10000)) as intag1A ,
CAST(intag1B as CHAR(10000)) as intag1B ,
CAST(intag1C as CHAR(10000)) as intag1C ,
CAST(intag1D as CHAR(10000)) as intag1D ,
CAST(intag1E as CHAR(10000)) as intag1E ,
CAST(intag1F as CHAR(10000)) as intag1F 
FROM bdicti  
where url_id=11

intag 00-09, 0A-0F, 10-19, 1A-1F

SELECT 
CONCAT(CAST(intag00 as CHAR(10000)),CAST(intag01 as CHAR(10000)),CAST(intag02 as CHAR(10000)),CAST(intag03 as CHAR(10000)),
CAST(intag04 as CHAR(10000)),CAST(intag05 as CHAR(10000)),CAST(intag06 as CHAR(10000)),CAST(intag07 as CHAR(10000)),CAST(intag08 as CHAR(10000)),CAST(intag09 as CHAR(10000)),
CAST(intag0A as CHAR(10000)),CAST(intag0B as CHAR(10000)),CAST(intag0C as CHAR(10000)),CAST(intag0D as CHAR(10000)),CAST(intag0E as CHAR(10000)),CAST(intag0F as CHAR(10000)),
CAST(intag10 as CHAR(10000)),CAST(intag11 as CHAR(10000)),CAST(intag12 as CHAR(10000)),CAST(intag13 as CHAR(10000)),CAST(intag14 as CHAR(10000)),CAST(intag15 as CHAR(10000)),
CAST(intag16 as CHAR(10000)),CAST(intag17 as CHAR(10000)),CAST(intag18 as CHAR(10000)),CAST(intag19 as CHAR(10000)),
CAST(intag1A as CHAR(10000)),CAST(intag1B as CHAR(10000)),CAST(intag1C as CHAR(10000)),CAST(intag1D as CHAR(10000)),
CAST(intag1E as CHAR(10000)),CAST(intag1F as CHAR(10000)))
as descript
FROM bdicti

table bdict

Nombre de mot (records) stockés dans BDICT : 
 select count(*) from bdict

 SELECT CAST(intag as CHAR(10000)) 
 FROM bdict 
 where word='bisualen'

 SELECT count(*),word 
 FROM bdict 
 group by word
 order by word DESC;

 SELECT count(*),word 
 FROM bdict 
 WHERE 
 CHAR_LENGTH(word)>=3
 and ASCII(MID(word,1,1))>=65 AND ASCII(MID(word,1,1))<=126 
 and ASCII(MID(word,2,1))>=65 AND ASCII(MID(word,2,1))<=126 
 GROUP BY word
 ORDER BY word;

Description des champs :

+--------+-------------+------+-----+---------+-------+
| Field  | Type        | Null | Key | Default | Extra |
+--------+-------------+------+-----+---------+-------+
| url_id | int(11)     | NO   | MUL | NULL    |       |
| sname  | varchar(32) | NO   |     | NULL    |       |
| sval   | mediumtext  | NO   |     | NULL    |       |
+--------+-------------+------+-----+---------+-------+

les meta donnees :

select * 
from urlinfo
where instr(sval,'arbonne'>=0) 
and sname='meta.description'