[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: DB company default_language

Hello Chris,

On the next db-update release, following statements should be executed.
But i do not know where to put them.

ALTER TABLE entity_credit_account alter column language_code set default 'en';
ALTER TABLE entity_credit_account ADD FOREIGN KEY (language_code)

in sql/upgrade/???
in sql/upgrade/svn/???

Best wishes,

2011/11/23 Chris Travers <..hidden..>:
> On Tue, Nov 22, 2011 at 1:25 PM, herman vierendeels
> <..hidden..> wrote:
>> Hi Chris,
>> There already is a field  language_code in entity_credit_account.
>> But there is something i do not understand in
>> sql/modules/Company.sql
>> CREATE OR REPLACE FUNCTION entity_credit_save
>> all parameters have a name structure like in_fieldname
>> except in_language
>> May i not change  in_language to in_language_code ?
> Sure, change this.  Just make sure that any related inputs are renamed
> or created with the name minus the in_ prefix.
>> Should we also not define language_code in entity_credit_account as:
>> in_language_code varchar(6) with default 'en_US'   references
>> language(code) on delete SET DEFAULT
> Sure.
>> As we are discussing web-services, fat client <--> api-layer <--> fat
>> DB-function, we should protect
>> db-fields as much as possible , are we not ?
> The procedural API is how the db is encapsulated.  I think *most* fat
> clients should go through the db API directly (for example, web
> services to a POS terminal adds complexity and latency into a very
> performance-sensitive environment).
> There are however a number of use cases where web services beat the db api....
> Hope this makes sense.
> Best Wishes,
> Chris Travers
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel