/* SQL-92 Table Creation Script with DBISAM Extensions */
DROP TABLE IF EXISTS "CASEINS";
CREATE TABLE IF NOT EXISTS "CaseIns"
(
   "f" AUTOINC,
   "f2" VARCHAR(10),
PRIMARY KEY ("RecordID") COMPRESS NONE
LOCALE CODE 1060
USER MAJOR VERSION 1
LAST AUTOINC 6
);

CREATE NOCASE INDEX IF NOT EXISTS "ByString" ON "CaseIns" ("f2");

INSERT INTO "CaseIns" VALUES (1, 
         'Ba');
INSERT INTO "CaseIns" VALUES (2, 
         'bb');
INSERT INTO "CaseIns" VALUES (3, 
         'Aa');
INSERT INTO "CaseIns" VALUES (4, 
         'aa');
INSERT INTO "CaseIns" VALUES (5, 
         'ba');
INSERT INTO "CaseIns" VALUES (6, 
         'bc');
  