http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7840
--- Comment #7 from Galen Charlton <[email protected]> --- (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. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
