7 * Table structure for table 'userinfo'
10 CREATE TABLE userinfo (
12 username VARCHAR(128) DEFAULT '' NOT NULL,
13 name VARCHAR(128) DEFAULT '' NOT NULL,
14 mail VARCHAR(128) DEFAULT '' NOT NULL,
15 department VARCHAR(128) DEFAULT '' NOT NULL,
16 workphone VARCHAR(128) DEFAULT '' NOT NULL,
17 homephone VARCHAR(128) DEFAULT '' NOT NULL,
18 mobile VARCHAR(128) DEFAULT '' NOT NULL
20 CREATE INDEX userinfo_department_idx ON userinfo (department);
21 CREATE INDEX userinfo_username_idx ON userinfo (username);
22 CREATE SEQUENCE userinfo_seq START WITH 1 INCREMENT BY 1;
25 /* Trigger to emulate a serial # on the primary key */
26 CREATE OR REPLACE TRIGGER userinfo_serialnumber
27 BEFORE INSERT OR UPDATE OF id ON userinfo
30 if ( :new.id = 0 or :new.id is null ) then
31 SELECT userinfo_seq.nextval into :new.id from dual;