[Patch] MySQL: Errors in tables TMC_ALERTS and TMC_FILES

[Ludovic Maitre]

Hi all,

It miss the primary key declaration in the 2 above mentioned tables. The 
attached file correct this. With this patch the Administration -> Manage 
Lokahi screens should be fully functionals.

Best regards,

--
Cordialement,
Ludo - http://www.ubik-products.com
---
"L'amour pour principe et l'ordre pour base; le progres pour but" (A.Comte) 

DROP TABLE IF EXISTS TMC_ALERTS;
CREATE TABLE TMC_ALERTS (ALERT_ID INT(11) NOT NULL auto_increment, PRIMARY KEY 
(ALERT_ID),ALERT_CONTENTS BLOB ,SUBMISION_DATE DATETIME ,SUBMITTER_ID INT(11) 
NOT NULL, KEY (SUBMITTER_ID),ALERT_TITLE VARCHAR(200) ,ALERT_LINK VARCHAR(4000) 
);

DROP TABLE IF EXISTS TMC_FILES;
CREATE TABLE TMC_FILES (FILE_ID INT(11) NOT NULL auto_increment, PRIMARY KEY 
(FILE_ID),FILE_NAME VARCHAR(100) NOT NULL,FILE_CONTENT BLOB ,FILE_DESCRIPTOR 
VARCHAR(100) ,FILE_PATH VARCHAR(2000) );