]> git.evergreen-ils.org Git - working/Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/0062.schema.provider_SAN_as_text.sql
Update permission name to match existing ones
[working/Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0062.schema.provider_SAN_as_text.sql
1 BEGIN;
2
3 INSERT INTO config.upgrade_log (version) VALUES ('0062');
4
5 ALTER TABLE acq.provider ALTER COLUMN san TYPE TEXT USING lpad(text(san), 7, '0');
6
7 COMMIT;
8