diff options
author | Sean Dague | 2008-06-12 18:44:58 +0000 |
---|---|---|
committer | Sean Dague | 2008-06-12 18:44:58 +0000 |
commit | 202a4bec13a37d8a2f702f879a5e2b0d2e74085a (patch) | |
tree | f19f849a6d5f742e15100103defbf6b73d50559b /OpenSim/Data/MySQL/Resources/001_RegionStore.sql | |
parent | * minor: Remove and tidy duplicate 'storing object to scene' messages in log (diff) | |
download | opensim-SC_OLD-202a4bec13a37d8a2f702f879a5e2b0d2e74085a.zip opensim-SC_OLD-202a4bec13a37d8a2f702f879a5e2b0d2e74085a.tar.gz opensim-SC_OLD-202a4bec13a37d8a2f702f879a5e2b0d2e74085a.tar.bz2 opensim-SC_OLD-202a4bec13a37d8a2f702f879a5e2b0d2e74085a.tar.xz |
Fix mysql migrations. This is tested with an existing up to date schema,
and no schema. It should also work with a non up to date schema as well.
Btw, meetings in which I can get code done are the right kind of meetings.
Diffstat (limited to '')
-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 | ||