"Fossies" - the Fresh Open Source Software Archive  

Source code changes of the file "install/upgrade_136.php" between
opendocman-1.4.3-release.tar.gz and opendocman-1.4.4-release.tar.gz

About: OpenDocman is a document management system (DMS) designed to comply with ISO 17025 and OIE standard for document management (using PHP, MySQL).

upgrade_136.php  (opendocman-1.4.3-release):upgrade_136.php  (opendocman-1.4.4-release)
skipping to change at line 33 skipping to change at line 33
echo 'Altering the data table...<br />'; echo 'Altering the data table...<br />';
$query = "ALTER TABLE `{$_SESSION['db_prefix']}data` DROP key `description`"; $query = "ALTER TABLE `{$_SESSION['db_prefix']}data` DROP key `description`";
$stmt = $pdo->prepare($query); $stmt = $pdo->prepare($query);
$stmt->execute(); $stmt->execute();
$query = "ALTER TABLE `{$_SESSION['db_prefix']}data` ADD KEY `description` (`des cription`(200))"; $query = "ALTER TABLE `{$_SESSION['db_prefix']}data` ADD KEY `description` (`des cription`(200))";
$stmt = $pdo->prepare($query); $stmt = $pdo->prepare($query);
$stmt->execute(); $stmt->execute();
echo 'Altering the settings table...<br />'; echo 'Altering the settings table...<br />';
$query = "ALTER TABLE `{$_SESSION['db_prefix']}settings` DROP CONSTRAINT `name`" ; $query = "ALTER TABLE `{$_SESSION['db_prefix']}settings` DROP INDEX `name`";
$stmt = $pdo->prepare($query); $stmt = $pdo->prepare($query);
$stmt->execute(); $stmt->execute();
$query = "ALTER TABLE `{$_SESSION['db_prefix']}settings` ADD CONSTRAINT `name` U NIQUE (`name`(200))"; $query = "ALTER TABLE `{$_SESSION['db_prefix']}settings` ADD CONSTRAINT `name` U NIQUE (`name`(200))";
$stmt = $pdo->prepare($query); $stmt = $pdo->prepare($query);
$stmt->execute(); $stmt->execute();
echo 'Updating db version...<br />'; echo 'Updating db version...<br />';
$query = "UPDATE {$_SESSION['db_prefix']}odmsys SET sys_value='1.4.0' WHERE sys_ name='version'"; $query = "UPDATE {$_SESSION['db_prefix']}odmsys SET sys_value='1.4.0' WHERE sys_ name='version'";
$stmt = $pdo->prepare($query); $stmt = $pdo->prepare($query);
$stmt->execute(); $stmt->execute();
 End of changes. 1 change blocks. 
1 lines changed or deleted 1 lines changed or added

Home  |  About  |  Features  |  All  |  Newest  |  Dox  |  Diffs  |  RSS Feeds  |  Screenshots  |  Comments  |  Imprint  |  Privacy  |  HTTP(S)