diff options
Diffstat (limited to 'update.php')
-rw-r--r-- | update.php | 20 |
1 files changed, 19 insertions, 1 deletions
diff --git a/update.php b/update.php index 6eade22f7..4dff59c98 100644 --- a/update.php +++ b/update.php @@ -1,6 +1,6 @@ <?php -define( 'UPDATE_VERSION' , 1114 ); +define( 'UPDATE_VERSION' , 1115 ); /** * @@ -972,3 +972,21 @@ function update_1113() { q("ALTER TABLE `notify` ADD `verb` CHAR( 255 ) NOT NULL , ADD `otype` CHAR( 16 ) NOT NULL"); } + +function update_1114() { + q("CREATE TABLE IF NOT EXISTS `item_id` ( +`iid` INT NOT NULL , +`uid` INT NOT NULL , +`face` CHAR( 255 ) NOT NULL , +`dspr` CHAR( 255 ) NOT NULL , +`twit` CHAR( 255 ) NOT NULL , +`stat` CHAR( 255 ) NOT NULL , +PRIMARY KEY ( `iid` ), +INDEX ( `uid` ), +INDEX ( `face` ), +INDEX ( `dspr` ), +INDEX ( `twit` ), +INDEX ( `stat` ) +) ENGINE = MYISAM "); + +} |