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