-- MySQL dump 10.10
--
-- Host: localhost Database: sinfosystem
-- ------------------------------------------------------
-- Server version 5.0.15-nt
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `board`
--
DROP TABLE IF EXISTS `board`;
CREATE TABLE `board` (
`id` int(10) unsigned NOT NULL auto_increment,
`title` varchar(45) NOT NULL,
`context` varchar(255) NOT NULL,
`addtime` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `board`
--
/*!40000 ALTER TABLE `board` DISABLE KEYS */;
LOCK TABLES `board` WRITE;
INSERT INTO `board` VALUES (1,'test','test','2007-12-29 00:00:00'),(2,'哈哈哈啊','忍忍忍没哟也','2008-01-02 00:00:00'),(3,'天天','顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶顶地点 ','2008-01-29 00:00:00');
UNLOCK TABLES;
/*!40000 ALTER TABLE `board` ENABLE KEYS */;
--
-- Table structure for table `checkfield`
--
DROP TABLE IF EXISTS `checkfield`;
CREATE TABLE `checkfield` (
`SID` char(15) NOT NULL,
`visiableField` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `checkfield`
--
/*!40000 ALTER TABLE `checkfield` DISABLE KEYS */;
LOCK TABLES `checkfield` WRITE;
INSERT INTO `checkfield` VALUES ('0517285','dormaddress'),('0517285','dormphone'),('0517285','mobilephone'),('0517285','homephone'),('0517285','email'),('0517285','QQ'),('0517285','homeaddress'),('0517285','postid'),('0517285','gender'),('0517285','face'),('0517285','birthday'),('0517285','area'),('0517285','backg'),('0517286','dormaddress'),('0517286','homephone'),('0517286','email'),('0517286','QQ'),('0517286','homeaddress'),('0517286','birthday'),('0517286','backg'),('0517287','dormaddress'),('0517287','dormphone'),('0517287','email'),('0517287','QQ'),('0517287','homeaddress'),('0517287','area'),('0517287','backg');
UNLOCK TABLES;
/*!40000 ALTER TABLE `checkfield` ENABLE KEYS */;
--
-- Table structure for table `email_group`
--
DROP TABLE IF EXISTS `email_group`;
CREATE TABLE `email_group` (
`GroupName1` varchar(45) NOT NULL,
`ID` int(10) unsigned NOT NULL auto_increment,
`email` varchar(1000) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `email_group`
--
/*!40000 ALTER TABLE `email_group` DISABLE KEYS */;
LOCK TABLES `email_group` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `email_group` ENABLE KEYS */;
--
-- Table structure for table `interest`
--
DROP TABLE IF EXISTS `interest`;
CREATE TABLE `interest` (
`sid` char(15) NOT NULL,
`vollyball` varchar(15) character set utf8 default NULL,
`pingpongball` varchar(15) character set utf8 default NULL,
`football` varchar(15) character set utf8 default NULL,
`basketball` varchar(15) character set utf8 default NULL,
`chinese_chess` varchar(15) character set utf8 default NULL,
`chess` varchar(15) character set utf8 default NULL,
`music` varchar(15) character set utf8 default NULL,
`movie` varchar(15) character set utf8 default NULL,
`reading` varchar(15) character set utf8 default NULL,
`other` varchar(100) default NULL,
PRIMARY KEY (`sid`),
CONSTRAINT `FK_interest_1` FOREIGN KEY (`sid`) REFERENCES `regist` (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `interest`
--
/*!40000 ALTER TABLE `interest` DISABLE KEYS */;
LOCK TABLES `interest` WRITE;
INSERT INTO `interest` VALUES ('0517285',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'武术'),('0517286',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,''),('0517287','vollyball','pingpongball','football','basketball',NULL,'chess','music','movie',NULL,''),('1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'');
UNLOCK TABLES;
/*!40000 ALTER TABLE `interest` ENABLE KEYS */;
--
-- Table structure for table `login`
--
DROP TABLE IF EXISTS `login`;
CREATE TABLE `login` (
`SID` char(15) NOT NULL,
`PASSWORD` varchar(45) NOT NULL,
`USERNAME` varchar(45) NOT NULL,
PRIMARY KEY (`SID`),
CONSTRAINT `FK_login_1` FOREIGN KEY (`SID`) REFERENCES `regist` (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `login`
--
/*!40000 ALTER TABLE `login` DISABLE KEYS */;
LOCK TABLES `login` WRITE;
INSERT INTO `login` VALUES ('0517285','damon','damon'),('0517286','stone ','stone'),('0517287','green ','green'),('1','damon','damon');
UNLOCK TABLES;
/*!40000 ALTER TABLE `login` ENABLE KEYS */;
--
-- Table structure for table `regist`
--
DROP TABLE IF EXISTS `regist`;
CREATE TABLE `regist` (
`name` varchar(20) NOT NULL,
`sid` char(15) NOT NULL,
`dormaddress` varchar(45) NOT NULL,
`dormphone` char(20) NOT NULL,
`mobilephone` char(20) NOT NULL,
`homephone` char(20) NOT NULL,
`email` char(45) NOT NULL,
`QQ` char(45) default NULL,
`homeaddress` varchar(45) NOT NULL,
`postid` char(20) NOT NULL,
`gender` char(10) NOT NULL,
`birthday` datetime NOT NULL,
`area` varchar(45) NOT NULL,
`city` varchar(45) NOT NULL,
`backg` varchar(45) NOT NULL,
`honor` varchar(100) default NULL,
`face` varchar(150) default NULL,
PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `regist`
--
/*!40000 ALTER TABLE `regist` DISABLE KEYS */;
LOCK TABLES `regist` WRITE;
INSERT INTO `regist` VALUES ('顾孝东','0517285','08101','28101','13661508559','586521451','g2stone@yahoo.com','704830622','浙江省海宁市','330419820905281','male','1982-09-05 00:00:00','南汇区','上海','党员','无','../uploadfile/image/SV300795.jpg'),('李小刀','0517286','08102','28102','13642514582','51425621','g2stone@sohu.com','45215425','上海','254125625142512','male','1984-08-01 00:00:00','南汇区','上海','群众','一等奖','../uploadfile/image/SV300773.JPG'),('郭晋','0517287','24101','04101','13482845125','021-54254125','g2stone@163.com','704830622','上海市','452157841258652','female','1984-01-01 00:00:00','南汇区','上海','团员','','null'),('tom','1','07113','27113','13475852645','010-54125841','g2stone@hotmail.com','1','北京','330417825641259','female','1981-01-01 00:00:00','南汇区','上海','群众','','null');
UNLOCK TABLES;
/*!40000 ALTER TABLE `regist` ENABLE KEYS */;
--
-- Table structure for table `tlogon`
--
DROP TABLE IF EXISTS `tlogon`;
CREATE TABLE `tlogon` (
`tid` int(10) unsigned NOT NULL auto_increment,
`username` varchar(45) NOT NULL,
`password` varchar(45) NOT NULL,
PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `tlogon`
--
/*!40000 ALTER TABLE `tlogon` DISABLE KEYS */;
LOCK TABLES `tlogon` WRITE;
INSERT INTO `tlogon` VALUES (1,'test','damon'),(2,'admin','admin');
UNLOCK TABLES;
/*!40000 ALTER TABLE `tlogon` ENABLE KEYS */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;