Trigger fix for blojsom-full-initial-data-oracle.sql

In order to successful create new users, I had to modify the blojsom-full-initial-data-oracle.sql file as follows:

Add:

DROP TRIGGER Blojsom_user_md_id_auto;

CREATE OR REPLACE TRIGGER Blojsom_user_md_id_auto

BEFORE INSERT ON Blojsom_DBUserMetadata FOR EACH ROW

BEGIN

                IF :new.user_metadata_id IS NULL THEN

                                select Blojsom_user_md_id_Seq.nextval INTO :new.user_metadata_id FROM DUAL;

                END IF;

END;

/

After:

DROP SEQUENCE Blojsom_user_md_id_Seq;

CREATE SEQUENCE Blojsom_user_md_id_Seq START WITH 1 INCREMENT BY 1;

Hope this helps,

Kurt Lund

lund@...