diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/016_RegionStore.sql | 27 |
1 files changed, 27 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/016_RegionStore.sql b/OpenSim/Data/MySQL/Resources/016_RegionStore.sql new file mode 100644 index 0000000..9bc265e --- /dev/null +++ b/OpenSim/Data/MySQL/Resources/016_RegionStore.sql | |||
@@ -0,0 +1,27 @@ | |||
1 | BEGIN; | ||
2 | |||
3 | ALTER TABLE prims ADD COLUMN PayPrice integer not null default 0; | ||
4 | ALTER TABLE prims ADD COLUMN PayButton1 integer not null default 0; | ||
5 | ALTER TABLE prims ADD COLUMN PayButton2 integer not null default 0; | ||
6 | ALTER TABLE prims ADD COLUMN PayButton3 integer not null default 0; | ||
7 | ALTER TABLE prims ADD COLUMN PayButton4 integer not null default 0; | ||
8 | ALTER TABLE prims ADD COLUMN LoopedSound char(36) not null default '00000000-0000-0000-0000-000000000000'; | ||
9 | ALTER TABLE prims ADD COLUMN LoopedSoundGain float not null default 0.0; | ||
10 | ALTER TABLE prims ADD COLUMN TextureAnimation blob; | ||
11 | ALTER TABLE prims ADD COLUMN OmegaX float not null default 0.0; | ||
12 | ALTER TABLE prims ADD COLUMN OmegaY float not null default 0.0; | ||
13 | ALTER TABLE prims ADD COLUMN OmegaZ float not null default 0.0; | ||
14 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float not null default 0.0; | ||
15 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float not null default 0.0; | ||
16 | ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float not null default 0.0; | ||
17 | ALTER TABLE prims ADD COLUMN CameraAtOffsetX float not null default 0.0; | ||
18 | ALTER TABLE prims ADD COLUMN CameraAtOffsetY float not null default 0.0; | ||
19 | ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float not null default 0.0; | ||
20 | ALTER TABLE prims ADD COLUMN ForceMouselook tinyint not null default 0; | ||
21 | ALTER TABLE prims ADD COLUMN ScriptAccessPin integer not null default 0; | ||
22 | ALTER TABLE prims ADD COLUMN AllowedDrop tinyint not null default 0; | ||
23 | ALTER TABLE prims ADD COLUMN DieAtEdge tinyint not null default 0; | ||
24 | ALTER TABLE prims ADD COLUMN SalePrice integer not null default 10; | ||
25 | ALTER TABLE prims ADD COLUMN SaleType tinyint not null default 0; | ||
26 | |||
27 | COMMIT; | ||