户籍管理系统的设计与实现.zip

-- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 5.1.51-community /*!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 */; /*!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' */; -- -- Create schema wuye -- CREATE DATABASE IF NOT EXISTS wuye; USE wuye; -- -- Definition of table `login` -- DROP TABLE IF EXISTS `login`; CREATE TABLE `login` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(45) NOT NULL, `password` varchar(45) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; -- -- Dumping data for table `login` -- /*!40000 ALTER TABLE `login` DISABLE KEYS */; INSERT INTO `login` (`id`,`username`,`password`) VALUES (1,'1','1'), (2,'admin','admin'), (3,'1','1'), (4,'1','1'), (5,'9','9'); /*!40000 ALTER TABLE `login` ENABLE KEYS */; -- -- Definition of table `qianru` -- DROP TABLE IF EXISTS `qianru`; CREATE TABLE `qianru` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(45) NOT NULL, `shiyong_time` varchar(45) NOT NULL, `shijian` varchar(45) NOT NULL, `qNo` varchar(45) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; -- -- Dumping data for table `qianru` -- /*!40000 ALTER TABLE `qianru` DISABLE KEYS */; INSERT INTO `qianru` (`id`,`username`,`shiyong_time`,`shijian`,`qNo`) VALUES (2,'张三','2017-3-01','2017-3-01','001'), (3,'王冬','2017-3-01','2017-3-01','002'), (4,'李东','2017-3-01','2017-3-01','003'), (5,'张东华','2017-3-01','2017-3-01','004'), (8,'5','777','2017-6-5','777'); /*!40000 ALTER TABLE `qianru` ENABLE KEYS */; -- -- Definition of table `salary` -- DROP TABLE IF EXISTS `salary`; CREATE TABLE `salary` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(45) NOT NULL, `salary_all` varchar(45) NOT NULL COMMENT '缴费总额', `salary_type` varchar(45) NOT NULL COMMENT '缴费方式', `salary_per` varchar(45) NOT NULL COMMENT '收费人员', `salary_time` varchar(45) NOT NULL, `beizhu` varchar(300) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; -- -- Dumping data for table `salary` -- /*!40000 ALTER TABLE `salary` DISABLE KEYS */; INSERT INTO `salary` (`id`,`username`,`salary_all`,`salary_type`,`salary_per`,`salary_time`,`beizhu`) VALUES (2,'张三','100','现金缴费','A','2017-3-01','无'), (3,'王冬','200','刷卡缴费','B','2017-3-01','无'), (4,'李东','200','现金缴费','A','2017-3-01','无'), (5,'张东华','100','现金缴费','A','2017-3-01','无'), (6,'5','5','现金缴费','5','2017-6-5','5'), (8,'6','6','现金缴费','6','2017-6-5','6'); /*!40000 ALTER TABLE `salary` ENABLE KEYS */; -- -- Definition of table `tousu` -- DROP TABLE IF EXISTS `tousu`; CREATE TABLE `tousu` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(45) NOT NULL, `content` varchar(300) NOT NULL, `tou_time` varchar(45) NOT NULL, `answer` varchar(300) DEFAULT NULL, `da_time` varchar(45) DEFAULT NULL, `username` varchar(45) NOT NULL, `tel` varchar(45) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- -- Dumping data for table `tousu` -- /*!40000 ALTER TABLE `tousu` DISABLE KEYS */; INSERT INTO `tousu` (`id`,`title`,`content`,`tou_time`,`answer`,`da_time`,`username`,`tel`) VALUES (1,'5','5','2017-6-5','666','2017-6-5','5','5'); /*!40000 ALTER TABLE `tousu` ENABLE KEYS */; -- -- Definition of table `yonghu` -- DROP TABLE IF EXISTS `yonghu`; CREATE TABLE `yonghu` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `username` varchar(45) NOT NULL, `password` varchar(45) NOT NULL, `tel` varchar(45) NOT NULL, `l_name` varchar(45) NOT NULL COMMENT '楼宇名称', `l_ceng` varchar(45) NOT NULL COMMENT '楼层', `l_wu` varchar(45) NOT NULL COMMENT '房屋号', `l_danyuan` varchar(45) NOT NULL COMMENT '单元', `ru_time` varchar(45) NOT NULL COMMENT '迁入日期', `l_fangxing` varchar(45) NOT NULL COMMENT '房型', `beizhu` varchar(300) NOT NULL, `shijian` varchar(45) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8; -- -- Dumping data for table `yonghu` -- /*!40000 ALTER TABLE `yonghu` DISABLE KEYS */; INSERT INTO `yonghu` (`id`,`username`,`password`,`tel`,`l_name`,`l_ceng`,`l_wu`,`l_danyuan`,`ru_time`,`l_fangxing`,`beizhu`,`shijian`) VALUES (1,'5','5','5','5','5','5','5','5','正常','5','2017-6-5'), (2,'7','7','7','7','7','7','7','7','正常','7','2017-6-5'); /*!40000 ALTER TABLE `yonghu` ENABLE KEYS */; /*!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 */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;