From 294035fefa8db80d8ccdf2b7fb86fbea44f60808 Mon Sep 17 00:00:00 2001
From: Jan Schneider <jan@horde.org>
Date: Fri, 20 Feb 2009 01:23:14 +0100
Subject: [PATCH] Add color attribute.

---
 kronolith/scripts/sql/kronolith.mssql.sql                     | 1 +
 kronolith/scripts/sql/kronolith.mysql.sql                     | 1 +
 kronolith/scripts/sql/kronolith.oci8.sql                      | 1 +
 kronolith/scripts/sql/kronolith.pgsql.sql                     | 1 +
 kronolith/scripts/sql/kronolith.sql                           | 1 +
 kronolith/scripts/sql/kronolith.xml                           | 8 ++++++++
 kronolith/scripts/upgrades/2009-02-20_add_attribute_color.sql | 1 +
 7 files changed, 14 insertions(+)
 create mode 100644 kronolith/scripts/upgrades/2009-02-20_add_attribute_color.sql

diff --git a/kronolith/scripts/sql/kronolith.mssql.sql b/kronolith/scripts/sql/kronolith.mssql.sql
index a5abdcf69..b22798fca 100644
--- a/kronolith/scripts/sql/kronolith.mssql.sql
+++ b/kronolith/scripts/sql/kronolith.mssql.sql
@@ -49,6 +49,7 @@ CREATE TABLE kronolith_shares (
     perm_guest SMALLINT NOT NULL DEFAULT 0,
     attribute_name VARCHAR(255) NOT NULL,
     attribute_desc VARCHAR(255),
+    attribute_color VARCHAR(7),
     PRIMARY KEY (share_id)
 );
 
diff --git a/kronolith/scripts/sql/kronolith.mysql.sql b/kronolith/scripts/sql/kronolith.mysql.sql
index c5b7a190e..92e3073c2 100644
--- a/kronolith/scripts/sql/kronolith.mysql.sql
+++ b/kronolith/scripts/sql/kronolith.mysql.sql
@@ -49,6 +49,7 @@ CREATE TABLE kronolith_shares (
     perm_guest SMALLINT NOT NULL DEFAULT 0,
     attribute_name VARCHAR(255) NOT NULL,
     attribute_desc VARCHAR(255),
+    attribute_color VARCHAR(7),
     PRIMARY KEY (share_id)
 );
 
diff --git a/kronolith/scripts/sql/kronolith.oci8.sql b/kronolith/scripts/sql/kronolith.oci8.sql
index e5788ec35..2af01c86d 100644
--- a/kronolith/scripts/sql/kronolith.oci8.sql
+++ b/kronolith/scripts/sql/kronolith.oci8.sql
@@ -49,6 +49,7 @@ CREATE TABLE kronolith_shares (
     perm_guest SMALLINT NOT NULL DEFAULT 0,
     attribute_name VARCHAR2(255) NOT NULL,
     attribute_desc VARCHAR2(255),
+    attribute_color VARCHAR2(7),
     PRIMARY KEY (share_id)
 );
 
diff --git a/kronolith/scripts/sql/kronolith.pgsql.sql b/kronolith/scripts/sql/kronolith.pgsql.sql
index d1924692d..e83c044a8 100644
--- a/kronolith/scripts/sql/kronolith.pgsql.sql
+++ b/kronolith/scripts/sql/kronolith.pgsql.sql
@@ -49,6 +49,7 @@ CREATE TABLE kronolith_shares (
     perm_guest SMALLINT NOT NULL DEFAULT 0,
     attribute_name VARCHAR(255) NOT NULL,
     attribute_desc VARCHAR(255),
+    attribute_color VARCHAR(7),
     PRIMARY KEY (share_id)
 );
 
diff --git a/kronolith/scripts/sql/kronolith.sql b/kronolith/scripts/sql/kronolith.sql
index 2174b3654..e938cd674 100644
--- a/kronolith/scripts/sql/kronolith.sql
+++ b/kronolith/scripts/sql/kronolith.sql
@@ -49,6 +49,7 @@ CREATE TABLE kronolith_shares (
     perm_guest SMALLINT NOT NULL DEFAULT 0,
     attribute_name VARCHAR(255) NOT NULL,
     attribute_desc VARCHAR(255),
+    attribute_color VARCHAR(7),
     PRIMARY KEY (share_id)
 );
 
diff --git a/kronolith/scripts/sql/kronolith.xml b/kronolith/scripts/sql/kronolith.xml
index 8951c80fa..20a1e10c0 100644
--- a/kronolith/scripts/sql/kronolith.xml
+++ b/kronolith/scripts/sql/kronolith.xml
@@ -292,6 +292,14 @@
     <length>255</length>
    </field>
 
+   <field>
+    <name>attribute_color</name>
+    <type>text</type>
+    <default></default>
+    <notnull>false</notnull>
+    <length>7</length>
+   </field>
+
    <index>
     <name>kronolith_shares_share_name</name>
     <field>
diff --git a/kronolith/scripts/upgrades/2009-02-20_add_attribute_color.sql b/kronolith/scripts/upgrades/2009-02-20_add_attribute_color.sql
new file mode 100644
index 000000000..9d65ba128
--- /dev/null
+++ b/kronolith/scripts/upgrades/2009-02-20_add_attribute_color.sql
@@ -0,0 +1 @@
+ALTER TABLE kronolith_shares ADD attribute_color VARCHAR(7);
-- 
2.11.0