incubator-lokahi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tob...@apache.org
Subject svn commit: r451348 - /incubator/lokahi/lokahi/branches/mysql/database/mysql/tables.sql
Date Fri, 29 Sep 2006 16:59:29 GMT
Author: toback
Date: Fri Sep 29 09:59:28 2006
New Revision: 451348

URL: http://svn.apache.org/viewvc?view=rev&rev=451348
Log:
Re:
http://mail-archives.apache.org/mod_mbox/incubator-lokahi-dev/200609.mbox/%3c451B1BF9.9@free.fr%3e

Modified:
    incubator/lokahi/lokahi/branches/mysql/database/mysql/tables.sql

Modified: incubator/lokahi/lokahi/branches/mysql/database/mysql/tables.sql
URL: http://svn.apache.org/viewvc/incubator/lokahi/lokahi/branches/mysql/database/mysql/tables.sql?view=diff&rev=451348&r1=451347&r2=451348
==============================================================================
--- incubator/lokahi/lokahi/branches/mysql/database/mysql/tables.sql (original)
+++ incubator/lokahi/lokahi/branches/mysql/database/mysql/tables.sql Fri Sep 29 09:59:28 2006
@@ -54,7 +54,7 @@
 
 
 DROP TABLE IF EXISTS TMC_ALERTS;
-CREATE TABLE TMC_ALERTS (ALERT_ID INT(11) NOT NULL, 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) );
+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_CONTROLLER;
@@ -70,7 +70,7 @@
 
 
 DROP TABLE IF EXISTS TMC_FILES;
-CREATE TABLE TMC_FILES (FILE_ID INT(11) NOT NULL, KEY (FILE_ID),FILE_NAME VARCHAR(100) NOT
NULL,FILE_CONTENT BLOB ,FILE_DESCRIPTOR VARCHAR(100) ,FILE_PATH VARCHAR(2000) );
+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)
);
 
 
 DROP TABLE IF EXISTS TMC_FILE_ARCHIVE;



Mime
View raw message