004_InventoryStore.sql 338 B

1234567
  1. BEGIN;
  2. update inventoryitems set creatorID = '00000000-0000-0000-0000-000000000000' where creatorID is NULL;
  3. update inventoryitems set creatorID = '00000000-0000-0000-0000-000000000000' where creatorID = '';
  4. alter table inventoryitems modify column creatorID varchar(36) not NULL default '00000000-0000-0000-0000-000000000000';
  5. COMMIT;