diff options
Diffstat (limited to 'update.php')
-rw-r--r-- | update.php | 50 |
1 files changed, 49 insertions, 1 deletions
diff --git a/update.php b/update.php index 0f7bf664d..d752eaa6d 100644 --- a/update.php +++ b/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1149 ); +define( 'UPDATE_VERSION' , 1153 ); /** * @@ -1289,3 +1289,51 @@ function update_1148() { return UPDATE_FAILED; return UPDATE_SUCCESS; } + + +function update_1149() { + $r1 = q("ALTER TABLE profile ADD likes text NOT NULL after prv_keywords"); + $r2 = q("ALTER TABLE profile ADD dislikes text NOT NULL after likes"); + if (! ($r1 && $r2)) + return UPDATE_FAILED; + return UPDATE_SUCCESS; +} + + +function update_1150() { + $r = q("ALTER TABLE event ADD summary text NOT NULL after finish, add index ( uid ), add index ( cid ), add index ( uri ), add index ( `start` ), add index ( finish ), add index ( `type` ), add index ( adjust ) "); + if(! $r) + return UPDATE_FAILED; + return UPDATE_SUCCESS; +} + + +function update_1151() { + $r = q("CREATE TABLE IF NOT EXISTS locks ( + id INT NOT NULL AUTO_INCREMENT PRIMARY KEY , + name CHAR( 128 ) NOT NULL , + locked TINYINT( 1 ) NOT NULL DEFAULT '0' + ) ENGINE = MYISAM DEFAULT CHARSET=utf8 "); + if (!$r) + return UPDATE_FAILED; + return UPDATE_SUCCESS; +} + +function update_1152() { + $r = q("CREATE TABLE IF NOT EXISTS `term` ( + `tid` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , + `oid` INT UNSIGNED NOT NULL , + `otype` TINYINT( 3 ) UNSIGNED NOT NULL , + `type` TINYINT( 3 ) UNSIGNED NOT NULL , + `term` CHAR( 255 ) NOT NULL , + `url` CHAR( 255 ) NOT NULL, + KEY `oid` ( `oid` ), + KEY `otype` ( `otype` ), + KEY `type` ( `type` ), + KEY `term` ( `term` ) + ) ENGINE = MYISAM DEFAULT CHARSET=utf8 "); + if (!$r) + return UPDATE_FAILED; + return UPDATE_SUCCESS; +} + |