2112A-zgl-dya08-rk/sql/2112-zgl-dya08-rk.sql

36 lines
984 B
SQL

/*
Navicat Premium Data Transfer
Source Server : 2112B
Source Server Type : MySQL
Source Server Version : 50557
Source Host : localhost:3306
Source Schema : 2112-zgl-dya08-rk
Target Server Type : MySQL
Target Server Version : 50557
File Encoding : 65001
Date: 26/07/2024 08:59:36
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for t_bill
-- ----------------------------
DROP TABLE IF EXISTS `t_bill`;
CREATE TABLE `t_bill` (
`bill_id` int(11) NOT NULL AUTO_INCREMENT,
`bill_date` datetime NULL DEFAULT NULL,
`bill_monery` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`bill_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of t_bill
-- ----------------------------
SET FOREIGN_KEY_CHECKS = 1;