diff options
Diffstat (limited to 'update.php')
-rw-r--r-- | update.php | 26 |
1 files changed, 25 insertions, 1 deletions
diff --git a/update.php b/update.php index 9b5772af1..6eade22f7 100644 --- a/update.php +++ b/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1112 ); +define( 'UPDATE_VERSION' , 1114 ); /** * @@ -948,3 +948,27 @@ function update_1111() { q("ALTER TABLE `gcontact` ADD `connect` CHAR( 255 ) NOT NULL "); } + +function update_1112() { + + q("CREATE TABLE IF NOT EXISTS `notify` ( +`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , +`type` INT( 11 ) NOT NULL , +`name` CHAR( 255 ) NOT NULL , +`url` CHAR( 255 ) NOT NULL , +`photo` CHAR( 255 ) NOT NULL , +`date` DATETIME NOT NULL , +`msg` MEDIUMTEXT NOT NULL , +`uid` INT NOT NULL , +`link` CHAR( 255 ) NOT NULL , +`seen` TINYINT( 1 ) NOT NULL DEFAULT '0' +) ENGINE = MYISAM "); + + q("ALTER TABLE `notify` ADD INDEX ( `type` ), ADD INDEX ( `uid`), ADD INDEX (`seen`), ADD INDEX (`date`) "); + +} + +function update_1113() { + q("ALTER TABLE `notify` ADD `verb` CHAR( 255 ) NOT NULL , +ADD `otype` CHAR( 16 ) NOT NULL"); +} |