From: Alan Knowles Date: Mon, 23 May 2011 09:59:22 +0000 (+0800) Subject: DataObjects/core.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=64eb138c487dfd15821e79a4ca510515391b569a DataObjects/core.sql --- diff --git a/DataObjects/core.sql b/DataObjects/core.sql index 314de02a..4e5e4a07 100644 --- a/DataObjects/core.sql +++ b/DataObjects/core.sql @@ -42,13 +42,8 @@ ALTER TABLE Companies UPDATE Companies set comptype='OWNER' where isOwner=1; - -CREATE TABLE `core_company_type` ( - `id` int(11) NOT NULL AUTO_INCREMENT, - `name` varchar(64) NOT NULL, - PRIMARY KEY (`id`) -); - +#// core comapy types - use core enums (Company Type) +DROP TABLE core_company_type; CREATE TABLE `Events` ( `id` int(11) NOT NULL auto_increment,