1
0

016_RegionStore.sql 1.6 KB

123456789101112131415161718192021222324252627
  1. BEGIN;
  2. ALTER TABLE prims ADD COLUMN PayPrice integer not null default 0;
  3. ALTER TABLE prims ADD COLUMN PayButton1 integer not null default 0;
  4. ALTER TABLE prims ADD COLUMN PayButton2 integer not null default 0;
  5. ALTER TABLE prims ADD COLUMN PayButton3 integer not null default 0;
  6. ALTER TABLE prims ADD COLUMN PayButton4 integer not null default 0;
  7. ALTER TABLE prims ADD COLUMN LoopedSound char(36) not null default '00000000-0000-0000-0000-000000000000';
  8. ALTER TABLE prims ADD COLUMN LoopedSoundGain float not null default 0.0;
  9. ALTER TABLE prims ADD COLUMN TextureAnimation blob;
  10. ALTER TABLE prims ADD COLUMN OmegaX float not null default 0.0;
  11. ALTER TABLE prims ADD COLUMN OmegaY float not null default 0.0;
  12. ALTER TABLE prims ADD COLUMN OmegaZ float not null default 0.0;
  13. ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float not null default 0.0;
  14. ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float not null default 0.0;
  15. ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float not null default 0.0;
  16. ALTER TABLE prims ADD COLUMN CameraAtOffsetX float not null default 0.0;
  17. ALTER TABLE prims ADD COLUMN CameraAtOffsetY float not null default 0.0;
  18. ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float not null default 0.0;
  19. ALTER TABLE prims ADD COLUMN ForceMouselook tinyint not null default 0;
  20. ALTER TABLE prims ADD COLUMN ScriptAccessPin integer not null default 0;
  21. ALTER TABLE prims ADD COLUMN AllowedDrop tinyint not null default 0;
  22. ALTER TABLE prims ADD COLUMN DieAtEdge tinyint not null default 0;
  23. ALTER TABLE prims ADD COLUMN SalePrice integer not null default 10;
  24. ALTER TABLE prims ADD COLUMN SaleType tinyint not null default 0;
  25. COMMIT;