Revision: 1724
http://mrbs.svn.sourceforge.net/mrbs/?rev=1724&view=rev
Author: cimorrison
Date: 2010-12-21 12:04:46 +0000 (Tue, 21 Dec 2010)
Log Message:
-----------
Tidied up allocation of sequence numbers to existing bookings
Modified Paths:
--------------
mrbs/branches/ics_attachments/tables.my.sql
mrbs/branches/ics_attachments/tables.pg.pre73.sql
mrbs/branches/ics_attachments/tables.pg.sql
mrbs/branches/ics_attachments/web/dbsys.inc
Added Paths:
-----------
mrbs/branches/ics_attachments/web/upgrade/25/
mrbs/branches/ics_attachments/web/upgrade/25/mysql.sql
mrbs/branches/ics_attachments/web/upgrade/25/pgsql.sql
Modified: mrbs/branches/ics_attachments/tables.my.sql
===================================================================
--- mrbs/branches/ics_attachments/tables.my.sql 2010-12-21 12:03:38 UTC (rev
1723)
+++ mrbs/branches/ics_attachments/tables.my.sql 2010-12-21 12:04:46 UTC (rev
1724)
@@ -138,6 +138,6 @@
);
INSERT INTO mrbs_variables (variable_name, variable_content)
- VALUES ( 'db_version', '24');
+ VALUES ( 'db_version', '25');
INSERT INTO mrbs_variables (variable_name, variable_content)
VALUES ( 'local_db_version', '1');
Modified: mrbs/branches/ics_attachments/tables.pg.pre73.sql
===================================================================
--- mrbs/branches/ics_attachments/tables.pg.pre73.sql 2010-12-21 12:03:38 UTC
(rev 1723)
+++ mrbs/branches/ics_attachments/tables.pg.pre73.sql 2010-12-21 12:04:46 UTC
(rev 1724)
@@ -129,6 +129,6 @@
);
INSERT INTO mrbs_variables (variable_name, variable_content)
- VALUES ('db_version', '24');
+ VALUES ('db_version', '25');
INSERT INTO mrbs_variables (variable_name, variable_content)
VALUES ('local_db_version', '1');
Modified: mrbs/branches/ics_attachments/tables.pg.sql
===================================================================
--- mrbs/branches/ics_attachments/tables.pg.sql 2010-12-21 12:03:38 UTC (rev
1723)
+++ mrbs/branches/ics_attachments/tables.pg.sql 2010-12-21 12:04:46 UTC (rev
1724)
@@ -142,6 +142,6 @@
);
INSERT INTO mrbs_variables (variable_name, variable_content)
- VALUES ('db_version', '24');
+ VALUES ('db_version', '25');
INSERT INTO mrbs_variables (variable_name, variable_content)
VALUES ('local_db_version', '1');
Modified: mrbs/branches/ics_attachments/web/dbsys.inc
===================================================================
--- mrbs/branches/ics_attachments/web/dbsys.inc 2010-12-21 12:03:38 UTC (rev
1723)
+++ mrbs/branches/ics_attachments/web/dbsys.inc 2010-12-21 12:04:46 UTC (rev
1724)
@@ -15,7 +15,7 @@
$tbl_variables = $db_tbl_prefix . "variables";
-$db_schema_version = 24;
+$db_schema_version = 25;
$local_db_schema_version = 1;
Added: mrbs/branches/ics_attachments/web/upgrade/25/mysql.sql
===================================================================
--- mrbs/branches/ics_attachments/web/upgrade/25/mysql.sql
(rev 0)
+++ mrbs/branches/ics_attachments/web/upgrade/25/mysql.sql 2010-12-21
12:04:46 UTC (rev 1724)
@@ -0,0 +1,8 @@
+# $Id$
+
+# Fixes a mistake in the previous upgrade. If we've got an individual member
of a
+# series that has been modified, ie has entry_type=2, then the sequence number
+# cannot be 0. We will set it to 1.
+
+UPDATE %DB_TBL_PREFIX%entry
+SET ical_sequence=1 WHERE ical_sequence=0 AND entry_type=2;
Property changes on: mrbs/branches/ics_attachments/web/upgrade/25/mysql.sql
___________________________________________________________________
Added: svn:keywords
+ Id
Added: svn:eol-style
+ native
Added: mrbs/branches/ics_attachments/web/upgrade/25/pgsql.sql
===================================================================
--- mrbs/branches/ics_attachments/web/upgrade/25/pgsql.sql
(rev 0)
+++ mrbs/branches/ics_attachments/web/upgrade/25/pgsql.sql 2010-12-21
12:04:46 UTC (rev 1724)
@@ -0,0 +1,8 @@
+-- $Id$
+
+-- Fixes a mistake in the previous upgrade. If we've got an individual member
of a
+-- series that has been modified, ie has entry_type=2, then the sequence
number
+-- cannot be 0. We will set it to 1.
+
+UPDATE %DB_TBL_PREFIX%entry
+SET ical_sequence=1 WHERE ical_sequence=0 AND entry_type=2;
Property changes on: mrbs/branches/ics_attachments/web/upgrade/25/pgsql.sql
___________________________________________________________________
Added: svn:keywords
+ Id
Added: svn:eol-style
+ native
This was sent by the SourceForge.net collaborative development platform, the
world's largest Open Source development site.
------------------------------------------------------------------------------
Lotusphere 2011
Register now for Lotusphere 2011 and learn how
to connect the dots, take your collaborative environment
to the next level, and enter the era of Social Business.
http://p.sf.net/sfu/lotusphere-d2d
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
