# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                 localhost
# Database:             student
# Server version:       4.1.16-nt
# Server OS:            Win32
# max_allowed_packet:   1048576
# HeidiSQL version:     3.0 RC4 Revision: 334
# --------------------------------------------------------

/*!40100 SET CHARACTER SET latin1;*/


#
# Database structure for database 'student'
#

CREATE DATABASE /*!32312 IF NOT EXISTS*/ student;

USE student;


#
# Table structure for table 'account'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ `account` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `UserName` varchar(30) NOT NULL default '',
  `Password` varchar(30) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



#
# Dumping data for table 'account'
#

/*!40000 ALTER TABLE account DISABLE KEYS;*/
LOCK TABLES account WRITE;
REPLACE INTO account (id, UserName, Password) VALUES ('1','admin','admin'),
	('2','never','never'),
	('3','成成','9988');
UNLOCK TABLES;
/*!40000 ALTER TABLE account ENABLE KEYS;*/


#
# Table structure for table 'studentinfo'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ `studentinfo` (
  `StudentID` varchar(20) NOT NULL default '',
  `StudentName` varchar(30) NOT NULL default '',
  `StudentSex` char(2) NOT NULL default '',
  `StudentDepartment` varchar(100) NOT NULL default '',
  `StudentClass` varchar(100) NOT NULL default '',
  `StudentPhone` varchar(100) NOT NULL default '',
  `StudentEmail` varchar(100) NOT NULL default '',
  `StudentAddress` varchar(200) NOT NULL default '',
  PRIMARY KEY  (`StudentID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



#
# Dumping data for table 'studentinfo'
#

/*!40000 ALTER TABLE studentinfo DISABLE KEYS;*/
LOCK TABLES studentinfo WRITE;
REPLACE INTO studentinfo (StudentID, StudentName, StudentSex, StudentDepartment, StudentClass, StudentPhone, StudentEmail, StudentAddress) VALUES ('200403001','成成成','男','計算機','04計算機','135645435','never@126.com','孩子地區差價'),
	('200403002','成成成成成','女','計算機','04計算機','654645435','never@126.com','一些單位'),
	('200403003','成成','男','計算機','04計算機','785645435','never@126.com','灰塵ISO8859-1ISO8859-1'),
	('200403004','成成成成成成成成','女','計算機','04計算機','655645435','never@126.com','灰塵成成成成成成'),
	('200403005','成成成成','女','計算機','04計算機','135645435','never@126.com','職工中國地方工業');
UNLOCK TABLES;
/*!40000 ALTER TABLE studentinfo ENABLE KEYS;*/