-- Assembly sets for Sales Order rules
CREATE TABLE llx_prod_assemblyset (
  rowid integer AUTO_INCREMENT PRIMARY KEY,
  ref varchar(128) NOT NULL,
  description text NULL,
  fk_user_creat integer NULL,
  fk_user_modif integer NULL,
  entity integer DEFAULT 1 NOT NULL,
  tms timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  datec datetime NULL,
  status smallint DEFAULT 1 NOT NULL
) ENGINE=innodb;

ALTER TABLE llx_prod_assemblyset ADD UNIQUE INDEX uk_prod_assemblyset_ref (ref, entity);
