[Alerting] Added new fields to ad_session
authorAnder Iraceburu <ander.iraceburu@openbravo.com>
Thu, 03 May 2018 17:58:33 +0200
changeset 33998 71dba334c40b
parent 33997 56f36e3e80ab
child 33999 86cb314ebf98
[Alerting] Added new fields to ad_session
src-db/database/model/tables/AD_SESSION.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
--- a/src-db/database/model/tables/AD_SESSION.xml	Thu Mar 01 11:02:23 2018 +0100
+++ b/src-db/database/model/tables/AD_SESSION.xml	Thu May 03 17:58:33 2018 +0200
@@ -69,12 +69,19 @@
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="AD_USER_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_CLIENT" name="AD_SESSION_AD_CLIENT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
       <foreign-key foreignTable="AD_ORG" name="AD_SESSION_AD_ORG">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
+      <foreign-key foreignTable="AD_USER" name="AD_SESSION_AD_USER">
+        <reference local="AD_USER_ID" foreign="AD_USER_ID"/>
+      </foreign-key>
       <index name="AD_SESSION_ACTIVE_IDX" unique="false">
         <index-column name="SESSION_ACTIVE"/>
       </index>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Thu Mar 01 11:02:23 2018 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Thu May 03 17:58:33 2018 +0200
@@ -373199,6 +373199,44 @@
 <!--DF97786558E348AD807C77F1917B1C30-->  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK>
 <!--DF97786558E348AD807C77F1917B1C30--></AD_COLUMN>
 
+<!--DFCD2EC5687F413F8D0F4E10EF00435D--><AD_COLUMN>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <AD_COLUMN_ID><![CDATA[DFCD2EC5687F413F8D0F4E10EF00435D]]></AD_COLUMN_ID>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <NAME><![CDATA[User]]></NAME>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <DESCRIPTION><![CDATA[The User identifies a unique user in the system.]]></DESCRIPTION>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <HELP><![CDATA[The User identifies a unique user in the system.]]></HELP>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <COLUMNNAME><![CDATA[AD_User_ID]]></COLUMNNAME>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <AD_TABLE_ID><![CDATA[566]]></AD_TABLE_ID>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <SEQNO><![CDATA[91]]></SEQNO>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <AD_ELEMENT_ID><![CDATA[0C050A4090E5411EB1514BDD0E19DAAA]]></AD_ELEMENT_ID>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <POSITION><![CDATA[21]]></POSITION>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D-->  <ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK>
+<!--DFCD2EC5687F413F8D0F4E10EF00435D--></AD_COLUMN>
+
 <!--DFD312AEF4DC4E5A8145A487ECD0C280--><AD_COLUMN>
 <!--DFD312AEF4DC4E5A8145A487ECD0C280-->  <AD_COLUMN_ID><![CDATA[DFD312AEF4DC4E5A8145A487ECD0C280]]></AD_COLUMN_ID>
 <!--DFD312AEF4DC4E5A8145A487ECD0C280-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Thu Mar 01 11:02:23 2018 +0100
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Thu May 03 17:58:33 2018 +0200
@@ -21278,6 +21278,20 @@
 <!--0C8A533A80214372BA5C7D7295F59D92-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--0C8A533A80214372BA5C7D7295F59D92--></AD_ELEMENT>
 
+<!--0C050A4090E5411EB1514BDD0E19DAAA--><AD_ELEMENT>
+<!--0C050A4090E5411EB1514BDD0E19DAAA-->  <AD_ELEMENT_ID><![CDATA[0C050A4090E5411EB1514BDD0E19DAAA]]></AD_ELEMENT_ID>
+<!--0C050A4090E5411EB1514BDD0E19DAAA-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0C050A4090E5411EB1514BDD0E19DAAA-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0C050A4090E5411EB1514BDD0E19DAAA-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0C050A4090E5411EB1514BDD0E19DAAA-->  <COLUMNNAME><![CDATA[AD_User_ID]]></COLUMNNAME>
+<!--0C050A4090E5411EB1514BDD0E19DAAA-->  <NAME><![CDATA[User]]></NAME>
+<!--0C050A4090E5411EB1514BDD0E19DAAA-->  <PRINTNAME><![CDATA[User]]></PRINTNAME>
+<!--0C050A4090E5411EB1514BDD0E19DAAA-->  <DESCRIPTION><![CDATA[The User identifies a unique user in the system.]]></DESCRIPTION>
+<!--0C050A4090E5411EB1514BDD0E19DAAA-->  <HELP><![CDATA[The User identifies a unique user in the system.]]></HELP>
+<!--0C050A4090E5411EB1514BDD0E19DAAA-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--0C050A4090E5411EB1514BDD0E19DAAA-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--0C050A4090E5411EB1514BDD0E19DAAA--></AD_ELEMENT>
+
 <!--0CC014AD7EFD4D949B995E8DCC256EEC--><AD_ELEMENT>
 <!--0CC014AD7EFD4D949B995E8DCC256EEC-->  <AD_ELEMENT_ID><![CDATA[0CC014AD7EFD4D949B995E8DCC256EEC]]></AD_ELEMENT_ID>
 <!--0CC014AD7EFD4D949B995E8DCC256EEC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>