From 9ac0e51a1c397f0652e51ccdbd5b76090c7326e5 Mon Sep 17 00:00:00 2001
From: einhverfr If you already built a dataset without this change you will get
-an error when you try to save a PO or assembly.
-
- "ERROR: column "oid" does not exist"
-
- Drop the tables and rebuild WITH OIDS.
-
PostgreSQL 8.0+
-
-To use LedgerSMB with PostgreSQL 8.0+ you have to modify
-Pg-tables.sql. This file is in the sql directory.
-
-
-CREATE TABLE orderitems (
- trans_id int,
- parts_id int,
- description text,
- qty float4,
- sellprice float8,
- discount float4,
- unit varchar(5),
- project_id int,
- reqdate date,
- ship float4,
- serialnumber text,
- id int default nextval('orderitemsid')
-) WITH OIDS;
-
-CREATE TABLE inventory (
- warehouse_id int,
- parts_id int,
- trans_id int,
- orderitems_id int,
- qty float4,
- shippingdate date,
- employee_id int
-) WITH OIDS;
-
-CREATE TABLE assembly (
- id int,
- parts_id int,
- qty float,
- bom bool,
- adj bool
-) WITH OIDS;
-
-
-This change is only required for LedgerSMB versions 2.6.3 and below.
-
-Japanese characters
modify apache so that EUC_JP is the main additional language.
comment out all unrelated languages except, UTF_8 shift jis, EUC_JP
@@ -193,6 +144,10 @@ To make them work load the template either with the builtin template editor
or a text editor and save. Templates designed on a Windows platform have the
same problem and won't work on a UNIX platform. Once you strip the ^M's
the'll work just fine.
+
+Note too that most Linux and UNIX installations come with two utilities for making these +conversions: unix2dos and dos2unix. Windows users can obtain these utilities as part of +Cygwin.
include the terminal variable on the URL -
- http://localhost/ledger-smb/login.pl?terminal=lynx-Valid terminal variables are lynx, mozilla and js - -