DROP TABLE IF EXISTS order_product;

-- DROP SEQUENCE IF EXISTS order_product_order_product_id_seq;
-- CREATE SEQUENCE order_product_order_product_id_seq;


CREATE TABLE order_product (
  "order_product_id" int PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY, -- SERIAL PRIMARY KEY
  "order_id" int check ("order_id" > 0) NOT NULL,
  "product_id" int check ("product_id" > 0) NOT NULL,
  "name" varchar(191) NOT NULL,
  "model" varchar(64) NOT NULL,
  "quantity" int NOT NULL,
  "price" decimal(15,4) NOT NULL DEFAULT 0.0000,
  "total" decimal(15,4) NOT NULL DEFAULT 0.0000,
  "tax" decimal(15,4) NOT NULL DEFAULT 0.0000,
  "points" int NOT NULL DEFAULT 0
  -- PRIMARY KEY("order_product_id")
);

CREATE INDEX "order_product_order_id" ON order_product ("order_id");
CREATE INDEX "order_product_product_id" ON order_product ("product_id");
-- SELECT setval('order_product_order_product_id_seq', 0, true); -- last inserted id by sample data