001
014
015 package com.liferay.portal.upgrade.v7_0_0.util;
016
017 import java.sql.Types;
018
019
023 public class OrgLaborTable {
024
025 public static final String TABLE_NAME = "OrgLabor";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"mvccVersion", Types.BIGINT},
029 {"orgLaborId", Types.BIGINT},
030 {"organizationId", Types.BIGINT},
031 {"typeId", Types.BIGINT},
032 {"sunOpen", Types.INTEGER},
033 {"sunClose", Types.INTEGER},
034 {"monOpen", Types.INTEGER},
035 {"monClose", Types.INTEGER},
036 {"tueOpen", Types.INTEGER},
037 {"tueClose", Types.INTEGER},
038 {"wedOpen", Types.INTEGER},
039 {"wedClose", Types.INTEGER},
040 {"thuOpen", Types.INTEGER},
041 {"thuClose", Types.INTEGER},
042 {"friOpen", Types.INTEGER},
043 {"friClose", Types.INTEGER},
044 {"satOpen", Types.INTEGER},
045 {"satClose", Types.INTEGER}
046 };
047
048 public static final String TABLE_SQL_CREATE = "create table OrgLabor (mvccVersion LONG default 0,orgLaborId LONG not null primary key,organizationId LONG,typeId LONG,sunOpen INTEGER,sunClose INTEGER,monOpen INTEGER,monClose INTEGER,tueOpen INTEGER,tueClose INTEGER,wedOpen INTEGER,wedClose INTEGER,thuOpen INTEGER,thuClose INTEGER,friOpen INTEGER,friClose INTEGER,satOpen INTEGER,satClose INTEGER)";
049
050 public static final String TABLE_SQL_DROP = "drop table OrgLabor";
051
052 public static final String[] TABLE_SQL_ADD_INDEXES = {
053 "create index IX_6AF0D434 on OrgLabor (organizationId)"
054 };
055
056 }