diff options
Diffstat (limited to 'OpenSim/Data/MySQL/Resources/001_RegionStore.sql')
-rw-r--r-- | OpenSim/Data/MySQL/Resources/001_RegionStore.sql | 16 |
1 files changed, 10 insertions, 6 deletions
diff --git a/OpenSim/Data/MySQL/Resources/001_RegionStore.sql b/OpenSim/Data/MySQL/Resources/001_RegionStore.sql index 6604c3b..31164b3 100644 --- a/OpenSim/Data/MySQL/Resources/001_RegionStore.sql +++ b/OpenSim/Data/MySQL/Resources/001_RegionStore.sql | |||
@@ -1,3 +1,5 @@ | |||
1 | BEGIN; | ||
2 | |||
1 | CREATE TABLE `prims` ( | 3 | CREATE TABLE `prims` ( |
2 | `UUID` varchar(255) NOT NULL, | 4 | `UUID` varchar(255) NOT NULL, |
3 | `RegionUUID` varchar(255) default NULL, | 5 | `RegionUUID` varchar(255) default NULL, |
@@ -46,7 +48,7 @@ CREATE TABLE `prims` ( | |||
46 | `SitTargetOrientY` float default NULL, | 48 | `SitTargetOrientY` float default NULL, |
47 | `SitTargetOrientZ` float default NULL, | 49 | `SitTargetOrientZ` float default NULL, |
48 | PRIMARY KEY (`UUID`) | 50 | PRIMARY KEY (`UUID`) |
49 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | 51 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
50 | 52 | ||
51 | CREATE TABLE `primshapes` ( | 53 | CREATE TABLE `primshapes` ( |
52 | `UUID` varchar(255) NOT NULL, | 54 | `UUID` varchar(255) NOT NULL, |
@@ -77,7 +79,7 @@ CREATE TABLE `primshapes` ( | |||
77 | `Texture` longblob, | 79 | `Texture` longblob, |
78 | `ExtraParams` longblob, | 80 | `ExtraParams` longblob, |
79 | PRIMARY KEY (`UUID`) | 81 | PRIMARY KEY (`UUID`) |
80 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | 82 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
81 | 83 | ||
82 | CREATE TABLE `primitems` ( | 84 | CREATE TABLE `primitems` ( |
83 | `itemID` varchar(255) NOT NULL, | 85 | `itemID` varchar(255) NOT NULL, |
@@ -99,13 +101,13 @@ CREATE TABLE `primitems` ( | |||
99 | `everyonePermissions` int(11) default NULL, | 101 | `everyonePermissions` int(11) default NULL, |
100 | `groupPermissions` int(11) default NULL, | 102 | `groupPermissions` int(11) default NULL, |
101 | PRIMARY KEY (`itemID`) | 103 | PRIMARY KEY (`itemID`) |
102 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | 104 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
103 | 105 | ||
104 | CREATE TABLE `terrain` ( | 106 | CREATE TABLE `terrain` ( |
105 | `RegionUUID` varchar(255) default NULL, | 107 | `RegionUUID` varchar(255) default NULL, |
106 | `Revision` int(11) default NULL, | 108 | `Revision` int(11) default NULL, |
107 | `Heightfield` longblob | 109 | `Heightfield` longblob |
108 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | 110 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
109 | 111 | ||
110 | CREATE TABLE `land` ( | 112 | CREATE TABLE `land` ( |
111 | `UUID` varchar(255) NOT NULL, | 113 | `UUID` varchar(255) NOT NULL, |
@@ -141,10 +143,12 @@ CREATE TABLE `land` ( | |||
141 | `UserLookAtZ` float default NULL, | 143 | `UserLookAtZ` float default NULL, |
142 | `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', | 144 | `AuthbuyerID` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000', |
143 | PRIMARY KEY (`UUID`) | 145 | PRIMARY KEY (`UUID`) |
144 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Rev. 2' | 146 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
145 | 147 | ||
146 | CREATE TABLE `landaccesslist` ( | 148 | CREATE TABLE `landaccesslist` ( |
147 | `LandUUID` varchar(255) default NULL, | 149 | `LandUUID` varchar(255) default NULL, |
148 | `AccessUUID` varchar(255) default NULL, | 150 | `AccessUUID` varchar(255) default NULL, |
149 | `Flags` int(11) default NULL | 151 | `Flags` int(11) default NULL |
150 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1 \ No newline at end of file | 152 | ) ENGINE=MyISAM DEFAULT CHARSET=latin1; |
153 | |||
154 | COMMIT; \ No newline at end of file | ||