Can anyone tell me why this query is generating an ERROR:
DROP TRIGGER rtsadven_development.content_assets_after_insert_subtypes;
CREATE TRIGGER `rtsadven_development`.`content_assets_after_insert_subtypes`
AFTER INSERT ON `rtsadven_development`.`content_assets`
FOR EACH ROW
BEGIN
IF NEW.content_asset_type_code = 'CURRI' THEN
INSERT INTO curriculums (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'COURS' THEN
INSERT INTO courses (content_asset_id) VALUES (NEW.id);
IF NEW.content_asset_type_code = 'DOC' THEN
INSERT INTO documents (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'MODUL' THEN
INSERT INTO modules (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'TOPIC' THEN
INSERT INTO topics (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'WEBPG' THEN
INSERT INTO web_pages (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'EMAIL' THEN
INSERT INTO emails (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'FBPOST' THEN
INSERT INTO facebook_posts (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'TWEET' THEN
INSERT INTO tweets (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'CHALL' THEN
INSERT INTO challenges (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'IMAGE' THEN
INSERT INTO images (content_asset_id) VALUES (NEW.id);
ELSEIF NEW.content_asset_type_code = 'VIDEO' THEN
INSERT INTO videos (content_asset_id) VALUES (NEW.id);
END IF;
INSERT INTO content_asset_statistics (content_asset_id,
statistic_type_code, seq) SELECT NEW.id, statistic_type_code, seq from
content_asset_statistic_types where content_asset_type_code =
NEW.content_asset_type_code;
END;
Appreciate it.
Don Wieland
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
