/* SQL-92 Table Creation Script with DBISAM Extensions */

CREATE TABLE IF NOT EXISTS "tblJobs"
(
   "JobStart" DATE,
   "JobStop" DATE,
   "JobsAutoInc" AUTOINC,
   "JobNo" VARCHAR(20),
   "FilePath" VARCHAR(100),
   "DateIn" DATE,
   "ClientsAutoInc" INTEGER DEFAULT 0,
   "Address" MEMO,
   "Status" VARCHAR(30),
   "JobNextAction" MEMO,
   "JobNotes" MEMO COMPRESS 6,
   "JobInstruction" VARCHAR(200),
   "JobsTelNos" MEMO,
   "Project" VARCHAR(70),
   "ArchNotes" MEMO,
   "QSNotes" MEMO,
   "ContractorNotes" MEMO,
   "ArchAutoInc" INTEGER DEFAULT 0,
   "ArchJobRefNo" VARCHAR(30),
   "ArchJobTitle" VARCHAR(50),
   "QSAutoInc" INTEGER DEFAULT 0,
   "QSJobRefNo" VARCHAR(30),
   "QSJobTitle" VARCHAR(50),
   "ContractorAutoInc" INTEGER DEFAULT 0,
   "ContractorJobRefNo" VARCHAR(30),
   "ContractorJobTitle" VARCHAR(50),
   "ShowArchTab" BOOLEAN DEFAULT True,
   "ShowEngTab" BOOLEAN DEFAULT False,
   "ShowQSTab" BOOLEAN DEFAULT False,
   "ShowLATab" BOOLEAN DEFAULT False,
   "ShowTQsTab" BOOLEAN DEFAULT False,
   "ShowDrgRegTab" BOOLEAN DEFAULT False,
   "ShowExpensesTab" BOOLEAN DEFAULT False,
   "ShowContractorTab" BOOLEAN DEFAULT False,
   "ShowJobContactsTab" BOOLEAN,
   "CreatedByUserID" INTEGER,
   "DateCreated" TIMESTAMP,
   "LAAutoInc" INTEGER DEFAULT 0,
   "LAPlanningRefNo" VARCHAR(30),
   "BCRefNo" VARCHAR(30),
   "LAPlanningApplicationDate" DATE,
   "LAPlanningReceived" DATE,
   "BCAutoInc" INTEGER DEFAULT 0,
   "BCApplicationDate" DATE,
   "BCApproved" DATE,
   "LAPlanningOfficerAutoInc" INTEGER DEFAULT 0,
   "BCOfficerAutoInc" INTEGER DEFAULT 0,
   "LAPlanningNotes" MEMO,
   "BCNotes" MEMO,
   "FeeNotes" MEMO,
   "Quotation" MONEY,
   "FeeBasis" VARCHAR(20) DEFAULT 'Quote',
   "Percentage" FLOAT,
   "ContractValue" MONEY,
   "ClientProjectRefNo" VARCHAR(20),
   "ClientOrderNo" VARCHAR(20),
   "EngAutoInc" INTEGER DEFAULT 0,
   "EngJobRefNo" VARCHAR(30),
   "ManagerRefNo" INTEGER,
   "ManagerName" VARCHAR(40),
   "JobType" VARCHAR(30),
   "JobType2" VARCHAR(30),
   "tsChanged" TIMESTAMP,
   "LACOAutoInc" INTEGER,
   "LACORefNo" VARCHAR(30),
   "LACONotes" MEMO,
   "LAHighwaysAutoInc" INTEGER,
   "LAHighwaysRefNo" VARCHAR(30),
   "LAHighwaysNotes" MEMO,
   "Office" VARCHAR(30),
   "Sector" VARCHAR(30),
NOCASE PRIMARY KEY ("JobsAutoInc") COMPRESS NONE
TEXT INDEX ("Address","JobNotes","Project","JobInstruction")
STOP WORDS 'A AN AND BE FOR HOW IN IS IT OF ON OR THAT THE THIS TO WAS WHAT WHEN WHICH WHY WILL'
SPACE CHARS #1+#2+#3+#4+#5+#6+#7+#8+#9+#10+#11+#12+#13
+#14+#15+#16+#17+#18+#19+#20+#21+#22+#23
+#24+#25+#26+#27+#28+#29+#30+#31+#32+'*+'+
',-./:;<=>\`'
INCLUDE CHARS '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ_ab'+
'cdefghijklmnopqrstuvwxyz€‚ƒ„…†‡ˆ‰Š‹ŒŽ'+
'‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§¨©ª«¬­®¯°±²³´µ¶·'+
'¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß'+
'àáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþ'
LOCALE CODE 2057
ENCRYPTED WITH 'SolutionsIT'
USER MAJOR VERSION 1
USER MINOR VERSION 3
);

CREATE UNIQUE INDEX IF NOT EXISTS "Temp" ON "tblJobs" ("RecordID");
CREATE INDEX IF NOT EXISTS "ClientsAutoInc" ON "tblJobs" ("ClientsAutoInc");
CREATE INDEX IF NOT EXISTS "ArchAutoInc" ON "tblJobs" ("ArchAutoInc");
CREATE INDEX IF NOT EXISTS "BC" ON "tblJobs" ("BCAutoInc");
CREATE INDEX IF NOT EXISTS "LA" ON "tblJobs" ("LAAutoInc");
CREATE INDEX IF NOT EXISTS "QS" ON "tblJobs" ("QSAutoInc");
CREATE INDEX IF NOT EXISTS "Contractor" ON "tblJobs" ("ContractorAutoInc");
CREATE INDEX IF NOT EXISTS "Eng" ON "tblJobs" ("EngAutoInc");
CREATE INDEX IF NOT EXISTS "JobNo" ON "tblJobs" ("JobNo");
CREATE INDEX IF NOT EXISTS "BCOfficerAutoInc" ON "tblJobs" ("BCOfficerAutoInc");
CREATE INDEX IF NOT EXISTS "LAPlanningOfficerAutoInc" ON "tblJobs" ("LAPlanningOfficerAutoInc");
CREATE NOCASE INDEX IF NOT EXISTS "Instruction" ON "tblJobs" ("JobInstruction");
CREATE NOCASE INDEX IF NOT EXISTS "Project" ON "tblJobs" ("Project");
CREATE INDEX IF NOT EXISTS "Status" ON "tblJobs" ("Status");
CREATE INDEX IF NOT EXISTS "Office" ON "tblJobs" ("Office");
CREATE INDEX IF NOT EXISTS "Sector" ON "tblJobs" ("Sector");
   