1
0

011_RegionStore.sql 280 B

123456789
  1. BEGIN;
  2. ALTER TABLE prims change SceneGroupID SceneGroupIDold varchar(255);
  3. ALTER TABLE prims add SceneGroupID char(36);
  4. UPDATE prims set SceneGroupID = SceneGroupIDold;
  5. ALTER TABLE prims drop SceneGroupIDold;
  6. ALTER TABLE prims add index prims_scenegroupid(SceneGroupID);
  7. COMMIT;