Revision 3123
Added by Jing Tao almost 18 years ago
src/delete-xml-documents.sql | ||
---|---|---|
1 |
DELETE FROM xml_index WHERE docid ='tao.12043'; |
|
2 |
DELETE FROM xml_access WHERE accessfileid ='tao.12043'; |
|
3 |
DELETE FROM xml_access WHERE docid ='tao.12043'; |
|
4 |
DELETE FROM xml_queryresult WHERE docid ='tao.12043'; |
|
5 |
DELETE FROM xml_relation WHERE docid ='tao.12043'; |
|
6 |
DELETE FROM xml_path_index WHERE docid ='tao.12043'; |
|
7 |
DELETE FROM xml_accesssubtree WHERE docid = 'tao.12043'; |
|
8 |
DELETE FROM xml_documents WHERE docid ='tao.12043'; |
|
9 |
DELETE FROM xml_nodes where docid ='tao.12043'; |
|
10 |
|
|
11 |
DELETE FROM xml_index WHERE docid ='tao.12045'; |
|
12 |
DELETE FROM xml_access WHERE accessfileid ='tao.12045'; |
|
13 |
DELETE FROM xml_access WHERE docid ='tao.12045'; |
|
14 |
DELETE FROM xml_queryresult WHERE docid ='tao.12045'; |
|
15 |
DELETE FROM xml_relation WHERE docid ='tao.12045'; |
|
16 |
DELETE FROM xml_path_index WHERE docid ='tao.12045'; |
|
17 |
DELETE FROM xml_accesssubtree WHERE docid = 'tao.12045'; |
|
18 |
DELETE FROM xml_documents WHERE docid ='tao.12045'; |
|
19 |
DELETE FROM xml_nodes where docid ='tao.12045'; |
|
0 | 20 |
Also available in: Unified diff
Add a script to delete documents manually.