diff options
| author | friendica <info@friendica.com> | 2012-01-01 00:39:22 -0800 |
|---|---|---|
| committer | friendica <info@friendica.com> | 2012-01-01 00:39:22 -0800 |
| commit | 44b4baa0ca43e78b92b08c57e86df13b5736bfaf (patch) | |
| tree | b4a48ece41c3197e865189672996a58702051e56 /update.php | |
| parent | 3e162bcf8f4c08d197f9507dd6daa56cf6104a4e (diff) | |
| download | volse-hubzilla-44b4baa0ca43e78b92b08c57e86df13b5736bfaf.tar.gz volse-hubzilla-44b4baa0ca43e78b92b08c57e86df13b5736bfaf.tar.bz2 volse-hubzilla-44b4baa0ca43e78b92b08c57e86df13b5736bfaf.zip | |
notification data type
Diffstat (limited to 'update.php')
| -rw-r--r-- | update.php | 21 |
1 files changed, 20 insertions, 1 deletions
diff --git a/update.php b/update.php index 9b5772af1..7293e1b98 100644 --- a/update.php +++ b/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1112 ); +define( 'UPDATE_VERSION' , 1113 ); /** * @@ -948,3 +948,22 @@ 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`) "); + +}
\ No newline at end of file |