CREATE TABLE dif_news_dif_newsicle (
  dif_news_id int(10) unsigned NOT NULL auto_increment,
  dif_news_name varchar(50) default NULL,
  dif_news_author varchar(100) default NULL,
  dif_news_dif_newsicle text,
  dif_news_category int(10) unsigned NOT NULL default '0',
  dif_news_approved int(10) unsigned NOT NULL default '0',
  dif_news_posted int(10) unsigned NOT NULL default '0',
  dif_news_views int(10) unsigned NOT NULL default '0',
  dif_news_viewers text,
  dif_news_unique int(10) unsigned NOT NULL default '0',
  dif_news_rate tinyint(3) unsigned NOT NULL default '0',
  dif_news_comment tinyint(3) unsigned NOT NULL default '0',
  dif_news_expires int(10) unsigned NOT NULL default '0',
  dif_news_order int(10) unsigned NOT NULL default '0',
  dif_news_forum tinyint(3) unsigned NOT NULL default '0',
  PRIMARY KEY  (dif_news_id),
  KEY dif_news_name (dif_news_name),
  KEY dif_news_category (dif_news_category)
) TYPE=MyISAM COMMENT='dif_news dif_newsicles table';

CREATE TABLE dif_news_category (
  dif_news_category_id int(10) NOT NULL auto_increment,
  dif_news_category_name varchar(50) default NULL,
  dif_news_category_description varchar(250) default NULL,
  dif_news_category_updated int(10) unsigned NOT NULL default '0',
  dif_news_category_readclass int(10) unsigned NOT NULL default '0',
  dif_news_category_order int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (dif_news_category_id),
  KEY dif_news_category (dif_news_category_name)
) TYPE=MyISAM COMMENT='dif_news categories table';