-- This is the first patch to be applied.

CREATE TABLE "LOGINS" (
	"UsrName"	TEXT NOT NULL UNIQUE,
	"UsrPword"	TEXT NOT NULL,
	PRIMARY KEY("UsrName")
);

-- Some examples only for use on a test system

INSERT INTO LOGINS(UsrName,UsrPword) values("johnpearcey","password");
INSERT INTO LOGINS(UsrName,UsrPword) values("larspetersen","nesretepsral");
INSERT INTO LOGINS(UsrName,UsrPword) values("rolandovalle","ellavodnalor");

alter table BULIST add column Res_User TEXT;
alter table BULIST add column Res_Pwd TEXT;