maintenance/ibm_db2/patch-ipb_allow_usertalk.sql

   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
  22
  23 );