filesystem.updates.inc

groupoffice

<?php
$updates[15] = array();

$updates[14][] = "CREATE TABLE `fs_links` (
  `link_id` int(11) NOT NULL default '0',
  `path` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`link_id`),
  KEY `path` (`path`)
) TYPE=MyISAM;";

$updates[14][] = "ALTER TABLE `fsShares` RENAME `fs_shares` ;"; 

$updates[13] = array();

$updates[12][] = "ALTER TABLE `fsShares` ADD `link_id` INT  AFTER `user_id` ;";
$updates[12][] = "ALTER TABLE `fsShares` ADD INDEX ( `link_id` ) ;";
$updates[12][] = "ALTER TABLE `fsShares` DROP INDEX `path`;";

$updates[11][] = "ALTER TABLE `fsShares` ADD `type` VARCHAR( 50 ) NOT NULL AFTER `path`";
$updates[11][] = "UPDATE `fsShares` SET TYPE = 'filesystem';";
$updates[11][] = "ALTER TABLE `fsShares` ADD INDEX ( `type` );";

$updates[10][] = "DROP TABLE `fs_settings`";
?>