FrontAccounting forum — about database

Re: about database

null@example.com (itronics) — Tue, 28 Apr 2009 22:16:19 +0000

Only primary keys as used as foreign keys, so if you wish you can translate any unique key which is not primary. But translated text have to be unique of course.
The double auto_increment clause is MySQL dump issue, you can delete one of the two if you wish.
Janusz

Re: about database

null@example.com (Leo) — Mon, 27 Apr 2009 15:21:00 +0000

CREATE TABLE `0_credit_status` (
`id` int(11) NOT NULL auto_increment,
`reason_description` char(100) NOT NULL default '',
`dissallow_invoices` tinyint(1) NOT NULL default '0',
`inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `reason_description` (`reason_description`)
) TYPE=MyISAM AUTO_INCREMENT=5 AUTO_INCREMENT=5 ;

for example, i want to translate the reason_description in the credit_status table.

and why in this table, there are 2 AUTO_INCREMENT?

thanks a lot

Re: about database

null@example.com (itronics) — Mon, 27 Apr 2009 07:14:36 +0000

what about foreign key?

Which unique keys do you want to translate?
JAnusz

Re: about database

null@example.com (Leo) — Sun, 26 Apr 2009 14:14:52 +0000

joe wrote:

Regarding the differences between the 'tax_group_items' fields in en_US-demo.sql and en_US-new.sql, you are right. In en_US-demo.sql there is a field called 'included_in_price'. This field is obsolete and will be removed in the next release.
/Joe

thanks Joe

Re: about database

null@example.com (Leo) — Sun, 26 Apr 2009 14:13:02 +0000

itronics wrote:

Why not? But you should also use the same translated value in other table, if it is used as foreign key.
Janusz

thanks Janusz

what about foreign key?

Re: about database

null@example.com (joe) — Sat, 25 Apr 2009 15:31:56 +0000

Regarding the differences between the 'tax_group_items' fields in en_US-demo.sql and en_US-new.sql, you are right. In en_US-demo.sql there is a field called 'included_in_price'. This field is obsolete and will be removed in the next release.

/Joe

Re: about database

null@example.com (Leo) — Sat, 25 Apr 2009 15:00:02 +0000

hi Janusz.

i didn't see the foreign key in the sql script. where is it? in the en_US_new.sql just have the primary key, unique key, key, there are not foreign key constraint.

Re: about database

null@example.com (itronics) — Sat, 25 Apr 2009 14:44:45 +0000

Why not? But you should also use the same translated value in other table, if it is used as foreign key.
Janusz

Re: about database

null@example.com (Leo) — Sat, 25 Apr 2009 13:44:32 +0000

another question. i have a little ideas about database. the unique key in the table can be tanslated into chinese?

thanks
/leo

Re: about database

null@example.com (Leo) — Sat, 25 Apr 2009 13:42:46 +0000

my meaning is that the table fields are different.

Re: about database

null@example.com (joe) — Sat, 25 Apr 2009 12:45:01 +0000

It is because there is more demo data in the en_US-demo.sql file.

/Joe

about database

null@example.com (Leo) — Sat, 25 Apr 2009 12:27:17 +0000

hi.
why the table 0_tax_group_items in the en_US_new.sql different from in the en_US_demo.sql

/leo

thanks everyone for help.