note.sql

本系统采用jsp编写,数据库采用的是MYSQL,使用JDBC驱动

-- MySQL dump 9.08
--
-- Host: localhost    Database: note
---------------------------------------------------------
-- Server version	4.0.13-nt

--
-- Table structure for table 'admin'
--

CREATE TABLE admin (
  admin_name char(20) NOT NULL default '',
  admin_password char(20) NOT NULL default '',
  PRIMARY KEY  (admin_name)
) TYPE=MyISAM;

--
-- Dumping data for table 'admin'
--

INSERT INTO admin VALUES ('admin','admin');

--
-- Table structure for table 'guest'
--

CREATE TABLE guest (
  id int(11) NOT NULL auto_increment,
  username varchar(20) NOT NULL default '',
  sex char(2) NOT NULL default '',
  email varchar(20) default NULL,
  QQ varchar(9) default NULL,
  url varchar(24) default NULL,
  title text NOT NULL,
  content text NOT NULL,
  time datetime NOT NULL default '0000-00-00 00:00:00',
  images text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'guest'
--

INSERT INTO guest VALUES (64,'白鹰','男','[e-mail]','38998186','http://www.ntsky.com','欢迎光临！','管理员的用户名和密码分别是admin,admin','2003-07-14 19:38:30','images/image/12.gif');

--
-- Table structure for table 'reply'
--

CREATE TABLE reply (
  replyid int(11) NOT NULL default '0',
  content text,
  time datetime default NULL
) TYPE=MyISAM;

--
-- Dumping data for table 'reply'
--

INSERT INTO reply VALUES (48,'很好啊！！','2003-06-30 15:32:31');
INSERT INTO reply VALUES (34,'asdf','2003-06-30 11:39:52');
INSERT INTO reply VALUES (54,'asdfasfdasdf','2003-07-13 22:48:48');
INSERT INTO reply VALUES (46,'asdfasf','2003-07-13 23:08:58');
INSERT INTO reply VALUES (46,'a\r\nkl;','2003-07-13 23:09:03');
INSERT INTO reply VALUES (45,'ads\r\ngjfgj','2003-07-13 23:09:14');
INSERT INTO reply VALUES (44,'asf<br>\njj','2003-07-13 23:09:50');

--
-- Table structure for table 'usr'
--

CREATE TABLE usr (
  id int(11) NOT NULL auto_increment,
  username char(20) NOT NULL default '',
  sex char(2) NOT NULL default '',
  password char(10) NOT NULL default '',
  qq char(9) default NULL,
  email char(40) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'usr'
--