-- 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 99999,
  CONSTRAINT llx_product_price_by_qty_pkey PRIMARY KEY (rowid)
);


-- Sequence: llx_product_price_by_qty_rowid_seq

-- DROP SEQUENCE llx_product_price_by_qty_rowid_seq;



-- 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 99999,
  CONSTRAINT llx_product_price_by_qty_pkey PRIMARY KEY (rowid)
);