-- Table: llx_product_price_by_qty

-- DROP TABLE llx_product_price_by_qty;

CREATE TABLE llx_product_price_by_qty
(
  rowid serial NOT NULL,
  fk_product_price integer NOT NULL,
  date_price timestamp,
  price numeric(24,8) DEFAULT 0,
  price_ttc numeric(24,8) DEFAULT NULL,
  qty_min real DEFAULT 0,
  qty_max real DEFAULT (999999999),
  CONSTRAINT llx_product_price_by_qty_pkey PRIMARY KEY (rowid)
)

);

-- Table: llx_product_price_by_qty

-- DROP TABLE llx_product_price_by_qty;

CREATE TABLE llx_product_price_by_qty
(
  rowid serial NOT NULL,
  fk_product_price integer NOT NULL,
  date_price timestamp,
  price numeric(24,8) DEFAULT 0,
  price_ttc numeric(24,8) DEFAULT NULL,
  qty_min real DEFAULT 0,
  qty_max real DEFAULT (999999999),
  CONSTRAINT llx_product_price_by_qty_pkey PRIMARY KEY (rowid)
)

);