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