aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
diff options
context:
space:
mode:
Diffstat (limited to 'OpenSim/Data/SQLite/Resources/006_RegionStore.sql')
-rw-r--r--OpenSim/Data/SQLite/Resources/006_RegionStore.sql180
1 files changed, 90 insertions, 90 deletions
diff --git a/OpenSim/Data/SQLite/Resources/006_RegionStore.sql b/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
index 60b348a..2f6ea22 100644
--- a/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
+++ b/OpenSim/Data/SQLite/Resources/006_RegionStore.sql
@@ -1,107 +1,107 @@
1BEGIN TRANSACTION; 1BEGIN TRANSACTION;
2 2
3drop table if exists `estate_groups`; 3drop table if exists estate_groups;
4CREATE TABLE `estate_groups` ( 4CREATE TABLE estate_groups (
5 `EstateID` int(10) NOT NULL, 5 EstateID int(10) NOT NULL,
6 `uuid` char(36) NOT NULL 6 uuid char(36) NOT NULL
7); 7);
8 8
9drop table if exists `estate_managers`; 9drop table if exists estate_managers;
10CREATE TABLE `estate_managers` ( 10CREATE TABLE estate_managers (
11 `EstateID` int(10) NOT NULL, 11 EstateID int(10) NOT NULL,
12 `uuid` char(36) NOT NULL 12 uuid char(36) NOT NULL
13); 13);
14 14
15drop table if exists `estate_map`; 15drop table if exists estate_map;
16CREATE TABLE `estate_map` ( 16CREATE TABLE estate_map (
17 `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000', 17 RegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
18 `EstateID` int(11) NOT NULL 18 EstateID int(11) NOT NULL
19); 19);
20 20
21drop table if exists `estate_settings`; 21drop table if exists estate_settings;
22CREATE TABLE `estate_settings` ( 22CREATE TABLE estate_settings (
23 `EstateID` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 23 EstateID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
24 `EstateName` varchar(64) default NULL, 24 EstateName varchar(64) default NULL,
25 `AbuseEmailToEstateOwner` tinyint(4) NOT NULL, 25 AbuseEmailToEstateOwner tinyint(4) NOT NULL,
26 `DenyAnonymous` tinyint(4) NOT NULL, 26 DenyAnonymous tinyint(4) NOT NULL,
27 `ResetHomeOnTeleport` tinyint(4) NOT NULL, 27 ResetHomeOnTeleport tinyint(4) NOT NULL,
28 `FixedSun` tinyint(4) NOT NULL, 28 FixedSun tinyint(4) NOT NULL,
29 `DenyTransacted` tinyint(4) NOT NULL, 29 DenyTransacted tinyint(4) NOT NULL,
30 `BlockDwell` tinyint(4) NOT NULL, 30 BlockDwell tinyint(4) NOT NULL,
31 `DenyIdentified` tinyint(4) NOT NULL, 31 DenyIdentified tinyint(4) NOT NULL,
32 `AllowVoice` tinyint(4) NOT NULL, 32 AllowVoice tinyint(4) NOT NULL,
33 `UseGlobalTime` tinyint(4) NOT NULL, 33 UseGlobalTime tinyint(4) NOT NULL,
34 `PricePerMeter` int(11) NOT NULL, 34 PricePerMeter int(11) NOT NULL,
35 `TaxFree` tinyint(4) NOT NULL, 35 TaxFree tinyint(4) NOT NULL,
36 `AllowDirectTeleport` tinyint(4) NOT NULL, 36 AllowDirectTeleport tinyint(4) NOT NULL,
37 `RedirectGridX` int(11) NOT NULL, 37 RedirectGridX int(11) NOT NULL,
38 `RedirectGridY` int(11) NOT NULL, 38 RedirectGridY int(11) NOT NULL,
39 `ParentEstateID` int(10) NOT NULL, 39 ParentEstateID int(10) NOT NULL,
40 `SunPosition` double NOT NULL, 40 SunPosition double NOT NULL,
41 `EstateSkipScripts` tinyint(4) NOT NULL, 41 EstateSkipScripts tinyint(4) NOT NULL,
42 `BillableFactor` float NOT NULL, 42 BillableFactor float NOT NULL,
43 `PublicAccess` tinyint(4) NOT NULL 43 PublicAccess tinyint(4) NOT NULL
44); 44);
45insert into `estate_settings` (`EstateID`,`EstateName`,`AbuseEmailToEstateOwner`,`DenyAnonymous`,`ResetHomeOnTeleport`,`FixedSun`,`DenyTransacted`,`BlockDwell`,`DenyIdentified`,`AllowVoice`,`UseGlobalTime`,`PricePerMeter`,`TaxFree`,`AllowDirectTeleport`,`RedirectGridX`,`RedirectGridY`,`ParentEstateID`,`SunPosition`,`PublicAccess`,`EstateSkipScripts`,`BillableFactor`) values ( 99, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); 45insert into estate_settings (EstateID,EstateName,AbuseEmailToEstateOwner,DenyAnonymous,ResetHomeOnTeleport,FixedSun,DenyTransacted,BlockDwell,DenyIdentified,AllowVoice,UseGlobalTime,PricePerMeter,TaxFree,AllowDirectTeleport,RedirectGridX,RedirectGridY,ParentEstateID,SunPosition,PublicAccess,EstateSkipScripts,BillableFactor) values ( 99, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
46delete from `estate_settings`; 46delete from estate_settings;
47CREATE TABLE `estate_users` ( 47CREATE TABLE estate_users (
48 `EstateID` int(10) NOT NULL, 48 EstateID int(10) NOT NULL,
49 `uuid` char(36) NOT NULL 49 uuid char(36) NOT NULL
50); 50);
51 51
52drop table if exists `estateban`; 52drop table if exists estateban;
53CREATE TABLE `estateban` ( 53CREATE TABLE estateban (
54 `EstateID` int(10) NOT NULL, 54 EstateID int(10) NOT NULL,
55 `bannedUUID` varchar(36) NOT NULL, 55 bannedUUID varchar(36) NOT NULL,
56 `bannedIp` varchar(16) NOT NULL, 56 bannedIp varchar(16) NOT NULL,
57 `bannedIpHostMask` varchar(16) NOT NULL, 57 bannedIpHostMask varchar(16) NOT NULL,
58 `bannedNameMask` varchar(64) default NULL 58 bannedNameMask varchar(64) default NULL
59); 59);
60 60
61drop table if exists `regionsettings`; 61drop table if exists regionsettings;
62CREATE TABLE `regionsettings` ( 62CREATE TABLE regionsettings (
63 `regionUUID` char(36) NOT NULL, 63 regionUUID char(36) NOT NULL,
64 `block_terraform` int(11) NOT NULL, 64 block_terraform int(11) NOT NULL,
65 `block_fly` int(11) NOT NULL, 65 block_fly int(11) NOT NULL,
66 `allow_damage` int(11) NOT NULL, 66 allow_damage int(11) NOT NULL,
67 `restrict_pushing` int(11) NOT NULL, 67 restrict_pushing int(11) NOT NULL,
68 `allow_land_resell` int(11) NOT NULL, 68 allow_land_resell int(11) NOT NULL,
69 `allow_land_join_divide` int(11) NOT NULL, 69 allow_land_join_divide int(11) NOT NULL,
70 `block_show_in_search` int(11) NOT NULL, 70 block_show_in_search int(11) NOT NULL,
71 `agent_limit` int(11) NOT NULL, 71 agent_limit int(11) NOT NULL,
72 `object_bonus` float NOT NULL, 72 object_bonus float NOT NULL,
73 `maturity` int(11) NOT NULL, 73 maturity int(11) NOT NULL,
74 `disable_scripts` int(11) NOT NULL, 74 disable_scripts int(11) NOT NULL,
75 `disable_collisions` int(11) NOT NULL, 75 disable_collisions int(11) NOT NULL,
76 `disable_physics` int(11) NOT NULL, 76 disable_physics int(11) NOT NULL,
77 `terrain_texture_1` char(36) NOT NULL, 77 terrain_texture_1 char(36) NOT NULL,
78 `terrain_texture_2` char(36) NOT NULL, 78 terrain_texture_2 char(36) NOT NULL,
79 `terrain_texture_3` char(36) NOT NULL, 79 terrain_texture_3 char(36) NOT NULL,
80 `terrain_texture_4` char(36) NOT NULL, 80 terrain_texture_4 char(36) NOT NULL,
81 `elevation_1_nw` float NOT NULL, 81 elevation_1_nw float NOT NULL,
82 `elevation_2_nw` float NOT NULL, 82 elevation_2_nw float NOT NULL,
83 `elevation_1_ne` float NOT NULL, 83 elevation_1_ne float NOT NULL,
84 `elevation_2_ne` float NOT NULL, 84 elevation_2_ne float NOT NULL,
85 `elevation_1_se` float NOT NULL, 85 elevation_1_se float NOT NULL,
86 `elevation_2_se` float NOT NULL, 86 elevation_2_se float NOT NULL,
87 `elevation_1_sw` float NOT NULL, 87 elevation_1_sw float NOT NULL,
88 `elevation_2_sw` float NOT NULL, 88 elevation_2_sw float NOT NULL,
89 `water_height` float NOT NULL, 89 water_height float NOT NULL,
90 `terrain_raise_limit` float NOT NULL, 90 terrain_raise_limit float NOT NULL,
91 `terrain_lower_limit` float NOT NULL, 91 terrain_lower_limit float NOT NULL,
92 `use_estate_sun` int(11) NOT NULL, 92 use_estate_sun int(11) NOT NULL,
93 `fixed_sun` int(11) NOT NULL, 93 fixed_sun int(11) NOT NULL,
94 `sun_position` float NOT NULL, 94 sun_position float NOT NULL,
95 `covenant` char(36) default NULL, 95 covenant char(36) default NULL,
96 `Sandbox` tinyint(4) NOT NULL, 96 Sandbox tinyint(4) NOT NULL,
97 PRIMARY KEY (`regionUUID`) 97 PRIMARY KEY (regionUUID)
98); 98);
99 99
100CREATE INDEX `estate_ban_estate_id` on `estateban`(`EstateID`); 100CREATE INDEX estate_ban_estate_id on estateban(EstateID);
101CREATE INDEX `estate_groups_estate_id` on `estate_groups`(`EstateID`); 101CREATE INDEX estate_groups_estate_id on estate_groups(EstateID);
102CREATE INDEX `estate_managers_estate_id` on `estate_managers`(`EstateID`); 102CREATE INDEX estate_managers_estate_id on estate_managers(EstateID);
103CREATE INDEX `estate_map_estate_id` on `estate_map`(`EstateID`); 103CREATE INDEX estate_map_estate_id on estate_map(EstateID);
104CREATE UNIQUE INDEX `estate_map_region_id` on `estate_map`(`RegionID`); 104CREATE UNIQUE INDEX estate_map_region_id on estate_map(RegionID);
105CREATE INDEX `estate_users_estate_id` on `estate_users`(`EstateID`); 105CREATE INDEX estate_users_estate_id on estate_users(EstateID);
106 106
107COMMIT; \ No newline at end of file 107COMMIT; \ No newline at end of file