diff options
author | David Walter Seikel | 2016-11-03 21:44:39 +1000 |
---|---|---|
committer | David Walter Seikel | 2016-11-03 21:44:39 +1000 |
commit | 134f86e8d5c414409631b25b8c6f0ee45fbd8631 (patch) | |
tree | 216b89d3fb89acfb81be1e440c25c41ab09fa96d /sql/ossearch-migrations.sql | |
parent | More changing to production grid. Double oops. (diff) | |
download | opensim-SC-134f86e8d5c414409631b25b8c6f0ee45fbd8631.zip opensim-SC-134f86e8d5c414409631b25b8c6f0ee45fbd8631.tar.gz opensim-SC-134f86e8d5c414409631b25b8c6f0ee45fbd8631.tar.bz2 opensim-SC-134f86e8d5c414409631b25b8c6f0ee45fbd8631.tar.xz |
Initial update to OpenSim 0.8.2.1 source code.
Diffstat (limited to '')
-rw-r--r-- | sql/ossearch-migrations.sql | 36 |
1 files changed, 0 insertions, 36 deletions
diff --git a/sql/ossearch-migrations.sql b/sql/ossearch-migrations.sql deleted file mode 100644 index 65b4cad..0000000 --- a/sql/ossearch-migrations.sql +++ /dev/null | |||
@@ -1,36 +0,0 @@ | |||
1 | #This file updates the tables used by OpenSimSearch to the latest schema. | ||
2 | #Use this file if you are updating an existing installation of the search | ||
3 | #module. If you are doing a first time install, use the ossearch.sql file. | ||
4 | |||
5 | #SVN revision 126 | ||
6 | BEGIN; | ||
7 | ALTER TABLE `parcelsales` CHANGE `mature` `mature` varchar(32) NOT NULL DEFAULT 'PG'; | ||
8 | COMMIT; | ||
9 | |||
10 | #SVN revision 142 | ||
11 | BEGIN; | ||
12 | ALTER TABLE `hostsregister` DROP `lastcheck`; | ||
13 | ALTER TABLE `hostsregister` ADD `nextcheck` int(10) NOT NULL AFTER `register`; | ||
14 | ALTER TABLE `hostsregister` ADD `checked` tinyint(1) NOT NULL AFTER `nextcheck`; | ||
15 | ALTER TABLE `hostsregister` CHANGE `failcounter` `failcounter` int(10) NOT NULL; | ||
16 | COMMIT; | ||
17 | |||
18 | #SVN revision 149 | ||
19 | BEGIN; | ||
20 | ALTER TABLE `events` DROP `mature`; | ||
21 | ALTER TABLE `events` CHANGE `eventflags` `eventflags` tinyint(1) NOT NULL; | ||
22 | ALTER TABLE `parcels` ADD `mature` VARCHAR( 10 ) NOT NULL; | ||
23 | ALTER TABLE `parcelsales` CHANGE `mature` `mature` VARCHAR( 10 ) NOT NULL DEFAULT 'PG'; | ||
24 | ALTER TABLE `popularplaces` CHANGE `has_picture` `has_picture` tinyint(1) NOT NULL; | ||
25 | COMMIT; | ||
26 | |||
27 | #SVN revision 153 | ||
28 | BEGIN; | ||
29 | ALTER TABLE `parcels` CHANGE `mature` `mature` VARCHAR( 10 ) NOT NULL DEFAULT 'PG'; | ||
30 | COMMIT; | ||
31 | |||
32 | #SVN revision 154 | ||
33 | BEGIN; | ||
34 | ALTER TABLE `events` CHANGE `dateUTC` `dateUTC` int(10) NOT NULL; | ||
35 | ALTER TABLE `events` CHANGE `covercharge` `covercharge` tinyint(1) NOT NULL; | ||
36 | COMMIT; | ||