1-- ========================================================================
2-- Copyright (C) 2016	Laurent Destailleur	<eldy@users.sourceforge.net>
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
20CREATE TABLE llx_website_page
21(
22	rowid         integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
23	fk_website    integer NOT NULL,
24	type_container varchar(16) NOT NULL DEFAULT 'page',
25	pageurl       varchar(255) NOT NULL,
26	aliasalt      varchar(255),
27	title         varchar(255),
28	description   varchar(255),
29	image         varchar(255),
30	keywords      varchar(255),
31	lang          varchar(6),
32	fk_page       integer,
33	allowed_in_frames  integer DEFAULT 0,
34	htmlheader	  text,
35	content		  mediumtext,		-- text is not enough in size
36    status        integer DEFAULT 1,
37	grabbed_from  varchar(255),
38    fk_user_creat integer,
39    fk_user_modif integer,
40    author_alias  varchar(64),
41    date_creation datetime,
42	tms           timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
43    import_key    varchar(14),      -- import key
44    object_type   varchar(255),		-- To link page to an object
45    fk_object     varchar(255)		-- To link page to an object
46) ENGINE=innodb;
47