Mine

BEGIN;CREATE TABLE IF NOT EXISTS category ( categoryName varchar(255) NOT NULL PRIMARY KEY );INSERT INTO category (categoryName) VALUES ( '0DAY' );INSERT INTO category (categoryName) VALUES ( '0DAY-XXX' );INSERT INTO category (categoryName) VALUES ( 'APPS' );INSERT INTO category (categoryName) VALUES ( 'ANIME' );INSERT INTO category (categoryName) VALUES ( 'COVERS' );INSERT INTO category (categoryName) VALUES ( 'DOX' );INSERT INTO category (categoryName) VALUES ( 'DVDR' );INSERT INTO category (categoryName) VALUES ( 'DVDR-HD' );INSERT INTO category (categoryName) VALUES ( 'EBOOK' );INSERT INTO category (categoryName) VALUES ( 'GAMES' );INSERT INTO category (categoryName) VALUES ( 'MP3' );INSERT INTO category (categoryName) VALUES ( 'MVID' );INSERT INTO category (categoryName) VALUES ( 'PRE' );INSERT INTO category (categoryName) VALUES ( 'PSP' );INSERT INTO category (categoryName) VALUES ( 'PS2' );INSERT INTO category (categoryName) VALUES ( 'PS3' );INSERT INTO category (categoryName) VALUES ( 'VCD' );INSERT INTO category (categoryName) VALUES ( 'SVCD' );INSERT INTO category (categoryName) VALUES ( 'MDVDR' );INSERT INTO category (categoryName) VALUES ( 'NDS' );INSERT INTO category (categoryName) VALUES ( 'PDA' );INSERT INTO category (categoryName) VALUES ( 'TV-XVID' );INSERT INTO category (categoryName) VALUES ( 'TV-HR' );INSERT INTO category (categoryName) VALUES ( 'TV-DVDR' );INSERT INTO category (categoryName) VALUES ( 'TV-DVDRIP' );INSERT INTO category (categoryName) VALUES ( 'TV-X264' );INSERT INTO category (categoryName) VALUES ( 'XVID' );INSERT INTO category (categoryName) VALUES ( 'XBOX' );INSERT INTO category (categoryName) VALUES ( 'XBOX360' );INSERT INTO category (categoryName) VALUES ( 'WII' );INSERT INTO category (categoryName) VALUES ( 'X264' );INSERT INTO category (categoryName) VALUES ( 'XXX' );INSERT INTO category (categoryName) VALUES ( 'XXX-DVDR' );COMMIT;CREATE TRIGGER fki_pre_category_category_nameBEFORE INSERT ON [pre]FOR EACH ROW BEGIN  SELECT RAISE(ROLLBACK, 'insert on table "pre" violates foreign key constraint "fki_pre_category_category_name"')  WHERE (SELECT categoryName FROM category WHERE categoryName = NEW.category) IS NULL;END;CREATE TRIGGER fku_pre_category_category_nameBEFORE UPDATE ON [pre]FOR EACH ROW BEGIN    SELECT RAISE(ROLLBACK, 'update on table "pre" violates foreign key constraint "fku_pre_category_category_name"')    WHERE (SELECT categoryName FROM category WHERE categoryName = NEW.category) IS NULL;END;CREATE TRIGGER fkd_pre_category_category_nameBEFORE DELETE ON categoryFOR EACH ROW BEGIN  SELECT RAISE(ROLLBACK, 'delete on table "category" violates foreign key constraint "fkd_pre_category_category_name"')  WHERE (SELECT category FROM pre WHERE category = OLD.categoryName) IS NOT NULL;END;