<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<title><![CDATA[FrontAccounting forum — COA SQL statement order change preferred]]></title>
		<link>https://frontaccounting.com/punbb/viewtopic.php?id=3330</link>
		<atom:link href="https://frontaccounting.com/punbb/extern.php?action=feed&amp;tid=3330&amp;type=rss" rel="self" type="application/rss+xml" />
		<description><![CDATA[The most recent posts in COA SQL statement order change preferred.]]></description>
		<lastBuildDate>Sun, 09 Sep 2012 13:40:40 +0000</lastBuildDate>
		<generator>PunBB</generator>
		<item>
			<title><![CDATA[Re: COA SQL statement order change preferred]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=13301#p13301</link>
			<description><![CDATA[<p>Fair enough. Atleast the order of the SQL statements would make it easier to track the changes - All DROP DATABASE statements first, then all the CREATE DATABASE statements and then the INSERT INTO statements all the while maintaining the alphabetical order of table names.</p><p>This way, each COA needs to change only in the last part - INSERT INTO statemenst alone.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Sun, 09 Sep 2012 13:40:40 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=13301#p13301</guid>
		</item>
		<item>
			<title><![CDATA[Re: COA SQL statement order change preferred]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=13297#p13297</link>
			<description><![CDATA[<p>We prefer to have complete sql init files for every separate country/coa type. This make&nbsp; major version upgrade easier. Next FA version will include switch to internal utf8 tables, and any selected&nbsp; user encoding. Now this is handled improperly.<br />Janusz</p>]]></description>
			<author><![CDATA[null@example.com (itronics)]]></author>
			<pubDate>Sun, 09 Sep 2012 08:21:01 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=13297#p13297</guid>
		</item>
		<item>
			<title><![CDATA[COA SQL statement order change preferred]]></title>
			<link>https://frontaccounting.com/punbb/viewtopic.php?pid=13292#p13292</link>
			<description><![CDATA[<p>Since the chart of accounts across all countries have the same table schema isn&#039;t it advisable to bundle the &quot;DROP TABLE&quot;, &quot;CREATE TABLE&quot; and some of the common &quot;INSERT INTO&quot; SQL statements into a single database.sql file with the implementation specific &quot;INSERT INTO&quot; SQL data statements (bearing the COA data / demo data) being separated into another sql file?</p><p>As there is no provision on this board to attach COAs, I am unable to provide the SG and IN COA files for v2.3.11+ with the new SQL statement order format.</p><p><strong>Caveat</strong> - the use of UTF8, Latin1 or other collation may warrant a set of ALTER TABLE statements for certain implementations if the proposed order and file separation is used.</p>]]></description>
			<author><![CDATA[null@example.com (apmuthu)]]></author>
			<pubDate>Sat, 08 Sep 2012 21:47:00 +0000</pubDate>
			<guid>https://frontaccounting.com/punbb/viewtopic.php?pid=13292#p13292</guid>
		</item>
	</channel>
</rss>
