30.1.2012 git - skeleton for a deltasql client written in Python 28.1.2012 git patch 3 - bugfix in homepage of enterprise edition 27.1.2012 git patch 2 - email notification contains to which branches the script is applied 26.1.2012 git patch 1 - author name in subject of email notification - script version in email notification - email notification also if script is edited or deleted - initial install page has the option to enable email notification ******************************* 1.4.3 Release Notes (25.1.2012) There are several new improvements in this release: - deltasql server is able to notify users by email if a new script is inserted in deltasql. This feature is important to slowly migrate users from the manual synchronization burden to the deltasql way of life. - Users can define preferences: if help links are shown, if rows are colored. The number of scripts shown in the list script page is configurable as well. - Minor visual enhancements - Minor bugfixes ******************************* 23-25.1.2012 git - Testing and debugging the new release 13.1.2012 git - email notification for new scripts works both under Linux and Windows :-D - added FAQ entry on how to configure email notification for new scripts 12.1.2012 git - towards the implementation of email notification for new scripts 11.1.2012 git - created configuration to enable/disable emails. Users can choose in preferences.php if they want to be notified by email. 9.1.2012 git - implemented user preferences for scripts per page, display help links and color new rows 6.1.2012 git - bugfix: in some mysql versions, deltasql was not searching for the modified scripts, when the option was set - bugfix: package and view detection on lowercase + undefined index errors on this page - preparing utils.inc.php to handle new column in tbparameter, refactoring code a bit 5.1.2012 git - preparing datamodel to accept usersettings (added user_id column to tbparameter) - more updates on footers 4.1.2012 git - updating footers to be consistent - spreading help links to topics overall over deltasql server 2.1.2012 git - deltasql reports an error when trying to submit a script with no modules defined (happens when deltasql is freshly installed). - fixing minor bug on login screen ******************************* 1.4.2 Release Notes (1.1.2012) Maintenance release: Visual enhancements (icons on important actions and border to empty cells) Ability to branch from existing tags Minor bugfixes ******************************* 28.12.2011 git - Disabling ability to edit username, as it might create problems in rare situations. - adding - to empty cells in tables, so that the cell appears correctly, even if it is empty - User creation still had undefined variables, if under strict error reporting in php.ini 27.12.2011 git - Adding some icons to improve navigation. The icons are taken from phpMyAdmin 24.11.2011 git Adding ability to branch from existing tags. ******************************* 1.4.1 Release Notes (23.9.2011) Maintenance release: deltaclient: new field database type added, fixed errors in closing files project.conf and branches.conf deltasql server: - minimizing impact of Undefined Index errors when running with php.ini error_reporting = E_ALL | E_STRICT ; instead of E_ALL & ~E_NOTICE - dropped unused schemaname and description fields as they created confusion to users and were used by spammers - back to the onliner INSERT statement to update synchronization information - inserted links to videos into documentation, improved documentation ******************************* 15.9.2011 git - refreshing script.sql to create a database manually with the script - removing undefined index error during install procedure - fixing Get Development Tree if no project is defined - adding javascript code for Google Analytics for deltasql test instance on www.deltasql.org - refreshing www.deltasql.org schema - dropping script-test-data.sql as it is a burden to mantain - updating manual client options and moving them to main manual page 14.9.2011 git - fixed missing Closefile in deltaclient - fixing Undefined index error when retrieveing data from a client 13.9.2011 git - Added dbtype field to deltaclient - If a client does not specify dbtype, it defaults to database type "Other" - Back to the oneliner INSERT statement to update synchronization information 10.9.2011 git - dropping column description from TBSYNCHRONIZE and TBUSAGEHISTORY ALTER TABLE `tbsynchronize` DROP `description`; ALTER TABLE `tbusagehistory` DROP `description`; 9.9.2011 git - Started fixing "Undefined Index" error - Removed schemaname filed from TBSYNCHRONIZE and TBUSAGEHISTORY ALTER TABLE `tbsynchronize` DROP `schemaname`; ALTER TABLE `tbusagehistory` DROP `schemaname`; 5.9.2011 git - Added movie links to manual and to FAQ - Referencing FAQ on Undefined index problem in manual 4.9.2011 git - Added FAQ answer to "Undefined price index" problem when installing deltasql server - Added external libraries used by Deltasql in README.txt 1.9.2011 A new video tutorial revealing in 11 minutes the secret of installing the deltasql server has been published :-) As usual, the tutorial does not ship with this package. ******************************* 1.4.0 Release Notes (23.8.2011) New client: Multipurpose deltaclient for Windows XP, Vista, 7 with dynamic project/branches selection and automatic copy to clipboard of generated script. People upgrading from 1.3.7 should follow the procedure described on the Deltasql main page, as deltasql detects changing in the underlying datamodel. ******************************* 23.8.2011 git - documenting deltaclient install steps and particularities on manual.php - adding ip column to tbusagehistory to troubleshoot client issues Users need to run the following script on their schemas: ALTER TABLE `tbusagehistory` ADD `ip` VARCHAR( 32 ) NULL ; 14.8.2011-22.8.2011 git - the deltasql client written in freepascal is finished and ready for release with 1.4.0 13.8.2011 git - adding GUI skeleton for deltasql client in freepascal - adding libraries which the new freepascal deltasql client will use 9.8.2011 git adding branch visibility to interface for deltasql clients 8.8.2011 git added interface for deltasql clients to retrieve branches and project information ******************************* 1.3.7 Release Notes (5.6.2011) Security improvement: all passwords of deltasql users are stored as salted MD5 hashed strings. Administrators can reset the password of a user, if it was lost. Updates to deltasql: deltasql detects if the datamodel was changed during the upgrade and if there is need for an update. If yes, it redirects to a page on deltasql.org, were the synchronization script can be retrieved. Maintenance release: several minor bugfixes. People upgrading from 1.3.6 should execute the following script: ALTER TABLE `tbuser` ADD `encrypted` TINYINT( 1 ) NOT NULL DEFAULT '0', ADD `passwhash` VARCHAR( 40 ) NULL ; INSERT INTO `tbparameter` VALUES ('', 'SECURITY', 'PWD_HASH_SALT', 'CHANGEMETOANYRANDOMSTRING'); ALTER TABLE `tbbranch` CHANGE `create_dt` `create_dt` DATETIME NOT NULL; UPDATE tbsynchronize SET tagname='TAG_deltasql_1.3.7' WHERE versionnr=0; ******************************* 5.6.2011 - Password policy: do not allow the combination username=password - Password policy: When resetting a password, a random string is chosen 4.6.2011 git Improving detection of updated datamodel for deltasql itself. Improving error messages. Updated versions of all deltasql clients, the version was retrieved with this ChangeLog :-) 3.6.2011 git Password management: - changed table tbuser to support encrypted passwords - changed login method and Change Password window to store encrypted passwords - keeping backward compatibility to old authentication method to easy upgrade of deltasql - added ability for administators to reset password of a user - added salt for MD5 password hashes - automatically encrypting old plain passwords at login - added FAQ question on how to reset admin password Detecting updates: - if deltasql is updated, but the underlying schema is not correct, deltasql redirects to the synchronization page on www.deltasql.org Other: - showing not only day but also hour of latest changes in main page 2.5.2011 git - fixing empty RSS feed which was broken if there were no messages ******************************* 1.3.6 Release Notes 2.5.2011 With this release, a set of 7 tutorial videos explaining how deltasql works were created. Those videos need to be downloaded separately, they are not included in this package. New features in 1.3.6: - RSS feed which shows latest scripts - ability to give latest version number to edited scripts - colored diff for edited scripts (works in IE but not in Firefox) ******************************* 27.4.2011 git - added RSS feed to deltasql showing latest 20 scripts 23.4.2011 git - ability to increase version number to latest when editing a script, difference in versionnumber is shown in getdiff of history 22.4.2011 - three more tutorial movies: 050_deltasql_user_management_7min.avi 060_deltasql_editing_scripts_3min.avi 070_deltasql_how_verification_step_works_5min.avi 19.4.2011 git - created three additional movies on branching and tagging 020_deltasql_branching_and_transforming_schema_to_production_10min.avi 030_deltasql_transforming_schema_from_production_back_to_development_7min.avi 040_deltasql_tagging_7min.avi - ability to branch from HEAD in "List Branches and tags" added 14.4.2011 git - created an introductory movie on deltasql as screencast, named 010_deltasql_how_synchronization_works_14min.avi - added a link to the tutorial on the main page of deltasql 4.4.2011 git - added colored diff ******************************* 1.3.5 Release Notes New feature: ability to diff scripts stored in history. New feature: ability to graph development tree for a project in "List Branches and Tags" page. ******************************* 8.3.2011 git - Choosing project in order to display its graph in list_branches.php 7.3.2011 git - added ability to show difference between revisions (title, modules, branches) in History - added option to exclude tags from graph of dev tree - when tagging HEAD one needs to define to which project the tag belongs to - when synchronizing from or to a tag, check that the project matches - changed caption of button to detect views and packages 4.3.2011 git - added textdiff library - added ability to show difference between revisions (scripts and comments) in History - added ability to plot graph of development tree 2.3.2011 git - framework to display patchlevel (if any) - text area for fields in edit_script.php and submit_script.php set in constants.inc.php ******************************* 1.3.4 Release notes 1.3.2011 New feature: it is possible to synchronize from a tag, without need of the query to retrieve the version number Improvements in the History feature introduced with 1.3.3 People upgrading from 1.3.2 should execute this script: CREATE TABLE `tbscriptbranchchangelog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `script_id` int(11) NOT NULL, `branch_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `script_id` (`script_id`,`branch_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ; ******************************* 28.2.2011 git - submit script has wider entry area for script and comments 27.2.2011 git - showing data in history also for latest revision - some more fixes 26.2.2011 git - each time a synchronization is done, deltasql records the project name in a cookie and retrieves it next time - added ability to specify a tag in the from field of the synchronization step - added error message if trying to synchronize from a tag and at the same time specifying the from version number. The tag implicitly sets a version number from where to start the synchronization. - IE8 compatibility fix in Main menu - updating FAQ on how to upgrade deltasql (by using TAGs, one can easily retrieve the missing scripts to be executed) - updating manual on project and modules - recording changes of branches as well in a new table TBSCRIPTBRANCHCHANGELOG, so that it is possible to find in history if there were changes in respect to branches CREATE TABLE `tbscriptbranchchangelog` ( `id` int(11) NOT NULL AUTO_INCREMENT, `script_id` int(11) NOT NULL, `branch_id` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `script_id` (`script_id`,`branch_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ; ******************************* 1.3.3 Release Notes 25.2.2011 Deltasql is more wiki-like as anyone can edit a script. The history of editing is recorded as well. Administrators can retrieve deleted scripts. Improved right management with bugfixes. People upgrading from 1.3.2 should execute this script into the deltasql schema: CREATE TABLE `tbscriptchangelog` ( `id` int(11) NOT NULL auto_increment, `code` longtext collate latin1_general_ci NOT NULL, `module_id` int(11) NOT NULL, `versionnr` int(11) NOT NULL, `user_id` int(11) NOT NULL, `update_user` VARCHAR( 64 ) NULL, `script_id` int(11) NOT NULL, `create_dt` datetime NOT NULL, `comments` longtext collate latin1_general_ci, `title` varchar(64) collate latin1_general_ci default NULL, `isapackage` tinyint(1) NOT NULL default '0', `isaview` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1; ******************************* 25.2.2011 git - added logic to save changes into tbscriptchangelog, if a script is edited or removed - added ability to list history of edited files for anyone so that Deltasql gets more wiki-like (suggestion by Hari) - added abilily for administrators to see deleted scripts 24.2.2011 git - bugfix: editing a script hijacked ownership of script to the submitting user - dropped feature of editing script and increasing version number at the same time as it has some hidden consequences which could get dangerous (Hari suggestion as well). - preparing data structure to record changes to scripts: CREATE TABLE `tbscriptchangelog` ( `id` int(11) NOT NULL auto_increment, `code` longtext collate latin1_general_ci NOT NULL, `module_id` int(11) NOT NULL, `versionnr` int(11) NOT NULL, `user_id` int(11) NOT NULL, `update_user` VARCHAR( 64 ) NULL, `script_id` int(11) NOT NULL, `create_dt` datetime NOT NULL, `comments` longtext collate latin1_general_ci, `title` varchar(64) collate latin1_general_ci default NULL, `isapackage` tinyint(1) NOT NULL default '0', `isaview` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1; 21.2.2011 git - cosmetic changes (removed 'back to main menu' link where not needed, changed button text from 'Edit' to 'Save') 17.2.2011 git - on user request (Hari): editing a script increases its version number ******************************* 1.3.2 Release Notes 11.2.2011 This release reenables the upgrade from production to development schema, which was disabled in 1.3.1 because the new algorithm in 1.3.0 some basic issues were found. If you upgrade from version 1.3.1 or 1.3.0, you should launch this script on deltasql server schema: ALTER TABLE tbscriptgeneration ADD `exclbranch` tinyint(1) NOT NULL default '0'; ******************************* 11.2.2011 git - reimplementing update from production schema (branch) to development schema (HEAD) - added debug flag on dbsync.php to show debug information in synchronization script - raised version to 1.3.2 - added one FAQ question on how to move between production and development schemas - updated manual (Insights on deltasql algorithm chapter) 10.2.2011 git - removed table when displaying branches in submit_script.php on user request (Hari) - you need to launch this script when upgrading to version 1.3.2: ALTER TABLE tbscriptgeneration ADD `exclbranch` tinyint(1) NOT NULL default '0'; ******************************* 1.3.1 Release Notes 26.1.2011 - important set of fixes for the broken synchronization algorithm delivered with 1.3.0 - all buttons renamed from 'Submit Query' into their corresponding action - if you upgrade from previous versions you should run this script: INSERT INTO `tbparameter` VALUES ('', 'TEST', 'DB_CONNECTION', 'OK'); - if you installed test data, you should run this script as well: INSERT INTO tbscript (id, code, module_id, versionnr, user_id, update_dt, update_user, comments, title, isapackage, isaview) VALUES (9, '-- 6 script only for HEAD before branch DELTA_2 comes', 5, 17, 1, '2008-05-21', '', '', 'db update', 0, 0); ******************************* 26.1.2011 git - Tests_To_Verify_deltasql_correctness.txt updated - if test data is used, add this missing script to verify deltasql correctness: INSERT INTO tbscript (id, code, module_id, versionnr, user_id, update_dt, update_user, comments, title, isapackage, isaview) VALUES (9, '-- 6 script only for HEAD before branch DELTA_2 comes', 5, 17, 1, '2008-05-21', '', '', 'db update', 0, 0); - Fix in dbsync algo patching test cases 1-5 - Test cases 6 and 7 now are much more difficult, and need some idea to handle them. In the meanwhile I added an error message to inform the user that upgrades from development schemas to production schemas are not supported yet. The documentation was upgraded to reflect this fact. - Test case 8 is even more difficult and needs the concept of merging... It is about upgrading a production schema to a newer production schema. This case can not be even detected at the moment. - added following parameter to TBPARAMETER: INSERT INTO `tbparameter` VALUES ('', 'TEST', 'DB_CONNECTION', 'OK'); used in script check_db_connection.php which could be later used in bash deltasql clients 24.1.2011 git - changed all buttons from "Submit query" to action text in caption - bugfix in edit_script.php: Tags are not allowed - bugfix in search_scripts.php: Tags are not allowed 21.1.2011 git - added FAQ question on verification step - minor changes in FAQ document ******************************* 1.3.0 Release Notes 30.12.2010 Completely new synchronization algorithm which handles among others branches of branches, tagging and upgrade from production to development schema. WARNING: if upgrading production environments from previous versions, please always create a backup copy, and adjust table TBBRANCH manually to include sourcebranch and sourcebranch_id. In such cases, you can get support from gpu-world at lists.sourceforge.net When upgrading deltasql server, please launch the following script: ALTER TABLE `tbbranch` ADD `sourcebranch` VARCHAR( 40 ) NULL; ALTER TABLE `tbbranch` ADD `sourcebranch_id` int(11) default NULL; UPDATE `tbbranch` SET sourcebranch='HEAD' where name<>'HEAD'; UPDATE `tbbranch` SET sourcebranch_id=1 where name<>'HEAD'; ALTER TABLE `tbbranch` ADD `istag` tinyint(1) NOT NULL default '0'; ALTER TABLE tbsynchronize ADD tagname varchar(128) NULL; CREATE TABLE `tbscriptgeneration` ( `id` int(11) NOT NULL auto_increment, `sessionid` varchar(40) collate latin1_general_ci NOT NULL, `fromversionnr` int(11) default NULL, `toversionnr` int(11) default NULL, `frombranch` varchar(40) collate latin1_general_ci NOT NULL, `tobranch` varchar(40) collate latin1_general_ci NOT NULL, `frombranch_id` int(11) NOT NULL, `tobranch_id` int(11) NOT NULL, `create_dt` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1; You should launch on database schemas under deltasql versioning the following statement: ALTER TABLE tbsynchronize ADD tagname varchar(128) NULL; ******************************* 30.12.2010 git - added tagname to table TBSYNCHRONIZE, on the schemas where deltasql is active, one should run a statement: ALTER TABLE tbsynchronize ADD tagname varchar(128) NULL; This column records the name of the tag, in case the synchronization was up to a tag. - adjusted test data during install procedure. Install procedure tested - documenting new synchronization step in manual and FAQ. 24.12.2010 git implemented tagging :-), including all business logic around it :-) 23.12.2010 git - logic to upgrade schemas from production to development (HEAD) added as well ---------------- - error messages 7 and 4 removed, as they are superseeded by error 13 ---------------- I think the new synchronization algorithm works already :-) The next steps are: - add logic when upgrading from production schema to development schema - add logic to support tags (quite simple) ---------------- - added sourcebranch_id to table tbbranch, and making sure datamodel is consistent when branching - get_and_increase_globalversion() when branching, instead of get_globalversion() - modified structure of table tbscriptgeneration to improve its performance: instead of storing each script individually, we only store each segment of the path in the tree. - started modifying dbsync_update.inc.php to fullfill the new algorithm - TODO: the whole test data must be regenerated, also the compatibility with the old branching mechanism is lost!!! 22.12.2010 git This are changes resulting from the proposals of Harikrishnan Nair, Peter Kevin and Ramesh Raghavan. In particular, the document sent by Ramesh was very enlightning. Synchronization will be implemented as tree traversal beginning from the leaf in direction of the root until sourcebranch and scriptversion match. When traversing back, each encountered script will be added to a table tbscriptgeneration. When the traversing across the branches is done, the table tbscriptgeneration is ORDERED BY script_id ASC and passed to a outputscript() routine as it is already implemented now. To allow multiple synchronizations steps to be processed at once, a session id is generated. Traversing back from leaf to root makes the traversal unique and easy. The only thing to be implemented as exception to the algorithm is when changing from production schema to development schema. In this case, all scripts which belong to HEAD but not to the traversal will be added to the output of the script. Tagging will be implemented in this way: tags are stored in tbbranch with istag=1 and being the sourcebranch the tagged branch and versionnr the moment where the tag was issued. When taking a branch to begin the traversal, the highest script number of HEAD is taken as starting point, when taking a tag the stored versionnr is taken instead. Changes: - fix in head.inc.php as some browsers did not support the rough way it was implemented - added istag column to table TBBRANCH to support tagging - added sourcebranch column to table TBBRANCH and logic to populate it - added table TBSCRIPTGENERATION which will be used in the new synchronization step which will be more straightforward then the current one. IMPORTANT: users who upgrade from previous versions should execute these statements in their deltasql schema: ALTER TABLE `tbbranch` ADD `sourcebranch` VARCHAR( 40 ) NULL; ALTER TABLE `tbbranch` ADD `sourcebranch_id` int(11) default NULL; UPDATE `tbbranch` SET sourcebranch='HEAD' where name<>'HEAD'; UPDATE `tbbranch` SET sourcebranch_id=1 where name<>'HEAD'; ALTER TABLE `tbbranch` ADD `istag` tinyint(1) NOT NULL default '0'; CREATE TABLE `tbscriptgeneration` ( `id` int(11) NOT NULL auto_increment, `sessionid` varchar(40) collate latin1_general_ci NOT NULL, `fromversionnr` int(11) default NULL, `toversionnr` int(11) default NULL, `frombranch` varchar(40) collate latin1_general_ci NOT NULL, `tobranch` varchar(40) collate latin1_general_ci NOT NULL, `frombranch_id` int(11) NOT NULL, `tobranch_id` int(11) NOT NULL, `create_dt` datetime default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1; ******************************* 1.2.1 Release Notes - Support for PostgreSQL database works - typo in bash client fixed which prevented deltasql bash client to work correctly ******************************* 31.10.2010 git - major fix in continouus integration script - PostgreSQL support succesfully tested 29.9.2010 git - added PostgreSQL support to bash client for continouus database integration - raised version to 1.2.1 ******************************* 1.2.0 Release Notes 28.9.2010 Bash client is able to perform continouus database integration for Oracle and mySQL. Deltasql server is able to export scripts each one in a numbered file, grouped together in a zip file for further use in autoupdater tools (like the ones available at www.dbdeploy.com). Deltasql server adds support for sqlite databases. ******************************* 27.10.2010 git - raised version to 1.2.0 - added manual entry on how to install bash client 26.10.2010 git - bash client: continouus integration works for Oracle several consistency checks added to bash client now envisioning PostgreSQL 24.10.2010 git - bash client: continouus database integration works for mySQL schema. Now envisioning Oracle. - added FAQ question which explains how to improve continouus integration with the deltasql bash client 23.10.2010 git - added FAQ questions on how to download, test and checkout deltasql with git. Bash client: - continouus database integration is close to work for mySQL schemas 22.10.2010 git - added FAQ question on formats which can be exported by deltasql 21.10.2010 git Server changes - added sqlite support (sync table definition) - added ability to export the synchronization script as single files zipped to be used in dbdeploy like tools (check http://www.dbdeploy.com for more details) - added zip library under /utils/createzip by Rochak Chauhan (www.rochakchauhan.com) ******************************* 7.10.2010 1.1.1 Release Notes Server changes - improved error handling in synchronization step, 2 new error types added, 1 error did not show up due to mistake in code - deletion scripts revisited to leave database consistent: delete Project and delete Module were not working properly - Layout on initial page changed ******************************* 7.10.2010 git - fixed error message number 5 which never appeared during db synchronization. - when deleting a user, the scripts submitted by this user are reassigned to admin - deleting a module also deletes assignment of scripts to branches - deleting branches and scripts revisited - Layout of initial page rivisited, removed code for piwik stats as it was not used anymore 6.10.2010 git Project deletion also deletes existing branches for the deleted project and the reference from scripts to the deleted branches. Added error messages on synchronization steps: - if the version number is less than 0 or alphanumeric - if the user is attempting to synchronize on a project without any modules 18.9.2010 git Moved source code from CVS module dbsync hosted on GPU project to git module deltasql hosted on project deltasql of project homepage. ******************************* 13.9.2010 1.1.0 Release Notes - ability to submit scripts in chain - new deltasql client in bash script, skilled people should be able to build continous integration for databases with cron jobs and additional scripts for database bindings - collection of usage statistics sent to deltasql.org if user agrees - manual and FAQ improved with additional sections/questions ******************************* 10.9.2010 CVS - 1 FAQ added on phone home functionality added - source code walk through in manual - Bash deltasql client added 9.9.2010 CVS - added phone home capability to deltasql to collect usage statistics - added 3 new questions to FAQ, FAQ reorganized - added sections in manual about Projects and Modules and on how synchronization works. 8.9.2010 CVS - ability to submit scripts in chain (setting recorded in cookie) 30.7.2010 1.0.9 Release Notes - maintenance release with fixes from community 29.6.2010 CVS - when in "Search scripts" the output as text file option is selected, the scripts are showed in ascending order 15.6.2010 CVS - added slash at the end of Oracle stored procedure to verify scripts ******************************* 1.0.8 Release Notes (24.5.2010) - Important fix in install routines - Ability to set a default database type - Stored procedure for MS SQL server to verify that the script is executed on the correct database ******************************* 24.5.2010 CVS Fix to the install routines finalised 21.5.2010 CVS Added ability to select default database type during install Applied fix to the install routines 18.5.2010 CVS Added stored procedure for MS SQL server to verify script correctness (tested only in read-only mode though) 24.2.2010 CVS Minor fixes in manual.php ******************************* 1.0.7 Release Notes (15.2.2010) Minor bugfixes and URLs adjusted to the new URL www.deltasql.org ******************************* 15.1.10 CVS Changed the wiki url to www.deltasql.org/wiki 28.10.09 CVS - bugfix: a missing script title is defaulted to "db update" so that it is clickable on the google gadget 20.10.09 CVS - google gadget has number of scripts and font size as preferences - bugfix: scripts opened in google gadget open a new browser tab ******************************* 1.0.6 Release Notes (14.10.2009) The main feature of 1.0.6 is the Google Gadget that displays the latest scripts on your iGoogle start page. The manual is updated on how to install the gadget. Additionally, the 'List scripts' view shows coloured rows depending on the age of a submitted script. For each submitted script, not only the date is recorded, but now also the hour. With 1.0.6 we change the version number to a schema numbering which is very common in the Open Source world. WARNING: Before installing 1.0.6 you need to run this script on the database schema: ALTER TABLE `tbscript` CHANGE `create_dt` `create_dt` DATETIME NOT NULL; ALTER TABLE `tbscript` CHANGE `update_dt` `update_dt` DATETIME NOT NULL; ******************************* 14.10.09 - added settings and refined deltasql google gadget - added gadget on the initial page - added a F.A.Q question on the gadget - added a section in the manual that explains how to intall the gadget - list scripts colors scripts as the gadget does - removed deltasql-1.005.ebuild (gentoo ebuild script) 13.10.09 - list computers is refreshed each 3 minutes - started adding skeleton for a google gadget displaying the latest scripts - changed format in tbscript for create_dt and update_dt, people need to run: ALTER TABLE `tbscript` CHANGE `create_dt` `create_dt` DATETIME NOT NULL; ALTER TABLE `tbscript` CHANGE `update_dt` `update_dt` DATETIME NOT NULL; 23.7.09 - added under the directory "gentoo" an overlay called "gpu-grid" that will contain ebuilds for the different gentoo versions. ******************************* 1.005 Release Notes (22.4.09) - possibility to submit scripts with the option "in all branches" or "not in any branch" (by Lukas Stucki) - ability to remove empty lines in a script in submitscript.php (by Lukas Stucki) - bugfix: test data is correctly inserted by install.php - bugfix: error rights in Top Ten Submitters ******************************* 8.02.09 - Lukas Stucki added the possibility to submit scripts to "all" branches or "none", by clicking on a button on the submit_script.php page ******************************* 1.004 Release Notes - possibility to create a branch of a branch by duplicating it - it is possible to see who modified last a script and when - it is possible to search among modified scripts - added FAQ questions ******************************* 19.12.08 CVS - on the deltasql schema please execute: ALTER TABLE `tbscript` ADD `update_dt` DATE NULL AFTER `create_dt` ; ALTER TABLE `tbscript` ADD `update_user` VARCHAR( 64 ) NULL AFTER `update_dt`; - this adds the functionality of keeping track of script changes 17.12.08 CVS - added possibility to duplicate a branch - added a FAQ on how to duplicate the branch 11.12.08 CVS - added FAQ note on how to upgrade deltasql ******************************* 11.12.08 1.003 Release Notes - search scripts page: it is possible to search for scripts in a given time interval by using the jscalendar component - important bugfix: branch names with dots or other special chars created problems to the submit, list scripts pages (reported from Harikrishnan V at amritatech.com) - documentation improvements: added a Frequently Asked Question, the ant-client install instructions and a tip to the manual - alphabetic sorting for project names and module names ******************************* 10.12.08 CVS - added a tip to the manual - added piwik stats (only if flag $include_piwik_stats is set to true), by default disabled 9.12.08 CVS - added section on how to install ant-client in manual and one more question in the FAQ 8.12.08 CVS - wrote down a minimal FAQ 4.12.08 CVS - added a $default_script_title variable in config.inc.php to configure the default script title when submitting a new script - added skeleton for deltasql FAQ 1.12.08 CVS - bugfix for the issue reported by Harikrishnan: it is possible to name branches like "1.1.1" or using special chars now - bugfix: if a script is less than 35 chars it is not shown in list_scripts.php 19.11.08 CVS - added jscalendar (http://jscalendar.sourceforge.net) to search scripts for a date interval 18.11.08 CVS - alphabetic ordering of module names and branch names in edit_script.php and submit_script.php - alphabetic ordering of project names in dbsync.php 14.11.08 1.002 Release Notes - When deleting a script, a branch, a module or a project, a page asks for confirmation - Several documentation improvements 13.11.08 CVS - added directory structure text file, to explain the package structure of deltasql_thunder_1.xxx.tar - several improvements on tablesync (including timer) - minor documentation improvements 7.11.08 CVS - improvements to the deltasql algorithm section in the manual 6.11.08 CVS - added little section in manual that documents the deltasql algorithm 4.11.08 CVS - added number of synchronizations in list usage history 29.10.08 CVS - confirm page for deletion of project, user, branch and module 28.10.08 CVS - script deletion has a confirmation page - tablesync implements basic functionality without foreign key management - reduced the number of scripts per page from 20 to 15 in utils/constants.inc.php ******************************* 15.10.08 1.001 Release Notes The deltasql clients now also support Microsoft SQL server and Sybase thanks to the open source driver jTDS. Some refinements in respect to 1.000: - the schema name is removed as it was creating confusion. - install procedure: added possibility to specify another user as root user - the test data script is running now ******************************* 14.10.08 CVS - initial skeleton for the tablesync utility under /tablesync subfolder: it is a Java process (which can run on a Linux/Unix server) that is able to synchronize data between different database types (via JDBC driver) 2.10.08 CVS - deleted some entries in the test data script under subdirectory db, as they were not working - removed optional schema name from UI as it creates confusion - install procedure: added possibility to specify another user as root user 1.10.08 CVS - added a new JDBC driver to the ant-client and to the dbredactor client that allows connections to Microsoft SQL Server and Sybase. The JDBC driver name is jTDS and is under LGPL, distributed at jtds.sourceforge.net - changes server side to support the Microsoft SQL server and Sybase 24.09.08 CVS Improved error message in stored procedure DELTASQL_VERIFY_SCHEMA ******************************* 15.09.08 1.000 Release Notes 0.950 is rereleased as version 1.000 due to its stability. Only the .tar.gz packaging has a correct Unix end of line format. ******************************* ******************************* 19.08.08 0.950 Release Notes Improved project module management (possibility to delete modules, less confusing navigation) Improved user management (possibility to delete users for administrators) Improved error management (bugfixes, more error types, link to error documentation if format is HTML) XML Export for advanced deltasql clients This release is Release Candidate 1 for Version 1. ******************************* 18.08.08 CVS - documented the possible error messages in deltasql server - changed logic to format error, so that it can show documentation on an hyperlink - added possibility to choose between XML, HTML (default) and text in dbsync form 15.08.08 CVS - finished XML export functionality for dbsync updates, to enable use xmlformatted=1 parameter in URL string - fixed minor bugs in error messages if client were not aligned - documented the options a deltasql client can set via URL parameters 14.08.08 CVS - Added delete project module functionality - Revised Add Module workflow - "Back To" links not too close of end of table - Added initial stubs to handle xml output of dbsync - Added possibility to delete users for Administrators ******************************* 13.08.08 0.901 Release Notes - Important bugfix: the list of database types was not shown when getting the synchronization table ******************************* ******************************* 12.08.08 0.900 Release Notes - Top Ten Submitters List (can be installed with an option) - Editing the description of Modules, Projects and Branches - bugfixes in the install procedure if options are chosen - added test document to verify accuracy of synchronization mechanism ******************************* 8.08.08 CVS - added editing of projects, branches and modules (description and for modules also name) 28.07.08 CVS - added document "Tests_To_Verify_deltasql_correctness.txt" containing the output of the synchronization mechanism with the test data that can be installed with install.php 25.07.08 CVS - added top ten submitters list - added possibility to disable the top ten list on the install.php page 21.07.08 CVS - bugfix: test system did not shown admin password in login screen 11.07.08 CVS - bugfix: enterprise logo never shown if deltasql configured as Enterprise Edition 10.07.08 0.850 Release Notes - provides the reliability of 0.810 - easiness of installation thanks to the new install.php page which takes the entire burden of configuring deltasql away from the user - usage statistics for administrators 10.07.08 CVS - added single scripts to recreate schema in db/ subfolder - install.php works perfectly :-). In one shot it is possible to install deltasql with options :-) 8.07.08 CVS - Install procedure: database creation works. now tables are missing. 4.07.08 CVS - configuration script is automatically generated via install.php 3.07.08 CVS - created nice layout for install.php - redirection to install.php if deltasql not already installed 27.06.08 CVS - added entry in README.TXT that pictures/enterprise_logo.jpg is the only file not under GPL in this package. 27.05.08 CVS - added table tbusagehistory to record some deltasql activities for administrators, it has exactly the same structure as TBSYNCHRONIZE (a part of the unique constraint on the version number). - added page list_usage_history.php if the user is logged as administrator ******************************* 22.05.08 0.810 Release Notes - Important Fixes to the update logic for BRANCH->HEAD and HEAD->BRANCH operations (the duplicate problem is solved as well) - Look&Feel changed with Cascade Style Sheets - Fixes to the backup shell script ******************************* 22.05.08 CVS - all combinations HEAD -> HEAD, BRANCH->BRANCH, BRANCH->HEAD and HEAD->BRANCH are tested and seem to work (after several adjustments and adding a third phase into the synchronization step) 21.05.08 CVS - initial bugfixes to the dbsync update logic (duplicate problem seems solved, but maybe a refactoring is needed) - stuckas fixes to backup script under /db/backup 05.05.08 CVS - added cascade style sheet to the html page (the style sheet is copyed from the Tomcat 5.5 inside JBoss) ******************************* 0.809 Release Notes - DELTASQL_VERIFY_SCHEMA stored procedure verify that a synchronization script is executed in the correct schema (for Oracle and postgreSQL. mySQL might support this at a later point) - possibility to edit in which branches a script belongs to (before it was possible only through the removal workaround) - example backup shell script for Linux to periodically dump deltasql data under /db/backup - minor fixes and changes ******************************* 2.5.08 CVS - edit script allows modification of to which branches a script is applied 27.4.08 CVS - added verification step for database postgreSQL as stored function 24.4.08 CVS - important end of line bugfix in synchronization script generation 23.4.08 CVS - changed verification step by using a stored procedure 21.4.08 CVS - bugfix in echo statement of ant-client 20.4.08 CVS - removed flag $enable_verification_script_for_dbsync, added a column to tbsynchronize named dbtype instead. If it is an Oracle database, dbtype will contain the string Oracle, and the verification script will be shown. - added also a column schemaname to tbsynchronize - adapted ant-client and dbredactor to support the database type setting 18.4.08 CVS - added Oracle verification script, to verify if a dbsync script is executed at the correct place (flag $enable_verification_script_for_dbsync in config.inc.php to enable it) 17.4.08 CVS - script by Lukas to backup sql dumps on a samba server under db/backup ******************************* 16.4.08 0.808 Release notes - syntax highlighting for SQL scripts with the Geshi library of Nigel McNie and Benny Baumann added by Lukas Stucki - bugfix: if there are no scripts a commment is shown - database schema revised - ant client revised ******************************* 10.4.08 CVS - title links to show script in list scripts view. 7.4.08 CVS - possibility to disable client download table in config.inc.php via variable $disable_clients_table_on_main_page - redone database schema for deltasql by reexporting it with a project and some modules as example 6.4.08 CVS - better title management for "collection scripts" mode, search among titles, titles different than "db update" are underlined - bugfix: if there are no SQL scripts, the INSERT into TBSYNCHRONIZE statement is not returned. A commment that no database update is needed is printed instead 4.4.08 CVS - possibility to disable SQL highlighting if it creates performance problems 3.4.08 CVS - ant client tested, some variable names renamed - added SQL coloring of updatestatement 1.4.08 CVS stuckas: syntax highlighting for SQL scripts with the Geshi library of Nigel McNie and Benny Baumann ******************************* 30.3.08 0.807 Release Notes - ant client of Lukas Stucki as additional deltasql client - output of filtered scripts also as text file - minor fixes ******************************* 30.3.08 CVS - modified ant client to make it JDBC driver independent. so it can support mySQL and postgreSQL as well 28.3.08 CVS - modified query in ant client to be compatible with other databases - added php version information if logged as administrator 25.3.08 CVS - added ant client of Lukas Stucki 6.3.08 CVS - added possibility to search among scripts and have the output as a text list for faster copy-paste. ******************************* 4.3.08 0.806 Maintenance Release ******************************* 24.2.08 CVS - tbsynchronize is now described in the native format of postgreSQL (though the format used until now was understood by PostgreSQL). 20.2.08 CVS - bugfix: if tbscript was empty, list_scripts.php might not work 15.2.08 CVS - clients are allowed to get the html formatted version by setting the parameter htmlformatted=1 11.2.08 CVS - dbredactor: changed name from datasource.properties to deltasql.properties ******************************* 7.2.08 0.805 Release Notes WARNING: you need to drop and recreate TBSYNCHRONIZE on all of your database schemas as two new columns were added! - database synchronization logs also from which version and from which branch the update started, dbredactor updated to reflect this - bugfix in database schema creation for the deltasql server - settings are remembered in search script window, to allow refinements - possibility to add a commit comment in database synchronization form - bugfix branch visibility - it is possible to search scripts belonging in a given version range ******************************* 5.2.08 CVS - dbredactor: URL encoding of most parameters - dbredactor: replacing white spaces with underscores in script names 4.2.08 CVS - bugfix: created branch must have visible set to 1 by default. 3.2.08 CVS - update_fromsource is logged in TBSYNCHRONIZE as well - bugfix in db/script.sql about INSERT statement in TBSYNCHRONIZE - remembering settings in search_script.php to refine searches 1.2.08 CVS - search scripts from version to version - update_fromversion is logged in TBSYNCHRONIZE as well 31.1.08 CVS - possibility to add a commit comment - dbredactor uses the commit comment to signal for which branch the script is ******************************* 0.804 Release Notes WARNING: you need to drop and recreate TBSYNCHRONIZE on all of your database schemas as the format changed! - TBSYNCHRONIZE keeps history of changes and remembers which user did changes on schema - Navigation with pages while browsing scripts (also if a search filter is enabled) - Last search is remembered until Cancel Search button is pressed ******************************* 25.1.08 CVS - added support UPDATE_USER und UPDATE_TYPE to TBSYNCHRONIZE in dbredactor und deltasql-server - implemented match case logic for search_scripts.php. However the query does not work in list_scripts.php. For now we keep it disabled 24.1.08 CVS - changing columns of TBSYNCHRONIZE, so that it is possible to insert multiple entries, to have a little history of what happened to the database - changed name of a column of TBSYNCHRONIZE from LASTVERSIONNR to VERSIONNR (breaks backward compatibility unfortunately) - UPDATE_DT has default SYSDATE in Oracle Table 22.1.08 CVS - navigation among scripts works fine also if search filter is enabled 21.1.08 CVS - added Last page in list_scripts.php 18.1.08 CVS - added primitive Top/Next/Previous in list_scripts.php - remembering search queries among scripts with cookies ******************************* 16.1.08 0.803 Release Notes - important bugfix in dbredactor logic - branch visibility - searching views and packages ******************************* 16.1.08 CVS - branch visibility also in dbsync.php - show/hide branches also for Project Managers. Delete branches only for Administrators. 15.1.08 CVS - dbredactor bugfix: dbsync info was not working properly when current version on schema and on deltasql were the same - implemented branch visibility: hidden branches are not shown in submit_script.php - added dbredactor versioning 10.1.08 CVS - detect packages and views only if project manager or administrator 9.1.08 CVS - drop table and commit statements when getting synchronization table 8.1.08 CVS - searching among packages and views ******************************* 7.1.08 0.802 Release Notes - supported marking scripts as views and packages - easier to upgrade deltasql by removing stuff from configuration file - minor changes for production (removed adding of ; if missing, removed some default values in forms to avoid mistakes) - advertisement for logos of Patrizia Pulice Cascio ******************************* 7.1.08 CVS - added script to mark views and packages automatically in dbsync.php 6.1.08 CVS - exclusion of views and packages works 5.1.08 CVS - added possibility to mark a script as a view or as a package (later views and packages can be excluded from dbsync at wish) 4.1.08 CVS - removed automatic end of line ; for scripts as it creates some problems 2.1.08 CVS - added page of Patrizia 21.12.07 CVS - Submit script: added mandatory specification of module without default as it was source of errors 20.12.07 CVS - Changed show script so that also the comment can be copy-pasted into an SQL client 15.12.07 CVS - Changed config.inc.php to example_config.inc.php and manual to reflect this - added $dbserver variable if instance of mySQL is not running on the same server where Apache runs. ******************************* 13.12.07 0.801 Renamed tables to lowercase, as queries create some problems with some mySQL instances. ******************************* ******************************* 12.12.07 0.800 Initial Release on Sourceforge.net *******************************