1-- ============================================================================
2-- Copyright (C) 2015       Alexandre Spangaro  <aspangaro@open-dsi.fr>
3--
4-- This program is free software; you can redistribute it and/or modify
5-- it under the terms of the GNU General Public License as published by
6-- the Free Software Foundation; either version 3 of the License, or
7-- (at your option) any later version.
8--
9-- This program is distributed in the hope that it will be useful,
10-- but WITHOUT ANY WARRANTY; without even the implied warranty of
11-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
12-- GNU General Public License for more details.
13--
14-- You should have received a copy of the GNU General Public License
15-- along with this program. If not, see <https://www.gnu.org/licenses/>.
16--
17-- ============================================================================
18--
19-- Structure de la table llx_establishment
20--
21
22CREATE TABLE llx_establishment (
23  rowid 			integer NOT NULL auto_increment PRIMARY KEY,
24  entity 			integer NOT NULL DEFAULT 1,
25  ref				varchar(30),
26  name				varchar(128),
27  address           varchar(255),
28  zip               varchar(25),
29  town              varchar(50),
30  fk_state          integer DEFAULT 0,
31  fk_country        integer DEFAULT 0,
32  profid1			varchar(20),
33  profid2			varchar(20),
34  profid3			varchar(20),
35  phone				varchar(20),
36  fk_user_author 	integer NOT NULL,
37  fk_user_mod		integer,
38  datec				datetime NOT NULL,
39  tms				timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL,
40  status            tinyint DEFAULT 1
41) ENGINE=innodb;
42
43