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 @@
 BEGIN TRANSACTION;
-drop table if exists `estate_groups`;
+drop table if exists estate_groups;
-CREATE TABLE `estate_groups` (
+CREATE TABLE estate_groups (
-  `EstateID` int(10) NOT NULL,
+  EstateID int(10) NOT NULL,
-  `uuid` char(36) NOT NULL
+  uuid char(36) NOT NULL
 );
-drop table if exists `estate_managers`;
+drop table if exists estate_managers;
-CREATE TABLE `estate_managers` (
+CREATE TABLE estate_managers (
-  `EstateID` int(10) NOT NULL,
+  EstateID int(10) NOT NULL,
-  `uuid` char(36) NOT NULL
+  uuid char(36) NOT NULL
 );
-drop table if exists `estate_map`;
+drop table if exists estate_map;
-CREATE TABLE `estate_map` (
+CREATE TABLE estate_map (
-  `RegionID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
+  RegionID char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
-  `EstateID` int(11) NOT NULL
+  EstateID int(11) NOT NULL
 );
-drop table if exists `estate_settings`;
+drop table if exists estate_settings;
-CREATE TABLE `estate_settings` (
+CREATE TABLE estate_settings (
-  `EstateID` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+  EstateID INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-  `EstateName` varchar(64) default NULL,
+  EstateName varchar(64) default NULL,
-  `AbuseEmailToEstateOwner` tinyint(4) NOT NULL,
+  AbuseEmailToEstateOwner tinyint(4) NOT NULL,
-  `DenyAnonymous` tinyint(4) NOT NULL,
+  DenyAnonymous tinyint(4) NOT NULL,
-  `ResetHomeOnTeleport` tinyint(4) NOT NULL,
+  ResetHomeOnTeleport tinyint(4) NOT NULL,
-  `FixedSun` tinyint(4) NOT NULL,
+  FixedSun tinyint(4) NOT NULL,
-  `DenyTransacted` tinyint(4) NOT NULL,
+  DenyTransacted tinyint(4) NOT NULL,
-  `BlockDwell` tinyint(4) NOT NULL,
+  BlockDwell tinyint(4) NOT NULL,
-  `DenyIdentified` tinyint(4) NOT NULL,
+  DenyIdentified tinyint(4) NOT NULL,
-  `AllowVoice` tinyint(4) NOT NULL,
+  AllowVoice tinyint(4) NOT NULL,
-  `UseGlobalTime` tinyint(4) NOT NULL,
+  UseGlobalTime tinyint(4) NOT NULL,
-  `PricePerMeter` int(11) NOT NULL,
+  PricePerMeter int(11) NOT NULL,
-  `TaxFree` tinyint(4) NOT NULL,
+  TaxFree tinyint(4) NOT NULL,
-  `AllowDirectTeleport` tinyint(4) NOT NULL,
+  AllowDirectTeleport tinyint(4) NOT NULL,
-  `RedirectGridX` int(11) NOT NULL,
+  RedirectGridX int(11) NOT NULL,
-  `RedirectGridY` int(11) NOT NULL,
+  RedirectGridY int(11) NOT NULL,
-  `ParentEstateID` int(10) NOT NULL,
+  ParentEstateID int(10) NOT NULL,
-  `SunPosition` double NOT NULL,
+  SunPosition double NOT NULL,
-  `EstateSkipScripts` tinyint(4) NOT NULL,
+  EstateSkipScripts tinyint(4) NOT NULL,
-  `BillableFactor` float NOT NULL,
+  BillableFactor float NOT NULL,
-  `PublicAccess` tinyint(4) NOT NULL
+  PublicAccess tinyint(4) NOT NULL
 );
-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, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
+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, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
-delete from `estate_settings`;
+delete from estate_settings;
-CREATE TABLE `estate_users` (
+CREATE TABLE estate_users (
-  `EstateID` int(10) NOT NULL,
+  EstateID int(10) NOT NULL,
-  `uuid` char(36) NOT NULL
+  uuid char(36) NOT NULL
 );
-drop table if exists `estateban`;
+drop table if exists estateban;
-CREATE TABLE `estateban` (
+CREATE TABLE estateban (
-  `EstateID` int(10) NOT NULL,
+  EstateID int(10) NOT NULL,
-  `bannedUUID` varchar(36) NOT NULL,
+  bannedUUID varchar(36) NOT NULL,
-  `bannedIp` varchar(16) NOT NULL,
+  bannedIp varchar(16) NOT NULL,
-  `bannedIpHostMask` varchar(16) NOT NULL,
+  bannedIpHostMask varchar(16) NOT NULL,
-  `bannedNameMask` varchar(64) default NULL
+  bannedNameMask varchar(64) default NULL
 );
-drop table if exists `regionsettings`;
+drop table if exists regionsettings;
-CREATE TABLE `regionsettings` (
+CREATE TABLE regionsettings (
-  `regionUUID` char(36) NOT NULL,
+  regionUUID char(36) NOT NULL,
-  `block_terraform` int(11) NOT NULL,
+  block_terraform int(11) NOT NULL,
-  `block_fly` int(11) NOT NULL,
+  block_fly int(11) NOT NULL,
-  `allow_damage` int(11) NOT NULL,
+  allow_damage int(11) NOT NULL,
-  `restrict_pushing` int(11) NOT NULL,
+  restrict_pushing int(11) NOT NULL,
-  `allow_land_resell` int(11) NOT NULL,
+  allow_land_resell int(11) NOT NULL,
-  `allow_land_join_divide` int(11) NOT NULL,
+  allow_land_join_divide int(11) NOT NULL,
-  `block_show_in_search` int(11) NOT NULL,
+  block_show_in_search int(11) NOT NULL,
-  `agent_limit` int(11) NOT NULL,
+  agent_limit int(11) NOT NULL,
-  `object_bonus` float NOT NULL,
+  object_bonus float NOT NULL,
-  `maturity` int(11) NOT NULL,
+  maturity int(11) NOT NULL,
-  `disable_scripts` int(11) NOT NULL,
+  disable_scripts int(11) NOT NULL,
-  `disable_collisions` int(11) NOT NULL,
+  disable_collisions int(11) NOT NULL,
-  `disable_physics` int(11) NOT NULL,
+  disable_physics int(11) NOT NULL,
-  `terrain_texture_1` char(36) NOT NULL,
+  terrain_texture_1 char(36) NOT NULL,
-  `terrain_texture_2` char(36) NOT NULL,
+  terrain_texture_2 char(36) NOT NULL,
-  `terrain_texture_3` char(36) NOT NULL,
+  terrain_texture_3 char(36) NOT NULL,
-  `terrain_texture_4` char(36) NOT NULL,
+  terrain_texture_4 char(36) NOT NULL,
-  `elevation_1_nw` float NOT NULL,
+  elevation_1_nw float NOT NULL,
-  `elevation_2_nw` float NOT NULL,
+  elevation_2_nw float NOT NULL,
-  `elevation_1_ne` float NOT NULL,
+  elevation_1_ne float NOT NULL,
-  `elevation_2_ne` float NOT NULL,
+  elevation_2_ne float NOT NULL,
-  `elevation_1_se` float NOT NULL,
+  elevation_1_se float NOT NULL,
-  `elevation_2_se` float NOT NULL,
+  elevation_2_se float NOT NULL,
-  `elevation_1_sw` float NOT NULL,
+  elevation_1_sw float NOT NULL,
-  `elevation_2_sw` float NOT NULL,
+  elevation_2_sw float NOT NULL,
-  `water_height` float NOT NULL,
+  water_height float NOT NULL,
-  `terrain_raise_limit` float NOT NULL,
+  terrain_raise_limit float NOT NULL,
-  `terrain_lower_limit` float NOT NULL,
+  terrain_lower_limit float NOT NULL,
-  `use_estate_sun` int(11) NOT NULL,
+  use_estate_sun int(11) NOT NULL,
-  `fixed_sun` int(11) NOT NULL,
+  fixed_sun int(11) NOT NULL,
-  `sun_position` float NOT NULL,
+  sun_position float NOT NULL,
-  `covenant` char(36) default NULL,
+  covenant char(36) default NULL,
-  `Sandbox` tinyint(4) NOT NULL,
+  Sandbox tinyint(4) NOT NULL,
-  PRIMARY KEY  (`regionUUID`)
+  PRIMARY KEY  (regionUUID)
 );
-CREATE INDEX `estate_ban_estate_id` on `estateban`(`EstateID`);
+CREATE INDEX estate_ban_estate_id on estateban(EstateID);
-CREATE INDEX `estate_groups_estate_id` on `estate_groups`(`EstateID`);
+CREATE INDEX estate_groups_estate_id on estate_groups(EstateID);
-CREATE INDEX `estate_managers_estate_id` on `estate_managers`(`EstateID`);
+CREATE INDEX estate_managers_estate_id on estate_managers(EstateID);
-CREATE INDEX `estate_map_estate_id` on `estate_map`(`EstateID`);
+CREATE INDEX estate_map_estate_id on estate_map(EstateID);
-CREATE UNIQUE INDEX `estate_map_region_id` on `estate_map`(`RegionID`);
+CREATE UNIQUE INDEX estate_map_region_id on estate_map(RegionID);
-CREATE INDEX `estate_users_estate_id` on `estate_users`(`EstateID`);
+CREATE INDEX estate_users_estate_id on estate_users(EstateID);
 COMMIT;
 \ No newline at end of file

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