From b035834fc53db9ed67456211bffeb1aab0ac3914 Mon Sep 17 00:00:00 2001
From: moodler <moodler>
Date: Fri, 30 Jul 2004 03:55:27 +0000
Subject: [PATCH] resource->type is now a varchar

---
 mod/resource/db/mysql.sql     | 2 +-
 mod/resource/db/postgres7.sql | 2 +-
 2 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/mod/resource/db/mysql.sql b/mod/resource/db/mysql.sql
index 9c8f69c231..12cc8b9ed2 100755
--- a/mod/resource/db/mysql.sql
+++ b/mod/resource/db/mysql.sql
@@ -18,7 +18,7 @@ CREATE TABLE prefix_resource (
   id int(10) unsigned NOT NULL auto_increment,
   course int(10) unsigned NOT NULL default '0',
   name varchar(255) NOT NULL default '',
-  type tinyint(4) NOT NULL default '0',
+  type varchar(30) NOT NULL default '',
   reference varchar(255) default NULL,
   summary text NOT NULL,
   alltext text NOT NULL,
diff --git a/mod/resource/db/postgres7.sql b/mod/resource/db/postgres7.sql
index 086feb0937..8c1286f01a 100644
--- a/mod/resource/db/postgres7.sql
+++ b/mod/resource/db/postgres7.sql
@@ -18,7 +18,7 @@ CREATE TABLE prefix_resource (
   id SERIAL PRIMARY KEY,
   course integer NOT NULL default '0',
   name varchar(255) NOT NULL default '',
-  type integer NOT NULL default '0',
+  type varchar(30) NOT NULL default '',
   reference varchar(255) default NULL,
   summary text NOT NULL default '',
   alltext text NOT NULL default '',
-- 
2.39.5