diff options
author | Sean Dague | 2008-07-18 15:19:52 +0000 |
---|---|---|
committer | Sean Dague | 2008-07-18 15:19:52 +0000 |
commit | df1485fc51e9fb0e090b36e0aace60eb24c7c4a2 (patch) | |
tree | 872cd70a46181e0d4c9d16bacd6c53f6658a47a5 | |
parent | put the entire thing inside a transaction. This probably doesn't (diff) | |
download | opensim-SC-df1485fc51e9fb0e090b36e0aace60eb24c7c4a2.zip opensim-SC-df1485fc51e9fb0e090b36e0aace60eb24c7c4a2.tar.gz opensim-SC-df1485fc51e9fb0e090b36e0aace60eb24c7c4a2.tar.bz2 opensim-SC-df1485fc51e9fb0e090b36e0aace60eb24c7c4a2.tar.xz |
remove all the odd quoting, on the off chance this was causing some
of the issue.
Diffstat (limited to '')
-rw-r--r-- | OpenSim/Data/SQLite/Resources/006_RegionStore.sql | 180 |
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 @@ | |||
1 | BEGIN TRANSACTION; | 1 | BEGIN TRANSACTION; |
2 | 2 | ||
3 | drop table if exists `estate_groups`; | 3 | drop table if exists estate_groups; |
4 | CREATE TABLE `estate_groups` ( | 4 | CREATE 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 | ||
9 | drop table if exists `estate_managers`; | 9 | drop table if exists estate_managers; |
10 | CREATE TABLE `estate_managers` ( | 10 | CREATE 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 | ||
15 | drop table if exists `estate_map`; | 15 | drop table if exists estate_map; |
16 | CREATE TABLE `estate_map` ( | 16 | CREATE 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 | ||
21 | drop table if exists `estate_settings`; | 21 | drop table if exists estate_settings; |
22 | CREATE TABLE `estate_settings` ( | 22 | CREATE 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 | ); |
45 | insert 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, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); | 45 | insert 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, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''); |
46 | delete from `estate_settings`; | 46 | delete from estate_settings; |
47 | CREATE TABLE `estate_users` ( | 47 | CREATE 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 | ||
52 | drop table if exists `estateban`; | 52 | drop table if exists estateban; |
53 | CREATE TABLE `estateban` ( | 53 | CREATE 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 | ||
61 | drop table if exists `regionsettings`; | 61 | drop table if exists regionsettings; |
62 | CREATE TABLE `regionsettings` ( | 62 | CREATE 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 | ||
100 | CREATE INDEX `estate_ban_estate_id` on `estateban`(`EstateID`); | 100 | CREATE INDEX estate_ban_estate_id on estateban(EstateID); |
101 | CREATE INDEX `estate_groups_estate_id` on `estate_groups`(`EstateID`); | 101 | CREATE INDEX estate_groups_estate_id on estate_groups(EstateID); |
102 | CREATE INDEX `estate_managers_estate_id` on `estate_managers`(`EstateID`); | 102 | CREATE INDEX estate_managers_estate_id on estate_managers(EstateID); |
103 | CREATE INDEX `estate_map_estate_id` on `estate_map`(`EstateID`); | 103 | CREATE INDEX estate_map_estate_id on estate_map(EstateID); |
104 | CREATE UNIQUE INDEX `estate_map_region_id` on `estate_map`(`RegionID`); | 104 | CREATE UNIQUE INDEX estate_map_region_id on estate_map(RegionID); |
105 | CREATE INDEX `estate_users_estate_id` on `estate_users`(`EstateID`); | 105 | CREATE INDEX estate_users_estate_id on estate_users(EstateID); |
106 | 106 | ||
107 | COMMIT; \ No newline at end of file | 107 | COMMIT; \ No newline at end of file |