7 * Table structure for table 'radcheck'
10 CREATE TABLE badusers (
12 username VARCHAR(30) DEFAULT '' NOT NULL,
13 incidentdate TIMESTAMP WITH TIME ZONE DEFAULT sysdate NOT NULL,
14 reason VARCHAR(128) DEFAULT '' NOT NULL,
15 admin VARCHAR(128) DEFAULT '-' NOT NULL
17 CREATE SEQUENCE badusers_seq START WITH 1 INCREMENT BY 1;
18 CREATE INDEX badusers_incidentdate_idx ON badusers (incidentdate);
19 CREATE INDEX badusers_username_idx ON badusers (username);
21 /* Trigger to emulate a serial # on the primary key */
22 CREATE OR REPLACE TRIGGER badusers_serialnumber
23 BEFORE INSERT OR UPDATE OF id ON badusers
26 if ( :new.id = 0 or :new.id is null ) then
27 SELECT badusers_seq.nextval into :new.id from dual;