/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package org.geoforge.basusrspcdsp.table;
import org.geoforge.sql.constraint.CstPrimaryKey;
import org.geoforge.sql.field.sql92.FldSql92VaryingCharacter;
import org.geoforge.sql.table.GfrSqlTblAbs;
/**
*
* @author bill
*/
/*
*
*
*
* key plugin name | key version | value date first run
*
* key plugin name NOT NULL NOT UNIQUE
* key version NOT NULL NOT UNIQUE
* value date first run NOT UNIQUE COULD BE NULL
*
* Key key = PrimaryKey();
* key.add(key plugin name);
* key.add(key version);
*
*
*
*
*
*
*
* key plugin name | key version | value path abs lic file
*
* key plugin name NOT NULL NOT UNIQUE
* key version NOT NULL NOT UNIQUE
* value path abs lic file UNIQUE COULD BE NULL
*
* Key key = PrimaryKey();
* key.add(key plugin name);
* key.add(key version);
*
*/
public class GfrSqlTblUsrPlgLicence extends GfrSqlTblAbs
{
final static public FldSql92VaryingCharacter FLD_STR_USER_PREF_PLUGIN_KEY_NAME =
new FldSql92VaryingCharacter("key_plugin_name",
80,
false,
true);
final static public FldSql92VaryingCharacter FLD_STR_USER_PREF_PLUGIN_KEY_VERSION =
new FldSql92VaryingCharacter("key_plugin_version",
80,
false,
true);
final static public FldSql92VaryingCharacter FLD_STR_USER_PREF_PLUGIN_VALUE_DATE_FIRST_RUN =
new FldSql92VaryingCharacter("user_preferences_plugin_value_date_first_run",
80,
false, // !!! assuming more than one plugin could be (first) run at same time !!!
true);
final static public FldSql92VaryingCharacter FLD_STR_USER_PREF_PLUGIN_VALUE_PATH_ABS_FILE_LIC =
new FldSql92VaryingCharacter("user_preferences_plugin_value_path_absolute_file_license",
80,
true,
false);
static private GfrSqlTblUsrPlgLicence _INSTANCE_;
static public synchronized GfrSqlTblUsrPlgLicence s_getInstance()
{
if (GfrSqlTblUsrPlgLicence._INSTANCE_ == null)
GfrSqlTblUsrPlgLicence._INSTANCE_ = new GfrSqlTblUsrPlgLicence();
return GfrSqlTblUsrPlgLicence._INSTANCE_;
}
private CstPrimaryKey _cstPrimaryKey_ = null;
private GfrSqlTblUsrPlgLicence()
{
super("user_plugin_licence");
super.setIfNotExists(true);
super.add(GfrSqlTblUsrPlgLicence.FLD_STR_USER_PREF_PLUGIN_KEY_NAME);
super.add(GfrSqlTblUsrPlgLicence.FLD_STR_USER_PREF_PLUGIN_KEY_VERSION);
super.add(GfrSqlTblUsrPlgLicence.FLD_STR_USER_PREF_PLUGIN_VALUE_DATE_FIRST_RUN);
super.add(GfrSqlTblUsrPlgLicence.FLD_STR_USER_PREF_PLUGIN_VALUE_PATH_ABS_FILE_LIC);
this._cstPrimaryKey_ = new CstPrimaryKey("constraintPrimKey");
this._cstPrimaryKey_.addField(GfrSqlTblUsrPlgLicence.FLD_STR_USER_PREF_PLUGIN_KEY_NAME);
this._cstPrimaryKey_.addField(GfrSqlTblUsrPlgLicence.FLD_STR_USER_PREF_PLUGIN_KEY_VERSION);
super.add(this._cstPrimaryKey_);
}
}