alter table `PARTY_CONTACT` add `VISIBLE_PUBLIC` tinyint(1);



-- Inserted at 2011-01-21T17:54:12.250Z

alter table `PARTY_CONTACT` add `DESCRIPTION` text;



-- Inserted at 2011-01-27T12:19:54.118Z

create table `SOFTWARE_APPLICATION` (`UPDATE_ENTITY` text, `OID` bigint unsigned, `NAME` text, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `VENDOR_EMAIL` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `VENDOR` text, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
create table `LICENSE_MODEL` (`UPDATE_ENTITY` text, `OID` bigint unsigned, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `OID_SHARED_KEY` bigint unsigned, `OID_VERSION` bigint unsigned, `OJB_CONCRETE_CLASS` varchar(255) NOT NULL DEFAULT '', `KEY_REQUEST_EMAIL_TEMPLATE` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `AVAILABILITY_POLICY` text, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
create table `SOFTWARE_VERSION` (`UPDATE_ENTITY` text, `OID` bigint unsigned, `OID_LICENSE_MODEL` bigint unsigned, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `OID_APPLICATION` bigint unsigned, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `REPOSITORY_URL` text, `VERSION_IDENTIFIER` text, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_APPLICATION), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;
create table `LICENSE_KEY` (`UPDATE_ENTITY` text, `OID` bigint unsigned, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `CREATION_ENTITY_DATE` text, `CREATION_ENTITY` text, `OJB_CONCRETE_CLASS` varchar(255) NOT NULL DEFAULT '', `OID_PERSONAL_KEY_MODEL` bigint unsigned, `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `OID_SHARED_KEY_MODEL` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_ROOT_DOMAIN_OBJECT), index (OID_PERSONAL_KEY_MODEL)) type=InnoDB, character set latin1;

create table `LICENSE_REQUEST` (`OID` bigint unsigned, `OID_GRANTED_KEY` bigint unsigned, `CREATION_ENTITY` text, `CREATION_ENTITY_DATE` text, `BEGIN` text, `UPDATE_ENTITY` text, `UPDATE_ENTITY_DATE` timestamp NULL default NULL, `END` text, `INSTALL_CODE` text, `OID_REQUESTOR` bigint unsigned, `ACTIVE` tinyint(1), `OID_ROOT_DOMAIN_OBJECT` bigint unsigned, `OID_REQUESTED_VERSION` bigint unsigned, `ID_INTERNAL` int(11) NOT NULL auto_increment, primary key (ID_INTERNAL), index (OID), index (OID_GRANTED_KEY), index (OID_REQUESTOR), index (OID_REQUESTED_VERSION), index (OID_ROOT_DOMAIN_OBJECT)) type=InnoDB, character set latin1;

-- Inserted at 2011-01-28T13:37:01.846Z

alter table `LICENSE_KEY` add `KEY_VALUE` text;
