I've taken the current jyve CVS and added the my stuff, here is the diffs file. Mark. ------------------------BEGIN DIFF 95a96,103 > -- 10/08/2000 [EMAIL PROTECTED] > -- Modifications :- > -- Add new sequences > -- Add Before Insert triggers for the new sequences > -- Added some primary keys and unique constraints removed in the MySQL > -- translation. > -- Add PROJECT_ID to faq table as per MySQL schema > -- Removed VISITORID from Visitor Primary Key 226,227d233 < --INDEX ( VISITORID, LOGINID ), < --UNIQUE (LOGINID) 231c237 < ADD CONSTRAINT VISITOR_PK PRIMARY KEY (VISITORID,LOGINID); --- > ADD CONSTRAINT VISITOR_PK PRIMARY KEY (LOGINID); 367c373,374 < VISITORID integer default 1, --- > PROJECT_ID integer NOT NULL, > VISITORID integer DEFAULT 1, 415a423,473 > > -- > > PROMPT Creating Index 'ROLE_NAME' > CREATE UNIQUE INDEX ROLE_NAME ON USERROLE > (ROLENAME) > / > > PROMPT Creating Index 'VISITOR_LOGINID' > CREATE INDEX VISITOR_LOGINID ON VISITOR > ( VISITORID, LOGINID ) > / > > PROMPT Creating Sequence 'NEXT_ROLEID' > CREATE SEQUENCE NEXT_ROLEID > / > > PROMPT Creating Trigger 'BFI_VISITOR' > CREATE OR REPLACE TRIGGER BFI_VISITOR > BEFORE INSERT > ON VISITOR > FOR EACH ROW > BEGIN > SELECT visitor_sequence.nextval > INTO :new.visitorid > FROM dual; > END BFI_VISITOR; > / > > PROMPT Creating Trigger 'BFI_PERMISSION' > CREATE OR REPLACE TRIGGER BFI_PERMISSION > BEFORE INSERT > ON PERMISSION > FOR EACH ROW > BEGIN > SELECT PERMISSION_SEQUENCE.nextval > INTO :new.permissionid > FROM dual; > / > > PROMPT Creating Trigger 'BFI_USERROLE' > CREATE OR REPLACE TRIGGER BFI_USERROLE > BEFORE INSERT > ON USERROLE > FOR EACH ROW > BEGIN > SELECT next_roleid.nextval > INTO :new.roleid > FROM dual; > END BFI_USERROLE; > / ------------------------END DIFF -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of burtonator Sent: Friday, 11 August 2000 6:14 AM To: JetSpeed Subject: Re: Jetspeed 1.2b1 Oracle source updates Mark White wrote: > > Who do I send some modifications/corrections to the Oracle scripts to so > that can be placed into CVS? Send diffs to the Turbine mailing list... note that the scripts might have been updated in the latest CVS so you need to be carefull. Kevin -- Kevin A Burton (e-mail: [EMAIL PROTECTED], UIN: 73488596, ZKey: burtonator) http://relativity.yi.org Message to SUN: "Please Open Source Java!" To fight and conquer in all your battles is not supreme excellence; supreme excellence consists in breaking the enemy's resistance without fighting. - Sun Tzu, 300 B.C. -- -------------------------------------------------------------- Please read the FAQ! <http://java.apache.org/faq/> To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Archives and Other: <http://java.apache.org/main/mail.html> Problems?: [EMAIL PROTECTED] -- -------------------------------------------------------------- To subscribe: [EMAIL PROTECTED] To unsubscribe: [EMAIL PROTECTED] Archives and Other: <http://java.apache.org/main/mail.html> Problems?: [EMAIL PROTECTED]
