Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DELETE FROM alf_node_properties
- WHERE (node_id, qname_id) IN
- (SELECT p.node_id "node_id",
- p.qname_id "qname_id"
- FROM alf_namespace ns
- INNER JOIN alf_qname q ON (ns.id = q.ns_id)
- INNER JOIN alf_node_properties p ON (p.qname_id = q.id)
- INNER JOIN alf_node n ON (n.id = p.node_id)
- WHERE ns.uri = ?
- AND q.local_name = ?)
- UPDATE alf_node
- SET type_qname_id = 76
- WHERE id IN
- (SELECT n.id "node_id"
- FROM alf_namespace ns
- INNER JOIN alf_qname q ON (ns.id = q.ns_id)
- INNER JOIN alf_node n ON (n.type_qname_id = q.id)
- WHERE ns.uri = ?)
- DELETE FROM alf_node_aspects
- WHERE (node_id, qname_id) IN
- (SELECT a.node_id "node_id", a.qname_id "qname_id"
- FROM alf_namespace ns
- INNER JOIN alf_qname q ON (ns.id = q.ns_id)
- INNER JOIN alf_node_aspects a ON (a.qname_id = q.id)
- WHERE ns.uri=?)
- UPDATE alf_child_assoc
- SET qname_ns_id = 2
- WHERE id IN
- (SELECT ca.id "id"
- FROM alf_namespace ns
- INNER JOIN alf_child_assoc ca ON (ca.qname_ns_id = ns.id)
- WHERE ns.uri = ?)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement