1 CREATE TABLE ipblocks (
2 ipb_id
INTEGER NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY (START WITH 1),
3 --DEFAULT nextval('ipblocks_ipb_id_val'),
4 ipb_address
VARCHAR(1024),
5 ipb_user
BIGINT NOT NULL DEFAULT 0,
6 -- REFERENCES user(user_id) ON DELETE SET NULL,
7 ipb_by
BIGINT NOT NULL DEFAULT 0,
8 -- REFERENCES user(user_id) ON DELETE CASCADE,
9 ipb_by_text
VARCHAR(255) NOT NULL DEFAULT '',
10 ipb_reason
VARCHAR(1024) NOT NULL,
11 ipb_timestamp
TIMESTAMP(3) NOT NULL,
12 ipb_auto
SMALLINT NOT NULL DEFAULT 0,
13 ipb_anon_only
SMALLINT NOT NULL DEFAULT 0,
14 ipb_create_account
SMALLINT NOT NULL DEFAULT 1,
15 ipb_enable_autoblock
SMALLINT NOT NULL DEFAULT 1,
16 ipb_expiry
TIMESTAMP(3) NOT NULL,
17 ipb_range_start
VARCHAR(1024),
18 ipb_range_end
VARCHAR(1024),
19 ipb_deleted
SMALLINT NOT NULL DEFAULT 0,
20 ipb_block_email
SMALLINT NOT NULL DEFAULT 0,
21 ipb_allow_usertalk
SMALLINT NOT NULL DEFAULT 0