From 6cf5fcad1dba7e4e86e7b83c32b26da6841ab204 Mon Sep 17 00:00:00 2001
From: garvinhicking <garvinhicking>
Date: Thu, 9 Jun 2005 09:24:43 +0000
Subject: [PATCH] fix type to length 200 so that the index key is not > 500.
 Since only two users ever reported problems I'm not creating a new version
 stepping only for this.

---
 sql/db.sql                                       | 2 +-
 sql/db_update_0.9-alpha1_0.9-alpha2_mysql.sql    | 2 +-
 sql/db_update_0.9-alpha1_0.9-alpha2_postgres.sql | 2 +-
 sql/db_update_0.9-alpha1_0.9-alpha2_sqlite.sql   | 2 +-
 4 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/sql/db.sql b/sql/db.sql
index fa491e4..7d4b31c 100644
--- a/sql/db.sql
+++ b/sql/db.sql
@@ -237,7 +237,7 @@ CREATE UNIQUE INDEX prop_idx ON {PREFIX}entryproperties (entryid, property);
 CREATE TABLE {PREFIX}permalinks (
     permalink varchar(255) not null default '',
     entry_id int(10) {UNSIGNED} not null default '0',
-    type varchar(255) not null default '',
+    type varchar(200) not null default '',
     data text
 );
 
diff --git a/sql/db_update_0.9-alpha1_0.9-alpha2_mysql.sql b/sql/db_update_0.9-alpha1_0.9-alpha2_mysql.sql
index 235efac..a95faaa 100644
--- a/sql/db_update_0.9-alpha1_0.9-alpha2_mysql.sql
+++ b/sql/db_update_0.9-alpha1_0.9-alpha2_mysql.sql
@@ -1,7 +1,7 @@
 CREATE TABLE {PREFIX}permalinks (
     permalink varchar(255) not null default '',
     entry_id int(10) {UNSIGNED} not null default '0',
-    type varchar(255) not null default '',
+    type varchar(200) not null default '',
     data text
 );
 
diff --git a/sql/db_update_0.9-alpha1_0.9-alpha2_postgres.sql b/sql/db_update_0.9-alpha1_0.9-alpha2_postgres.sql
index 235efac..a95faaa 100644
--- a/sql/db_update_0.9-alpha1_0.9-alpha2_postgres.sql
+++ b/sql/db_update_0.9-alpha1_0.9-alpha2_postgres.sql
@@ -1,7 +1,7 @@
 CREATE TABLE {PREFIX}permalinks (
     permalink varchar(255) not null default '',
     entry_id int(10) {UNSIGNED} not null default '0',
-    type varchar(255) not null default '',
+    type varchar(200) not null default '',
     data text
 );
 
diff --git a/sql/db_update_0.9-alpha1_0.9-alpha2_sqlite.sql b/sql/db_update_0.9-alpha1_0.9-alpha2_sqlite.sql
index 235efac..a95faaa 100644
--- a/sql/db_update_0.9-alpha1_0.9-alpha2_sqlite.sql
+++ b/sql/db_update_0.9-alpha1_0.9-alpha2_sqlite.sql
@@ -1,7 +1,7 @@
 CREATE TABLE {PREFIX}permalinks (
     permalink varchar(255) not null default '',
     entry_id int(10) {UNSIGNED} not null default '0',
-    type varchar(255) not null default '',
+    type varchar(200) not null default '',
     data text
 );
 
-- 
2.39.5