Version History


Version Description Date Applied Success
2.20200 Added support for deleting Custom Roads. Updated the User Manual 14/02/2020 3:42:30 PM Y
2.20190 Added support for adding Road Name into the Database. visible when adding a closure - next to the road names 14/02/2020 3:42:30 PM Y
2.20180 Replace deprecated Google Address Lookup with the new Google Address Lookup. 22/11/2018 11:24:17 AM Y
2.10880 Added a 0 option for :Hours to display Reopened Events after reopening: in System Parameters. 16/11/2017 12:32:35 PM Y
2.10870 Corrected the issue where new closures did not correctely display if signs were deployed. 16/11/2017 12:32:35 PM Y
2.10860 Added provision for Suburbs with apostrophe. 29/03/2017 3:32:51 PM Y
2.10850 Fixed the history logging on updates to closures. 2/03/2017 4:45:59 PM Y
2.10840 Corrected the Signs Erected Flag. 2/03/2017 4:45:59 PM Y
2.10830 Updated location Lookup to handle http hosts. 2/03/2017 4:45:59 PM Y
2.10820 Updated the mapping layers to remore Mapquest. 2/03/2017 4:45:59 PM Y
2.10810 Added in some checking for [reportbale_tmr] flag. 2/03/2017 4:45:59 PM Y
2.10800 Cleaned up the add - edit closure page a little - removed a script error and hopefully improved the map drawing. 2/03/2017 4:45:58 PM Y
2.10790 Modified reopen all roads in training for new Test System Identifier. 23/02/2016 5:13:54 PM Y
2.10780 Added Button in Settings to Set as Training System. 23/02/2016 5:13:54 PM Y
2.10770 Corrected labelling on input boxes when changing your own password. 23/02/2016 5:13:46 PM Y
2.10760 Added a detector in for IE to revert back to the Popup for Road Geolocation - its more compatible with IE. 19/02/2015 8:40:02 AM Y
2.10750 I have noticed that some sites are not altering the advice to motorists when reopening a road. If the Set Road as Open Button is clicked - it will now also set the Advice to Motorists drop box to null and mark as red, to remind you to set the appropriate advice for the new condition. 19/02/2015 8:40:02 AM Y
2.10740 Added Report - Known Trouble Spots. 19/02/2015 8:40:02 AM Y
2.10730 Parameters field - makeRoadClosureFiles_showReopenedHrs added - Default 24 hrs. 11/12/2014 12:07:17 AM Y
2.10720 Corrected a bug in Editing Closure. 11/12/2014 12:07:17 AM Y
2.10710 Parameters field - makeRoadClosureFiles_showNext Update - Modified Text and Description. 11/12/2014 12:07:17 AM Y
2.10700 Parameters field - makeRoadClosureFiles_showLastUpdated - Modified Text and Description. 11/12/2014 12:07:17 AM Y
2.10690 Parameters field - makeRoadClosureFiles_showNotes added - Default True. 11/12/2014 12:07:17 AM Y
2.10680 Parameters field - makeRoadClosureFiles_showAdditionalLocation added - Default False - Requested By Gympie. 11/12/2014 12:07:17 AM Y
2.10670 Parameters field - makeRoadClosureFiles_showAdvice added - Default True - Requested By Gympie. 11/12/2014 12:07:17 AM Y
2.10660 In New Closure Screen - stopped Magnify Icon from wrapping. 30/10/2014 8:56:26 AM Y
2.10650 Geo Location lookup has now been replaced with a friedlier overlay instead of the popup window. Better for tablets. 30/10/2014 8:56:26 AM Y
2.10640 Corrected DataSharing Status Function For Central Collection. 29/10/2014 4:42:36 PM Y
2.10630 Enhanced the mobile management to avoid conflicts - stops re-enabling until disable has been completed. 29/10/2014 4:42:36 PM Y
2.10620 Corrected a bug - when adding new closures, next update time not entered, introduced with scheduling component. 29/10/2014 4:42:36 PM Y
2.10610 Looking at the verions will now tell you if there is a new version update available. From the Menu Help >> Version History 7/07/2014 1:16:08 PM Y
2.10600 The Mobile integration code will now create the web files with scheduled events displayed. 7/07/2014 1:16:08 PM Y
2.10590 YOU CAN NOW SCHEDULE CLOSURES. Schedule Start for Roadworks. Schedule Start and End for Special Events. Requires Minimum version 20140630 of Mobile Integration Code. You can check that under --> Help --> Mobile Integration Tasks 7/07/2014 1:16:08 PM Y
2.10580 Menu hidden when printing. If you print any of the pages, the Menu will not print out in that big list at the top of the page.. 7/07/2014 1:16:08 PM Y
2.10570 Maps and input screens should now auto fit your window size. 7/07/2014 1:16:08 PM Y
2.10560 A new item in the Map menu has been added, Scheduled Events - To show events that are scheduled in the future. 7/07/2014 1:16:08 PM Y
2.10550 Mapped Events Summary now has a Scheduled Events counter displayed. These are events in the future, and will not be displayed on the default Currently Impacted Roads Map. 7/07/2014 1:16:08 PM Y
2.10540 Updated [RC_Closures_v] to include new fields for scheduling closure end dates. 7/07/2014 1:16:08 PM Y
2.10530 New Field added to the [RC_Security_tbl] - Records last Version user was logged on with. Used for displaying update information to users when they log on. 7/07/2014 1:16:08 PM Y
2.10520 New Scheduling Fields added to the [RC_Closures_tbl] - ready for scheduling of Special Events and Planned Roadworks. 7/07/2014 1:16:08 PM Y
2.10510 Maps are now aware of your window height and will attempt to fit themselves in it. No more false click on a pin where it adjusts itself the first time. 5/06/2014 1:21:10 AM Y
2.10500 Added new report : Signs Currently Deployed - Associated Logger : Thanks Michelle K. 5/06/2014 1:21:10 AM Y
2.10490 Added Geo Search to existing Closures when editing. Even though the road name is locked, you can still search it's position. 5/06/2014 1:21:10 AM Y
2.10480 Deleteing Closures while they are in the staging Area will also now delete the orphaned [Image] and [Signs Deployed] Records. All current orphaned records are now deleted. 5/06/2014 1:21:10 AM Y
2.10470 Closure condition now has status grouping in the drop down. 3/06/2014 1:57:27 PM Y
2.10460 Update the Set Road As Open Button to be jquery dialog. 3/06/2014 1:57:27 PM Y
2.10450 Updated Trigger [T_RC_Closures_insert] to handle new Conditions and Reasons - non-reportable to tmr. 3/06/2014 1:57:27 PM Y
2.10440 Added new closure types - Incident | Roadworks | Special Event. 3/06/2014 1:57:27 PM Y
2.10430 Updated the Help Page to include more information on the file generation. 29/05/2014 10:02:10 PM Y
2.10420 Corrected a Javascript Issue which failed in IE (only). 9/05/2014 11:39:27 AM Y
2.10410 Added [editDateUTC] to [RC_KnownTroubleSpots_tbl], ready for new KTS List on Mobile. 9/05/2014 11:39:27 AM Y
2.10400 On the main map screen, the roads are all listed alphabetically by Road Name and Suburb. 9/05/2014 11:39:27 AM Y
2.10390 On the main page, the road closure list is in a new tabbed element. The second tab has a simple table with the closures in it, this table is sortable by clicking on the Column Header. 9/05/2014 11:39:27 AM Y
2.10380 Once a closure has been saved against a road, the road cannot be changed. This is a data continuity safeguard. If a change is needed, clone the closure and change the name there. Then reopen the original closure. 9/05/2014 11:39:27 AM Y
2.10370 Report Added - Current Closures. 9/05/2014 11:39:27 AM Y
2.10360 Enhanced the configuration uploader. 7/04/2014 11:29:43 PM Y
2.10350 NOW LIVE Stamp in the Banner when data is being Shared with 131940. 7/04/2014 11:29:43 PM Y
2.10340 Adding a task to the [taptojob] table for pushing Shared road closured to TMR. 27/03/2014 6:43:07 PM Y
2.10330 For TEST Systems Only - Under the Admin Menu [You must be an Admin] - There is now a feature to reopen all roads - created to clear map screen for training scenarios. 27/03/2014 6:43:07 PM Y
2.10320 A previous limit for drawing 100 points in a polyline has been upgraded to support unlimited points. 27/03/2014 6:43:07 PM Y
2.10310 Added centralised config update to the app. When Version history is displayed the configuration will be updated on our central server. This is a config and change management process. 27/03/2014 6:43:07 PM Y
2.10300 Background Update - Added mobIntVersion Field to taptojob table. 27/03/2014 6:43:07 PM Y
2.10290 Corrected some code, some points were not being kept when pins were dragged in Known Trouble Spots. 27/03/2014 6:43:07 PM Y
2.10280 Some sites experienced problems with road Geo Search. Bug Fixed. 27/03/2014 6:43:07 PM Y
2.10270 When Editong a KTS, there is now a button below the map to allow you to add a point to show the Signage Midpoint. Handy as a reference when moving signs around. 27/03/2014 6:43:07 PM Y
2.10260 Allowed for apostrophe in editNotes. 5/02/2014 6:32:39 PM Y
2.10250 Allowed for Unknown or Large ID Number Maintenance Zones in Known Trouble Spots. 5/02/2014 3:28:11 PM Y
2.10240 Increased the speed that all KTS' are drawn. Again, for big data sets this will be a marked improvement. 5/02/2014 3:28:11 PM Y
2.10230 Added Edit Notes to the KTS Details. 5/02/2014 9:39:31 AM Y
2.10220 Improved the first initial load time. 31/01/2014 5:27:47 PM Y
2.10210 Known Trouble Spots have been extended to store the OtherImpact and OtherSignage Points. 31/01/2014 5:27:47 PM Y
2.10200 Extended search to Known Trouble Spots to include Edit Notes. There is also a new menu item under Known Trouble Spots so go straight to search in case of large data sets (Somerset ;P ) . 31/01/2014 5:27:47 PM Y
2.10190 You can now edit all details of your Known Trouble Spots. As well as dragging the map pins to reposition them. 31/01/2014 5:27:47 PM Y
2.10180 When creating and Editing Road Closures, you can now drag the marker pins around to adjust them instead or removing an adding again. 31/01/2014 5:27:47 PM Y
2.10170 Userr Manual now included under Help Menu. 4/12/2013 4:05:04 PM Y
2.10160 Update inc_global inc_func inc_closures for a simpler hidden gernator to fix error on IIS 2.0 the ambiguous copyright symbol. 4/12/2013 4:05:03 PM Y
2.10150 TimeBars now show for all closures, not just those that have been reviewed. 4/12/2013 4:05:03 PM Y
2.10140 Share Data Setting is now recorded in each closure to allow replication to TMR. 26/11/2013 7:46:48 AM Y
2.10130 Maps are now resizable, also fixed some spelling errors. 26/11/2013 7:46:48 AM Y
2.10120 Modified Security Hash For Mobile. 14/11/2013 10:30:05 AM Y
2.10110 Updated Security Update Trigger to Include Security Hash. 14/11/2013 10:30:05 AM Y
2.10100 Updated Security Insert Trigger to Include Security Hash. 14/11/2013 10:30:05 AM Y
2.10090 Corrected the Closure Search results to match with new midpoints. 14/11/2013 10:30:05 AM Y
2.10080 Updated Mapping to show layer control automatically. 14/11/2013 10:30:05 AM Y
2.10070 Fixed a duplicate security hash being created for mobile users. 14/11/2013 10:30:05 AM Y
2.10060 Fixed Security bug where Managers could not select New Closure from the Menu, only Administrators Could - Thanks Brad L 14/11/2013 10:30:05 AM Y
2.10050 Fixed Parameter Setup Glitch on install -- publicEmailAddress -- reference 14/11/2013 10:30:05 AM Y
2.10040 Added new view to show Impact Midpoint 14/11/2013 10:30:04 AM Y
2.10030 Added Additional Layers Option 14/11/2013 10:30:04 AM Y
2.10020 Added Guardian Test Councils 14/11/2013 10:30:04 AM Y
2.10010 Locked down altering Council IDs 14/11/2013 10:30:04 AM Y
2.10000 Modify [RC_Closures_tbl] Set clousreID as rowguid 14/11/2013 10:30:04 AM Y
2.06430 Dropped Old Trigger [T_Audit_MaintenanceZones_tbl_update] 14/11/2013 10:30:04 AM Y
2.06420 Readded the Camera Icon on Images 14/11/2013 10:30:04 AM Y
2.06410 Added Some jQuery interactions 14/11/2013 10:30:04 AM Y
2.06400 Added Some jQuery interactions 14/11/2013 10:30:04 AM Y
2.06300 Added Report - Closures Reopened Between Dates 14/11/2013 10:30:04 AM Y
2.06200 Added Report - Closures Started Between Dates 14/11/2013 10:30:04 AM Y
2.06100 Added Report - Closures Active Between Dates 14/11/2013 10:30:04 AM Y
2.06000 Checking all reopened events have a closureEnding Time 14/11/2013 10:30:04 AM Y
2.05900 Added View RC_reportSignsCurrentlyDeployedDetail_v and Report - Signs Currently Deployed Detail. 14/11/2013 10:30:04 AM Y
2.05800 Added View RC_SignsCurrentlyDeployedByZone_v and Report - Signs Currently Deployed By Zone. 14/11/2013 10:30:04 AM Y
2.05700 Added View RC_SignsCurrentlyDeployed_v and Report - Signs Currently Deployed. 14/11/2013 10:30:04 AM Y
2.05600 End Closure Date now written when record locked. Integration and Web. 14/11/2013 10:30:04 AM Y
2.05500 Added Chr 10 and 13 support to jescaper function. 14/11/2013 10:30:04 AM Y
2.05400 Delete Closure now limited to Unpublished events. 14/11/2013 10:30:04 AM Y
2.05300 Small Code Fixes. 14/11/2013 10:30:04 AM Y
2.05200 Updated the Image URL for Photos from Mobiles to the new 443 port : removing 9443 dependancy. An Integration exe update should already be applied. 14/11/2013 10:30:04 AM Y
2.05100 Updated the Image URL for Photos from Mobiles. An Integration exe update should already be applied. 14/11/2013 10:30:04 AM Y
2.05000 Cosmetic Fixes 14/11/2013 10:30:04 AM Y
2.04100 Add View Audit History to road closures 14/11/2013 10:30:04 AM Y
2.04000 Added Version History in Help Menu - Also fixed version history date recording 14/11/2013 10:30:04 AM Y
2.03950 Dropped RC_Version_tbl_tmp 14/11/2013 10:30:04 AM Y
2.03940 Insert Version History from Tmp Table into RC_Version_tbl 14/11/2013 10:30:04 AM Y
2.03930 Recreated new RC_Version_tbl 14/11/2013 10:30:04 AM Y
2.03900 Created RC_Version_tbl_tmp 14/11/2013 10:30:04 AM Y
2.03800 Dropped Constraint on RC_Version_tbl 14/11/2013 10:30:04 AM Y
2.03700 Added Contraints to Table [Audit_RC_MaintenanceZones_tbl] 14/11/2013 10:30:04 AM Y
2.03600 Dropped Table [Audit_MaintenanceZones_tbl] 14/11/2013 10:30:04 AM Y
2.03500 Modified Trigger [T_Audit_MaintenanceZones_tbl_delete] 14/11/2013 10:30:04 AM Y
2.03400 Dropped Trigger [T_Audit_MaintenanceZones_tbl_insert] 14/11/2013 10:30:04 AM Y
2.03300 Dropped Trigger [T_Audit_MaintenanceZones_tbl_update] 14/11/2013 10:30:04 AM Y
2.03200 Created Trigger [T_Audit_RC_MaintenanceZones_tbl_update] 14/11/2013 10:30:04 AM Y
2.03100 Created Trigger [T_Audit_RC_MaintenanceZones_tbl_insert] 14/11/2013 10:30:04 AM Y
2.03000 Inserted Data from [Audit_MaintenanceZones_tbl] into [Audit_RC_MaintenanceZones_tbl] 14/11/2013 10:30:04 AM Y
2.02900 Created Table [Audit_RC_MaintenanceZones_tbl] 14/11/2013 10:30:04 AM Y
2.02800 Updated Trigger [T_RC_UnderlyingCause_tbl_delete] 14/11/2013 10:30:04 AM Y
2.02700 Dropped Trigger [T_Audit_RC_MaintenanceZones_tbl_delete] 14/11/2013 10:30:04 AM Y
2.02600 Updated Trigger [T_RC_MaintenanceZones_tbl_delete] 14/11/2013 10:30:04 AM Y
2.02500 Dropped Trigger [T_Audit_RC_Signs_tbl_delete] 14/11/2013 10:30:04 AM Y
2.02400 Updated Trigger [T_RC_Signs_tbl_delete] 14/11/2013 10:30:04 AM Y
2.02300 Updated Trigger [T_Audit_RC_Security_tbl_delete] 14/11/2013 10:30:04 AM Y
2.02200 Updated Trigger [T_RC_Roads_tbl_delete] 14/11/2013 10:30:04 AM Y
2.02100 Updated Trigger [T_RC_Advice_tbl_delete] 14/11/2013 10:30:04 AM Y
2.02000 Added Searchng to Closures and Known Trouble Spots 14/11/2013 10:30:04 AM Y
2.01900 Block deleting the last Maintenance Zone 14/11/2013 10:30:04 AM Y
2.01800 Relocated the "Known Trouble Spots" Menu. 14/11/2013 10:30:04 AM Y
2.01700 Added a more succint summary of closures in the RHS of main map window. 14/11/2013 10:30:04 AM Y
2.01600 Added a Map Pin Legend 14/11/2013 10:30:04 AM Y
2.01500 Fixed fitting all pins onto the initial map, prior it would sometimes miss the odd pin when fitting the map 14/11/2013 10:30:04 AM Y
2.01400 Added Resizing of Map Windows 14/11/2013 10:30:04 AM Y
2.01300 Added Known Trouble Spots Management : Found under manage Lists. create delete and create from Known Trouble Spots : Available to Admins, not Managers 14/11/2013 10:30:04 AM Y
2.01200 Added Deleting Closures : Use with caution, the need may arise 14/11/2013 10:30:04 AM Y
2.01100 Added Cloning Closed Jobs 14/11/2013 10:30:04 AM Y
2.01000 Created Table [RC_KnownTroubleSpots_tbl] 14/11/2013 10:30:04 AM Y
2.00000 All Default values have been loaded - Except Roads 14/11/2013 10:30:04 AM Y
1.00600 Added records to Table [RC_ClosureCondition_tbl] 14/11/2013 10:30:04 AM Y
1.00500 Added records to Table [RC_ClosureReason_tbl] 14/11/2013 10:30:04 AM Y
1.00400 Added Default Underlying Cause Values to [RC_UnderlyingCause_tbl] 14/11/2013 10:30:04 AM Y
1.00300 Added Default Advice Values to [RC_Advice_tbl] 14/11/2013 10:30:04 AM Y
1.00200 Added Default Zones to [RC_MaintenanceZones_tbl] 14/11/2013 10:30:04 AM Y
1.00100 Added Default Signs to [RC_Signs_tbl] 14/11/2013 10:30:04 AM Y
1.00010 Added initial Preferences 14/11/2013 10:30:04 AM Y
1.00000 Created the first admin in anonymous sucurity mode 14/11/2013 10:30:04 AM Y
0.02300 Created Table [tapToJob] 14/11/2013 10:30:04 AM Y
0.02220 Created Table [RC_Roads_tbl] 14/11/2013 10:30:04 AM Y
0.02210 Created Trigger [T_RC_Roads_tbl_add] 14/11/2013 10:30:04 AM Y
0.02200 Created Table [RC_Roads_tbl] 14/11/2013 10:30:04 AM Y
0.02110 Created Table [RC_Advice_tbl] 14/11/2013 10:30:04 AM Y
0.02100 Created Trigger [T_RC_Advice_tbl_add] 14/11/2013 10:30:04 AM Y
0.02030 Created UPDATE trigger on Audit_RC_UnderlyingCause_tbl 14/11/2013 10:30:04 AM Y
0.02020 Created INSERT trigger on Audit_RC_UnderlyingCause_tbl 14/11/2013 10:30:04 AM Y
0.02010 Created DELETE trigger on Audit_RC_UnderlyingCause_tbl 14/11/2013 10:30:04 AM Y
0.02000 Created Table [Audit_RC_UnderlyingCause_tbl] 14/11/2013 10:30:04 AM Y
0.01920 Created Table [RC_UnderlyingCause_tbl] 14/11/2013 10:30:04 AM Y
0.01910 Created Trigger [T_RC_UnderlyingCause_tbl_add_update] 14/11/2013 10:30:04 AM Y
0.01900 Created Table [RC_UnderlyingCause_tbl] 14/11/2013 10:30:04 AM Y
0.01900 Created Table [RC_Advice_tbl] 14/11/2013 10:30:04 AM Y
0.01800 Created View [RC_ClosureConditionReason_v] 14/11/2013 10:30:04 AM Y
0.01720 Created Table [RC_ClosureReason_tbl] 14/11/2013 10:30:04 AM Y
0.01710 Created Insert - Update trigger on RC_ClosureReason_tbl 14/11/2013 10:30:04 AM Y
0.01700 Created Table [RC_ClosureReason_tbl] 14/11/2013 10:30:04 AM Y
0.01620 Created Trigger delete on [RC_ClosureCondition_tbl] 14/11/2013 10:30:04 AM Y
0.01610 Created Insert - Update trigger on RC_ClosureCondition_tbl 14/11/2013 10:30:04 AM Y
0.01600 Created Table [RC_ClosureCondition_tbl] 14/11/2013 10:30:04 AM Y
0.01520 Created Table [RC_SignsDeployed_tbl] 14/11/2013 10:30:04 AM Y
0.01510 Created Trigger [T_RC_SignsDeployed_tbl_add_update] 14/11/2013 10:30:04 AM Y
0.01500 Created Table [RC_SignsDeployed_tbl] 14/11/2013 10:30:04 AM Y
0.01430 Created UPDATE trigger on Audit_MaintenanceZones_tbl 14/11/2013 10:30:04 AM Y
0.01420 Created INSERT trigger on Audit_MaintenanceZones_tbl 14/11/2013 10:30:04 AM Y
0.01410 Created DELETE trigger on Audit_MaintenanceZones_tbl 14/11/2013 10:30:04 AM Y
0.01400 Created Table [Audit_MaintenanceZones_tbl] 14/11/2013 10:30:04 AM Y
0.01320 Created DELETE Trigger on RC_MaintenanceZones_tbl 14/11/2013 10:30:04 AM Y
0.01310 Created Insert - Update trigger on RC_MaintenanceZones_tbl 14/11/2013 10:30:04 AM Y
0.01300 Created Table [RC_MaintenanceZones_tbl] 14/11/2013 10:30:04 AM Y
0.01200 Added ISO 3166-2 Country - State Codes to [RC_CountryState_tbl] 14/11/2013 10:30:04 AM Y
0.01120 Created TRIGGER [T_RC_Images_tbl_delete] ON [RC_Images_tbl] 14/11/2013 10:30:04 AM Y
0.01110 Created TRIGGER [T_RC_Images_tbl_add_update] ON [RC_Images_tbl] 14/11/2013 10:30:04 AM Y
0.01100 Created Table [RC_Images_tbl] 14/11/2013 10:30:04 AM Y
0.01030 Created UPDATE trigger on Audit_RC_Signs_tbl 14/11/2013 10:30:04 AM Y
0.01020 Created INSERT trigger on Audit_RC_Signs_tbl 14/11/2013 10:30:04 AM Y
0.01010 Created DELETE trigger on Audit_RC_Signs_tbl 14/11/2013 10:30:04 AM Y
0.01000 Created Table [Audit_RC_Signs_tbl] 14/11/2013 10:30:04 AM Y
0.00920 Created DELETE trigger on RC_Signs_tbl 14/11/2013 10:30:04 AM Y
0.00910 Created Insert - Update trigger on RC_Signs_tbl 14/11/2013 10:30:04 AM Y
0.00900 Created Table RC_Signs_tbl 14/11/2013 10:30:04 AM Y
0.00830 Created UPDATE trigger on RC_Security_tbl 14/11/2013 10:30:04 AM Y
0.00820 Created INSERT trigger on RC_Security_tbl 14/11/2013 10:30:04 AM Y
0.00810 Created DELETE trigger on RC_Security_tbl 14/11/2013 10:30:04 AM Y
0.00800 Created Table [Audit_RC_Security_tbl] 14/11/2013 10:30:04 AM Y
0.00800 Created Table [RC_Signs_tbl] 14/11/2013 10:30:04 AM Y
0.00700 Created Table [RC_Security_tbl] 14/11/2013 10:30:04 AM Y
0.00630 Created UPDATE trigger on RC_Closures_tbl 14/11/2013 10:30:04 AM Y
0.00620 Created INSERT trigger on RC_Closures_tbl 14/11/2013 10:30:04 AM Y
0.00610 Created DELETE trigger on RC_Closures_tbl 14/11/2013 10:30:04 AM Y
0.00600 Created Table [Audit_RC_Closures_tbl] 14/11/2013 10:30:04 AM Y
0.00500 Created Table [RC_Closures_tbl] 14/11/2013 10:30:04 AM Y
0.00410 Created Function [RC_F_getHeadOfficeLon] 14/11/2013 10:30:04 AM Y
0.00410 Created Function [RC_F_getDataSharing] 14/11/2013 10:30:04 AM Y
0.00410 Created Function [RC_F_getDefaultReviewTaskFactor] 14/11/2013 10:30:04 AM Y
0.00410 Created Function [RC_F_getDefaultReviewTaskHrs] 14/11/2013 10:30:04 AM Y
0.00410 Created Function [RC_F_getDefaultEscalationFactor] 14/11/2013 10:30:04 AM Y
0.00410 Created Function [RC_F_getDefaultRC_URL] 14/11/2013 10:30:04 AM Y
0.00410 Created Function [RC_F_getPublicEmail] 14/11/2013 10:30:04 AM Y
0.00400 Created Function [RC_F_getCouncilID] 14/11/2013 10:30:04 AM Y
0.00400 Created Function [RC_F_getLgaID] 14/11/2013 10:30:04 AM Y
0.00400 Created Function [RC_F_getPrimaryEmail] 14/11/2013 10:30:04 AM Y
0.00400 Created Function [RC_F_getPrimaryOffice] 14/11/2013 10:30:04 AM Y
0.00400 Created Function [RC_F_getHeadOfficeLat] 14/11/2013 10:30:04 AM Y
0.00330 Created UPDATE trigger on RC_Parameters_tbl 14/11/2013 10:30:04 AM Y
0.00320 Created INSERT trigger on RC_Parameters_tbl 14/11/2013 10:30:04 AM Y
0.00310 Created DELETE trigger on RC_Parameters_tbl 14/11/2013 10:30:04 AM Y
0.00300 Created Table [Audit_RC_Parameters_tbl] 14/11/2013 10:30:04 AM Y
0.00200 Created Table [RC_Parameters_tbl] 14/11/2013 10:30:04 AM Y
0.00100 Created Table [RC_Version_tbl] 14/11/2013 10:30:04 AM Y