1
0

003_AssetStore.sql 268 B

123456789
  1. BEGIN;
  2. ALTER TABLE assets change id oldid varchar(36);
  3. ALTER TABLE assets add id char(36) not null default '00000000-0000-0000-0000-000000000000';
  4. UPDATE assets set id = oldid;
  5. ALTER TABLE assets drop oldid;
  6. ALTER TABLE assets add constraint primary key(id);
  7. COMMIT;