aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL
diff options
context:
space:
mode:
authorMelanie Thielker2008-08-24 03:15:02 +0000
committerMelanie Thielker2008-08-24 03:15:02 +0000
commitf9ec65bc21b39209e3093e91bb44f6fc058a9577 (patch)
tree9928fc01c339118693822c56b03049cceeeacb5a /OpenSim/Data/MySQL
parentmore progress on new meshing routines (diff)
downloadopensim-SC_OLD-f9ec65bc21b39209e3093e91bb44f6fc058a9577.zip
opensim-SC_OLD-f9ec65bc21b39209e3093e91bb44f6fc058a9577.tar.gz
opensim-SC_OLD-f9ec65bc21b39209e3093e91bb44f6fc058a9577.tar.bz2
opensim-SC_OLD-f9ec65bc21b39209e3093e91bb44f6fc058a9577.tar.xz
Add the fields for the eye candy and sale featires to the prims table.
No user functionality yet. Run prebuild. Contains a Migration. May contain nuts.
Diffstat (limited to 'OpenSim/Data/MySQL')
-rw-r--r--OpenSim/Data/MySQL/Resources/016_RegionStore.sql27
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 @@
1BEGIN;
2
3ALTER TABLE prims ADD COLUMN PayPrice integer not null default 0;
4ALTER TABLE prims ADD COLUMN PayButton1 integer not null default 0;
5ALTER TABLE prims ADD COLUMN PayButton2 integer not null default 0;
6ALTER TABLE prims ADD COLUMN PayButton3 integer not null default 0;
7ALTER TABLE prims ADD COLUMN PayButton4 integer not null default 0;
8ALTER TABLE prims ADD COLUMN LoopedSound char(36) not null default '00000000-0000-0000-0000-000000000000';
9ALTER TABLE prims ADD COLUMN LoopedSoundGain float not null default 0.0;
10ALTER TABLE prims ADD COLUMN TextureAnimation blob;
11ALTER TABLE prims ADD COLUMN OmegaX float not null default 0.0;
12ALTER TABLE prims ADD COLUMN OmegaY float not null default 0.0;
13ALTER TABLE prims ADD COLUMN OmegaZ float not null default 0.0;
14ALTER TABLE prims ADD COLUMN CameraEyeOffsetX float not null default 0.0;
15ALTER TABLE prims ADD COLUMN CameraEyeOffsetY float not null default 0.0;
16ALTER TABLE prims ADD COLUMN CameraEyeOffsetZ float not null default 0.0;
17ALTER TABLE prims ADD COLUMN CameraAtOffsetX float not null default 0.0;
18ALTER TABLE prims ADD COLUMN CameraAtOffsetY float not null default 0.0;
19ALTER TABLE prims ADD COLUMN CameraAtOffsetZ float not null default 0.0;
20ALTER TABLE prims ADD COLUMN ForceMouselook tinyint not null default 0;
21ALTER TABLE prims ADD COLUMN ScriptAccessPin integer not null default 0;
22ALTER TABLE prims ADD COLUMN AllowedDrop tinyint not null default 0;
23ALTER TABLE prims ADD COLUMN DieAtEdge tinyint not null default 0;
24ALTER TABLE prims ADD COLUMN SalePrice integer not null default 10;
25ALTER TABLE prims ADD COLUMN SaleType tinyint not null default 0;
26
27COMMIT;