tables.sql

本系统用java+Mysql技术

/* 
SQLyog v3.62
Host - localhost : Database - hoodb
**************************************************************
Server version 4.0.16-nt
*/

create database if not exists `hoodb`;

use `hoodb`;

/*
Table struture for block
*/

drop table if exists `block`;
CREATE TABLE `block` (
  `username` varchar(100) NOT NULL default '',
  `freetime` datetime NOT NULL default '0000-00-00 00:00:00',
  KEY `usernameIndex` (`username`)
) TYPE=MyISAM;

/*
Table struture for message
*/

drop table if exists `message`;
CREATE TABLE `message` (
  `id` int(11) NOT NULL auto_increment,
  `from` varchar(100) NOT NULL default '',
  `to` varchar(100) NOT NULL default '',
  `sendtime` datetime NOT NULL default '0000-00-00 00:00:00',
  `isnew` tinyint(1) NOT NULL default '1',
  `content` text,
  `title` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `to_index` (`to`)
) TYPE=MyISAM;

/*
Table data for hoodb.message
*/

INSERT INTO `message` VALUES 
(2,'admin','20000811026','0000-00-00 00:00:00',0,'wwwwwwwwwwww','w'),
(9,'admin','20000811026','2003-09-30 14:39:21',0,'差点忘了十以下中文，','e'),
(4,'admin','20000811026','0000-00-00 00:00:00',0,'eeeeeeeeeeeeeeeee','e'),
(5,'admin','20000811026','2003-09-27 23:01:59',0,'rrrrrrrrrrrrrrrrrrrrrrrrrrrrrr','r'),
(10,'cc','aa','2003-09-30 15:08:33',0,'aaaaaaaaaaaaaaaaaa',''),
(32,'20000811026','admin','2003-10-02 13:23:42',0,'dddddddddd','Re: r'),
(13,'cc','aa','2003-09-30 15:33:00',0,'sssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssss',''),
(26,'tmd','tmd','2003-09-30 18:52:16',0,'sdfsdf','sdfds'),
(27,'tmd','tmd','2003-09-30 18:52:34',0,'sdfsfsf','Re: sdfds'),
(28,'tmd','tmd','2003-09-30 18:52:39',0,'','Re: sdfds'),
(29,'tmd','tmd','2003-09-30 18:52:46',0,'','Re: sdfds'),
(30,'中文名','admin','2003-09-30 19:01:25',0,'中文','中文'),
(31,'admin','中文名','2003-10-01 00:40:12',0,'中文名','中文名'),
(25,'aa','admin','2003-09-30 17:21:37',0,'终于可以了<dddd>不要出新问题','Re:');

/*
Table struture for user
*/

drop table if exists `user`;
CREATE TABLE `user` (
  `id` int(5) NOT NULL auto_increment,
  `username` char(50) NOT NULL default '',
  `password` char(50) NOT NULL default '',
  `grade` char(5) NOT NULL default '0',
  `totalmessage` int(11) NOT NULL default '0',
  `newmessage` int(11) NOT NULL default '0',
  `lasttime` datetime default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `username_index` (`username`)
) TYPE=MyISAM;

/*
Table data for hoodb.user
*/

INSERT INTO `user` VALUES 
(2,'test','test','0',0,0,'2005-10-02 14:23:26'),
(6,'20000811026','hubo','1',5,5,'2005-10-03 12:44:00'),
(8,'aa','aa','0',0,0,'2005-10-03 12:06:32'),
(16,'dd','dd','0',0,0,'2005-10-02 17:50:02'),
(13,'胡博','hh','0',0,0,'2005-10-02 14:23:26'),
(15,'admin','123456','0',0,0,'2005-10-02 14:23:26');