From lokahi-commits-return-198-apmail-incubator-lokahi-commits-archive=incubator.apache.org@incubator.apache.org Thu Oct 26 05:31:21 2006 Return-Path: Delivered-To: apmail-incubator-lokahi-commits-archive@locus.apache.org Received: (qmail 36199 invoked from network); 26 Oct 2006 00:19:51 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 26 Oct 2006 00:19:50 -0000 Received: (qmail 98940 invoked by uid 500); 25 Oct 2006 18:53:15 -0000 Delivered-To: apmail-incubator-lokahi-commits-archive@incubator.apache.org Received: (qmail 98929 invoked by uid 500); 25 Oct 2006 18:53:15 -0000 Mailing-List: contact lokahi-commits-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: lokahi-dev@incubator.apache.org Delivered-To: mailing list lokahi-commits@incubator.apache.org Received: (qmail 98920 invoked by uid 99); 25 Oct 2006 18:53:15 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Oct 2006 11:53:15 -0700 X-ASF-Spam-Status: No, hits=1.1 required=10.0 tests=NO_REAL_NAME,UPPERCASE_50_75 X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [140.211.11.3] (HELO eris.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Oct 2006 11:53:03 -0700 Received: by eris.apache.org (Postfix, from userid 65534) id 1012A1A9846; Wed, 25 Oct 2006 11:52:43 -0700 (PDT) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r467728 - /incubator/lokahi/lokahi/trunk/database/tables.sql Date: Wed, 25 Oct 2006 18:52:42 -0000 To: lokahi-commits@incubator.apache.org From: toback@apache.org X-Mailer: svnmailer-1.1.0 Message-Id: <20061025185243.1012A1A9846@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Author: toback Date: Wed Oct 25 11:52:42 2006 New Revision: 467728 URL: http://svn.apache.org/viewvc?view=rev&rev=467728 Log: Increased the size of the standard out log field in the TM_Container table to a reasonable number. (40 -> 300) Modified: incubator/lokahi/lokahi/trunk/database/tables.sql Modified: incubator/lokahi/lokahi/trunk/database/tables.sql URL: http://svn.apache.org/viewvc/incubator/lokahi/lokahi/trunk/database/tables.sql?view=diff&rev=467728&r1=467727&r2=467728 ============================================================================== --- incubator/lokahi/lokahi/trunk/database/tables.sql (original) +++ incubator/lokahi/lokahi/trunk/database/tables.sql Wed Oct 25 11:52:42 2006 @@ -143,7 +143,7 @@ CREATE TABLE TMC_USER ( FIRST_NAME VARCHAR2(30), LAST_NAME VARCHAR2(30), JOB_TITLE VARCHAR2(100), COMMENTS VARCHAR2(2000), EMAIL VARCHAR2(60), USER_ID NUMBER NOT NULL, USER_NAME VARCHAR2(30) NOT NULL, STATE_ID NUMBER DEFAULT 8, PASSWORD VARCHAR2(32) ) LOGGING NOCACHE NOPARALLEL; -CREATE TABLE TM_CONTAINER ( CONTAINER_ID NUMBER NOT NULL, CONTAINER_NAME VARCHAR2(40), BASE_LOCATION VARCHAR2(100), TOMCAT_HOME VARCHAR2(100), HTTP_PORT NUMBER, SYS_USER VARCHAR2(8), SYS_GROUP VARCHAR2(8), CONF_ENTRY BLOB, TOMCAT_TYPE NUMBER DEFAULT 4, DESCRIPTION VARCHAR2(100), STD_OUT_LOG VARCHAR2(40), START_CLASS VARCHAR2(40), JAVA_HOME VARCHAR2(40) ) LOGGING NOCACHE NOPARALLEL; +CREATE TABLE TM_CONTAINER ( CONTAINER_ID NUMBER NOT NULL, CONTAINER_NAME VARCHAR2(40), BASE_LOCATION VARCHAR2(100), TOMCAT_HOME VARCHAR2(100), HTTP_PORT NUMBER, SYS_USER VARCHAR2(8), SYS_GROUP VARCHAR2(8), CONF_ENTRY BLOB, TOMCAT_TYPE NUMBER DEFAULT 4, DESCRIPTION VARCHAR2(100), STD_OUT_LOG VARCHAR2(300), START_CLASS VARCHAR2(40), JAVA_HOME VARCHAR2(40) ) LOGGING NOCACHE NOPARALLEL; CREATE TABLE TM_ENTITY ( ENTITY_ID NUMBER NOT NULL, ENTITY_NAME VARCHAR2(60) NOT NULL, DOC_BASE VARCHAR2(500) NOT NULL, ENTITY_STATE_ID NUMBER NOT NULL, ENV_ID NUMBER NOT NULL, TOMCAT_POOL_ID NUMBER, ENTITY_DEFIN VARCHAR2(4000), EX_PROJECT_ID NUMBER DEFAULT 0 ) LOGGING NOCACHE NOPARALLEL;