lynews.sql

LyNews凌云新闻系统

CREATE TABLE news (
  id int(11) NOT NULL auto_increment,
  class int(6) NOT NULL default '0',
  editer varchar(50) NOT NULL default '',
  title varchar(255) NOT NULL default '',
  newsfile varchar(50) NOT NULL default '',
  date bigint(20) NOT NULL default '0',
  top tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY class (class)
) TYPE=MyISAM;

CREATE TABLE news_admin (
  id int(6) NOT NULL auto_increment,
  username varchar(50) NOT NULL default '',
  password varchar(32) NOT NULL default '',
  flag smallint(3) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY news_admin_1 (username,password)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `news_admin`
#

INSERT INTO news_admin VALUES (1,'admin','0192023A7BBD7325',1);
INSERT INTO news_admin VALUES (2,'edit','EB3CD4F5998527CC',0);


CREATE TABLE news_class (
  id int(6) NOT NULL auto_increment,
  classname varchar(50) NOT NULL default '',
  parentid int(6) NOT NULL default '0',
  orders int(6) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY parentid (parentid)
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `news_class`
#

INSERT INTO news_class VALUES (1,'JAVA技术',0,0);
INSERT INTO news_class VALUES (2,'服务器技术',0,0);
INSERT INTO news_class VALUES (3,'数据库技术',0,0);
INSERT INTO news_class VALUES (4,'J2SE技术',1,1);
INSERT INTO news_class VALUES (5,'J2EE技术',1,1);
INSERT INTO news_class VALUES (6,'J2ME技术',1,1);
INSERT INTO news_class VALUES (7,'WebLogic专栏',2,2);
INSERT INTO news_class VALUES (8,'Tomcat/Resin专栏',2,2);
INSERT INTO news_class VALUES (9,'Oracle数据库',3,3);
INSERT INTO news_class VALUES (10,'Sql Server数据库',3,3);
INSERT INTO news_class VALUES (11,'MySQL数据库',3,3);


CREATE TABLE news_class_counter (
  id int(6) unsigned NOT NULL auto_increment,
  classid int(6) unsigned NOT NULL default '0',
  totaltimes int(10) unsigned NOT NULL default '0',
  recorddate date NOT NULL default '0000-00-00',
  hour0 int(6) unsigned NOT NULL default '0',
  hour1 int(6) unsigned NOT NULL default '0',
  hour2 int(6) unsigned NOT NULL default '0',
  hour3 int(6) unsigned NOT NULL default '0',
  hour4 int(6) unsigned NOT NULL default '0',
  hour5 int(6) unsigned NOT NULL default '0',
  hour6 int(6) unsigned NOT NULL default '0',
  hour7 int(6) unsigned NOT NULL default '0',
  hour8 int(6) unsigned NOT NULL default '0',
  hour9 int(6) unsigned NOT NULL default '0',
  hour10 int(6) unsigned NOT NULL default '0',
  hour11 int(6) unsigned NOT NULL default '0',
  hour12 int(6) unsigned NOT NULL default '0',
  hour13 int(6) unsigned NOT NULL default '0',
  hour14 int(6) unsigned NOT NULL default '0',
  hour15 int(6) unsigned NOT NULL default '0',
  hour16 int(6) unsigned NOT NULL default '0',
  hour17 int(6) unsigned NOT NULL default '0',
  hour18 int(6) unsigned NOT NULL default '0',
  hour19 int(6) unsigned NOT NULL default '0',
  hour20 int(6) unsigned NOT NULL default '0',
  hour21 int(6) unsigned NOT NULL default '0',
  hour22 int(6) unsigned NOT NULL default '0',
  hour23 int(6) unsigned NOT NULL default '0',
  yesterdaytimes int(6) unsigned NOT NULL default '0',
  todaytimes int(6) unsigned NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY id (id,classid,recorddate)
) TYPE=MyISAM;

CREATE TABLE news_config (
  id tinyint(1) unsigned NOT NULL default '0',
  adimage varchar(100) NOT NULL default '',
  adimagelink varchar(100) NOT NULL default '',
  adimagewidth smallint(4) unsigned NOT NULL default '0',
  adimageheight smallint(4) unsigned NOT NULL default '0',
  adimage2 varchar(100) NOT NULL default '',
  adimagelink2 varchar(100) NOT NULL default '',
  adimagewidth2 smallint(4) unsigned NOT NULL default '0',
  adimageheight2 smallint(4) unsigned NOT NULL default '0',
  adimage3 varchar(100) NOT NULL default '',
  adimagelink3 varchar(100) NOT NULL default '',
  adimagewidth3 smallint(4) unsigned NOT NULL default '0',
  adimageheight3 smallint(4) unsigned NOT NULL default '0',
  infoimage varchar(100) NOT NULL default '',
  infoimagewidth smallint(4) unsigned NOT NULL default '0',
  infoimageheight smallint(4) unsigned NOT NULL default '0',
  infoimagelink varchar(255) NOT NULL default '',
  infoimagealt varchar(255) NOT NULL default '',
  marquee varchar(255) NOT NULL default '',
  announcement varchar(255) NOT NULL default '',
  allowuploadext varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY id (id)
) TYPE=MyISAM;

CREATE TABLE news_counter (
  createDate date default '0000-00-00',
  counter int(11) default '0',
  todayDate date default '0000-00-00',
  todayCounter int(11) default '0',
  maxDate date default '0000-00-00',
  maxCounter int(11) default '0'
) TYPE=MyISAM;

#
# 导出下面的数据库内容 `news_counter`
#

INSERT INTO news_counter VALUES ('2003-09-26',0,'2003-09-26',0,'2003-09-26',0);

CREATE TABLE news_pic (
  id int(10) unsigned NOT NULL auto_increment,
  width smallint(5) unsigned NOT NULL default '0',
  height smallint(5) unsigned NOT NULL default '0',
  border tinyint(3) unsigned NOT NULL default '0',
  filename varchar(20) NOT NULL default '',
  alt varchar(255) NOT NULL default '',
  link varchar(255) NOT NULL default '',
  position varchar(20) NOT NULL default '',
  saveat bigint(20) NOT NULL default '0',
  PRIMARY KEY  (id),
  KEY id (id)
) TYPE=MyISAM;