DB_51Aspx/drugsp.sql

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

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

/*
 Navicat Premium Data Transfer

 Source Server         : root
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : localhost:3306
 Source Schema         : drugsp

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 30/06/2022 11:21:15
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for d_admin
-- ----------------------------
DROP TABLE IF EXISTS `d_admin`;
CREATE TABLE `d_admin`  (
  `a_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理員id',
  `a_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理員用戶名',
  `a_password` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '管理員密碼',
  PRIMARY KEY (`a_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of d_admin
-- ----------------------------
INSERT INTO `d_admin` VALUES (1, 'root', 'root');

-- ----------------------------
-- Table structure for d_classify
-- ----------------------------
DROP TABLE IF EXISTS `d_classify`;
CREATE TABLE `d_classify`  (
  `c_id` int(11) NOT NULL COMMENT '分類id',
  `c_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分類名',
  PRIMARY KEY (`c_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of d_classify
-- ----------------------------
INSERT INTO `d_classify` VALUES (1, '抗菌消炎药');
INSERT INTO `d_classify` VALUES (2, '消化系统药');
INSERT INTO `d_classify` VALUES (3, '呼吸系统药');
INSERT INTO `d_classify` VALUES (4, '泌尿系统药');
INSERT INTO `d_classify` VALUES (5, '妇科用药');
INSERT INTO `d_classify` VALUES (6, '儿科用药');
INSERT INTO `d_classify` VALUES (7, '注射液');

-- ----------------------------
-- Table structure for d_drugs
-- ----------------------------
DROP TABLE IF EXISTS `d_drugs`;