From ef304a546c2695e13bdcae448c5d3be4337b8e26 Mon Sep 17 00:00:00 2001 From: "Michael J. Rubinsky" Date: Wed, 6 Oct 2010 11:47:13 -0400 Subject: [PATCH] Mnemo migrations --- mnemo/migration/1_mnemo_base_tables.php | 97 ++++++ mnemo/migration/2_mnemo_upgrade_autoincrement.php | 33 ++ mnemo/scripts/sql/mnemo.mssql.sql | 55 ---- mnemo/scripts/sql/mnemo.oci8.sql | 55 ---- mnemo/scripts/sql/mnemo.sql | 55 ---- mnemo/scripts/sql/mnemo.xml | 339 --------------------- mnemo/scripts/upgrades/1.1_to_2.0.mysql.sql | 17 -- mnemo/scripts/upgrades/1.1_to_2.0.pgsql.sql | 42 --- mnemo/scripts/upgrades/2.1_to_2.2.oci8.sql | 40 --- mnemo/scripts/upgrades/2.1_to_2.2.sql | 40 --- mnemo/scripts/upgrades/2.2.1_to_2.2.2.oci8.sql | 1 - mnemo/scripts/upgrades/2.2.1_to_2.2.2.pgsql.sql | 1 - mnemo/scripts/upgrades/2.2.1_to_2.2.2.sql | 1 - mnemo/scripts/upgrades/2.2_to_2.2.1.oci8.sql | 2 - mnemo/scripts/upgrades/2.2_to_2.2.1.pgsql.sql | 2 - mnemo/scripts/upgrades/2.2_to_2.2.1.sql | 2 - .../upgrades/2008-06-17_fix_varchar_lengths.sql | 2 - .../scripts/upgrades/2008-09-23_fix_group_uid.sql | 1 - 18 files changed, 130 insertions(+), 655 deletions(-) create mode 100644 mnemo/migration/1_mnemo_base_tables.php create mode 100644 mnemo/migration/2_mnemo_upgrade_autoincrement.php delete mode 100644 mnemo/scripts/sql/mnemo.mssql.sql delete mode 100644 mnemo/scripts/sql/mnemo.oci8.sql delete mode 100644 mnemo/scripts/sql/mnemo.sql delete mode 100644 mnemo/scripts/sql/mnemo.xml delete mode 100644 mnemo/scripts/upgrades/1.1_to_2.0.mysql.sql delete mode 100644 mnemo/scripts/upgrades/1.1_to_2.0.pgsql.sql delete mode 100644 mnemo/scripts/upgrades/2.1_to_2.2.oci8.sql delete mode 100644 mnemo/scripts/upgrades/2.1_to_2.2.sql delete mode 100644 mnemo/scripts/upgrades/2.2.1_to_2.2.2.oci8.sql delete mode 100644 mnemo/scripts/upgrades/2.2.1_to_2.2.2.pgsql.sql delete mode 100644 mnemo/scripts/upgrades/2.2.1_to_2.2.2.sql delete mode 100644 mnemo/scripts/upgrades/2.2_to_2.2.1.oci8.sql delete mode 100644 mnemo/scripts/upgrades/2.2_to_2.2.1.pgsql.sql delete mode 100644 mnemo/scripts/upgrades/2.2_to_2.2.1.sql delete mode 100644 mnemo/scripts/upgrades/2008-06-17_fix_varchar_lengths.sql delete mode 100644 mnemo/scripts/upgrades/2008-09-23_fix_group_uid.sql diff --git a/mnemo/migration/1_mnemo_base_tables.php b/mnemo/migration/1_mnemo_base_tables.php new file mode 100644 index 000000000..c9ce81936 --- /dev/null +++ b/mnemo/migration/1_mnemo_base_tables.php @@ -0,0 +1,97 @@ + + * @category Horde + * @license http://www.fsf.org/copyleft/gpl.html GPL + * @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('primaryKey' => 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', 'memo_owner'); + $this->addIndex('mnemo_memos', 'memo_uid'); + } + + if (!in_array('mnemo_shares', $tableList)) { + $t = $this->createTable('mnemo_shares', array('primaryKey' => 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', 'share_name'); + $this->addIndex('mnemo_shares', 'share_owner'); + $this->addIndex('mnemo_shares', 'perm_creator'); + $this->addIndex('mnemo_shares', 'perm_default'); + $this->addIndex('mnemo_shares', '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', 'share_id'); + $this->addIndex('mnemo_shares_groups', 'group_uid'); + $this->addIndex('mnemo_shares_groups', '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_id', 'string', array('limit' => 255)); + $t->column('perm', 'integer', array('null' => false)); + $t->end(); + + $this->addIndex('mnemo_shares_users', 'share_id'); + $this->addIndex('mnemo_shares_users', 'user_id'); + $this->addIndex('mnemo_shares_users', 'perm'); + } + } + + /** + * Downgrade + * + */ + public function down() + { + $this->dropTable('mnemo_memos'); + $this->dropTable('mnemo_shares'); + $this->dropTable('mnemo_shares_users'); + $this->dropTable('mnemo_shares_groups'); + } + +} diff --git a/mnemo/migration/2_mnemo_upgrade_autoincrement.php b/mnemo/migration/2_mnemo_upgrade_autoincrement.php new file mode 100644 index 000000000..d6e99d2f6 --- /dev/null +++ b/mnemo/migration/2_mnemo_upgrade_autoincrement.php @@ -0,0 +1,33 @@ + + * @category Horde + * @license http://www.fsf.org/copyleft/gpl.html GPL + * @package Mnemo + */ +class MnemoUpgradeAutoIncrement extends Horde_Db_Migration_Base +{ + /** + * Upgrade. + */ + public function up() + { + $this->changeColumn('mnemo_shares', 'share_id', 'integer', array('null' => false, 'autoincrement' => true)); + } + + /** + * Downgrade + */ + public function down() + { + $this->changeColumn('mnemo_shares', 'share_id', 'integer', array('null' => false)); + } + +} \ No newline at end of file diff --git a/mnemo/scripts/sql/mnemo.mssql.sql b/mnemo/scripts/sql/mnemo.mssql.sql deleted file mode 100644 index 1e24bb692..000000000 --- a/mnemo/scripts/sql/mnemo.mssql.sql +++ /dev/null @@ -1,55 +0,0 @@ --- $Horde: mnemo/scripts/sql/mnemo.mssql.sql,v 1.9 2009/10/20 21:28:29 jan Exp $ - -CREATE TABLE mnemo_memos ( - memo_owner VARCHAR(255) NOT NULL, - memo_id VARCHAR(32) NOT NULL, - memo_uid VARCHAR(255) NOT NULL, - memo_desc VARCHAR(64) NOT NULL, - memo_body VARCHAR(MAX), - memo_category VARCHAR(80), - memo_private SMALLINT DEFAULT 0 NOT NULL, --- - PRIMARY KEY (memo_owner, memo_id) -); - -CREATE INDEX mnemo_notepad_idx ON mnemo_memos (memo_owner); -CREATE INDEX mnemo_uid_idx ON mnemo_memos (memo_uid); - -CREATE TABLE mnemo_shares ( - share_id INT NOT NULL, - share_name VARCHAR(255) NOT NULL, - share_owner VARCHAR(255) NOT NULL, - share_flags SMALLINT DEFAULT 0 NOT NULL, - perm_creator SMALLINT DEFAULT 0 NOT NULL, - perm_default SMALLINT DEFAULT 0 NOT NULL, - perm_guest SMALLINT DEFAULT 0 NOT NULL, - attribute_name VARCHAR(255) NOT NULL, - attribute_desc VARCHAR(255), - PRIMARY KEY (share_id) -); - -CREATE INDEX mnemo_shares_share_name_idx ON mnemo_shares (share_name); -CREATE INDEX mnemo_shares_share_owner_idx ON mnemo_shares (share_owner); -CREATE INDEX mnemo_shares_perm_creator_idx ON mnemo_shares (perm_creator); -CREATE INDEX mnemo_shares_perm_default_idx ON mnemo_shares (perm_default); -CREATE INDEX mnemo_shares_perm_guest_idx ON mnemo_shares (perm_guest); - -CREATE TABLE mnemo_shares_groups ( - share_id INT NOT NULL, - group_uid VARCHAR(255) NOT NULL, - perm SMALLINT NOT NULL -); - -CREATE INDEX mnemo_shares_groups_share_id_idx ON mnemo_shares_groups (share_id); -CREATE INDEX mnemo_shares_groups_group_uid_idx ON mnemo_shares_groups (group_uid); -CREATE INDEX mnemo_shares_groups_perm_idx ON mnemo_shares_groups (perm); - -CREATE TABLE mnemo_shares_users ( - share_id INT NOT NULL, - user_uid VARCHAR(255) NOT NULL, - perm SMALLINT NOT NULL -); - -CREATE INDEX mnemo_shares_users_share_id_idx ON mnemo_shares_users (share_id); -CREATE INDEX mnemo_shares_users_user_uid_idx ON mnemo_shares_users (user_uid); -CREATE INDEX mnemo_shares_users_perm_idx ON mnemo_shares_users (perm); diff --git a/mnemo/scripts/sql/mnemo.oci8.sql b/mnemo/scripts/sql/mnemo.oci8.sql deleted file mode 100644 index 284dda765..000000000 --- a/mnemo/scripts/sql/mnemo.oci8.sql +++ /dev/null @@ -1,55 +0,0 @@ --- $Horde: mnemo/scripts/sql/mnemo.oci8.sql,v 1.10 2009/10/20 21:28:29 jan Exp $ - -CREATE TABLE mnemo_memos ( - memo_owner VARCHAR2(255) NOT NULL, - memo_id VARCHAR2(32) NOT NULL, - memo_uid VARCHAR2(255) NOT NULL, - memo_desc VARCHAR2(64) NOT NULL, - memo_body VARCHAR2(4000), - memo_category VARCHAR2(80), - memo_private NUMBER(1) DEFAULT 0 NOT NULL, --- - PRIMARY KEY (memo_owner, memo_id) -); - -CREATE INDEX mnemo_notepad_idx ON mnemo_memos (memo_owner); -CREATE INDEX mnemo_uid_idx ON mnemo_memos (memo_uid); - -CREATE TABLE mnemo_shares ( - share_id NUMBER(16) NOT NULL, - share_name VARCHAR2(255) NOT NULL, - share_owner VARCHAR2(255) NOT NULL, - share_flags NUMBER(8) DEFAULT 0 NOT NULL, - perm_creator NUMBER(8) DEFAULT 0 NOT NULL, - perm_default NUMBER(8) DEFAULT 0 NOT NULL, - perm_guest NUMBER(8) DEFAULT 0 NOT NULL, - attribute_name VARCHAR2(255) NOT NULL, - attribute_desc VARCHAR2(255), - PRIMARY KEY (share_id) -); - -CREATE INDEX mnemo_shares_name_idx ON mnemo_shares (share_name); -CREATE INDEX mnemo_shares_owner_idx ON mnemo_shares (share_owner); -CREATE INDEX mnemo_shares_creator_idx ON mnemo_shares (perm_creator); -CREATE INDEX mnemo_shares_default_idx ON mnemo_shares (perm_default); -CREATE INDEX mnemo_shares_guest_idx ON mnemo_shares (perm_guest); - -CREATE TABLE mnemo_shares_groups ( - share_id NUMBER(16) NOT NULL, - group_uid VARCHAR2(255) NOT NULL, - perm NUMBER(8) NOT NULL -); - -CREATE INDEX mnemo_groups_share_id_idx ON mnemo_shares_groups (share_id); -CREATE INDEX mnemo_groups_group_uid_idx ON mnemo_shares_groups (group_uid); -CREATE INDEX mnemo_groups_perm_idx ON mnemo_shares_groups (perm); - -CREATE TABLE mnemo_shares_users ( - share_id NUMBER(16) NOT NULL, - user_uid VARCHAR2(255) NOT NULL, - perm NUMBER(8) NOT NULL -); - -CREATE INDEX mnemo_users_share_id_idx ON mnemo_shares_users (share_id); -CREATE INDEX mnemo_users_user_uid_idx ON mnemo_shares_users (user_uid); -CREATE INDEX mnemo_users_perm_idx ON mnemo_shares_users (perm); diff --git a/mnemo/scripts/sql/mnemo.sql b/mnemo/scripts/sql/mnemo.sql deleted file mode 100644 index 906355c45..000000000 --- a/mnemo/scripts/sql/mnemo.sql +++ /dev/null @@ -1,55 +0,0 @@ --- $Horde: mnemo/scripts/sql/mnemo.sql,v 1.13 2009/10/20 21:28:29 jan Exp $ - -CREATE TABLE mnemo_memos ( - memo_owner VARCHAR(255) NOT NULL, - memo_id VARCHAR(32) NOT NULL, - memo_uid VARCHAR(255) NOT NULL, - memo_desc VARCHAR(64) NOT NULL, - memo_body TEXT, - memo_category VARCHAR(80), - memo_private SMALLINT DEFAULT 0 NOT NULL, --- - PRIMARY KEY (memo_owner, memo_id) -); - -CREATE INDEX mnemo_notepad_idx ON mnemo_memos (memo_owner); -CREATE INDEX mnemo_uid_idx ON mnemo_memos (memo_uid); - -CREATE TABLE mnemo_shares ( - share_id INT NOT NULL, - share_name VARCHAR(255) NOT NULL, - share_owner VARCHAR(255) NOT NULL, - share_flags SMALLINT DEFAULT 0 NOT NULL, - perm_creator SMALLINT DEFAULT 0 NOT NULL, - perm_default SMALLINT DEFAULT 0 NOT NULL, - perm_guest SMALLINT DEFAULT 0 NOT NULL, - attribute_name VARCHAR(255) NOT NULL, - attribute_desc VARCHAR(255), - PRIMARY KEY (share_id) -); - -CREATE INDEX mnemo_shares_share_name_idx ON mnemo_shares (share_name); -CREATE INDEX mnemo_shares_share_owner_idx ON mnemo_shares (share_owner); -CREATE INDEX mnemo_shares_perm_creator_idx ON mnemo_shares (perm_creator); -CREATE INDEX mnemo_shares_perm_default_idx ON mnemo_shares (perm_default); -CREATE INDEX mnemo_shares_perm_guest_idx ON mnemo_shares (perm_guest); - -CREATE TABLE mnemo_shares_groups ( - share_id INT NOT NULL, - group_uid VARCHAR(255) NOT NULL, - perm SMALLINT NOT NULL -); - -CREATE INDEX mnemo_shares_groups_share_id_idx ON mnemo_shares_groups (share_id); -CREATE INDEX mnemo_shares_groups_group_uid_idx ON mnemo_shares_groups (group_uid); -CREATE INDEX mnemo_shares_groups_perm_idx ON mnemo_shares_groups (perm); - -CREATE TABLE mnemo_shares_users ( - share_id INT NOT NULL, - user_uid VARCHAR(255) NOT NULL, - perm SMALLINT NOT NULL -); - -CREATE INDEX mnemo_shares_users_share_id_idx ON mnemo_shares_users (share_id); -CREATE INDEX mnemo_shares_users_user_uid_idx ON mnemo_shares_users (user_uid); -CREATE INDEX mnemo_shares_users_perm_idx ON mnemo_shares_users (perm); diff --git a/mnemo/scripts/sql/mnemo.xml b/mnemo/scripts/sql/mnemo.xml deleted file mode 100644 index 800074637..000000000 --- a/mnemo/scripts/sql/mnemo.xml +++ /dev/null @@ -1,339 +0,0 @@ - - - - name - false - false - - - - mnemo_memos - - - - - memo_owner - text - 255 - true - - - - memo_id - text - 32 - true - - - - memo_uid - text - 255 - true - - - - memo_desc - text - 64 - true - - - - memo_body - clob - - - - memo_category - text - 80 - - - - memo_private - integer - 1 - true - 0 - - - - mnemo_primary - true - - memo_owner - - - memo_id - - - - - mnemo_notepad - - memo_owner - ascending - - - - - mnemo_uid - - memo_uid - ascending - - - - - -
- - - - mnemo_shares - - - - - share_id - integer - - true - 4 - - - - share_name - text - - true - 255 - - - - share_owner - text - - true - 255 - - - - share_flags - integer - 0 - true - 2 - - - - perm_creator - integer - 0 - true - 2 - - - - perm_default - integer - 0 - true - 2 - - - - perm_guest - integer - 0 - true - 2 - - - - attribute_name - text - - true - 255 - - - - attribute_desc - text - - false - 255 - - - - mnemo_shares_name - - share_name - ascending - - - - - mnemo_shares_owner - - share_owner - ascending - - - - - mnemo_shares_creator - - perm_creator - ascending - - - - - mnemo_shares_default - - perm_default - ascending - - - - - mnemo_shares_guest - - perm_guest - ascending - - - - - mnemo_shares_pKey - true - - share_id - ascending - - - - - -
- - - - mnemo_shares_groups - - - - - share_id - integer - - true - 4 - - - - group_uid - text - - true - 255 - - - - perm - integer - - true - 2 - - - - mnemo_groups_share_id - - share_id - ascending - - - - - mnemo_groups_group_uid - - group_uid - ascending - - - - - mnemo_groups_perm - - perm - ascending - - - - - -
- - - - mnemo_shares_users - - - - - share_id - integer - - true - 4 - - - - user_uid - text - - true - 255 - - - - perm - integer - - true - 2 - - - - mnemo_users_share_id - - share_id - ascending - - - - - mnemo_users_user_uid - - user_uid - ascending - - - - - mnemo_users_perm - - perm - ascending - - - - - -
- - diff --git a/mnemo/scripts/upgrades/1.1_to_2.0.mysql.sql b/mnemo/scripts/upgrades/1.1_to_2.0.mysql.sql deleted file mode 100644 index fc295fee1..000000000 --- a/mnemo/scripts/upgrades/1.1_to_2.0.mysql.sql +++ /dev/null @@ -1,17 +0,0 @@ --- $Horde: mnemo/scripts/upgrades/1.1_to_2.0.mysql.sql,v 1.8 2009/10/20 21:28:29 jan Exp $ --- --- You can simply execute this file in your database. --- --- Run as: --- --- $ mysql --user=root --password= < 1.1_to_2.0.mysql.sql - -ALTER TABLE mnemo_memos DROP COLUMN memo_modified; - -ALTER TABLE mnemo_memos ADD COLUMN memo_uid VARCHAR(255) NOT NULL; - -ALTER TABLE mnemo_memos CHANGE COLUMN memo_id memo_id VARCHAR(32) NOT NULL; -ALTER TABLE mnemo_memos CHANGE COLUMN memo_category memo_category VARCHAR(80); -ALTER TABLE mnemo_memos CHANGE COLUMN memo_private memo_private SMALLINT DEFAULT 0 NOT NULL; - -CREATE INDEX mnemo_uid_idx ON mnemo_memos (memo_uid); diff --git a/mnemo/scripts/upgrades/1.1_to_2.0.pgsql.sql b/mnemo/scripts/upgrades/1.1_to_2.0.pgsql.sql deleted file mode 100644 index 455ee6a7c..000000000 --- a/mnemo/scripts/upgrades/1.1_to_2.0.pgsql.sql +++ /dev/null @@ -1,42 +0,0 @@ --- Update script to update mnemo 1.1 data to 2.x data for pgsql --- Converted from mysql version by Daniel E. Markle --- --- You can simply execute this file in your database. --- --- Run as: --- --- $ psql -f < 1.1_to_2.0.pgsql.sql - -ALTER TABLE mnemo_memos DROP COLUMN memo_modified; - -BEGIN; -ALTER TABLE mnemo_memos ADD COLUMN memo_uid VARCHAR(255); -UPDATE mnemo_memos SET memo_uid = ''; -ALTER TABLE mnemo_memos ALTER COLUMN memo_uid SET NOT NULL; -COMMIT; - -BEGIN; -ALTER TABLE mnemo_memos ADD COLUMN memo_id_new VARCHAR(32); -UPDATE mnemo_memos SET memo_id_new = memo_id; -ALTER TABLE mnemo_memos DROP memo_id; -ALTER TABLE mnemo_memos RENAME memo_id_new TO memo_id; -ALTER TABLE mnemo_memos ALTER COLUMN memo_id SET NOT NULL; -COMMIT; - -BEGIN; -ALTER TABLE mnemo_memos ADD COLUMN memo_category_new VARCHAR(80); -UPDATE mnemo_memos SET memo_category_new = memo_category; -ALTER TABLE mnemo_memos DROP memo_category; -ALTER TABLE mnemo_memos RENAME memo_category_new TO memo_category; -COMMIT; - -BEGIN; -ALTER TABLE mnemo_memos ADD COLUMN memo_private_new SMALLINT; -UPDATE mnemo_memos SET memo_private_new = memo_private; -ALTER TABLE mnemo_memos DROP memo_private; -ALTER TABLE mnemo_memos RENAME memo_private_new TO memo_private; -ALTER TABLE mnemo_memos ALTER COLUMN memo_private SET NOT NULL; -ALTER TABLE mnemo_memos ALTER COLUMN memo_private SET DEFAULT 0; -COMMIT; - -CREATE INDEX mnemo_uid_idx ON mnemo_memos (memo_uid); diff --git a/mnemo/scripts/upgrades/2.1_to_2.2.oci8.sql b/mnemo/scripts/upgrades/2.1_to_2.2.oci8.sql deleted file mode 100644 index 7b2c53cd6..000000000 --- a/mnemo/scripts/upgrades/2.1_to_2.2.oci8.sql +++ /dev/null @@ -1,40 +0,0 @@ --- $Horde: mnemo/scripts/upgrades/2.1_to_2.2.oci8.sql,v 1.3 2009/10/20 21:28:29 jan Exp $ - -CREATE TABLE mnemo_shares ( - share_id NUMBER(16) NOT NULL, - share_name VARCHAR2(255) NOT NULL, - share_owner VARCHAR2(32) NOT NULL, - share_flags NUMBER(8) DEFAULT 0 NOT NULL, - perm_creator NUMBER(8) DEFAULT 0 NOT NULL, - perm_default NUMBER(8) DEFAULT 0 NOT NULL, - perm_guest NUMBER(8) DEFAULT 0 NOT NULL, - attribute_name VARCHAR2(255) NOT NULL, - attribute_desc VARCHAR2(255), - PRIMARY KEY (share_id) -); - -CREATE INDEX mnemo_shares_name_idx ON mnemo_shares (share_name); -CREATE INDEX mnemo_shares_owner_idx ON mnemo_shares (share_owner); -CREATE INDEX mnemo_shares_creator_idx ON mnemo_shares (perm_creator); -CREATE INDEX mnemo_shares_default_idx ON mnemo_shares (perm_default); -CREATE INDEX mnemo_shares_guest_idx ON mnemo_shares (perm_guest); - -CREATE TABLE mnemo_shares_groups ( - share_id NUMBER(16) NOT NULL, - group_uid NUMBER(16) NOT NULL, - perm NUMBER(8) NOT NULL -); - -CREATE INDEX mnemo_groups_share_id_idx ON mnemo_shares_groups (share_id); -CREATE INDEX mnemo_groups_group_uid_idx ON mnemo_shares_groups (group_uid); -CREATE INDEX mnemo_groups_perm_idx ON mnemo_shares_groups (perm); - -CREATE TABLE mnemo_shares_users ( - share_id NUMBER(16) NOT NULL, - user_uid VARCHAR2(32) NOT NULL, - perm NUMBER(8) NOT NULL -); - -CREATE INDEX mnemo_users_share_id_idx ON mnemo_shares_users (share_id); -CREATE INDEX mnemo_users_user_uid_idx ON mnemo_shares_users (user_uid); -CREATE INDEX mnemo_users_perm_idx ON mnemo_shares_users (perm); diff --git a/mnemo/scripts/upgrades/2.1_to_2.2.sql b/mnemo/scripts/upgrades/2.1_to_2.2.sql deleted file mode 100644 index f1afbf95b..000000000 --- a/mnemo/scripts/upgrades/2.1_to_2.2.sql +++ /dev/null @@ -1,40 +0,0 @@ --- $Horde: mnemo/scripts/upgrades/2.1_to_2.2.sql,v 1.5 2009/10/20 21:28:29 jan Exp $ - -CREATE TABLE mnemo_shares ( - share_id INT NOT NULL, - share_name VARCHAR(255) NOT NULL, - share_owner VARCHAR(32) NOT NULL, - share_flags SMALLINT DEFAULT 0 NOT NULL, - perm_creator SMALLINT DEFAULT 0 NOT NULL, - perm_default SMALLINT DEFAULT 0 NOT NULL, - perm_guest SMALLINT DEFAULT 0 NOT NULL, - attribute_name VARCHAR(255) NOT NULL, - attribute_desc VARCHAR(255), - PRIMARY KEY (share_id) -); - -CREATE INDEX mnemo_shares_share_name_idx ON mnemo_shares (share_name); -CREATE INDEX mnemo_shares_share_owner_idx ON mnemo_shares (share_owner); -CREATE INDEX mnemo_shares_perm_creator_idx ON mnemo_shares (perm_creator); -CREATE INDEX mnemo_shares_perm_default_idx ON mnemo_shares (perm_default); -CREATE INDEX mnemo_shares_perm_guest_idx ON mnemo_shares (perm_guest); - -CREATE TABLE mnemo_shares_groups ( - share_id INT NOT NULL, - group_uid INT NOT NULL, - perm SMALLINT NOT NULL -); - -CREATE INDEX mnemo_shares_groups_share_id_idx ON mnemo_shares_groups (share_id); -CREATE INDEX mnemo_shares_groups_group_uid_idx ON mnemo_shares_groups (group_uid); -CREATE INDEX mnemo_shares_groups_perm_idx ON mnemo_shares_groups (perm); - -CREATE TABLE mnemo_shares_users ( - share_id INT NOT NULL, - user_uid VARCHAR(32) NOT NULL, - perm SMALLINT NOT NULL -); - -CREATE INDEX mnemo_shares_users_share_id_idx ON mnemo_shares_users (share_id); -CREATE INDEX mnemo_shares_users_user_uid_idx ON mnemo_shares_users (user_uid); -CREATE INDEX mnemo_shares_users_perm_idx ON mnemo_shares_users (perm); diff --git a/mnemo/scripts/upgrades/2.2.1_to_2.2.2.oci8.sql b/mnemo/scripts/upgrades/2.2.1_to_2.2.2.oci8.sql deleted file mode 100644 index a89526b68..000000000 --- a/mnemo/scripts/upgrades/2.2.1_to_2.2.2.oci8.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE mnemo_shares_groups MODIFY group_uid VARCHAR2(255); diff --git a/mnemo/scripts/upgrades/2.2.1_to_2.2.2.pgsql.sql b/mnemo/scripts/upgrades/2.2.1_to_2.2.2.pgsql.sql deleted file mode 100644 index c1fe815d2..000000000 --- a/mnemo/scripts/upgrades/2.2.1_to_2.2.2.pgsql.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE mnemo_shares_groups ALTER group_uid TYPE VARCHAR(255); diff --git a/mnemo/scripts/upgrades/2.2.1_to_2.2.2.sql b/mnemo/scripts/upgrades/2.2.1_to_2.2.2.sql deleted file mode 100644 index f46a8c675..000000000 --- a/mnemo/scripts/upgrades/2.2.1_to_2.2.2.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE mnemo_shares_groups CHANGE group_uid group_uid VARCHAR(255); diff --git a/mnemo/scripts/upgrades/2.2_to_2.2.1.oci8.sql b/mnemo/scripts/upgrades/2.2_to_2.2.1.oci8.sql deleted file mode 100644 index 02f1fa0f8..000000000 --- a/mnemo/scripts/upgrades/2.2_to_2.2.1.oci8.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE mnemo_shares MODIFY share_owner VARCHAR2(255); -ALTER TABLE mnemo_shares_users MODIFY user_uid VARCHAR2(255); diff --git a/mnemo/scripts/upgrades/2.2_to_2.2.1.pgsql.sql b/mnemo/scripts/upgrades/2.2_to_2.2.1.pgsql.sql deleted file mode 100644 index 13d6efd9b..000000000 --- a/mnemo/scripts/upgrades/2.2_to_2.2.1.pgsql.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE mnemo_shares ALTER share_owner TYPE VARCHAR(255); -ALTER TABLE mnemo_shares_users ALTER user_uid TYPE VARCHAR(255); diff --git a/mnemo/scripts/upgrades/2.2_to_2.2.1.sql b/mnemo/scripts/upgrades/2.2_to_2.2.1.sql deleted file mode 100644 index 257e32cbb..000000000 --- a/mnemo/scripts/upgrades/2.2_to_2.2.1.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE mnemo_shares CHANGE share_owner share_owner VARCHAR(255); -ALTER TABLE mnemo_shares_users CHANGE user_uid user_uid VARCHAR(255); diff --git a/mnemo/scripts/upgrades/2008-06-17_fix_varchar_lengths.sql b/mnemo/scripts/upgrades/2008-06-17_fix_varchar_lengths.sql deleted file mode 100644 index 257e32cbb..000000000 --- a/mnemo/scripts/upgrades/2008-06-17_fix_varchar_lengths.sql +++ /dev/null @@ -1,2 +0,0 @@ -ALTER TABLE mnemo_shares CHANGE share_owner share_owner VARCHAR(255); -ALTER TABLE mnemo_shares_users CHANGE user_uid user_uid VARCHAR(255); diff --git a/mnemo/scripts/upgrades/2008-09-23_fix_group_uid.sql b/mnemo/scripts/upgrades/2008-09-23_fix_group_uid.sql deleted file mode 100644 index f46a8c675..000000000 --- a/mnemo/scripts/upgrades/2008-09-23_fix_group_uid.sql +++ /dev/null @@ -1 +0,0 @@ -ALTER TABLE mnemo_shares_groups CHANGE group_uid group_uid VARCHAR(255); -- 2.11.0