DB_51aspx/assetmanagesystem.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
Navicat MySQL Data Transfer

Source Server         : cashier
Source Server Version : 50136
Source Host           : localhost:3306
Source Database       : assetmanagesystem

Target Server Type    : MYSQL
Target Server Version : 50136
File Encoding         : 65001

Date: 2014-05-16 00:33:37
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `asset_small_type`
-- ----------------------------
DROP TABLE IF EXISTS `asset_small_type`;
CREATE TABLE `asset_small_type` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `smalltypename` varchar(50) COLLATE utf8_bin NOT NULL,
  `bigtypeid` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_assetsmalltype_assettype` (`bigtypeid`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of asset_small_type
-- ----------------------------
INSERT INTO `asset_small_type` VALUES ('1', '硬盘', '1');
INSERT INTO `asset_small_type` VALUES ('2', 'vista操作系统', '2');
INSERT INTO `asset_small_type` VALUES ('3', '键盘', '1');
INSERT INTO `asset_small_type` VALUES ('4', 'Linux操作系统', '2');
INSERT INTO `asset_small_type` VALUES ('5', '笔记本电脑', '1');
INSERT INTO `asset_small_type` VALUES ('6', '台式机', '1');
INSERT INTO `asset_small_type` VALUES ('7', 'xp操作系统', '2');
INSERT INTO `asset_small_type` VALUES ('8', 'win7操作系统', '2');

-- ----------------------------
-- Table structure for `asset_type`
-- ----------------------------
DROP TABLE IF EXISTS `asset_type`;
CREATE TABLE `asset_type` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `typeName` varchar(10) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of asset_type
-- ----------------------------
INSERT INTO `asset_type` VALUES ('1', '硬件');
INSERT INTO `asset_type` VALUES ('2', '软件');

-- ----------------------------
-- Table structure for `data_basic`
-- ----------------------------