WebPasswordSafe Upgrade Notes

Version 1.2 to 1.3

1. Shutdown WebPasswordSafe v1.2
2. Run the following SQL to upgrade your webpasswordsafe database schema:
   • MySQL/MariaDB
     

     ALTER TABLE users MODIFY username VARCHAR(100);
     ALTER TABLE passwords MODIFY username VARCHAR(100);
     ALTER TABLE audit_log MODIFY username VARCHAR(100);
     ALTER TABLE password_data MODIFY password VARCHAR(300);
     ALTER TABLE passwords DROP INDEX name;
        

   • MSSQL
     

     ALTER TABLE users ALTER COLUMN username VARCHAR(100);
     ALTER TABLE passwords ALTER COLUMN username VARCHAR(100);
     ALTER TABLE audit_log ALTER COLUMN username VARCHAR(100);
     ALTER TABLE password_data ALTER COLUMN password VARCHAR(300);
     SELECT d.name FROM sys.tables t 
         JOIN sys.indexes d ON d.object_id = t.object_id AND d.type=2 AND d.is_unique=1
         JOIN sys.index_columns ic ON d.index_id=ic.index_id AND ic.object_id=t.object_id
         JOIN sys.columns c ON ic.column_id = c.column_id AND c.object_id=t.object_id
         WHERE t.name = 'passwords' AND c.name='name';
     ALTER TABLE passwords DROP CONSTRAINT {d.name};
        

   • PostgreSQL
     

     ALTER TABLE users ALTER COLUMN username TYPE VARCHAR(100);
     ALTER TABLE passwords ALTER COLUMN username TYPE VARCHAR(100);
     ALTER TABLE audit_log ALTER COLUMN username TYPE VARCHAR(100);
     ALTER TABLE password_data ALTER COLUMN password TYPE VARCHAR(300);
     ALTER TABLE passwords DROP CONSTRAINT passwords_name_key;
        

   • Oracle
     

     ALTER TABLE users MODIFY (username VARCHAR2(100));
     ALTER TABLE passwords MODIFY (username VARCHAR2(100));
     ALTER TABLE audit_log MODIFY (username VARCHAR2(100));
     ALTER TABLE password_data MODIFY (password VARCHAR2(300));
     SELECT constraint_name FROM all_constraints WHERE owner='WPS' AND table_name='PASSWORDS' AND constraint_type='U';
     ALTER TABLE passwords DROP CONSTRAINT {constraint_name};
        

3. Continue deployment of WebPasswordSafe v1.3