# $Id: mysql.sql,v 1.3 2005/10/22 08:21:02 ohwada Exp $

# =========================================================
# SQL: create table
# 2005-10-01 K.OHWADA
# =========================================================

#
# Table structure for table `whatsnew_module`
#

CREATE TABLE whatsnew_module (
  id smallint(5) unsigned NOT NULL auto_increment,
  mid int(5) unsigned NOT NULL default '0',
  dirname varchar(100) NOT NULL default '',
  block_show  tinyint(2) unsigned NOT NULL default '0',
  block_limit int(5)     unsigned NOT NULL default '0',
  rss_show    tinyint(2) unsigned NOT NULL default '0',
  rss_limit   int(5)     unsigned NOT NULL default '0',
  block_icon varchar(100) default '',
  aux_int_1 int(5) default '0',
  aux_int_2 int(5) default '0',
  aux_text_1 varchar(100) default '',
  aux_text_2 varchar(100) default '',
  PRIMARY KEY (id),
  KEY mid (mid)
) TYPE=MyISAM;

#
# Table structure for table `whatsnew_config`
# modify from system `config`
#

CREATE TABLE whatsnew_config (
  id smallint(5) unsigned NOT NULL auto_increment,
  conf_id smallint(5) unsigned NOT NULL default 0,
  conf_name varchar(25) NOT NULL default '',
  conf_value text NOT NULL,
  aux_int_1 int(5) default '0',
  aux_int_2 int(5) default '0',
  aux_text_1 varchar(100) default '',
  aux_text_2 varchar(100) default '',
  PRIMARY KEY (id),
  KEY conf_id (conf_id)
) TYPE=MyISAM;

