001
014
015 package com.liferay.portal.upgrade.v7_0_0.util;
016
017 import java.sql.Types;
018
019
023 public class ContactTable {
024
025 public static final String TABLE_NAME = "Contact_";
026
027 public static final Object[][] TABLE_COLUMNS = {
028 {"mvccVersion", Types.BIGINT},
029 {"contactId", Types.BIGINT},
030 {"companyId", Types.BIGINT},
031 {"userId", Types.BIGINT},
032 {"userName", Types.VARCHAR},
033 {"createDate", Types.TIMESTAMP},
034 {"modifiedDate", Types.TIMESTAMP},
035 {"classNameId", Types.BIGINT},
036 {"classPK", Types.BIGINT},
037 {"accountId", Types.BIGINT},
038 {"parentContactId", Types.BIGINT},
039 {"emailAddress", Types.VARCHAR},
040 {"firstName", Types.VARCHAR},
041 {"middleName", Types.VARCHAR},
042 {"lastName", Types.VARCHAR},
043 {"prefixId", Types.BIGINT},
044 {"suffixId", Types.BIGINT},
045 {"male", Types.BOOLEAN},
046 {"birthday", Types.TIMESTAMP},
047 {"smsSn", Types.VARCHAR},
048 {"aimSn", Types.VARCHAR},
049 {"facebookSn", Types.VARCHAR},
050 {"icqSn", Types.VARCHAR},
051 {"jabberSn", Types.VARCHAR},
052 {"msnSn", Types.VARCHAR},
053 {"mySpaceSn", Types.VARCHAR},
054 {"skypeSn", Types.VARCHAR},
055 {"twitterSn", Types.VARCHAR},
056 {"ymSn", Types.VARCHAR},
057 {"employeeStatusId", Types.VARCHAR},
058 {"employeeNumber", Types.VARCHAR},
059 {"jobTitle", Types.VARCHAR},
060 {"jobClass", Types.VARCHAR},
061 {"hoursOfOperation", Types.VARCHAR}
062 };
063
064 public static final String TABLE_SQL_CREATE = "create table Contact_ (mvccVersion LONG default 0,contactId LONG not null primary key,companyId LONG,userId LONG,userName VARCHAR(75) null,createDate DATE null,modifiedDate DATE null,classNameId LONG,classPK LONG,accountId LONG,parentContactId LONG,emailAddress VARCHAR(75) null,firstName VARCHAR(75) null,middleName VARCHAR(75) null,lastName VARCHAR(75) null,prefixId LONG,suffixId LONG,male BOOLEAN,birthday DATE null,smsSn VARCHAR(75) null,aimSn VARCHAR(75) null,facebookSn VARCHAR(75) null,icqSn VARCHAR(75) null,jabberSn VARCHAR(75) null,msnSn VARCHAR(75) null,mySpaceSn VARCHAR(75) null,skypeSn VARCHAR(75) null,twitterSn VARCHAR(75) null,ymSn VARCHAR(75) null,employeeStatusId VARCHAR(75) null,employeeNumber VARCHAR(75) null,jobTitle VARCHAR(100) null,jobClass VARCHAR(75) null,hoursOfOperation VARCHAR(75) null)";
065
066 public static final String TABLE_SQL_DROP = "drop table Contact_";
067
068 public static final String[] TABLE_SQL_ADD_INDEXES = {
069 "create index IX_B8C28C53 on Contact_ (accountId)",
070 "create index IX_791914FA on Contact_ (classNameId, classPK)",
071 "create index IX_66D496A3 on Contact_ (companyId)"
072 };
073
074 }