if (select count(*) from sys.systable where table_name='BulSystArchive')=0
  then
     CREATE TABLE "DBA"."BulSystArchive"
       (
        "BulSystID"             integer NOT NULL DEFAULT autoincrement,
	"RoomN"        		integer NOT NULL,
	"Concentrator" 		varchar(3),
	"Reader"   		varchar(3),
	"CardNumber"            varchar(10),
	"LeaveDate"             date,
	"LeaveTime"             time,
	"OperationDate"         date,
	"OperationTime"         time,
	"Status"                char(1)
        )
end if;

GO

COMMENT ON COLUMN "DBA"."BulSystArchive"."Status" IS 'I - for Insert, U for Update , D for Delete'