1 package com.teamkonzept.webman.mainint.db.queries.content; 2 3 import java.sql.Connection ; 4 import com.teamkonzept.db.*; 5 6 11 public class CreateTempTableSiteNodeId extends TKPrepQuery 12 { 13 14 public final static boolean PREPARED = true; 15 public final static String [] ORDER = null; 16 public final static Object [][] TYPES = null; 17 public final static boolean[] RELEVANTS = { true }; 18 19 public final static String SQLSTRING = (new StringBuffer ("CREATE " + DBStringFactory.declareAsTemp() + " TABLE WEBMAN_TEMP2 ") 20 .append(" ( SITE_NODE_ID int null, ") 21 .append(" CONTENT_NODE_ID int null, ") 22 .append(" CONTENT_NODE_SHORTNAME VARCHAR(80) null, ") 23 .append(" CONTENT_NODE_TYPE int null, ") 24 .append(" DC_SITE_NODE_ID int null, ") 25 .append(" DC_SITE_NODE_DOC_IDX int null) ") 26 .append(DBStringFactory.declareForTransaction())).toString(); 27 28 public void initQuery(Connection con) { 29 super.initQuery( 30 con, 31 PREPARED, 32 ORDER, 33 TYPES, 34 RELEVANTS, 35 SQLSTRING ); 36 } 37 38 } 39 | Popular Tags |