USE pos_db;

DROP TABLE IF EXISTS store_items;

CREATE TABLE store_items (
  item_id    INT AUTO_INCREMENT PRIMARY KEY,
  itemname   VARCHAR(200),
  barcode    VARCHAR(100),
  bprice     DECIMAL(10,2),
  sspprice   DECIMAL(10,2),
  minprice   DECIMAL(10,2),
  wsprice    DECIMAL(10,2),
  retprice   DECIMAL(10,2),
  groupname  VARCHAR(100),
  drawer     VARCHAR(50),
  modelname  VARCHAR(100)
);