⚝
One Hat Cyber Team
⚝
Your IP:
216.73.216.82
Server IP:
41.128.143.86
Server:
Linux host.raqmix.cloud 6.8.0-1025-azure #30~22.04.1-Ubuntu SMP Wed Mar 12 15:28:20 UTC 2025 x86_64
Server Software:
Apache
PHP Version:
8.3.23
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
usr
/
share
/
psa-horde
/
mnemo
/
migration
/
View File Name :
1_mnemo_base_tables.php
* @category Horde * @license http://www.horde.org/licenses/apache ASL * @package Mnemo */ class MnemoBaseTables extends Horde_Db_Migration_Base { /** * Upgrade. */ public function up() { $tableList = $this->tables(); if (!in_array('mnemo_memos', $tableList)) { $t = $this->createTable('mnemo_memos', array('autoincrementKey' => false)); $t->column('memo_owner', 'string', array('limit' => 255, 'null' => false)); $t->column('memo_id', 'string', array('limit' => 32, 'null' => false)); $t->column('memo_uid', 'string', array('limit' => 255, 'null' => false)); $t->column('memo_desc', 'string', array('limit' => 64, 'null' => false)); $t->column('memo_body', 'text'); $t->column('memo_category', 'string', array('limit' => 80)); $t->column('memo_private', 'integer', array('default' => 0, 'null' => false)); $t->primaryKey(array('memo_owner', 'memo_id')); $t->end(); $this->addIndex('mnemo_memos', array('memo_owner')); $this->addIndex('mnemo_memos', array('memo_uid')); } if (!in_array('mnemo_shares', $tableList)) { $t = $this->createTable('mnemo_shares', array('autoincrementKey' => false)); $t->column('share_id', 'integer', array('null' => false)); $t->column('share_name', 'string', array('limit' => 255, 'null' => false)); $t->column('share_owner', 'string', array('limit' => 255, 'null' => false)); $t->column('share_flags', 'integer', array('default' => 0, 'null' => false)); $t->column('perm_creator', 'integer', array('default' => 0, 'null' => false)); $t->column('perm_default', 'integer', array('default' => 0, 'null' => false)); $t->column('perm_guest', 'integer', array('default' => 0, 'null' => false)); $t->column('attribute_name', 'string', array('limit' => 255, 'null' => false)); $t->column('attribute_desc', 'string', array('limit' => 255)); $t->primaryKey(array('share_id')); $t->end(); $this->addIndex('mnemo_shares', array('share_name')); $this->addIndex('mnemo_shares', array('share_owner')); $this->addIndex('mnemo_shares', array('perm_creator')); $this->addIndex('mnemo_shares', array('perm_default')); $this->addIndex('mnemo_shares', array('perm_guest')); } if (!in_array('mnemo_shares_groups', $tableList)) { $t = $this->createTable('mnemo_shares_groups'); $t->column('share_id', 'integer', array('null' => false)); $t->column('group_uid', 'string', array('limit' => 255, 'null' => false)); $t->column('perm', 'integer', array('null' => false)); $t->end(); $this->addIndex('mnemo_shares_groups', array('share_id')); $this->addIndex('mnemo_shares_groups', array('group_uid')); $this->addIndex('mnemo_shares_groups', array('perm')); } if (!in_array('mnemo_shares_users', $tableList)) { $t = $this->createTable('mnemo_shares_users'); $t->column('share_id', 'integer', array('null' => false)); $t->column('user_uid', 'string', array('limit' => 255, 'null' => false)); $t->column('perm', 'integer', array('null' => false)); $t->end(); $this->addIndex('mnemo_shares_users', array('share_id')); $this->addIndex('mnemo_shares_users', array('user_uid')); $this->addIndex('mnemo_shares_users', array('perm')); } } /** * Downgrade * */ public function down() { $this->dropTable('mnemo_memos'); $this->dropTable('mnemo_shares'); $this->dropTable('mnemo_shares_users'); $this->dropTable('mnemo_shares_groups'); } }