From d714aa5e6236d0752d0b8c2013cb46f770c6726d Mon Sep 17 00:00:00 2001 From: Jan Schneider Date: Sat, 22 Jan 2011 13:25:50 +0100 Subject: [PATCH] Remove accidentally added file. --- ansel/migration/9_ansel_upgrade_sqlng.php.foo | 176 -------------------------- 1 file changed, 176 deletions(-) delete mode 100644 ansel/migration/9_ansel_upgrade_sqlng.php.foo diff --git a/ansel/migration/9_ansel_upgrade_sqlng.php.foo b/ansel/migration/9_ansel_upgrade_sqlng.php.foo deleted file mode 100644 index be7b787e8..000000000 --- a/ansel/migration/9_ansel_upgrade_sqlng.php.foo +++ /dev/null @@ -1,176 +0,0 @@ - - * @category Horde - * @license http://www.fsf.org/copyleft/gpl.html GPL - * @package Kronolith - */ - -require_once dirname(__FILE__) . '/../lib/Kronolith.php'; - -/** - * Adds tables for the Sqlng share driver. - * - * Copyright 2011 The Horde Project (http://www.horde.org/) - * - * See the enclosed file COPYING for license information (GPL). If you - * did not receive this file, see http://www.fsf.org/copyleft/gpl.html. - * - * @author Jan Schneider - * @category Horde - * @license http://www.fsf.org/copyleft/gpl.html GPL - * @package Kronolith - */ -class KronolithUpgradeSqlng extends Horde_Db_Migration_Base -{ - /** - * Upgrade. - */ - public function up() - { - $t = $this->createTable('kronolith_sharesng', array('primaryKey' => 'share_id')); - $t->column('share_name', 'string', array('limit' => 255, 'null' => false)); - $t->column('share_owner', 'string', array('limit' => 255)); - $t->column('share_flags', 'integer', array('default' => 0, 'null' => false)); - $t->column('perm_creator_' . Horde_Perms::SHOW, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_creator_' . Horde_Perms::READ, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_creator_' . Horde_Perms::EDIT, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_creator_' . Horde_Perms::DELETE, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_creator_' . Kronolith::PERMS_DELEGATE, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_default_' . Horde_Perms::SHOW, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_default_' . Horde_Perms::READ, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_default_' . Horde_Perms::EDIT, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_default_' . Horde_Perms::DELETE, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_default_' . Kronolith::PERMS_DELEGATE, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_guest_' . Horde_Perms::SHOW, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_guest_' . Horde_Perms::READ, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_guest_' . Horde_Perms::EDIT, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_guest_' . Horde_Perms::DELETE, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_guest_' . Kronolith::PERMS_DELEGATE, 'boolean', array('default' => false, 'null' => false)); - $t->column('attribute_name', 'string', array('limit' => 255, 'null' => false)); - $t->column('attribute_desc', 'string', array('limit' => 255)); - $t->column('attribute_color', 'string', array('limit' => 7)); - $t->end(); - - $this->addIndex('kronolith_sharesng', array('share_name')); - $this->addIndex('kronolith_sharesng', array('share_owner')); - $this->addIndex('kronolith_sharesng', array('perm_creator_' . Horde_Perms::SHOW)); - $this->addIndex('kronolith_sharesng', array('perm_creator_' . Horde_Perms::READ)); - $this->addIndex('kronolith_sharesng', array('perm_creator_' . Horde_Perms::EDIT)); - $this->addIndex('kronolith_sharesng', array('perm_creator_' . Horde_Perms::DELETE)); - $this->addIndex('kronolith_sharesng', array('perm_creator_' . Kronolith::PERMS_DELEGATE)); - $this->addIndex('kronolith_sharesng', array('perm_default_' . Horde_Perms::SHOW)); - $this->addIndex('kronolith_sharesng', array('perm_default_' . Horde_Perms::READ)); - $this->addIndex('kronolith_sharesng', array('perm_default_' . Horde_Perms::EDIT)); - $this->addIndex('kronolith_sharesng', array('perm_default_' . Horde_Perms::DELETE)); - $this->addIndex('kronolith_sharesng', array('perm_default_' . Kronolith::PERMS_DELEGATE)); - $this->addIndex('kronolith_sharesng', array('perm_guest_' . Horde_Perms::SHOW)); - $this->addIndex('kronolith_sharesng', array('perm_guest_' . Horde_Perms::READ)); - $this->addIndex('kronolith_sharesng', array('perm_guest_' . Horde_Perms::EDIT)); - $this->addIndex('kronolith_sharesng', array('perm_guest_' . Horde_Perms::DELETE)); - $this->addIndex('kronolith_sharesng', array('perm_guest_' . Kronolith::PERMS_DELEGATE)); - - $t = $this->createTable('kronolith_sharesng_groups', array('primaryKey' => false)); - $t->column('share_id', 'integer', array('null' => false)); - $t->column('group_uid', 'string', array('limit' => 255, 'null' => false)); - $t->column('perm_' . Horde_Perms::SHOW, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_' . Horde_Perms::READ, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_' . Horde_Perms::EDIT, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_' . Horde_Perms::DELETE, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_' . Kronolith::PERMS_DELEGATE, 'boolean', array('default' => false, 'null' => false)); - $t->end(); - - $this->addIndex('kronolith_sharesng_groups', array('share_id')); - $this->addIndex('kronolith_sharesng_groups', array('group_uid')); - $this->addIndex('kronolith_sharesng_groups', array('perm_' . Horde_Perms::SHOW)); - $this->addIndex('kronolith_sharesng_groups', array('perm_' . Horde_Perms::READ)); - $this->addIndex('kronolith_sharesng_groups', array('perm_' . Horde_Perms::EDIT)); - $this->addIndex('kronolith_sharesng_groups', array('perm_' . Horde_Perms::DELETE)); - $this->addIndex('kronolith_sharesng_groups', array('perm_' . Kronolith::PERMS_DELEGATE)); - - $t = $this->createTable('kronolith_sharesng_users', array('primaryKey' => false)); - $t->column('share_id', 'integer', array('null' => false)); - $t->column('user_uid', 'string', array('limit' => 255)); - $t->column('perm_' . Horde_Perms::SHOW, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_' . Horde_Perms::READ, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_' . Horde_Perms::EDIT, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_' . Horde_Perms::DELETE, 'boolean', array('default' => false, 'null' => false)); - $t->column('perm_' . Kronolith::PERMS_DELEGATE, 'boolean', array('default' => false, 'null' => false)); - $t->end(); - - $this->addIndex('kronolith_sharesng_users', array('share_id')); - $this->addIndex('kronolith_sharesng_users', array('user_uid')); - $this->addIndex('kronolith_sharesng_users', array('perm_' . Horde_Perms::SHOW)); - $this->addIndex('kronolith_sharesng_users', array('perm_' . Horde_Perms::READ)); - $this->addIndex('kronolith_sharesng_users', array('perm_' . Horde_Perms::EDIT)); - $this->addIndex('kronolith_sharesng_users', array('perm_' . Horde_Perms::DELETE)); - $this->addIndex('kronolith_sharesng_users', array('perm_' . Kronolith::PERMS_DELEGATE)); - - $this->dataUp(); - } - - /** - * Downgrade - */ - public function down() - { - $this->dropTable('kronolith_sharesng'); - $this->dropTable('kronolith_sharesng_groups'); - $this->dropTable('kronolith_sharesng_users'); - } - - public function dataUp() - { - $whos = array('creator', 'default', 'guest'); - $perms = array(Horde_Perms::SHOW, - Horde_Perms::READ, - Horde_Perms::EDIT, - Horde_Perms::DELETE, - Kronolith::PERMS_DELEGATE); - - $sql = 'INSERT INTO kronolith_sharesng (share_id, share_name, share_owner, share_flags, attribute_name, attribute_desc, attribute_color'; - $count = 0; - foreach ($whos as $who) { - foreach ($perms as $perm) { - $sql .= ', perm_' . $who . '_' . $perm; - $count++; - } - } - $sql .= ') VALUES (?, ?, ?, ?, ?, ?, ?' . str_repeat(', ?', $count) . ')'; - - foreach ($this->select('SELECT * FROM kronolith_shares') as $share) { - $values = array($share['share_id'], - $share['share_name'], - $share['share_owner'], - $share['share_flags'], - $share['attribute_name'], - $share['attribute_desc'], - $share['attribute_color']); - foreach ($whos as $who) { - foreach ($perms as $perm) { - $values[] = (bool)($share['perm_' . $who] & $perm); - } - } - $this->insert($sql, $values); - } - - foreach (array('user', 'group') as $what) { - $sql = 'INSERT INTO kronolith_sharesng_' . $what . 's (share_id, ' . $what . '_uid'; - $count = 0; - foreach ($perms as $perm) { - $sql .= ', perm_' . $perm; - $count++; - } - $sql .= ') VALUES (?, ?' . str_repeat(', ?', $count) . ')'; - - foreach ($this->select('SELECT * FROM kronolith_shares_' . $what . 's') as $share) { - $values = array($share['share_id'], - $share[$what . '_uid']); - foreach ($perms as $perm) { - $values[] = (bool)($share['perm'] & $perm); - } - $this->insert($sql, $values); - } - } - } -} -- 2.11.0