Attached Files | 24771.diff [^] (22,718 bytes) 2013-09-14 10:27 [Show Content] [Hide Content]diff --git a/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_TEMPLATE.xml b/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_TEMPLATE.xml
--- a/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_TEMPLATE.xml
+++ b/modules/org.openbravo.client.kernel/src-db/database/model/tables/OBCLKER_TEMPLATE.xml
@@ -15,7 +15,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default/>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="NAME" primaryKey="false" required="true" type="NVARCHAR" size="60" autoIncrement="false">
<default/>
diff --git a/modules/org.openbravo.service.datasource/src-db/database/model/tables/OBSERDS_DATASOURCE.xml b/modules/org.openbravo.service.datasource/src-db/database/model/tables/OBSERDS_DATASOURCE.xml
--- a/modules/org.openbravo.service.datasource/src-db/database/model/tables/OBSERDS_DATASOURCE.xml
+++ b/modules/org.openbravo.service.datasource/src-db/database/model/tables/OBSERDS_DATASOURCE.xml
@@ -15,7 +15,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default/>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="NAME" primaryKey="false" required="true" type="NVARCHAR" size="60" autoIncrement="false">
<default/>
diff --git a/modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR_FIELD.xml b/modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR_FIELD.xml
--- a/modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR_FIELD.xml
+++ b/modules/org.openbravo.userinterface.selector/src-db/database/model/tables/OBUISEL_SELECTOR_FIELD.xml
@@ -19,7 +19,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default/>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="AD_COLUMN_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_AUXILIARINPUT.xml b/src-db/database/model/tables/AD_AUXILIARINPUT.xml
--- a/src-db/database/model/tables/AD_AUXILIARINPUT.xml
+++ b/src-db/database/model/tables/AD_AUXILIARINPUT.xml
@@ -47,7 +47,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<foreign-key foreignTable="AD_CLIENT" name="AD_AUXILIARINPUT_AD_CLIENT">
<reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
diff --git a/src-db/database/model/tables/AD_CALLOUT.xml b/src-db/database/model/tables/AD_CALLOUT.xml
--- a/src-db/database/model/tables/AD_CALLOUT.xml
+++ b/src-db/database/model/tables/AD_CALLOUT.xml
@@ -43,7 +43,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<foreign-key foreignTable="AD_CLIENT" name="AD_CALLOUT_AD_CLIENT">
<reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
diff --git a/src-db/database/model/tables/AD_CLIENTMODULE.xml b/src-db/database/model/tables/AD_CLIENTMODULE.xml
--- a/src-db/database/model/tables/AD_CLIENTMODULE.xml
+++ b/src-db/database/model/tables/AD_CLIENTMODULE.xml
@@ -35,7 +35,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default/>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="VERSION" primaryKey="false" required="true" type="VARCHAR" size="10" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_COLUMN.xml b/src-db/database/model/tables/AD_COLUMN.xml
--- a/src-db/database/model/tables/AD_COLUMN.xml
+++ b/src-db/database/model/tables/AD_COLUMN.xml
@@ -159,7 +159,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="POSITION" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_DATASET.xml b/src-db/database/model/tables/AD_DATASET.xml
--- a/src-db/database/model/tables/AD_DATASET.xml
+++ b/src-db/database/model/tables/AD_DATASET.xml
@@ -47,7 +47,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="EXPORT" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
<default><![CDATA[N]]></default>
diff --git a/src-db/database/model/tables/AD_DATASET_COLUMN.xml b/src-db/database/model/tables/AD_DATASET_COLUMN.xml
--- a/src-db/database/model/tables/AD_DATASET_COLUMN.xml
+++ b/src-db/database/model/tables/AD_DATASET_COLUMN.xml
@@ -47,7 +47,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<foreign-key foreignTable="AD_CLIENT" name="AD_DATASET_COLUMN_AD_CLIENT">
<reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
diff --git a/src-db/database/model/tables/AD_DATASET_TABLE.xml b/src-db/database/model/tables/AD_DATASET_TABLE.xml
--- a/src-db/database/model/tables/AD_DATASET_TABLE.xml
+++ b/src-db/database/model/tables/AD_DATASET_TABLE.xml
@@ -59,7 +59,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="SECONDARYWHERECLAUSE" primaryKey="false" required="false" type="VARCHAR" size="2000" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_ELEMENT.xml b/src-db/database/model/tables/AD_ELEMENT.xml
--- a/src-db/database/model/tables/AD_ELEMENT.xml
+++ b/src-db/database/model/tables/AD_ELEMENT.xml
@@ -71,7 +71,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="ISGLOSSARY" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
<default><![CDATA[N]]></default>
diff --git a/src-db/database/model/tables/AD_FIELD.xml b/src-db/database/model/tables/AD_FIELD.xml
--- a/src-db/database/model/tables/AD_FIELD.xml
+++ b/src-db/database/model/tables/AD_FIELD.xml
@@ -115,7 +115,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="GRID_SEQNO" primaryKey="false" required="false" type="DECIMAL" size="10,0" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_FIELDGROUP.xml b/src-db/database/model/tables/AD_FIELDGROUP.xml
--- a/src-db/database/model/tables/AD_FIELDGROUP.xml
+++ b/src-db/database/model/tables/AD_FIELDGROUP.xml
@@ -39,7 +39,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="ISCOLLAPSED" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_FORM.xml b/src-db/database/model/tables/AD_FORM.xml
--- a/src-db/database/model/tables/AD_FORM.xml
+++ b/src-db/database/model/tables/AD_FORM.xml
@@ -55,7 +55,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="ISADVANCEDFEATURE" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
<default><![CDATA[N]]></default>
diff --git a/src-db/database/model/tables/AD_MENU.xml b/src-db/database/model/tables/AD_MENU.xml
--- a/src-db/database/model/tables/AD_MENU.xml
+++ b/src-db/database/model/tables/AD_MENU.xml
@@ -67,7 +67,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<foreign-key foreignTable="AD_CLIENT" name="AD_MENU_AD_CLIENT">
<reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
diff --git a/src-db/database/model/tables/AD_MESSAGE.xml b/src-db/database/model/tables/AD_MESSAGE.xml
--- a/src-db/database/model/tables/AD_MESSAGE.xml
+++ b/src-db/database/model/tables/AD_MESSAGE.xml
@@ -51,7 +51,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="ISINCLUDEINI18N" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
<default><![CDATA[N]]></default>
diff --git a/src-db/database/model/tables/AD_MODULE_DBPREFIX.xml b/src-db/database/model/tables/AD_MODULE_DBPREFIX.xml
--- a/src-db/database/model/tables/AD_MODULE_DBPREFIX.xml
+++ b/src-db/database/model/tables/AD_MODULE_DBPREFIX.xml
@@ -35,7 +35,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default/>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="NAME" primaryKey="false" required="true" type="VARCHAR" size="7" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_MODULE_DEPENDENCY.xml b/src-db/database/model/tables/AD_MODULE_DEPENDENCY.xml
--- a/src-db/database/model/tables/AD_MODULE_DEPENDENCY.xml
+++ b/src-db/database/model/tables/AD_MODULE_DEPENDENCY.xml
@@ -35,7 +35,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default/>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="AD_DEPENDENT_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_MODULE_LOG.xml b/src-db/database/model/tables/AD_MODULE_LOG.xml
--- a/src-db/database/model/tables/AD_MODULE_LOG.xml
+++ b/src-db/database/model/tables/AD_MODULE_LOG.xml
@@ -35,7 +35,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
<default/>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="AD_MODULE_VERSION_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_MODULE_TRL.xml b/src-db/database/model/tables/AD_MODULE_TRL.xml
--- a/src-db/database/model/tables/AD_MODULE_TRL.xml
+++ b/src-db/database/model/tables/AD_MODULE_TRL.xml
@@ -7,7 +7,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default/>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="AD_LANGUAGE" primaryKey="false" required="true" type="VARCHAR" size="6" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_ORGMODULE.xml b/src-db/database/model/tables/AD_ORGMODULE.xml
--- a/src-db/database/model/tables/AD_ORGMODULE.xml
+++ b/src-db/database/model/tables/AD_ORGMODULE.xml
@@ -35,7 +35,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default/>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="VERSION" primaryKey="false" required="true" type="VARCHAR" size="10" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_PACKAGE.xml b/src-db/database/model/tables/AD_PACKAGE.xml
--- a/src-db/database/model/tables/AD_PACKAGE.xml
+++ b/src-db/database/model/tables/AD_PACKAGE.xml
@@ -27,7 +27,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
<default/>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="ISACTIVE" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
<default><![CDATA[Y]]></default>
diff --git a/src-db/database/model/tables/AD_PROCESS.xml b/src-db/database/model/tables/AD_PROCESS.xml
--- a/src-db/database/model/tables/AD_PROCESS.xml
+++ b/src-db/database/model/tables/AD_PROCESS.xml
@@ -99,7 +99,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="UIPATTERN" primaryKey="false" required="true" type="VARCHAR" size="60" autoIncrement="false">
<default><![CDATA[S]]></default>
diff --git a/src-db/database/model/tables/AD_REFERENCE.xml b/src-db/database/model/tables/AD_REFERENCE.xml
--- a/src-db/database/model/tables/AD_REFERENCE.xml
+++ b/src-db/database/model/tables/AD_REFERENCE.xml
@@ -55,7 +55,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="ISBASEREFERENCE" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
<default><![CDATA[N]]></default>
diff --git a/src-db/database/model/tables/AD_REF_DATA_LOADED.xml b/src-db/database/model/tables/AD_REF_DATA_LOADED.xml
--- a/src-db/database/model/tables/AD_REF_DATA_LOADED.xml
+++ b/src-db/database/model/tables/AD_REF_DATA_LOADED.xml
@@ -35,7 +35,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
<default/>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="GENERIC_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_REF_LIST.xml b/src-db/database/model/tables/AD_REF_LIST.xml
--- a/src-db/database/model/tables/AD_REF_LIST.xml
+++ b/src-db/database/model/tables/AD_REF_LIST.xml
@@ -59,7 +59,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="SEQNO" primaryKey="false" required="false" type="DECIMAL" size="10,0" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_TAB.xml b/src-db/database/model/tables/AD_TAB.xml
--- a/src-db/database/model/tables/AD_TAB.xml
+++ b/src-db/database/model/tables/AD_TAB.xml
@@ -139,7 +139,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="UIPATTERN" primaryKey="false" required="true" type="VARCHAR" size="60" autoIncrement="false">
<default><![CDATA[STD]]></default>
diff --git a/src-db/database/model/tables/AD_TABLE.xml b/src-db/database/model/tables/AD_TABLE.xml
--- a/src-db/database/model/tables/AD_TABLE.xml
+++ b/src-db/database/model/tables/AD_TABLE.xml
@@ -103,7 +103,7 @@
</column>
<column name="AD_PACKAGE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_PACKAGE_ID FROM AD_PACKAGE WHERE AD_MODULE_ID<>'0']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="TREETYPE" primaryKey="false" required="false" type="VARCHAR" size="60" autoIncrement="false">
<default/>
diff --git a/src-db/database/model/tables/AD_TEXTINTERFACES.xml b/src-db/database/model/tables/AD_TEXTINTERFACES.xml
--- a/src-db/database/model/tables/AD_TEXTINTERFACES.xml
+++ b/src-db/database/model/tables/AD_TEXTINTERFACES.xml
@@ -47,7 +47,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<foreign-key foreignTable="AD_CLIENT" name="AD_TEXTINTERFACES_AD_CLIENT">
<reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
diff --git a/src-db/database/model/tables/AD_VAL_RULE.xml b/src-db/database/model/tables/AD_VAL_RULE.xml
--- a/src-db/database/model/tables/AD_VAL_RULE.xml
+++ b/src-db/database/model/tables/AD_VAL_RULE.xml
@@ -51,7 +51,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<foreign-key foreignTable="AD_CLIENT" name="AD_VAL_RULE_AD_CLIENT">
<reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
diff --git a/src-db/database/model/tables/AD_WINDOW.xml b/src-db/database/model/tables/AD_WINDOW.xml
--- a/src-db/database/model/tables/AD_WINDOW.xml
+++ b/src-db/database/model/tables/AD_WINDOW.xml
@@ -67,7 +67,7 @@
</column>
<column name="AD_MODULE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
<default><![CDATA[0]]></default>
- <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault>
+ <onCreateDefault/>
</column>
<column name="ISTHREADSAFE" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
<default><![CDATA[N]]></default>
|