IF (NOT EXISTS (select Table_name from SysTable where LCase(Table_name)=LCase('Printers'))) THEN

CREATE TABLE "DBA"."Printers"
(
	"Name"  			varchar(50) NOT NULL UNIQUE,
	"Driver"        		varchar(50) NOT NULL,
	"Port"  			varchar(50) NULL,
	"File"  			varchar(80) NULL,
	"Options"       		text NULL,
	"Header"        		text NULL,
	"Footer"        		text NULL,
	"Aktiv" 			integer NOT NULL DEFAULT 1,
	"TextWidth"     		integer NULL DEFAULT 40,
	"DirectPrint"   		integer NULL DEFAULT 1,
	"ReCoder"       		varchar(250) NULL DEFAULT '1',
	"Body"  			text NULL,
	"Description"   		text NULL,
	"N"     			integer NOT NULL DEFAULT autoincrement,
	 PRIMARY KEY ("N")
);


COMMENT ON COLUMN "DBA"."Printers"."Name" IS
	'Name (alias) of the printer. Similar to Widows printer names.';


COMMENT ON COLUMN "DBA"."Printers"."Driver" IS
	'Name of the printer driver. Currently supported: FP3530, Text, Text-BGR, Text-RUS, Screen';


COMMENT ON COLUMN "DBA"."Printers"."Port" IS
	'Similar to Windows printer port. Examples: LPT1, \\Server\\HP-690C';


COMMENT ON COLUMN "DBA"."Printers"."File" IS
	'If specified, the printer output goes there. If there is * in the file name, it will be replaced with consequential number.';


COMMENT ON COLUMN "DBA"."Printers"."Options" IS
	'Printer options in form <Option>=<Value>';


COMMENT ON COLUMN "DBA"."Printers"."Header" IS
	'Header of each print job. The format is free text or Pascal string format (allows\x0D\x0Anonprintable characters to be entered). Each line can be in one of the forms: if the line\x0D\x0Abegins with # or '' Pascal format is assumed (errors are reported).';


COMMENT ON COLUMN "DBA"."Printers"."Footer" IS
	'Footer of each print job. The format is free text or Pascal string format (allows\x0D\x0Anonprintable characters to be entered). Each line can be in one of the forms: if the line\x0D\x0Abegins with # or '' Pascal format is assumed (errors are reported).';


COMMENT ON COLUMN "DBA"."Printers"."Aktiv" IS
	'1: Active; 0: Not active';


COMMENT ON COLUMN "DBA"."Printers"."TextWidth" IS
	'Characters per line. The minimum is 30.';



END IF

GO

if (select count(*) from Printers where Name='Datecs FP1000')=0 then

INSERT INTO Printers(Name,Driver,Port,File,"Options",Header,Footer,Aktiv,TextWidth,DirectPrint,ReCoder,Body,Description,N)
 VALUES('Datecs FP1000','FP1000','1','','','','',1,40,1,'1','','',
 ISNULL((select MAX(N+1) from Printers),0));

end if;

GO

if (select count(*) from Printers where Name='FP-550')=0 then

INSERT INTO Printers(Name,Driver,Port,File,"Options",Header,Footer,Aktiv,TextWidth,DirectPrint,ReCoder,Body,Description,N)
 VALUES('FP-550','CBM262','1','','','','',1,28,1,'1','','Използва се за директно управление на фискален принтер Датекс FP-550. Старото име на драйвера беше CBM262
Comm Port-a се задава като допълнително свойсво(с-во ''Номер касов Апарат'') на склада, към който оперира системата',
ISNULL((select MAX(N+1) from Printers),0));


end if;