CREATE TABLE IF NOT EXISTS "MODETQ"
(
   "codigo" AUTOINC,
   "descricao" VARCHAR(20),
   "margem_esquerda" INTEGER,
   "margem_superior" INTEGER,
   "distancia_lateral" INTEGER,
   "distancia_vertical" INTEGER,
   "qtde_colunas" INTEGER,
   "largura" INTEGER,
   "altura" INTEGER,
PRIMARY KEY ("RecordID") COMPRESS NONE
DESCRIPTION 'Modelos de etiquetas graficas'
LOCALE CODE 0
USER MAJOR VERSION 4
USER MINOR VERSION 5
);

CREATE INDEX IF NOT EXISTS "descricao" ON "modetq" ("descricao");

INSERT INTO modetq
    (descricao,margem_esquerda,margem_superior,distancia_lateral,distancia_vertical,qtde_colunas,largura,altura)
VALUES
    ('MANUAL',10,10,10,10,2,344,142);
INSERT INTO "MODETQ" VALUES (2, 
         'MENOR(4 COLUNAS)', 2, 1, 10, 0, 4, NULL, NULL);
INSERT INTO "MODETQ" VALUES (3, 
         'MEDIA(3 COLUNAS)', 2, 4, 0, 0, 3, 240, 106);
INSERT INTO "MODETQ" VALUES (4, 
         'MAIOR(2 COLUNAS)', 2, 4, 10, 10, 2, 344, 142);