Revision: 1461
http://mrbs.svn.sourceforge.net/mrbs/?rev=1461&view=rev
Author: cimorrison
Date: 2010-09-20 14:13:17 +0000 (Mon, 20 Sep 2010)
Log Message:
-----------
Added information on inserting new periods in an existing system.
Modified Paths:
--------------
mrbs/trunk/INSTALL
mrbs/trunk/web/systemdefaults.inc.php
Modified: mrbs/trunk/INSTALL
===================================================================
--- mrbs/trunk/INSTALL 2010-09-20 13:10:11 UTC (rev 1460)
+++ mrbs/trunk/INSTALL 2010-09-20 14:13:17 UTC (rev 1461)
@@ -332,7 +332,29 @@
web directory. We recommend you backup your database before running
this script if you are at all worried.
+
+PERIODS
+---------------------------------------------------------------------------
+When using periods, MRBS stores bookings internally as one minute slots
+starting at 1200. If once you have had your system up and running for
+a while find that you need to add a new period then you will need to
+adjust the times of your existing bookings unless your new period is at
+the end of the day.
+The simplest example is when you want to add a new period at the start of
+the day. In this case you will need to run some SQL using phpMyAdmin or
+a similar program to move all bookings one minute later. In this example
+the SQL required would be
+
+UPDATE mrbs_entry SET start_time=start_time+60, end_time=end_time+60;
+UPDATE mrbs_repeat SET start_time=start_time+60, end_time=end_time+60,
+end_date=end_date+60;
+
+having changed "mrbs_" to your table prefix if necessary.
+
+Before running this SQL you should of course backup your database.
+
+
SECURITY NOTES!
---------------------------------------------------------------------------
You can configure your web server so that users can not obtain the ".inc"
Modified: mrbs/trunk/web/systemdefaults.inc.php
===================================================================
--- mrbs/trunk/web/systemdefaults.inc.php 2010-09-20 13:10:11 UTC (rev
1460)
+++ mrbs/trunk/web/systemdefaults.inc.php 2010-09-20 14:13:17 UTC (rev
1461)
@@ -217,7 +217,10 @@
$periods[] = "Period 2";
// NOTE: The maximum number of periods is 60. Do not define more than this.
+// NOTE: See INSTALL for information on how to add or remove periods in an
+// existing database.
+
/******************
* Booking policies
******************/
This was sent by the SourceForge.net collaborative development platform, the
world's largest Open Source development site.
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits
