CREATE EXTENSION IF NOT EXISTS pg_trgm;

BEGIN;

CREATE SCHEMA adjudication;

CREATE  TABLE adjudication.claims (
    id bigint NOT NULL,
    c001 bigint,
    c002 bigint,
    c003 character varying(15),
    c004 text,
    c005 timestamp without time zone,
    c006 timestamp without time zone DEFAULT date_trunc('day'::text, CURRENT_TIMESTAMP) NOT NULL,
    c007 timestamp without time zone,
    c008 character(1) DEFAULT '''R'''::bpchar NOT NULL,
    c009 smallint NOT NULL,
    c010 timestamp with time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    c011 text NOT NULL,
    c012 text,
    c013 text,
    c014 character varying(50),
    c015 character varying(1),
    c016 character varying(15),
    first_name text,
    c017 text,
    c018 timestamp without time zone,
    c019 text,
    c020 bigint,
    c021 bigint,
    c022 bigint,
    c023 bigint,
    c024 character varying(7),
    c025 text,
    c026 character varying(1),
    c027 text,
    c028 numeric(10,2),
    c029 character varying(2),
    c030 character varying(2),
    c031 character varying(6),
    c032 character varying(10),
    c033 character varying(1),
    c034 character varying(2),
    c035 character varying(15),
    c036 character varying(10),
    c037 character varying(50),
    c038 text,
    c039 text,
    c040 character varying(15),
    c041 character varying(1),
    c042 character varying(18),
    c043 character varying(3),
    c044 character varying(1),
    c045 character varying(20),
    c046 character varying(2),
    c047 character varying(1),
    c048 character varying(1),
    c049 character varying(20),
    c050 character varying(2),
    c051 character varying(50),
    c052 timestamp without time zone,
    c053 character varying(1),
    c054 text,
    c055 text,
    c056 text,
    c057 text,
    c058 text,
    c059 text,
    c060 character varying(2),
    c061 character varying(10),
    c062 character varying(2),
    c063 character varying(10),
    c064 character varying(2),
    c065 character varying(15),
    c066 character varying(1),
    c067 character varying(80),
    c068 character varying(2),
    c069 character varying(1),
    c070 character varying(20),
    c071 character varying(2),
    c072 character varying(40),
    c073 character varying(20),
    c074 timestamp without time zone,
    c075 character varying(2),
    c076 character varying(2),
    c077 character varying(2),
    c078 character varying(2),
    c079 character varying(2),
    c080 character varying(2),
    c081 character varying(2),
    c082 character varying(2),
    c083 character varying(2),
    c084 character varying(2),
    c085 numeric(10,3),
    c086 integer,
    c087 integer,
    c088 character varying(1),
    c089 character varying(1),
    c090 timestamp without time zone,
    c091 integer,
    c092 character varying(1),
    c093 character varying(3),
    c094 character varying(3),
    c095 character varying(3),
    c096 character varying(3),
    c097 character varying(3),
    c098 character varying(2),
    c099 character varying(2),
    c100 character varying(2),
    c101 character varying(2),
    c102 character varying(2),
    c103 numeric(10,3),
    c104 character varying(35),
    c105 character varying(2),
    c106 numeric(10,3),
    c107 character varying(2),
    c108 character varying(2),
    c109 character varying(2),
    c110 character varying(40),
    c111 numeric(10,3),
    c112 character varying(30),
    c113 character varying(2),
    c114 character varying(2),
    c115 character varying(2),
    c116 character varying(35),
    c117 character varying(1),
    c118 numeric(10,3),
    c119 integer,
    c120 character varying(2),
    c121 character varying(1),
    c122 character varying(11),
    c123 character varying(2),
    c124 character varying(2),
    c125 character varying(3),
    c126 character varying(2),
    c127 character varying(2),
    c128 integer,
    c129 character varying(2),
    c130 character varying(40),
    c131 character varying(2),
    c132 character varying(1),
    c133 integer,
    c134 timestamp without time zone,
    c135 character varying(2),
    c136 character varying(2),
    c137 character varying(2),
    c138 character varying(2),
    c139 character varying(2),
    c140 character varying(2),
    c141 character varying(2),
    c142 character varying(2),
    c143 character varying(2),
    c144 character varying(2),
    c145 character varying(2),
    c146 character varying(2),
    c147 character varying(2),
    c148 character varying(2),
    c149 character varying(2),
    c150 character varying(2),
    c151 character varying(2),
    c152 character varying(2),
    c153 character varying(2),
    c154 character varying(2),
    c155 character varying(2),
    c156 character varying(2),
    c157 character varying(2),
    c158 character varying(2),
    c159 character varying(2),
    c160 character varying(2),
    c161 character varying(2),
    c162 numeric(10,2),
    c163 numeric(10,2),
    c164 numeric(10,2),
    c165 numeric(10,2),
    c166 character varying(2),
    c167 numeric(10,2),
    c168 character varying(2),
    c169 numeric(10,2),
    c170 character varying(2),
    c171 numeric(10,2),
    c172 character varying(2),
    c173 numeric(10,2),
    c174 character varying(2),
    c175 numeric(10,2),
    c176 character varying(2),
    c177 numeric(10,2),
    c178 numeric(10,2),
    c179 numeric(10,2),
    c180 character varying(2),
    c181 numeric(10,2),
    c182 numeric(10,2),
    c183 character varying(2),
    c184 character varying(2),
    c185 character varying(15),
    c186 text,
    c187 text,
    c188 character varying(2),
    c189 character varying(15),
    c190 text,
    c191 character varying(10),
    c192 character varying(8),
    c193 character varying(2),
    c194 character varying(15),
    c195 text,
    c196 text,
    c197 text,
    c198 text,
    c199 text,
    c200 text,
    c201 character varying(2),
    c202 character varying(10),
    c203 character varying(2),
    c204 character varying(15),
    c205 character varying(2),
    c206 character varying(15),
    c207 character varying(1),
    c208 smallint,
    c209 character varying(2),
    c210 character varying(40),
    c211 numeric(10,3),
    c212 character varying(2),
    c213 character varying(40),
    c214 numeric(10,3),
    c215 character varying(2),
    c216 character varying(40),
    c217 numeric(10,3),
    c218 character varying(2),
    c219 character varying(40),
    c220 numeric(10,3),
    c221 character varying(2),
    c222 character varying(40),
    c223 numeric(10,3),
    c224 character varying(2),
    c225 character varying(40),
    c226 numeric(10,3),
    c227 character varying(2),
    c228 character varying(40),
    c229 numeric(10,3),
    c230 character varying(2),
    c231 character varying(40),
    c232 numeric(10,3),
    c233 character varying(2),
    c234 character varying(40),
    c235 numeric(10,3),
    c236 character varying(2),
    c237 character varying(40),
    c238 numeric(10,3),
    c239 character varying(2),
    c240 character varying(40),
    c241 numeric(10,3),
    c242 character varying(2),
    c243 character varying(40),
    c244 numeric(10,3),
    c245 character varying(2),
    c246 character varying(40),
    c247 numeric(10,3),
    c248 character varying(2),
    c249 character varying(40),
    c250 numeric(10,3),
    c251 character varying(2),
    c252 character varying(40),
    c253 numeric(10,3),
    c254 character varying(2),
    c255 character varying(40),
    c256 numeric(10,3),
    c257 character varying(2),
    c258 character varying(40),
    c259 numeric(10,3),
    c260 character varying(2),
    c261 character varying(40),
    c262 numeric(10,3),
    c263 character varying(2),
    c264 character varying(40),
    c265 numeric(10,3),
    c266 character varying(2),
    c267 character varying(40),
    c268 numeric(10,3),
    c269 character varying(2),
    c270 character varying(40),
    c271 numeric(10,3),
    c272 character varying(2),
    c273 character varying(40),
    c274 numeric(10,3),
    c275 character varying(2),
    c276 character varying(40),
    c277 numeric(10,3),
    c278 character varying(2),
    c279 character varying(40),
    c280 numeric(10,3),
    c281 character varying(2),
    c282 character varying(40),
    c283 numeric(10,3),
    c284 character varying(2),
    c285 character varying(15),
    c286 character varying(2),
    c287 character varying(15),
    c288 character varying(2),
    c289 character varying(15),
    c290 character varying(2),
    c291 character varying(15),
    c292 character varying(2),
    c293 character varying(15)
);

CREATE SEQUENCE adjudication.claims_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;

ALTER SEQUENCE adjudication.claims_id_seq OWNED BY adjudication.claims.id;

ALTER TABLE ONLY adjudication.claims ALTER COLUMN id SET DEFAULT nextval('adjudication.claims_id_seq'::regclass);

ALTER TABLE ONLY adjudication.claims
    ADD CONSTRAINT claims_pkey PRIMARY KEY (id);

CREATE INDEX idx_claims_first_name_upper_trgm ON adjudication.claims USING gist (upper(first_name) public.gist_trgm_ops);

SELECT count(*) FROM adjudication.claims;

ROLLBACK;