/* * $Id$ * *//* * Table structure for table 'radcheck' */CREATE TABLE badusers (	id		INT PRIMARY KEY,	username	VARCHAR(30) DEFAULT '' NOT NULL,	incidentdate	TIMESTAMP WITH TIME ZONE DEFAULT sysdate NOT NULL,	reason		VARCHAR(128) DEFAULT '' NOT NULL,	admin		VARCHAR(128) DEFAULT '-' NOT NULL);CREATE SEQUENCE badusers_seq START WITH 1 INCREMENT BY 1;CREATE INDEX badusers_incidentdate_idx ON badusers (incidentdate);CREATE INDEX badusers_username_idx ON badusers (username);/* Trigger to emulate a serial # on the primary key */CREATE OR REPLACE TRIGGER badusers_serialnumber        BEFORE INSERT OR UPDATE OF id ON badusers        FOR EACH ROW        BEGIN                if ( :new.id = 0 or :new.id is null ) then                        SELECT badusers_seq.nextval into :new.id from dual;                end if;        END;/