[Characteristics]Backout ch type, all ch are lists.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Fri, 01 Mar 2013 12:38:38 +0100
changeset 20863 14faf6af5691
parent 20862 289600223835
child 20864 c2079a6d34a1
[Characteristics]Backout ch type, all ch are lists.
src-db/database/model/tables/M_CHARACTERISTIC.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_FIELD.xml
src-db/database/sourcedata/AD_REFERENCE.xml
src-db/database/sourcedata/AD_REF_LIST.xml
--- a/src-db/database/model/tables/M_CHARACTERISTIC.xml	Fri Mar 01 11:14:11 2013 +0100
+++ b/src-db/database/model/tables/M_CHARACTERISTIC.xml	Fri Mar 01 12:38:38 2013 +0100
@@ -37,10 +37,6 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="CH_TYPE" primaryKey="false" required="true" type="VARCHAR" size="60" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
       <column name="DESCRIPTION" primaryKey="false" required="false" type="NVARCHAR" size="2000" autoIncrement="false">
         <default/>
         <onCreateDefault/>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Fri Mar 01 11:14:11 2013 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Fri Mar 01 12:38:38 2013 +0100
@@ -309075,41 +309075,6 @@
 <!--D69FF5B78C41C471E040007F010015B2-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--D69FF5B78C41C471E040007F010015B2--></AD_COLUMN>
 
-<!--D69FF5B78C42C471E040007F010015B2--><AD_COLUMN>
-<!--D69FF5B78C42C471E040007F010015B2-->  <AD_COLUMN_ID><![CDATA[D69FF5B78C42C471E040007F010015B2]]></AD_COLUMN_ID>
-<!--D69FF5B78C42C471E040007F010015B2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--D69FF5B78C42C471E040007F010015B2-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--D69FF5B78C42C471E040007F010015B2-->  <NAME><![CDATA[Type]]></NAME>
-<!--D69FF5B78C42C471E040007F010015B2-->  <HELP><![CDATA[The characteristic type defines how is set the value. A List characteristic uses a drop down menu with all the available values while a Text type uses a text box to manually set the desired value.]]></HELP>
-<!--D69FF5B78C42C471E040007F010015B2-->  <COLUMNNAME><![CDATA[CH_Type]]></COLUMNNAME>
-<!--D69FF5B78C42C471E040007F010015B2-->  <AD_TABLE_ID><![CDATA[91C26DEA4B3D4C05B4F277D009220872]]></AD_TABLE_ID>
-<!--D69FF5B78C42C471E040007F010015B2-->  <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID>
-<!--D69FF5B78C42C471E040007F010015B2-->  <AD_REFERENCE_VALUE_ID><![CDATA[7703E0B6FB0449FD8CB587D64B8A0A81]]></AD_REFERENCE_VALUE_ID>
-<!--D69FF5B78C42C471E040007F010015B2-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--D69FF5B78C42C471E040007F010015B2-->  <SEQNO><![CDATA[100]]></SEQNO>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--D69FF5B78C42C471E040007F010015B2-->  <AD_ELEMENT_ID><![CDATA[D69FE5544E74D667E040007F01001784]]></AD_ELEMENT_ID>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--D69FF5B78C42C471E040007F010015B2-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--D69FF5B78C42C471E040007F010015B2-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--D69FF5B78C42C471E040007F010015B2-->  <POSITION><![CDATA[10]]></POSITION>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--D69FF5B78C42C471E040007F010015B2-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--D69FF5B78C42C471E040007F010015B2-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
-<!--D69FF5B78C42C471E040007F010015B2-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
-<!--D69FF5B78C42C471E040007F010015B2--></AD_COLUMN>
-
 <!--D69FF5B78C43C471E040007F010015B2--><AD_COLUMN>
 <!--D69FF5B78C43C471E040007F010015B2-->  <AD_COLUMN_ID><![CDATA[D69FF5B78C43C471E040007F010015B2]]></AD_COLUMN_ID>
 <!--D69FF5B78C43C471E040007F010015B2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Fri Mar 01 11:14:11 2013 +0100
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Fri Mar 01 12:38:38 2013 +0100
@@ -30566,19 +30566,6 @@
 <!--D66DAAD6524140849CFCF28CE8FC8290-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--D66DAAD6524140849CFCF28CE8FC8290--></AD_ELEMENT>
 
-<!--D69FE5544E74D667E040007F01001784--><AD_ELEMENT>
-<!--D69FE5544E74D667E040007F01001784-->  <AD_ELEMENT_ID><![CDATA[D69FE5544E74D667E040007F01001784]]></AD_ELEMENT_ID>
-<!--D69FE5544E74D667E040007F01001784-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--D69FE5544E74D667E040007F01001784-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--D69FE5544E74D667E040007F01001784-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--D69FE5544E74D667E040007F01001784-->  <COLUMNNAME><![CDATA[CH_Type]]></COLUMNNAME>
-<!--D69FE5544E74D667E040007F01001784-->  <NAME><![CDATA[Type]]></NAME>
-<!--D69FE5544E74D667E040007F01001784-->  <PRINTNAME><![CDATA[Type]]></PRINTNAME>
-<!--D69FE5544E74D667E040007F01001784-->  <HELP><![CDATA[The characteristic type defines how is set the value. A List characteristic uses a drop down menu with all the available values while a Text type uses a text box to manually set the desired value.]]></HELP>
-<!--D69FE5544E74D667E040007F01001784-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--D69FE5544E74D667E040007F01001784-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
-<!--D69FE5544E74D667E040007F01001784--></AD_ELEMENT>
-
 <!--D69FE5544E75D667E040007F01001784--><AD_ELEMENT>
 <!--D69FE5544E75D667E040007F01001784-->  <AD_ELEMENT_ID><![CDATA[D69FE5544E75D667E040007F01001784]]></AD_ELEMENT_ID>
 <!--D69FE5544E75D667E040007F01001784-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Fri Mar 01 11:14:11 2013 +0100
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Fri Mar 01 12:38:38 2013 +0100
@@ -264913,33 +264913,6 @@
 <!--D69FE5884FF89B6BE040007F010015AE-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--D69FE5884FF89B6BE040007F010015AE--></AD_FIELD>
 
-<!--D69FE5884FF99B6BE040007F010015AE--><AD_FIELD>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <AD_FIELD_ID><![CDATA[D69FE5884FF99B6BE040007F010015AE]]></AD_FIELD_ID>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <NAME><![CDATA[Type]]></NAME>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <HELP><![CDATA[The characteristic type defines how is set the value. A List characteristic uses a drop down menu with all the available values while a Text type uses a text box to manually set the desired value.]]></HELP>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <AD_TAB_ID><![CDATA[A661A0A05DCD4650BCB14B010C87F0AA]]></AD_TAB_ID>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <AD_COLUMN_ID><![CDATA[D69FF5B78C42C471E040007F010015B2]]></AD_COLUMN_ID>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <SEQNO><![CDATA[30]]></SEQNO>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
-<!--D69FE5884FF99B6BE040007F010015AE-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
-<!--D69FE5884FF99B6BE040007F010015AE--></AD_FIELD>
-
 <!--D69FE5884FFA9B6BE040007F010015AE--><AD_FIELD>
 <!--D69FE5884FFA9B6BE040007F010015AE-->  <AD_FIELD_ID><![CDATA[D69FE5884FFA9B6BE040007F010015AE]]></AD_FIELD_ID>
 <!--D69FE5884FFA9B6BE040007F010015AE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REFERENCE.xml	Fri Mar 01 11:14:11 2013 +0100
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml	Fri Mar 01 12:38:38 2013 +0100
@@ -4996,18 +4996,6 @@
 <!--73625A8F22EF4CD7808603156BA606D7-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--73625A8F22EF4CD7808603156BA606D7--></AD_REFERENCE>
 
-<!--7703E0B6FB0449FD8CB587D64B8A0A81--><AD_REFERENCE>
-<!--7703E0B6FB0449FD8CB587D64B8A0A81-->  <AD_REFERENCE_ID><![CDATA[7703E0B6FB0449FD8CB587D64B8A0A81]]></AD_REFERENCE_ID>
-<!--7703E0B6FB0449FD8CB587D64B8A0A81-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--7703E0B6FB0449FD8CB587D64B8A0A81-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--7703E0B6FB0449FD8CB587D64B8A0A81-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--7703E0B6FB0449FD8CB587D64B8A0A81-->  <NAME><![CDATA[Characteristic Type]]></NAME>
-<!--7703E0B6FB0449FD8CB587D64B8A0A81-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--7703E0B6FB0449FD8CB587D64B8A0A81-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
-<!--7703E0B6FB0449FD8CB587D64B8A0A81-->  <PARENTREFERENCE_ID><![CDATA[17]]></PARENTREFERENCE_ID>
-<!--7703E0B6FB0449FD8CB587D64B8A0A81-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
-<!--7703E0B6FB0449FD8CB587D64B8A0A81--></AD_REFERENCE>
-
 <!--772B5918358B443A83F82F81A9A4BFB6--><AD_REFERENCE>
 <!--772B5918358B443A83F82F81A9A4BFB6-->  <AD_REFERENCE_ID><![CDATA[772B5918358B443A83F82F81A9A4BFB6]]></AD_REFERENCE_ID>
 <!--772B5918358B443A83F82F81A9A4BFB6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REF_LIST.xml	Fri Mar 01 11:14:11 2013 +0100
+++ b/src-db/database/sourcedata/AD_REF_LIST.xml	Fri Mar 01 12:38:38 2013 +0100
@@ -10567,18 +10567,6 @@
 <!--A3CE24F6238A416E8839102B952D1F4E-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--A3CE24F6238A416E8839102B952D1F4E--></AD_REF_LIST>
 
-<!--A3E70CCEFA1340838393A1FB8ED05429--><AD_REF_LIST>
-<!--A3E70CCEFA1340838393A1FB8ED05429-->  <AD_REF_LIST_ID><![CDATA[A3E70CCEFA1340838393A1FB8ED05429]]></AD_REF_LIST_ID>
-<!--A3E70CCEFA1340838393A1FB8ED05429-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--A3E70CCEFA1340838393A1FB8ED05429-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--A3E70CCEFA1340838393A1FB8ED05429-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--A3E70CCEFA1340838393A1FB8ED05429-->  <VALUE><![CDATA[L]]></VALUE>
-<!--A3E70CCEFA1340838393A1FB8ED05429-->  <NAME><![CDATA[List]]></NAME>
-<!--A3E70CCEFA1340838393A1FB8ED05429-->  <AD_REFERENCE_ID><![CDATA[7703E0B6FB0449FD8CB587D64B8A0A81]]></AD_REFERENCE_ID>
-<!--A3E70CCEFA1340838393A1FB8ED05429-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--A3E70CCEFA1340838393A1FB8ED05429-->  <SEQNO><![CDATA[10]]></SEQNO>
-<!--A3E70CCEFA1340838393A1FB8ED05429--></AD_REF_LIST>
-
 <!--A40750AD9C064CA2A2A4C2F2C220C4C7--><AD_REF_LIST>
 <!--A40750AD9C064CA2A2A4C2F2C220C4C7-->  <AD_REF_LIST_ID><![CDATA[A40750AD9C064CA2A2A4C2F2C220C4C7]]></AD_REF_LIST_ID>
 <!--A40750AD9C064CA2A2A4C2F2C220C4C7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -11652,18 +11640,6 @@
 <!--DFF194A875F94C2DBF37442242D93AA5-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--DFF194A875F94C2DBF37442242D93AA5--></AD_REF_LIST>
 
-<!--E184B1A50605459B82A2043D40C65ECB--><AD_REF_LIST>
-<!--E184B1A50605459B82A2043D40C65ECB-->  <AD_REF_LIST_ID><![CDATA[E184B1A50605459B82A2043D40C65ECB]]></AD_REF_LIST_ID>
-<!--E184B1A50605459B82A2043D40C65ECB-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--E184B1A50605459B82A2043D40C65ECB-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--E184B1A50605459B82A2043D40C65ECB-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--E184B1A50605459B82A2043D40C65ECB-->  <VALUE><![CDATA[T]]></VALUE>
-<!--E184B1A50605459B82A2043D40C65ECB-->  <NAME><![CDATA[Text]]></NAME>
-<!--E184B1A50605459B82A2043D40C65ECB-->  <AD_REFERENCE_ID><![CDATA[7703E0B6FB0449FD8CB587D64B8A0A81]]></AD_REFERENCE_ID>
-<!--E184B1A50605459B82A2043D40C65ECB-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--E184B1A50605459B82A2043D40C65ECB-->  <SEQNO><![CDATA[20]]></SEQNO>
-<!--E184B1A50605459B82A2043D40C65ECB--></AD_REF_LIST>
-
 <!--E249380AE2814BC7B0E5B8F267F387AC--><AD_REF_LIST>
 <!--E249380AE2814BC7B0E5B8F267F387AC-->  <AD_REF_LIST_ID><![CDATA[E249380AE2814BC7B0E5B8F267F387AC]]></AD_REF_LIST_ID>
 <!--E249380AE2814BC7B0E5B8F267F387AC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>