From 4410a3d62f37dd01feba6aaaa9a1090248aa0d6a Mon Sep 17 00:00:00 2001
From: einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46>
Date: Sat, 30 Sep 2006 15:01:08 +0000
Subject: Fixed Pg-tables.sql, added scripts to configure replication

git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@174 4979c152-3d1c-0410-bac9-87ea11338e46
---
 sql/Pg-tables.sql | 13 ++++++-------
 1 file changed, 6 insertions(+), 7 deletions(-)

(limited to 'sql/Pg-tables.sql')

diff --git a/sql/Pg-tables.sql b/sql/Pg-tables.sql
index 896dae28..9cd3f939 100755
--- a/sql/Pg-tables.sql
+++ b/sql/Pg-tables.sql
@@ -24,7 +24,7 @@ CREATE TABLE makemodel (
 );
 --
 CREATE TABLE gl (
-  id int DEFAULT nextval ( 'id' ) PRIMAY KEY,
+  id int DEFAULT nextval ( 'id' ) PRIMARY KEY,
   reference text,
   description text,
   transdate date DEFAULT current_date,
@@ -41,8 +41,7 @@ CREATE TABLE chart (
   category char(1),
   link text,
   gifi_accno text,
-  contra bool DEFAULT 'f',
-  PRIMARY KEY (id)
+  contra bool DEFAULT 'f'
 );
 --
 CREATE TABLE gifi (
@@ -261,7 +260,7 @@ CREATE TABLE customertax (
 CREATE TABLE vendortax (
   vendor_id int,
   chart_id int,
-  PRIMARKY KEY (vendor_id, chart_id)
+  PRIMARY KEY (vendor_id, chart_id)
 );
 --
 CREATE TABLE oe (
@@ -424,7 +423,7 @@ CREATE TABLE department (
 -- department transaction table
 CREATE TABLE dpt_trans (
   trans_id int PRIMARY KEY,
-  department_id int,
+  department_id int
 );
 --
 -- business table
@@ -454,7 +453,7 @@ CREATE TABLE inventory (
   qty numeric,
   shippingdate date,
   employee_id int,
-  entry_id SERIAL PRIMARY KEY,
+  entry_id SERIAL PRIMARY KEY
 );
 --
 CREATE TABLE yearend (
@@ -490,7 +489,7 @@ CREATE TABLE partscustomer (
 );
 --
 CREATE TABLE language (
-  code varchar(6) SERIAL PRIMARY KEY,
+  code varchar(6) PRIMARY KEY,
   description text
 );
 --
-- 
cgit v1.2.3