pgsql.initdata/public.whsinfo.sql

diff --git a/pgsql.initdata/public.whsinfo.sql b/pgsql.initdata/public.whsinfo.sql
index e69de29..653acbc 100644 (file)
--- a/pgsql.initdata/public.whsinfo.sql
+++ b/pgsql.initdata/public.whsinfo.sql
@@ -0,0 +1,30 @@
+--
+-- PostgreSQL database dump
+--
+
+SET statement_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = on;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+
+SET search_path = public, pg_catalog;
+
+--
+-- Data for Name: whsinfo; Type: TABLE DATA; Schema: public; Owner: admin
+--
+
+SET SESSION AUTHORIZATION DEFAULT;
+
+ALTER TABLE whsinfo DISABLE TRIGGER ALL;
+
+COPY whsinfo (warehous_id, warehous_code, warehous_descrip, warehous_fob, warehous_active, warehous_counttag_prefix, warehous_counttag_number, warehous_bol_prefix, warehous_bol_number, warehous_shipping, warehous_useslips, warehous_usezones, warehous_aislesize, warehous_aislealpha, warehous_racksize, warehous_rackalpha, warehous_binsize, warehous_binalpha, warehous_locationsize, warehous_locationalpha, warehous_enforcearbl, warehous_default_accnt_id, warehous_shipping_commission, warehous_cntct_id, warehous_addr_id, warehous_transit, warehous_shipform_id, warehous_shipvia_id, warehous_shipcomments, warehous_costcat_id, warehous_sitetype_id, warehous_taxzone_id, warehous_sequence) FROM stdin;
+35     WH1     Main Warehouse          t       WH1     90000   WH1     10000   t       t       f       2       t       2       t       2       t       2       t       f       NULL    0.0000  1       1       f       \N      \N      \N      \N      1       \N      0
+\.
+
+
+ALTER TABLE whsinfo ENABLE TRIGGER ALL;
+
+--
+-- PostgreSQL database dump complete
+--