CREATE TABLE IF NOT EXISTS "supplogs"
(
   "Ticket_Number" AUTOINC,
   "Store_Number" INTEGER,
   "Status" INTEGER,
   "Tech_taken_by" INTEGER,
   "Tech_Completed_by" INTEGER,
   "Time_Called" FLOAT,
   "Date_Called" SMALLINT,
   "Time_To_Call_Back" FLOAT,
   "Date_To_Call_Back" SMALLINT,
   "Time_Returned" FLOAT,
   "Date_Returned" SMALLINT,
   "Time_Complete" FLOAT,
   "Date_Complete" SMALLINT,
   "Problem_Type" INTEGER,
   "Total_Time" FLOAT,
   "Company_Number" INTEGER,
   "Number_Dummy" CHARACTER(26),
   "Persons_Name" CHARACTER(20),
   "ProblemSummary" CHARACTER(40),
   "ProblemKeyWord1" CHARACTER(15),
   "Problem" MEMO,
   "SolutionSummary" CHARACTER(40),
   "SolutionKeyWord1" CHARACTER(15),
   "Solution" MEMO,
PRIMARY KEY ("Ticket_Number") COMPRESS NONE
TEXT INDEX ("ProblemSummary","Problem","SolutionSummary","Solution")
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€�‚ƒ„…†‡ˆ‰Š‹Œ�Ž�"+
"�‘’“”•–—˜™š›œ�žŸ ¡¢£¤¥¦§¨©ª«¬­®¯°±²³´µ¶·"+
"¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞß"+
"àáâãäåæçèéêëìíîïðñòóôõö÷øùúûüýþ"
DESCRIPTION "Support Logs File"
LANGUAGE "ANSI Standard" SORT "Default Order"
);