bankdb.sql

界面不错的东西

# SQL-Front 4.1  (Build 1.93)

/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;


# Host: localhost    Database: bankdb
# ------------------------------------------------------
# Server version 5.1.30-community

DROP DATABASE IF EXISTS `bankdb`;
CREATE DATABASE `bankdb` /*!40100 DEFAULT CHARACTER SET gb2312 */;
USE `bankdb`;

#
# Table structure for table consume
#

CREATE TABLE `consume` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `con_acco` varchar(50) DEFAULT NULL COMMENT '添加用户存款取款记录,包括帐号和金额,日期,才操作员',
  `con_draw` int(10) DEFAULT NULL COMMENT '取款金额',
  `con_appe` int(10) DEFAULT NULL COMMENT '存款金额',
  `op_date` varchar(50) DEFAULT NULL COMMENT '存取款日期',
  `d_a` bit(1) NOT NULL COMMENT '存/取 1/0',
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;


#
# Dumping data for table consume
#
LOCK TABLES `consume` WRITE;
/*!40000 ALTER TABLE `consume` DISABLE KEYS */;

INSERT INTO `consume` VALUES (1,'2071002017',52,45,'2005',b'1');
INSERT INTO `consume` VALUES (2,NULL,0,0,NULL,b'0');
/*!40000 ALTER TABLE `consume` ENABLE KEYS */;
UNLOCK TABLES;

#
# Table structure for table consumer
#

CREATE TABLE `consumer` (
  `con_acco` varchar(50) NOT NULL DEFAULT '' COMMENT '储户账号',
  `con_name` varchar(50) DEFAULT NULL COMMENT '储户名称',
  `con_opna` varchar(50) DEFAULT NULL COMMENT '开户网点名',
  `con_idfi` varchar(50) DEFAULT NULL COMMENT '用户开户证件',
  `con_idno` varchar(50) DEFAULT NULL COMMENT '证件号码',
  `con_kind` varchar(50) DEFAULT NULL COMMENT '开户类型\r\n开户类型',
  `con_opde` datetime DEFAULT NULL COMMENT '开户日期',
  `con_rema` int(10) DEFAULT NULL COMMENT '账户余额',
  `con_pwd` varchar(50) DEFAULT NULL COMMENT '用户密码',
  PRIMARY KEY (`con_acco`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;


#
# Dumping data for table consumer
#
LOCK TABLES `consumer` WRITE;
/*!40000 ALTER TABLE `consumer` DISABLE KEYS */;

INSERT INTO `consumer` VALUES ('2071002001','李亮亮','北京市紫竹院支行','身份证','202015198405023658','人民币','2007-09-09',100,'123456');
INSERT INTO `consumer` VALUES ('2071002002','贾文精','北京市紫竹院支行','身份证','3712021984512547','人民币','2007-09-08',100,'123456');
INSERT INTO `consumer` VALUES ('2071002003','杨丽','北京市紫竹院支行','身份证','372928198408031254','RMB','2007-08-09',1,'123456');
INSERT INTO `consumer` VALUES ('2071002004','冯利','北京市紫竹院支行','身份证','3728251984587587','人民币','2007-09-08',0,'123456');
INSERT INTO `consumer` VALUES ('2071002005','刘咏梅','北京市紫竹院支行','身份证','2548798878852222','人民币','2007-07-07',100,'123456');
INSERT INTO `consumer` VALUES ('2071002007','周孝忠','北京市紫竹院支行','身份证','372877182778172','人民币','2007-09-09',100,'123456');
INSERT INTO `consumer` VALUES ('2071002013','毛春静','北京市紫竹院支行','身份证','201215198302051528','人民币','2007-09-11',75,'123');
INSERT INTO `consumer` VALUES ('2071002016','周向明','北京市紫竹院支行','身份证','502158198502015421','人民币','2007-09-08',1,'123456');
INSERT INTO `consumer` VALUES ('2071002017','任重山','北京市紫竹院支行','身份证','372926198407014215','人民币','2007-09-09',99479,'123456');
INSERT INTO `consumer` VALUES ('2071002022','jfdk','jkj','kjkjk','kjkjk','kjkjkjk','2007-09-09',100,'123456');
INSERT INTO `consumer` VALUES ('2071002024','田建雷','北京市紫竹院支行','身份证','372928198405044213','人民币','2007-09-09',1,'123456');
INSERT INTO `consumer` VALUES ('2071002025','454','545','454','45454','454','2007-04-04',454,'4545');
INSERT INTO `consumer` VALUES ('2071002026','武金相','北京市紫竹院支行','身份证','372829198505041254','人民币','2007-10-14',887744,'123245');
INSERT INTO `consumer` VALUES ('2071002027','wujinxiang','beijing','id','3732925544','222','2009-09-09',1,'123456');
INSERT INTO `consumer` VALUES ('2071002030','支铃铃','北京市紫竹院支行','身份证','487125198405021258','人民币','2007-09-09',500,'123456');
INSERT INTO `consumer` VALUES ('2071002058','吴刚','8888','888','666','777','1899-12-30 02:24:00',999,'888');
/*!40000 ALTER TABLE `consumer` ENABLE KEYS */;
UNLOCK TABLES;

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;