From 2530e3b908028473878d4b681e04a31509116eff Mon Sep 17 00:00:00 2001
From: icewing <icewing@36083f99-b078-4883-b0ff-0f9b5a30f544>
Date: Mon, 17 Mar 2008 17:07:24 +0000
Subject: Marcus Povey <marcus@dushka.co.uk> * guid not needed in subtype since
 this is just a label.

git-svn-id: https://code.elgg.org/elgg/trunk@237 36083f99-b078-4883-b0ff-0f9b5a30f544
---
 engine/schema/mysql.sql | 2 --
 1 file changed, 2 deletions(-)

(limited to 'engine/schema/mysql.sql')

diff --git a/engine/schema/mysql.sql b/engine/schema/mysql.sql
index 4d74fae8c..229c84064 100644
--- a/engine/schema/mysql.sql
+++ b/engine/schema/mysql.sql
@@ -33,12 +33,10 @@ CREATE TABLE `prefix_entities` (
 -- Entity subtypes - lets you subtype one of the main objects (sites/objects/etc)
 CREATE TABLE `prefix_entity_subtypes` (
 	`id` int(11) NOT NULL auto_increment,
-	`guid` bigint(20) unsigned  NOT NULL,
 	
 	`subtype` varchar(50) NOT NULL,
 	
 	PRIMARY KEY (`id`),
-	UNIQUE KEY (`guid`),
 	UNIQUE KEY (`subtype`)
 ) ENGINE=MyISAM;
 
-- 
cgit v1.2.3

