====== Base de données ======
* crossdict, dict sont vides
* links est vide
* qcache, qinfo, qtrack sont vides
===== SERVER et SRVINFO =====
* 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 | |
+------------+---------+------+-----+---------+-------+
[[http://www.mnogosearch.org/doc33/msearch-dbschema.html#db-server|tables server et srvinfo]]
pour visualiser le contenu d'un blob de la table **server** : SELECT CAST(url as CHAR(10000)) FROM server
===== URL =====
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
===== BDICTI =====
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
===== BDICT =====
[[http://www.mnogosearch.org/board/message.php?id=18916|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;
===== URLINFO =====
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'