IF (NOT EXISTS (select Table_name from SysTable where LCase(Table_name)=LCase('Inventory'))) THEN
  create table Inventory (
    N integer not null default autoincrement,
	"Name" varchar(50),
	"Active" integer,
	primary key("N")
  )
end if
go

IF (NOT EXISTS (select Table_name from SysTable where LCase(Table_name)=LCase('InventoryOperations'))) THEN
  create table InventoryOperations (
    N integer not null default autoincrement,
	OperationDate datetime not null,
	InventoryN integer not null,
	GuestN integer not null,
	Qty integer not null,
	AdminN integer not null,
	Notes varchar(250),
	AddOperationN integer,
	primary key("N")
  )
end if
go

if (not exists(select role from sys.sysforeignkey where role='FK_InvOps_Inventory')) then
ALTER TABLE InventoryOperations
ADD FOREIGN KEY "FK_InvOps_Inventory" ("InventoryN")
REFERENCES "DBA"."Inventory" ("N")
end if
go

if (not exists(select role from sys.sysforeignkey where role='FK_InvOps_Guests')) then
ALTER TABLE InventoryOperations
ADD FOREIGN KEY "FK_InvOps_Guests" ("GuestN")
REFERENCES "DBA"."Guests" ("GuestNum")
end if
go

if (not exists(select role from sys.sysforeignkey where role='FK_InvOps_Admin')) then
ALTER TABLE InventoryOperations
ADD FOREIGN KEY "FK_InvOps_Admin" ("AdminN")
REFERENCES "DBA"."Admin" ("AdminNo")
end if
go