sql/Pg-upgrade/Pg-upgrade-2.2.0.6-2.2.0.7.sql

   1 CREATE TABLE "rma" (
   2         "id" integer DEFAULT nextval('id'::text) PRIMARY KEY,
   3         "rmanumber" text NOT NULL,
   4         "transdate" date DEFAULT date('now'::text),
   5         "vendor_id" integer,
   6         "customer_id" integer,
   7         "amount" numeric (15,5),
   8         "netamount" numeric (15,5),
   9         "reqdate" date,
  10         "taxincluded" boolean,
  11         "shippingpoint" text,
  12         "notes" text,
  13         "curr" character(3),
  14         "employee_id" integer,
  15         "closed" boolean DEFAULT 'f',
  16         "quotation" boolean DEFAULT 'f',
  17         "quonumber" text,
  18         "cusrmanumber" text,
  19         "intnotes" text,
  20         "delivery_customer_id" integer,
  21         "delivery_vendor_id" integer,
  22         "language_id" integer,
  23         "payment_id" integer,
  24         "department_id" integer DEFAULT 0,
  25         "itime" timestamp DEFAULT now(),
  26         "mtime" timestamp,
  27         "shipvia" text,
  28         "cp_id" integer
  29 );
  30
  31 CREATE TABLE "rmaitems" (
  32         "trans_id" integer,
  33         "parts_id" integer REFERENCES parts (id),
  34         "description" text,
  35         "qty" real,
  36         "base_qty" real,
  37         "sellprice" numeric (15,5),
  38         "discount" real,
  39         "unit" character varying(10),
  40         "project_id" integer,
  41         "reqdate" date,
  42         "ship" real,
  43         "serialnumber" text,
  44         "id" integer DEFAULT nextval('orderitemsid'::text),
  45         "itime" timestamp DEFAULT now(),
  46         "mtime" timestamp,
  47         "pricegroup_id" integer,
  48         "rmanumber" text,
  49         "transdate" text,
  50         "cusrmanumber" text
  51 );
  52
  53 alter table defaults add column rmanumber text;