📄 create_tables.sql
字号:
DROP TABLE IF EXISTS `factory_masters`;
CREATE TABLE `factory_masters` ( `id` int(11) unsigned NOT NULL auto_increment, `name` varchar(255) default NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `factory_output_quantities`;
CREATE TABLE `factory_output_quantities` ( `id` int(11) unsigned NOT NULL auto_increment, `factory_master_id` int(11) unsigned NOT NULL, `date_pro` datetime default NULL, `quantity` double default NULL, PRIMARY KEY (`id`), KEY `FK_output_master` (`factory_master_id`), CONSTRAINT `FK_output_master` FOREIGN KEY (`factory_master_id`) REFERENCES `factory_masters` (`id`)) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8;
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -