Newer
Older
backup-commander / install / db / p-1.sql
  1. -- This is the first patch to be applied.
  2.  
  3. CREATE TABLE "LOGINS" (
  4. "UsrName" TEXT NOT NULL UNIQUE,
  5. "UsrPword" TEXT NOT NULL,
  6. PRIMARY KEY("UsrName")
  7. );
  8.  
  9. INSERT INTO LOGINS(UsrName,UsrPword) values("johnpearcey","password");
  10. INSERT INTO LOGINS(UsrName,UsrPword) values("larspetersen","nesretepsral");
  11. INSERT INTO LOGINS(UsrName,UsrPword) values("rolandovalle","ellavodnalor");
  12.  
  13. alter table BULIST add column Res_User TEXT;
  14. alter table BULIST add column Res_Pwd TEXT;