blob: adf141902eca2655cd298be0eca1c7d2c7620020 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
CREATE TABLE radippool (
id INT PRIMARY KEY,
pool_name VARCHAR(30) NOT NULL,
framedipaddress VARCHAR(15) NOT NULL,
nasipaddress VARCHAR(15) NOT NULL,
pool_key VARCHAR(30) DEFAULT '',
CalledStationId VARCHAR(64) DEFAULT '',
CallingStationId VARCHAR(64) DEFAULT '',
expiry_time timestamp(0) DEFAULT CURRENT_TIMESTAMP,
username VARCHAR(64) DEFAULT ''
);
CREATE INDEX radippool_poolname_expire ON radippool (pool_name, expiry_time);
CREATE INDEX radippool_framedipaddress ON radippool (framedipaddress);
CREATE INDEX radippool_nasip_poolkey_ipaddress ON radippool (nasipaddress, pool_key, framedipaddress);
CREATE SEQUENCE radippool_seq START WITH 1 INCREMENT BY 1;
CREATE OR REPLACE TRIGGER radippool_serialnumber
BEFORE INSERT OR UPDATE OF id ON radippool
FOR EACH ROW
BEGIN
if ( :new.id = 0 or :new.id is null ) then
SELECT radippool_seq.nextval into :new.id from dual;
end if;
END;
/
|