RE: [OpenCA-Devel] Signature handling

[Obes, Til]

Db structure suggestion:

CREATE TABLE `lang_setup` (
  `ID` tinyint(3) unsigned NOT NULL auto_increment,
  `IS_DEFAULT` tinyint(1) unsigned NOT NULL default '0',
  `IS_ONLINE` tinyint(1) unsigned NOT NULL default '0',
  `LANG` varchar(16) NOT NULL default '',
  `LANG_TOKEN` char(5) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

CREATE TABLE `website_text` (
  `KEY_ID` int(10) unsigned NOT NULL default '0',
  `LANG_ID` tinyint(3) unsigned NOT NULL default '0',
  `TEXT` mediumtext,
  PRIMARY KEY  (`KEY_ID`,`LANG_ID`)
) TYPE=MyISAM;

CREATE TABLE `website_text_categories` (
  `ID` tinyint(3) unsigned NOT NULL auto_increment,
  `NAME` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`ID`)
) TYPE=MyISAM;

CREATE TABLE `website_text_keys` (
  `ID` int(10) unsigned NOT NULL auto_increment,
  `CAT_ID` tinyint(3) unsigned NOT NULL default '0',
  `TEXT_KEY` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`ID`,`TEXT_KEY`,`CAT_ID`)
) TYPE=MyISAM;


Data:

lang_setup: '1','1','1','English','en_EN'
website_text_categories: '1','pub_req_new'
website_text_keys: '1','1','OPENCA_I18N_PUB_REQ_NEW_TEXT1'
website_text: '1','1','Enter the following data to request a generate a new
request'

References between tables:
website_text.KEY_ID=website_text_keys.ID
(rest should be clear)

Regards til

smime.p7s
Description: S/MIME cryptographic signature