/* * * Copyright 2013 Entando S.r.l. (http://www.entando.com) All rights reserved. * * This file is part of Entando software. * Entando is a free software; * You can redistribute it and/or modify it * under the terms of the GNU General Public License (GPL) as published by the Free Software Foundation; version 2. * * See the file License for the specific language governing permissions * and limitations under the License * * * * Copyright 2013 Entando S.r.l. (http://www.entando.com) All rights reserved. * */ package org.entando.entando.plugins.jpaddressbook.aps.system.init.servdb; import com.j256.ormlite.field.DataType; import com.j256.ormlite.field.DatabaseField; import com.j256.ormlite.table.DatabaseTable; import java.util.Date; import org.entando.entando.aps.system.init.IDatabaseManager; import org.entando.entando.aps.system.init.model.ExtendedColumnDefinition; /** * @author E.Santoboni */ @DatabaseTable(tableName = ContactSearch.TABLE_NAME) public class ContactSearch implements ExtendedColumnDefinition { public ContactSearch() {} @DatabaseField(foreign = true, columnName = "contactkey", width = 40, canBeNull = false, index = true) private Contact _contactKey; @DatabaseField(columnName = "attrname", dataType = DataType.STRING, width = 30, canBeNull = false, index = true) private String _attributeName; @DatabaseField(columnName = "textvalue", dataType = DataType.STRING) private String _textValue; @DatabaseField(columnName = "datevalue", dataType = DataType.DATE) private Date _dateValue; @DatabaseField(columnName = "numvalue", dataType = DataType.INTEGER) private int _numberValue; @DatabaseField(columnName = "langcode", dataType = DataType.STRING, width = 3) private String _langCode; @Override public String[] extensions(IDatabaseManager.DatabaseType type) { String tableName = TABLE_NAME; String contactTableName = Contact.TABLE_NAME; if (IDatabaseManager.DatabaseType.MYSQL.equals(type)) { tableName = "`" + tableName + "`"; contactTableName = "`" + contactTableName + "`"; } return new String[]{"ALTER TABLE " + tableName + " " + "ADD CONSTRAINT jpaddressbook_search_fkey FOREIGN KEY (contactkey) " + "REFERENCES " + contactTableName + " (contactkey)"}; } public static final String TABLE_NAME = "jpaddressbook_contactsearch"; } /* CREATE TABLE jpaddressbook_contactsearch ( contactkey character varying(40) NOT NULL, attrname character varying(30) NOT NULL, textvalue character varying(255), datevalue date, numvalue integer, langcode character varying(2), CONSTRAINT jpaddressbook_contactsearch_contactkey_fkey FOREIGN KEY (contactkey) REFERENCES jpaddressbook_contacts (contactkey) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION ) */