easy.sql

为我们学校开发的一个住房货币化补贴工作的专题网站

-- MySQL dump 9.11
--
-- Host: localhost    Database: easy
-- ------------------------------------------------------
-- Server version	4.0.24-standard

--
-- Table structure for table `admin`
--

CREATE TABLE admin (
  id tinyint(8) NOT NULL auto_increment,
  name varchar(32) default NULL,
  passwd varchar(255) default NULL,
  priv tinyint(4) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `admin`
--

INSERT INTO admin VALUES (1,'root','root',NULL);
INSERT INTO admin VALUES (2,'abcd','',NULL);
INSERT INTO admin VALUES (3,'aaa','aaa',NULL);

--
-- Table structure for table `news`
--

CREATE TABLE news (
  id tinyint(4) NOT NULL auto_increment,
  author varchar(32) default NULL,
  dates datetime default NULL,
  title varchar(255) default NULL,
  content varchar(255) default NULL,
  isshow enum('0','1') default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `news`
--

INSERT INTO news VALUES (5,'a','2006-12-01 01:51:00','Octerber2','The 10th month of the year.2','1');
INSERT INTO news VALUES (14,NULL,NULL,'Decmember','The last month of the year.','1');
INSERT INTO news VALUES (15,NULL,NULL,'Test','TestUpload',NULL);
INSERT INTO news VALUES (16,NULL,NULL,'UploadTest','UploadContent',NULL);

--
-- Table structure for table `upload`
--

CREATE TABLE upload (
  id int(10) unsigned NOT NULL auto_increment,
  source int(11) NOT NULL default '0',
  path varchar(255) NOT NULL default '',
  filename varchar(65) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Dumping data for table `upload`
--

INSERT INTO upload VALUES (10,16,'upload/jpg|gif|bmp/1165239051.jpg','3322.jpg');
INSERT INTO upload VALUES (11,16,'upload/jpg|gif|bmp/1165239493.gif','ArtsDev.gif');

--
-- Table structure for table `userinfo`
--

CREATE TABLE userinfo (
  id tinyint(4) NOT NULL auto_increment,
  name varchar(8) NOT NULL default '',
  passwd varchar(32) default NULL,
  mail varchar(30) default NULL,
  PRIMARY KEY  (id,name)
) TYPE=MyISAM;

--
-- Dumping data for table `userinfo`
--

INSERT INTO userinfo VALUES (1,'root','root',NULL);
INSERT INTO userinfo VALUES (2,'1','1',NULL);
INSERT INTO userinfo VALUES (3,'2','2',NULL);
INSERT INTO userinfo VALUES (4,'5','5',NULL);
INSERT INTO userinfo VALUES (5,'bb','bbb',NULL);
INSERT INTO userinfo VALUES (6,'easy','easy',NULL);
INSERT INTO userinfo VALUES (7,'aaa','aaa',NULL);
INSERT INTO userinfo VALUES (8,'a','a',NULL);
INSERT INTO userinfo VALUES (20,'ab','ab',NULL);
INSERT INTO userinfo VALUES (21,'abc','ag',NULL);