Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0010732Openbravo ERP00. Application dictionarypublic2009-09-24 11:242012-09-10 16:04
FrancescoFinamore 
marvintm 
normalminoralways
closedout of date 
20rPath Linux
2.50MP5 
 
Core
No
0010732: Config Script problems
I have a module with type "Industry Template",
I have launched this script on db :

ALTER TABLE c_city ADD CONSTRAINT it_nomecitta UNIQUE(c_country_id, c_region_id, name);
ALTER TABLE c_tax ALTER COLUMN isnotaxable SET NOT NULL;

When i launch task "ant export.config.script" i have at the end of the log this message :

Changes that couldn't be exported to the config script:
*******************************************************
AddUniqueChange. Name: IT_NOMECITTA
ColumnRequiredChange. Column: ISNOTAXABLE

But if isn't possible, it's a big limit for a Config Script, i can't customize the existing tables .


--- Added by rafaroda
Besides, disabling or removing an existing unique constraint does not get reflected in the config.script. For instance, remove C_DOCTYPE_NAME unique constraint from C_DOC_TYPE table.
1) Create a Module with type Industry Template
2) Launch scripts :
ALTER TABLE c_city ADD CONSTRAINT it_nomecitta UNIQUE(c_country_id, c_region_id, name);
ALTER TABLE c_tax ALTER COLUMN isnotaxable SET NOT NULL;
3) ALTER TABLE C_DOCTYPE DISABLE CONSTRAINT C_DOCTYPE_NAME
4) Run script task "ant export.config.script"
dev-platform-quick-wins
Issue History
2009-09-24 11:24FrancescoFinamoreNew Issue
2009-09-24 11:24FrancescoFinamoreAssigned To => rafaroda
2009-09-29 23:03psarobeAssigned Torafaroda => iciordia
2009-09-29 23:03psarobeStatusnew => scheduled
2010-10-07 09:52marvintmAssigned Toiciordia => marvintm
2010-12-10 09:16rafarodaDescription Updatedbug_revision_view_page.php?rev_id=1296#r1296
2010-12-10 09:16rafarodaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=1298#r1298
2010-12-10 09:16rafarodaIssue Monitored: rafaroda
2010-12-10 09:16rafarodaTag Attached: dev-platform-quick-wins
2012-05-08 16:37marvintmTypedefect => design defect
2012-09-10 16:04alostaleNote Added: 0051965
2012-09-10 16:04alostaleStatusscheduled => closed
2012-09-10 16:04alostaleResolutionopen => out of date

Notes
(0051965)
alostale   
2012-09-10 16:04   
*Required is already exported to config script
*Unique cannot be exported as it is a new artifact that can be included in a module