SF.net SVN: ledger-smb:[4662] addons/1.3/colombia_general

[..hidden..]

Revision: 4662
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4662&view=rev
Author:   einhverfr
Date:     2012-04-23 10:01:16 +0000 (Mon, 23 Apr 2012)
Log Message:
-----------
Schema changes for COlombia module

Added Paths:
-----------
    addons/1.3/colombia_general/sql/
    addons/1.3/colombia_general/sql/modules/
    addons/1.3/colombia_general/sql/modules/colombia-tables.sql

Added: addons/1.3/colombia_general/sql/modules/colombia-tables.sql
===================================================================
--- addons/1.3/colombia_general/sql/modules/colombia-tables.sql	                        (rev 0)
+++ addons/1.3/colombia_general/sql/modules/colombia-tables.sql	2012-04-23 10:01:16 UTC (rev 4662)
@@ -0,0 +1,16 @@
+CREATE TABLE municipality (
+   id serial not null unique,
+   code text primary key,
+   name text not nul unique
+);
+CREATE TABLE province (
+   id serial not null unique,
+   code text primary key,
+   name text not nul unique
+);
+ALTER TABLE country ADD code text unique;
+ALTER TABLE entity ADD province_id int references province (id);
+ALTER TABLE entity ADD municipality_id int references municipality (id);
+
+ALTER TABLE tax ADD base numeric;
+

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