From 3d5b9792d9fa71192374b538da7fb308679d9fd2 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Sun, 13 Feb 2011 21:47:58 +0800 Subject: [PATCH] DataObjects/core.sql --- DataObjects/core.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 3a18003a..8c5d0077 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -11,8 +11,10 @@ CREATE TABLE `Companies` ( `id` int(11) NOT NULL auto_increment, `isOwner` int(11) default NULL, PRIMARY KEY (`id`), - KEY `Company_Name` (`name`) + ) ; +ALTER TABLE `Company_Name` ADD INDEX name_lookup (`name`); + alter table Companies change column isOwner isOwner int(11); ALTER TABLE Companies ADD COLUMN logo_id INT(11) NOT NULL; -- 2.39.2