基于PHP的TineWeb的群件系统源码.zip

<?php /** * Tine 2.0 * * @package Tinebase * @subpackage Setup * @license http://www.gnu.org/licenses/agpl.html AGPL3 * @copyright Copyright (c) 2008 Metaways Infosystems GmbH (http://www.metaways.de) * @author Lars Kneschke <l.kneschke@metaways.de> */ /** * Tinebase updates for version 0.x * * @package Tinebase * @subpackage Setup */ class Tinebase_Setup_Update_Release0 extends Setup_Update_Abstract { /** * update function 0 * has no real functionality, only shows how its done * */ public function update_0() { // just show how it works $tableDefinition = '<table> <name>test_table</name> <version>1</version> <declaration> <field> <name>id</name> <type>integer</type> <autoincrement>true</autoincrement> </field> <field> <name>name</name> <type>text</type> <length>128</length> <notnull>true</notnull> </field> <index> <name>id</name> <primary>true</primary> <field> <name>id</name> </field> </index> </declaration> </table>' ; $table = Setup_Backend_Schema_Index_Factory::factory('String', $tableDefinition); $this->_backend->createTable($table); $this->_backend->dropTable('test_table'); } /** * update function 1 * adds application rights * */ public function update_1() { $this->validateTableVersion('application_rights', '1'); $declaration = new Setup_Backend_Schema_Field(); $declaration->name = 'account_type'; $declaration->type = 'enum'; $declaration->notnull = 'true'; $declaration->value = array(Tinebase_Acl_Rights::ACCOUNT_TYPE_ANYONE, 'account', Tinebase_Acl_Rights::ACCOUNT_TYPE_GROUP); $this->_backend->addCol('application_rights', $declaration); $declaration = new Setup_Backend_Schema_Field(); $declaration->name = 'right'; $declaration->type = 'text'; $declaration->length = 64; $declaration->notnull = 'true'; $this->_backend->alterCol('application_rights', $declaration); $rightsTable = new Tinebase_Db_Table(array('name' => 'application_rights')); $data = array( 'account_type' => Tinebase_Acl_Rights::ACCOUNT_TYPE_ANYONE ); $where = array( $this->_db->quoteIdentifier('account_id') . ' IS NULL', $this->_db->quoteIdentifier('group_id') . ' IS NULL' ); $rightsTable->update($data, $where); $data = array( 'account_type' => 'account' ); $where = array( $this->_db->quoteIdentifier('account_id') . ' IS NOT NULL', $this->_db->quoteIdentifier('group_id') . ' IS NULL' ); $rightsTable->update($data, $where); $data = array( 'account_type' => Tinebase_Acl_Rights::ACCOUNT_TYPE_GROUP ); $where = array( $this->_db->quoteIdentifier('account_id') . ' IS NULL', $this->_db->quoteIdentifier('group_id') . ' IS NOT NULL' ); $rightsTable->update($data, $where); $data = array( 'account_id' => new Zend_Db_Expr('group_id'), ); $where = array( $rightsTable->getAdapter()->quoteInto($this->_db->quoteIdentifier('account_type') . ' = ?', Tinebase_Acl_Rights::ACCOUNT_TYPE_GROUP), ); $rightsTable->update($data, $where); $this->_backend->dropIndex('application_rights', 'account_id-group_id-application_id-right'); $index = new StdClass(); $index->name = 'account_id-account_type-application_id-right'; $index->unique = 'true'; $index->field = array(); $field = new StdClass(); $field->name = 'account_id'; $index->field[] = $field; $field = new StdClass(); $field->name = 'account_type'; $index->field[] = $field; $field = new StdClass(); $field->name = 'application_id'; $index->field[] = $field; $field = new StdClass(); $field->name = 'right'; $index->field[] = $field; $this->_backend->addIndex( 'application_rights', $index); $this->_backend->dropCol('application_rights', 'group_id'); $this->setTableVersion('application_rights', '2'); $this->setApplicationVersion('Tinebase', '0.2'); } /** * update function 2 * adds roles (tables and user/admin role) * */ public function update_2() { /************ create roles tables **************/ $tableDefinitions = array( '<table> <name>roles</name> <version>1</version> <declaration> <field> <name>id</name> <type>integer</type> <autoincrement>true</autoincrement> </field> <field> <name>name</name> <type>text</type> <length>128</length> <notnull>true</notnull> </field> <field> <name>description</name> <type>text</type> <length>255</length> <notnull>false</notnull> </field> <field> <name>created_by</name> <type>integer</type> </field> <field> <name>creation_time</name> <type>datetime</type> </field> <field> <name>last_modified_by</name> <type>integer</type> </field> <field> <name>last_modified_time</name> <type>datetime</type> </field> <index> <name>id</name> <primary>true</primary> <field> <name>id</name> </field> </index> <index> <name>name</name> <unique>true</unique> <field> <name>name</name> </field> </index> </declaration> </table> ', '<table> <name>role_rights</name> <version>1</version> <declaration> <field> <name>id</name> <type>integer</type> <autoincrement>true</autoincrement> </field> <field> <name>role_id</name> <type>integer</type> <unsigned>true</unsigned> <notnull>true</notnull> </field> <field> <name>application_id</name> <type>integer</type> <length>11</length> <unsigned>true</unsigned> <notnull>true</notnull>