diff options
| author | redmatrix <git@macgirvin.com> | 2016-05-30 19:44:30 -0700 |
|---|---|---|
| committer | redmatrix <git@macgirvin.com> | 2016-05-30 19:44:30 -0700 |
| commit | 6602ff83dd54d0e17c985a5f527654fc2ed83eea (patch) | |
| tree | 920d7fa37f10786e806e847cf6b59b20a42e7cb8 /install/update.php | |
| parent | 490ab9e2c593275c0cf3d705a4ae52c6a22db4d9 (diff) | |
| download | volse-hubzilla-6602ff83dd54d0e17c985a5f527654fc2ed83eea.tar.gz volse-hubzilla-6602ff83dd54d0e17c985a5f527654fc2ed83eea.tar.bz2 volse-hubzilla-6602ff83dd54d0e17c985a5f527654fc2ed83eea.zip | |
start removing reserved words from database column names (this run: addon and hook)
Diffstat (limited to 'install/update.php')
| -rw-r--r-- | install/update.php | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/install/update.php b/install/update.php index 983db1bb9..686c199b5 100644 --- a/install/update.php +++ b/install/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1169 ); +define( 'UPDATE_VERSION' , 1170 ); /** * @@ -2114,3 +2114,21 @@ function update_r1168() { return UPDATE_FAILED; } +function update_r1169() { + + if(ACTIVE_DBTYPE == DBTYPE_POSTGRES) { + $r1 = q("ALTER TABLE `addon` CHANGE `timestamp` `tstamp` numeric( 20 ) UNSIGNED NOT NULL DEFAULT '0' "); + $r2 = q("ALTER TABLE `addon` CHANGE `name` `aname` text NOT NULL DEFAULT '' "); + $r3 = q("ALTER TABLE `hook` CHANGE `function` `fn` text NOT NULL DEFAULT '' "); + + } + else { + $r1 = q("ALTER TABLE `addon` CHANGE `timestamp` `tstamp` BIGINT( 20 ) UNSIGNED NOT NULL DEFAULT '0' "); + $r2 = q("ALTER TABLE `addon` CHANGE `name` `aname` CHAR(255) NOT NULL DEFAULT '' "); + $r3 = q("ALTER TABLE `hook` CHANGE `function` `fn` CHAR(255) NOT NULL DEFAULT '' "); + } + + if($r1 && $r2 && $r3) + return UPDATE_SUCCESS; + return UPDATE_FAILED; +}
\ No newline at end of file |