#!/usr/bin/python3
# -*- coding: utf-8 -*-

# 弃用
___create_sql = """
CREATE TABLE product_line_stop(
    pName int, 
    productPlan varchar(200), 
    theoreticalYield int,
    realNumber int,
    status varchar(20), 
    stopTime date, 
    all_stopTime int, 
    stop_count int
)default charset=utf8;
"""


create_employee_sql = """
CREATE TABLE EMPLOYEE (
     FIRST_NAME  CHAR(20) NOT NULL,
     LAST_NAME  CHAR(20),
     AGE INT,  
     SEX CHAR(1),
     INCOME FLOAT )"""


drop_exit_line = 'DROP TABLE IF EXISTS line_stop'


# 创建生产线停线表
create_table_line_stop = """
CREATE TABLE line_stop(
    pName varchar(20),
    workNumber varchar(20),
    productPlan varchar(100),
    theoryNumber float  NULL,
    realNumber float ,
    status varchar(20),
    stopTime time  NULL,
    timeCount int  NULL,
    allTimeCount int  NULL,
    stopCount int  NULL
)default charset=utf8;"""


# 插入一条生产线停线记录
insert_line = """
INSERT INTO line_stop(pName, workNumber, status, stopTime) values('H1', 'NO1', '延迟', '15:25:10');
"""


# 创建作业状况表，这个可以不用创建
create_table_work = """
CREATE TABLE work(
    delay varchar(50),
    badness varchar(20),
    shortcoming varchar(20),
    skill varchar(20),
    others varchar(20)
)default charset=utf8;
"""


#!/usr/bin/python3
# -*- coding: utf-8 -*-

# 弃用
___create_sql = """
CREATE TABLE product_line_stop(
    pName int, 
    productPlan varchar(200), 
    theoreticalYield int,
    realNumber int,
    status varchar(20), 
    stopTime date, 
    all_stopTime int, 
    stop_count int
)default charset=utf8;
"""


create_employee_sql = """
CREATE TABLE EMPLOYEE (
     FIRST_NAME  CHAR(20) NOT NULL,
     LAST_NAME  CHAR(20),
     AGE INT,  
     SEX CHAR(1),
     INCOME FLOAT )"""


drop_exit_line = 'DROP TABLE IF EXISTS line_stop'


# 创建生产线停线表
create_table_line_stop = """
CREATE TABLE line_stop(
    pName varchar(20),
    workNumber varchar(20),
    productPlan varchar(100),
    theoryNumber float  NULL,
    realNumber float ,
    status varchar(20),
    stopTime time  NULL,
    timeCount int  NULL,
    allTimeCount int  NULL,
    stopCount int  NULL
)default charset=utf8;"""


# 插入一条生产线停线记录
insert_line = """
INSERT INTO line_stop(pName, workNumber, status, stopTime) values('H1', 'NO1', '延迟', '15:25:10');
"""


# 创建作业状况表，这个可以不用创建
create_table_work = """
CREATE TABLE work(
    delay varchar(50),
    badness varchar(20),
    shortcoming varchar(20),
    skill varchar(20),
    others varchar(20)
)default charset=utf8;
"""


#!/usr/bin/python3 # -*- coding: utf-8 -*- # 弃用 CREATE TABLE product_line_stop(     pName int,      productPlan varchar(200),      theoreticalYield int,     realNumber int,     status varchar(20),      stopTime date,      all_stopTime int,      stop_count int )default charset=utf8; CREATE TABLE EMPLOYEE (      FIRST_NAME  CHAR(20) NOT NULL,      LAST_NAME  CHAR(20),      AGE INT,        SEX CHAR(1),      INCOME FLOAT ) # 创建生产线停线表 CREATE TABLE line_stop(     pName varchar(20),     workNumber varchar(20),     productPlan varchar(100),     theoryNumber float  NULL,     realNumber float ,     status varchar(20),     stopTime time  NULL,     timeCount int  NULL,     allTimeCount int  NULL,     stopCount int  NULL )default charset=utf8; # 插入一条生产线停线记录 INSERT INTO line_stop(pName, workNumber, status, stopTime) values('H1', 'NO1', '延迟', '15:25:10'); # 创建作业状况表，这个可以不用创建 CREATE TABLE work(     delay varchar(50),     badness varchar(20),     shortcoming varchar(20),     skill varchar(20),     others varchar(20) )default charset=utf8;