From 966179a90dfa6982dc973ee996fed7b663366560 Mon Sep 17 00:00:00 2001 From: Jan Schneider Date: Fri, 28 Jan 2011 18:42:05 +0100 Subject: [PATCH] DataTree tables don't need to be created anymore. --- horde/scripts/sql/horde_datatree.mssql.sql | 32 ------------------------- horde/scripts/sql/horde_datatree.mysql.sql | 29 ----------------------- horde/scripts/sql/horde_datatree.pgsql.sql | 38 ------------------------------ horde/scripts/sql/horde_datatree.sql | 38 ------------------------------ 4 files changed, 137 deletions(-) delete mode 100644 horde/scripts/sql/horde_datatree.mssql.sql delete mode 100644 horde/scripts/sql/horde_datatree.mysql.sql delete mode 100644 horde/scripts/sql/horde_datatree.pgsql.sql delete mode 100644 horde/scripts/sql/horde_datatree.sql diff --git a/horde/scripts/sql/horde_datatree.mssql.sql b/horde/scripts/sql/horde_datatree.mssql.sql deleted file mode 100644 index fef6b31af..000000000 --- a/horde/scripts/sql/horde_datatree.mssql.sql +++ /dev/null @@ -1,32 +0,0 @@ -CREATE TABLE horde_datatree ( - datatree_id INT NOT NULL, - group_uid VARCHAR(255) NOT NULL, - user_uid VARCHAR(255) NOT NULL, - datatree_name VARCHAR(255) NOT NULL, - datatree_parents VARCHAR(255) NOT NULL, - datatree_order INT, - datatree_data VARCHAR(MAX), - datatree_serialized SMALLINT DEFAULT 0 NOT NULL, - - PRIMARY KEY (datatree_id) -); - -CREATE INDEX datatree_datatree_name_idx ON horde_datatree (datatree_name); -CREATE INDEX datatree_group_idx ON horde_datatree (group_uid); -CREATE INDEX datatree_user_idx ON horde_datatree (user_uid); -CREATE INDEX datatree_order_idx ON horde_datatree (datatree_order); -CREATE INDEX datatree_serialized_idx ON horde_datatree (datatree_serialized); -CREATE INDEX datatree_parents_idx ON horde_datatree (datatree_parents); - - -CREATE TABLE horde_datatree_attributes ( - datatree_id INT NOT NULL, - attribute_name VARCHAR(255) NOT NULL, - attribute_key VARCHAR(255), - attribute_value VARCHAR(MAX) -); - -CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes (datatree_id); -CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes (attribute_name); -CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes (attribute_key); -CREATE INDEX datatree_attribute_value_idx ON horde_datatree_attributes (attribute_value); diff --git a/horde/scripts/sql/horde_datatree.mysql.sql b/horde/scripts/sql/horde_datatree.mysql.sql deleted file mode 100644 index d59c9737a..000000000 --- a/horde/scripts/sql/horde_datatree.mysql.sql +++ /dev/null @@ -1,29 +0,0 @@ -CREATE TABLE horde_datatree ( - datatree_id INT NOT NULL, - group_uid VARCHAR(255) NOT NULL, - user_uid VARCHAR(255) NOT NULL, - datatree_name VARCHAR(255) NOT NULL, - datatree_parents VARCHAR(255) NOT NULL, - datatree_order INT, - datatree_data TEXT, - datatree_serialized SMALLINT DEFAULT 0 NOT NULL, - PRIMARY KEY (datatree_id) -); - -CREATE INDEX datatree_datatree_name_idx ON horde_datatree (datatree_name); -CREATE INDEX datatree_group_idx ON horde_datatree (group_uid); -CREATE INDEX datatree_user_idx ON horde_datatree (user_uid); -CREATE INDEX datatree_serialized_idx ON horde_datatree (datatree_serialized); -CREATE INDEX datatree_parents_idx ON horde_datatree (datatree_parents); - -CREATE TABLE horde_datatree_attributes ( - datatree_id INT NOT NULL, - attribute_name VARCHAR(255) NOT NULL, - attribute_key VARCHAR(255) DEFAULT '' NOT NULL, - attribute_value TEXT -); - -CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes (datatree_id); -CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes (attribute_name); -CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes (attribute_key); -CREATE INDEX datatree_attribute_value_idx ON horde_datatree_attributes (attribute_value(255)); diff --git a/horde/scripts/sql/horde_datatree.pgsql.sql b/horde/scripts/sql/horde_datatree.pgsql.sql deleted file mode 100644 index 24722519a..000000000 --- a/horde/scripts/sql/horde_datatree.pgsql.sql +++ /dev/null @@ -1,38 +0,0 @@ -CREATE TABLE horde_datatree ( - datatree_id INT NOT NULL, - group_uid VARCHAR(255) NOT NULL, - user_uid VARCHAR(255) NOT NULL, - datatree_name VARCHAR(255) NOT NULL, - datatree_parents VARCHAR(255) NOT NULL, - datatree_order INT, - --- There is no portable way to do this apparently. If your db doesn't --- allow TEXT columns, then maybe it allows large VARCHAR columns, so --- try the second line. --- - datatree_data TEXT, --- datatree_data VARCHAR(4096), - - datatree_serialized SMALLINT DEFAULT 0 NOT NULL, - - PRIMARY KEY (datatree_id) -); - -CREATE INDEX datatree_datatree_name_idx ON horde_datatree (datatree_name); -CREATE INDEX datatree_group_idx ON horde_datatree (group_uid); -CREATE INDEX datatree_user_idx ON horde_datatree (user_uid); -CREATE INDEX datatree_order_idx ON horde_datatree (datatree_order); -CREATE INDEX datatree_serialized_idx ON horde_datatree (datatree_serialized); -CREATE INDEX datatree_parents_idx ON horde_datatree (datatree_parents); - -CREATE TABLE horde_datatree_attributes ( - datatree_id INT NOT NULL, - attribute_name VARCHAR(255) NOT NULL, - attribute_key VARCHAR(255), - attribute_value TEXT -); - -CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes USING HASH(datatree_id); -CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes (attribute_name); -CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes (attribute_key); -CREATE INDEX datatree_attribute_value_idx ON horde_datatree_attributes (attribute_value); diff --git a/horde/scripts/sql/horde_datatree.sql b/horde/scripts/sql/horde_datatree.sql deleted file mode 100644 index b0629a529..000000000 --- a/horde/scripts/sql/horde_datatree.sql +++ /dev/null @@ -1,38 +0,0 @@ -CREATE TABLE horde_datatree ( - datatree_id INT NOT NULL, - group_uid VARCHAR(255) NOT NULL, - user_uid VARCHAR(255) NOT NULL, - datatree_name VARCHAR(255) NOT NULL, - datatree_parents VARCHAR(255) NOT NULL, - datatree_order INT, - --- There is no portable way to do this apparently. If your db doesn't --- allow TEXT columns, then maybe it allows large VARCHAR columns, so --- try the second line. --- - datatree_data TEXT, --- datatree_data VARCHAR(4096), - - datatree_serialized SMALLINT DEFAULT 0 NOT NULL, - - PRIMARY KEY (datatree_id) -); - -CREATE INDEX datatree_datatree_name_idx ON horde_datatree (datatree_name); -CREATE INDEX datatree_group_idx ON horde_datatree (group_uid); -CREATE INDEX datatree_user_idx ON horde_datatree (user_uid); -CREATE INDEX datatree_order_idx ON horde_datatree (datatree_order); -CREATE INDEX datatree_serialized_idx ON horde_datatree (datatree_serialized); -CREATE INDEX datatree_parents_idx ON horde_datatree (datatree_parents); - -CREATE TABLE horde_datatree_attributes ( - datatree_id INT NOT NULL, - attribute_name VARCHAR(255) NOT NULL, - attribute_key VARCHAR(255), - attribute_value TEXT -); - -CREATE INDEX datatree_attribute_idx ON horde_datatree_attributes (datatree_id); -CREATE INDEX datatree_attribute_name_idx ON horde_datatree_attributes (attribute_name); -CREATE INDEX datatree_attribute_key_idx ON horde_datatree_attributes (attribute_key); -CREATE INDEX datatree_attribute_value_idx ON horde_datatree_attributes (attribute_value); -- 2.11.0