aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/sql/ossearch-migrations.sql
diff options
context:
space:
mode:
authorDavid Walter Seikel2016-11-03 21:44:39 +1000
committerDavid Walter Seikel2016-11-03 21:44:39 +1000
commit134f86e8d5c414409631b25b8c6f0ee45fbd8631 (patch)
tree216b89d3fb89acfb81be1e440c25c41ab09fa96d /sql/ossearch-migrations.sql
parentMore changing to production grid. Double oops. (diff)
downloadopensim-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.sql36
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
6BEGIN;
7ALTER TABLE `parcelsales` CHANGE `mature` `mature` varchar(32) NOT NULL DEFAULT 'PG';
8COMMIT;
9
10#SVN revision 142
11BEGIN;
12ALTER TABLE `hostsregister` DROP `lastcheck`;
13ALTER TABLE `hostsregister` ADD `nextcheck` int(10) NOT NULL AFTER `register`;
14ALTER TABLE `hostsregister` ADD `checked` tinyint(1) NOT NULL AFTER `nextcheck`;
15ALTER TABLE `hostsregister` CHANGE `failcounter` `failcounter` int(10) NOT NULL;
16COMMIT;
17
18#SVN revision 149
19BEGIN;
20ALTER TABLE `events` DROP `mature`;
21ALTER TABLE `events` CHANGE `eventflags` `eventflags` tinyint(1) NOT NULL;
22ALTER TABLE `parcels` ADD `mature` VARCHAR( 10 ) NOT NULL;
23ALTER TABLE `parcelsales` CHANGE `mature` `mature` VARCHAR( 10 ) NOT NULL DEFAULT 'PG';
24ALTER TABLE `popularplaces` CHANGE `has_picture` `has_picture` tinyint(1) NOT NULL;
25COMMIT;
26
27#SVN revision 153
28BEGIN;
29ALTER TABLE `parcels` CHANGE `mature` `mature` VARCHAR( 10 ) NOT NULL DEFAULT 'PG';
30COMMIT;
31
32#SVN revision 154
33BEGIN;
34ALTER TABLE `events` CHANGE `dateUTC` `dateUTC` int(10) NOT NULL;
35ALTER TABLE `events` CHANGE `covercharge` `covercharge` tinyint(1) NOT NULL;
36COMMIT;