diff options
| -rw-r--r-- | boot.php | 4 | ||||
| -rw-r--r-- | database.sql | 18 | ||||
| -rw-r--r-- | update.php | 21 |
3 files changed, 40 insertions, 3 deletions
@@ -9,9 +9,9 @@ require_once('include/nav.php'); require_once('include/cache.php'); define ( 'FRIENDICA_PLATFORM', 'Friendica'); -define ( 'FRIENDICA_VERSION', '2.3.1211' ); +define ( 'FRIENDICA_VERSION', '2.3.1212' ); define ( 'DFRN_PROTOCOL_VERSION', '2.22' ); -define ( 'DB_UPDATE_VERSION', 1112 ); +define ( 'DB_UPDATE_VERSION', 1113 ); define ( 'EOL', "<br />\r\n" ); define ( 'ATOM_TIME', 'Y-m-d\TH:i:s\Z' ); diff --git a/database.sql b/database.sql index e96aff4b7..65ff3b9d0 100644 --- a/database.sql +++ b/database.sql @@ -731,3 +731,21 @@ CREATE TABLE IF NOT EXISTS `conv` ( INDEX ( `created` ), INDEX ( `updated` ) ) ENGINE = MyISAM DEFAULT CHARSET=utf8; + + +CREAT 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', +INDEX ( `type` ), +INDEX ( `uid` ), +INDEX ( `seen` ), +INDEX ( `date` ) +) ENGINE = MyISAM DEFAULT CHARSET=utf8; 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 |