/* SQL-92 Table Creation Script with DBISAM Extensions */

DROP TABLE IF EXISTS "cae";

CREATE TABLE IF NOT EXISTS "cae"
(
   "Cod" WORD,
   "DRE" WORD,
   "Descricao" CHARACTER(30),

PRIMARY KEY ("Cod") COMPRESS NONE
DESCRIPTION "Tabela de CAEs"
BLOB BLOCK SIZE 128
LANGUAGE "Portuguese (Standard)" SORT "Default Order"
USER MAJOR VERSION 1
);

CREATE INDEX "DREC" ON "cae" ("DRE", "Cod");

INSERT INTO "cae" VALUES (103 , 1 ,          "Braga") NOAUTOINC;
INSERT INTO "cae" VALUES (104 , 1 ,          "Bragança") NOAUTOINC;
INSERT INTO "cae" VALUES (113 , 1 ,          "Porto") NOAUTOINC;
INSERT INTO "cae" VALUES (116 , 1 ,          "Viana do Castelo") 
NOAUTOINC;
INSERT INTO "cae" VALUES (117 , 1 ,          "Vila Real") NOAUTOINC;
INSERT INTO "cae" VALUES (120 , 1 ,          "Douro Sul") NOAUTOINC;
INSERT INTO "cae" VALUES (121 , 1 ,          "Entre Douro e Vouga") 
NOAUTOINC;
INSERT INTO "cae" VALUES (122 , 1 ,          "Tâmega") NOAUTOINC;
INSERT INTO "cae" VALUES (201 , 2 ,          "Aveiro") NOAUTOINC;
INSERT INTO "cae" VALUES (205 , 2 ,          "Castelo Branco") 
NOAUTOINC;
INSERT INTO "cae" VALUES (206 , 2 ,          "Coimbra") NOAUTOINC;
INSERT INTO "cae" VALUES (209 , 2 ,          "Guarda") NOAUTOINC;
INSERT INTO "cae" VALUES (210 , 2 ,          "Leiria") NOAUTOINC;
INSERT INTO "cae" VALUES (218 , 2 ,          "Viseu") NOAUTOINC;
INSERT INTO "cae" VALUES (311 , 3 ,          "Grande Lisboa") 
NOAUTOINC;
INSERT INTO "cae" VALUES (314 , 3 ,          "Lezíria e Médio Tejo") 
NOAUTOINC;
INSERT INTO "cae" VALUES (315 , 3 ,          "Península de Setúbal") 
NOAUTOINC;
INSERT INTO "cae" VALUES (319 , 3 ,          "Oeste") NOAUTOINC;
INSERT INTO "cae" VALUES (402 , 4 ,          
"Baixo Alent. e Alent. Litoral") NOAUTOINC;
INSERT INTO "cae" VALUES (407 , 4 ,          "Alentejo Central") 
NOAUTOINC;
INSERT INTO "cae" VALUES (412 , 4 ,          "Alto Alentejo") 
NOAUTOINC;
INSERT INTO "cae" VALUES (508 , 5 ,          "Algarve") NOAUTOINC;