--	/************************************************
--	* Copyright (C) 2016-2020	Sylvain Legrand - <contact@infras.fr>	InfraS - <https://www.infras.fr>
--	*
--	* This program is free software: you can redistribute it and/or modify
--	* it under the terms of the GNU General Public License as published by
--	* the Free Software Foundation, either version 3 of the License, or
--	* (at your option) any later version.
--	*
--	* This program is distributed in the hope that it will be useful,
--	* but WITHOUT ANY WARRANTY; without even the implied warranty of
--	* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
--	* GNU General Public License for more details.
--	*
--	* You should have received a copy of the GNU General Public License
--	* along with this program.  If not, see <http://www.gnu.org/licenses/>.
--	************************************************/

--	/************************************************
--	* 	\file		../infraspackplus/sql/llx_c_infraspackplus_mention.sql
--	* 	\ingroup	InfraS
--	* 	\brief		Create SQL table for module InfraS
--	************************************************/

CREATE TABLE IF NOT EXISTS llx_c_infraspackplus_mention
(
  rowid			integer AUTO_INCREMENT	PRIMARY KEY,
  code			varchar(32)				NOT NULL,
  entity		integer	DEFAULT 1		NOT NULL,		-- multi company id
  pos			integer	DEFAULT 0		NOT NULL,
  libelle		varchar(128)			NOT NULL,
  active		tinyint DEFAULT 1		NOT NULL
)
ENGINE = innodb;