[Koha-bugs] [Bug 7840] Remove from manual Koha as a CMS (or add it to master)

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7840

--- Comment #7 from Galen Charlton <gmcharlt at gmail.com> ---
(In reply to comment #5)
> I think maybe we could use the news tool for this. The advantage of the news
> tool is, that it already has some CMS-like functionality and allows you to
> add content in multiple languages. The system preferences are always limited
> in that area.

Interesting idea.  There are a couple aspects of OPAC news as it exists now
that don't map cleanly to the Koha-as-CMS hack, most particularly title and
number, but possibly also expirationdate.  However, a bit of refactoring of the
database tables might lead us to something like this:

CREATE TABLE page_content (
   id int(10) not null auto_increment,
   html text not null,
   PRIMARY KEY (id)
);

CREATE TABLE `opac_news` ( -- data from the news tool
  `idnew` int(10) unsigned NOT NULL auto_increment, -- unique identifier for
the news article
  `title` varchar(250) NOT NULL default '', -- title of the news article
  `lang` varchar(25) NOT NULL default '', -- location for the article (koha is
the staff client, slip is the circulation receipt and language codes are for
the opac)
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP, -- pulibcation date
and time
  `expirationdate` date default NULL, -- date the article is set to expire or
no longer be visible
  `number` int(11) default NULL, -- the order in which this article appears in
that specific location,
  page_content_id int(10) not null,
  CONSTRAINT opac_news_fk1 FOREIGN KEY (page_content_id) REFERENCES
page_content (id) ON DELETE RESTRICT ON UPDATE CASCADE 
  PRIMARY KEY  (`idnew`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE cms_page (
  id int(10) unsigned NOT NULL auto_increment,
  default_page_content_id int(10) null, -- page to use if no specific matching
language available
  PRIMARY KEY (id),
  CONSTRAINT cms_page_fk1 FOREIGN KEY (default_page_content_id) REFERENCES
page_content (id) ON DELETE SET NULL ON UPDATE CASCADE 
);

CREATE TABLE cms_page_lang_map (
  id int(10) unsigned NOT NULL auto_increment,
  lang varchar(25) NOT NULL default ''
  page_content_id int(10) not null,
  PRIMARY KEY (id),
  CONSTRAINT cms_page_lang_map_fk1 FOREIGN KEY (default_page_content_id)
REFERENCES page_content (id) ON DELETE CASCADE ON UPDATE CASCADE 
)

-- 
You are receiving this mail because:
You are watching all bug changes.