-- MySQL dump 10.13  Distrib 5.5.10, for Win32 (x86)
--
-- Host: localhost    Database: qhlrms
-- ------------------------------------------------------
-- Server version	5.5.10

/*!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 */;

--
-- Current Database: `qhlrms`
--

USE `qhlrms`;

--
-- Table structure for table `lease`
--

DROP TABLE IF EXISTS `lease`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lease` (
  `地区` char(6) NOT NULL,
  `年度` year(4) NOT NULL,
  `编号` mediumint(11) NOT NULL,
  `收费金额` int(10) unsigned zerofill DEFAULT NULL,
  `登记日期` date NOT NULL,
  `有效日起` date NOT NULL,
  `有效日止` date NOT NULL,
  PRIMARY KEY (`地区`,`年度`,`编号`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lease`
--

LOCK TABLES `lease` WRITE;
/*!40000 ALTER TABLE `lease` DISABLE KEYS */;
/*!40000 ALTER TABLE `lease` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `leasehouse`
--

DROP TABLE IF EXISTS `leasehouse`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `leasehouse` (
  `登记编号` char(15) NOT NULL,
  `房屋坐落` varchar(20) NOT NULL,
  `房屋用途` enum('商业柜台','专业批发市场','仓库') DEFAULT NULL,
  `房屋结构` enum('砖混结构','钢结构') DEFAULT NULL,
  `房屋证件` enum('房产证','土地证') DEFAULT NULL,
  `房屋证号` varchar(15) DEFAULT NULL,
  `土地性质` enum('国有','集体') DEFAULT NULL,
  `房屋面积` mediumint(9) DEFAULT '100',
  `期限（月）` tinyint(4) DEFAULT '12',
  `租金（元）` mediumint(9) DEFAULT NULL,
  PRIMARY KEY (`登记编号`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leasehouse`
--

LOCK TABLES `leasehouse` WRITE;
/*!40000 ALTER TABLE `leasehouse` DISABLE KEYS */;
/*!40000 ALTER TABLE `leasehouse` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `leasein`
--

DROP TABLE IF EXISTS `leasein`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `leasein` (
  `登记编号` char(15) NOT NULL,
  `承租方名称` varchar(25) NOT NULL,
  `承租方电话` varchar(30) DEFAULT NULL,
  `承租方证件` enum('身份证','户口簿') DEFAULT NULL,
  `承租方证号` varchar(18) DEFAULT NULL,
  `承租方地址` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`登记编号`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leasein`
--

LOCK TABLES `leasein` WRITE;
/*!40000 ALTER TABLE `leasein` DISABLE KEYS */;
/*!40000 ALTER TABLE `leasein` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `leaseout`
--

DROP TABLE IF EXISTS `leaseout`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `leaseout` (
  `登记编号` char(15) NOT NULL,
  `出租方名称` varchar(25) NOT NULL,
  `出租方电话` varchar(30) DEFAULT NULL,
  `出租方证件` enum('身份证','户口簿') DEFAULT NULL,
  `出租方证号` varchar(18) DEFAULT NULL,
  `出租方地址` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`登记编号`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leaseout`
--

LOCK TABLES `leaseout` WRITE;
/*!40000 ALTER TABLE `leaseout` DISABLE KEYS */;
/*!40000 ALTER TABLE `leaseout` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `log`
--

DROP TABLE IF EXISTS `log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `log` (
  `日期` datetime NOT NULL,
  `用户` char(4) NOT NULL,
  `描述` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`日期`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `log`
--

LOCK TABLES `log` WRITE;
/*!40000 ALTER TABLE `log` DISABLE KEYS */;
INSERT INTO `log` VALUES ('2012-06-11 12:27:56','root','清空日志');
/*!40000 ALTER TABLE `log` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 */;

-- Dump completed on 2012-06-11 12:28:17
