X-Git-Url: http://wagnertech.de/gitweb/gitweb.cgi/mfinanz.git/blobdiff_plain/397e706b4c72c9fe818b8c549b7ae59fe7671d95..b2bedb6b5eff41a17ddb194df1c75213b841f3bb:/sql/Pg-upgrade2/shops.sql

diff --git a/sql/Pg-upgrade2/shops.sql b/sql/Pg-upgrade2/shops.sql
new file mode 100644
index 000000000..840b095e0
--- /dev/null
+++ b/sql/Pg-upgrade2/shops.sql
@@ -0,0 +1,21 @@
+-- @tag: shops
+-- @description: Tabelle fÃ¼r Shops
+-- @depends: release_3_5_0 customer_klass_rename_to_pricegroup_id_and_foreign_key
+-- @ignore: 0
+
+CREATE TABLE shops (
+  id SERIAL PRIMARY KEY,
+  description text,
+  obsolete BOOLEAN NOT NULL DEFAULT false,
+  sortkey INTEGER,
+  connector text,     -- hardcoded options, e.g. xtcommerce, shopware
+  pricetype text,     -- netto/brutto
+  price_source text,  -- sellprice/listprice/lastcost or pricegroup id
+  taxzone_id INTEGER,
+  last_order_number INTEGER,
+  orders_to_fetch INTEGER,
+  url text,
+  port INTEGER,
+  login text,  -- "user" is reserved
+  password text
+);
