/* 
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
/**
 * Author:  clementcapmartin
 * Created: 29 mars 2020
 */
CREATE TABLE llx_c_motifsrefus ( 
	rowid int(11) NOT NULL AUTO_INCREMENT
	, entity int(11) NOT NULL DEFAULT 1
	, datec datetime DEFAULT NULL
	, tms timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
	, label varchar(255) DEFAULT NULL
	, active integer NOT NULL DEFAULT 1
	, content mediumtext
	, PRIMARY KEY (rowid)
);
