SF.net SVN: ledger-smb: [614] trunk/sql

[..hidden..]

Revision: 614
          http://svn.sourceforge.net/ledger-smb/?rev=614&view=rev
Author:   christopherm
Date:     2006-11-14 20:56:55 -0800 (Tue, 14 Nov 2006)

Log Message:
-----------
Removing UTF8 named copies of the Chinese sql files

Removed Paths:
-------------
    trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql
    trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql

Deleted: trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql
===================================================================
--- trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql	2006-11-15 04:55:23 UTC (rev 613)
+++ trunk/sql/Simplified-Chinese_Default-UTF8-chart.sql	2006-11-15 04:56:55 UTC (rev 614)
@@ -1,92 +0,0 @@
-begin;
--- Default chart of accounts -- sample only
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','åäæåç','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','éæèå','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','èäèæ','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500','äççé','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','éåçé','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','èèçé','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','ååçé','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000','èéææ','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5400','èèæå','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','æååççæå','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1205','åååæ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','æåèä','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','èæèä','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1825','çèåæäæ - èçåèå.','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1845','çèåæäæ - èèåå','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','æåèå','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620','éèåæ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3600','æåçé','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2160','åäååç','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3590','äççé - ååå','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','æéèä','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','åèèä','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5615','ååèé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5790','åå','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5700','ååçå','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','æåé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5610','äèæå','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5685','äé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5660','åææå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5620','åå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5680','æåç','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5690','åæåéèæçè','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','èè','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5420','äéæå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5430','éäéæå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5440','èåéæå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5470','ååçå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','éå / èä','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4440','åæ','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100','èè','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5760','çé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530','åå / èä','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1540','åå / äçååéä','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4040','éå / äçååéä','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','èéææ / èä','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','éè','A','','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5040','èéææ / äçååéä','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1065','éçé','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820','åååèçåèå','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5785','æèååä','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2680','èäèæ','A','','L','AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5795','æåè','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5780','çäè','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5781','çèèçè','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5765','çäççè','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2311','åæç','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4430','èéè','A','','I','IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','åå / çä','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','èéææ / çä','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100','åäåæ','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1840','èèåå','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4330','çåèè','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','éå / çä','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4320','èè','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','åæåæ','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1061','æçæå','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2310','ååæåç','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
---
--- exchange rate
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4450','Foreign Exchange Gain','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5810','Foreign Exchange Loss','A','','E','');
---
-insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.07);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '2311'),0.08);
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'CAD');
-
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
---
-commit;

Deleted: trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql
===================================================================
--- trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql	2006-11-15 04:55:23 UTC (rev 613)
+++ trunk/sql/Traditional-Chinese_Default-UTF8-chart.sql	2006-11-15 04:56:55 UTC (rev 614)
@@ -1,92 +0,0 @@
-begin;
--- Default chart of accounts -- sample only
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2190','æäæåç','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2600','éæèå','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3300','èäèæ','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3500','äççé','H','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4000','éåçé','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4300','èèçé','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4400','ååçé','H','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5000','èéææ','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5400','èèæå','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5600','æååççæå','H','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1205','åååæ','A','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1000','æåèç','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1800','èæèç','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1825','çèåæäæ - èçåèå.','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link,contra) values ('1845','çèåæäæ - éèåå','A','','A','','1');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2000','æåèå','H','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2620','éèåæ','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3600','æåçé','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2160','æäååç','A','','L','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3590','äççé - ååå','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('3350','æéèä','A','','Q','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1500','åèèç','H','','A','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5615','ååèé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5790','åå','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5700','èåçå','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5800','æåé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5610','æèæå','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5685','äé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5660','åææå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5620','åå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5680','æåç','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5690','åæåéèæçè','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5410','èè','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5420','äéæå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5430','éäéæå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5440','èåéæå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5470','ååçå','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4030','éå / èé','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4440','åæ','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5100','éè','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5760','çé','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1530','åå / èé','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1540','åå / äçååéä','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4040','éå / äçååéä','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5030','èéææ / èé','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5010','æè','A','','E','AP_amount:IC_cogs:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5040','èéææ / äçååéä','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1065','éçé','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1820','èååèçåèå','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5785','æèååæ','A','','E','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2680','èæèæ','A','','L','AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5795','èåè','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5780','éäè','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5781','çèéçè','A','','E','AP_amount:IC_expense');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5765','çäççè','A','','E','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2311','åæç','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4430','ééè','A','','I','IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1520','åå / çé','A','','A','IC');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5020','èéææ / çé','A','','E','AP_amount:IC_cogs');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2100','æäåæ','A','','L','AP');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1840','éèåå','A','','A','AP_amount');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4330','çåèè','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4020','éå / çé','A','','I','AR_amount:IC_sale');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4320','èè','A','','I','AR_amount:IC_income');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1200','ææåæ','A','','A','AR');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('1061','æçæé','A','','A','AR_paid:AP_paid');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('2310','ååæåç','A','','L','AR_tax:AP_tax:IC_taxpart:IC_taxservice');
---
--- exchange rate
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('4450','Foreign Exchange Gain','A','','I','');
-insert into chart (accno,description,charttype,gifi_accno,category,link) values ('5810','Foreign Exchange Loss','A','','E','');
---
-insert into tax (chart_id,rate) values ((select id from chart where accno = '2310'),0.07);
-insert into tax (chart_id,rate) values ((select id from chart where accno = '2311'),0.08);
---
-INSERT INTO defaults (setting_key, value) VALUES ('inventory_accno_id', (select id from chart where accno = '1520'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('income_accno_id', (select id from chart where accno = '4020'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('expense_accno_id', (select id from chart where accno = '5010'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxgain_accno_id', (select id from chart where accno = '4450'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('fxloss_accno_id', (select id from chart where accno = '5810'));
-
- INSERT INTO defaults (setting_key, value) VALUES ('curr', 'USD');
-
- INSERT INTO defaults (setting_key, value) VALUES ('weightunit', 'kg');
---
-commit;


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.