## Récupération des documents de spip dans drupal
##
## Table files

INSERT INTO drupal_prof.files(
fid,
uid,
filename,
filepath,
filemime,
filesize,
STATUS ,
timestamp
)
SELECT d.id_document, 9999, REVERSE(LEFT(REVERSE(d.fichier), INSTR(REVERSE(d.fichier), "/")-1)), CONCAT('sites/prof.quod.ch.drupal/files/', d.fichier) , RIGHT(d.fichier, 3), 
d.taille, 1,
UNIX_TIMESTAMP(d.maj) FROM spip.spip_documents d 



##
## Table upload


INSERT INTO drupal_prof.upload (fid, nid, vid, description, list, weight)
SELECT f.fid, sa.nid, sa.nid, sd.descriptif, 1, 0
FROM drupal_prof.files f, spip.spip_documents_articles sda, drupal_prof.spip_articles sa, spip.spip_documents sd
WHERE f.fid = sda.id_document
AND sd.id_document = sda.id_document
AND sda.id_article = sa.id_article


##
## Table files, màj des droits

UPDATE drupal_prof.files f SET uid = (SELECT n.uid FROM drupal_prof.upload u, drupal_prof.node n WHERE n.nid = u.nid AND u.fid = f.fid)