drop table prod9;
CREATE TABLE IF NOT EXISTS "prod9"
(
   "codigo" integer,
   "cstis" varchar(3),
   "cclasstribis" varchar(6),
   "aliqis" Float,
   "aliqisespec" Float,
   "cstcbs" varchar(3),
   "cclasstribcbs" varchar(6),
   "aliqibsuf" Float,
   "aliqdifibsuf" Float,
   "vldevtribibsuf" Float,
   "aliqredibsuf" Float,
   "aliqefetibsuf" Float,
   "aliqibsmun" Float,
   "aliqdifibsmun" Float,
   "vldevtribibsmun" Float,
   "aliqredibsmun" Float,
   "aliefetibsmun" Float,
   "aliqcbs" Float,
   "aliqdifcbs" Float,
   "aliqefetcbs" Float,
   "vldevtribcbs" Float,
   "aliqredcbs" Float,
   "aliqefetibsmun" Float,
   "qtde_trib" Float,
PRIMARY KEY ("RecordID") COMPRESS NONE
DESCRIPTION 'Infos Tributarias a partir da reforma tributaria'
LOCALE CODE 0
USER MAJOR VERSION 3
USER MINOR VERSION 5
);

CREATE INDEX IF NOT EXISTS "codigo" ON "prod9" ("codigo");