... | ... | @@ -29,12 +29,8 @@ DELETE FROM pathauto_state |
|
|
WHERE pathauto_state.entity_id in
|
|
|
(SELECT pathauto_state.entity_id FROM pathauto_state LEFT JOIN node ON (pathauto_state.entity_id = node.nid) WHERE node.type='form1' );
|
|
|
|
|
|
DELETE FROM url_alias
|
|
|
WHERE url_alias.alias IN
|
|
|
(SELECT url_alias.alias FROM node JOIN url_alias ON CONCAT('node/', node.nid) = url_alias.source WHERE node.type='form1');
|
|
|
|
|
|
-- delete also aliases based on users
|
|
|
DELETE FROM url_alias WHERE url_alias.source LIKE 'user/%';
|
|
|
-- delete all existing aliases
|
|
|
TRUNCATE url_alias;
|
|
|
|
|
|
-- delete all existing forms
|
|
|
DELETE FROM node WHERE type='form1';
|
... | ... | |