请问sql文件有吗？

[xunanmu]

没有在项目里面找到数据库文件

[RedCode-X]

-- auto-generated definition CREATE TABLE t_users ( user_id INT AUTO_INCREMENT COMMENT '用户id' PRIMARY KEY, user_name VARCHAR(20) NOT NULL COMMENT '用户名', user_pwd VARCHAR(100) NOT NULL COMMENT '用户密码', phone VARCHAR(11) NOT NULL COMMENT '手机号', create_date DATETIME DEFAULT CURRENT_TIMESTAMP NULL COMMENT '创建时间' );

-- auto-generated definition CREATE TABLE t_batch ( batch_id INT AUTO_INCREMENT COMMENT '批次ID' PRIMARY KEY, batch_number INT NULL COMMENT '批次编号', batch_status INT NOT NULL COMMENT '批次状态', CONSTRAINT batch_number UNIQUE (batch_number) );

-- auto-generated definition CREATE TABLE t_buy ( buy_id INT AUTO_INCREMENT COMMENT '唯一id' PRIMARY KEY, buy_date DATE NOT NULL COMMENT '购买日期', buy_quantity INT NOT NULL COMMENT '购买数量', buy_variety VARCHAR(20) NOT NULL COMMENT '购买品种', buy_price DOUBLE NOT NULL COMMENT '购买价格', buy_address VARCHAR(100) NULL COMMENT '购买地址', average_weight DECIMAL(10, 2) NOT NULL COMMENT '平均重量', beyond_price DOUBLE NULL COMMENT '超出标准重量价格', total_money DECIMAL(10, 2) NOT NULL COMMENT '购买总金额', batch_number INT NOT NULL COMMENT '批次号', CONSTRAINT t_buy_ibfk_1 FOREIGN KEY (batch_number) REFERENCES t_batch (batch_number) );

CREATE INDEX batch_number ON t_buy (batch_number);

-- auto-generated definition CREATE TABLE t_feed ( feed_id INT AUTO_INCREMENT COMMENT '饲料唯一ID' PRIMARY KEY, send_date DATE NOT NULL COMMENT '配送日期', feed_quantity INT NOT NULL COMMENT '配送数量', feed_price DOUBLE NOT NULL COMMENT '单价', feed_paystate VARCHAR(20) NOT NULL COMMENT '支付状态', feed_total DOUBLE NOT NULL COMMENT '金额总数', batch_number INT NOT NULL COMMENT '批次号', CONSTRAINT t_feed_ibfk_1 FOREIGN KEY (batch_number) REFERENCES t_batch (batch_number) );

CREATE INDEX batch_number ON t_feed (batch_number);

-- auto-generated definition CREATE TABLE t_other ( record_id INT AUTO_INCREMENT PRIMARY KEY, record_date DATE NULL COMMENT '记录日期', record_details VARCHAR(10000) NULL COMMENT '记录详情，可以为空', record_money DECIMAL(10, 2) NULL COMMENT '开销总数', batch_number INT NOT NULL COMMENT '批次号', CONSTRAINT t_other_ibfk_1 FOREIGN KEY (batch_number) REFERENCES t_batch (batch_number) );

CREATE INDEX batch_number ON t_other (batch_number);

-- auto-generated definition CREATE TABLE t_sale ( sale_id INT AUTO_INCREMENT COMMENT '唯一id' PRIMARY KEY, sale_date DATE NOT NULL COMMENT '销售日期', sale_price DECIMAL(10, 1) NOT NULL COMMENT '售价', sale_quantity INT NOT NULL COMMENT '销售数量', sale_variety VARCHAR(20) NOT NULL COMMENT '销售品种', total_weight DECIMAL(10, 2) NOT NULL COMMENT '总重量', average_weight DECIMAL(10, 2) NOT NULL COMMENT '平均重量', average_money DECIMAL(10, 2) NOT NULL COMMENT '平均每头金额', sale_amount DECIMAL(10, 2) NOT NULL COMMENT '销售总金额', batch_number INT NOT NULL COMMENT '批次号', CONSTRAINT t_sale_ibfk_1 FOREIGN KEY (batch_number) REFERENCES t_batch (batch_number) );

CREATE INDEX batch_number ON t_sale (batch_number);

-- auto-generated definition CREATE TABLE t_vaccine ( vaccine_id INT AUTO_INCREMENT COMMENT '唯一id' PRIMARY KEY, vaccine_name VARCHAR(30) NOT NULL COMMENT '疫苗种类名称', vaccine_date DATE NOT NULL COMMENT '接种日期', vaccine_quantity INT NOT NULL COMMENT '接种头数', vaccine_money DECIMAL(10, 2) NOT NULL COMMENT '疫苗开销花费', batch_number INT NOT NULL COMMENT '批次号', CONSTRAINT t_vaccine_ibfk_1 FOREIGN KEY (batch_number) REFERENCES t_batch (batch_number) );

CREATE INDEX batch_number ON t_vaccine (batch_number);