create table

-- login
CREATE TABLE test_mysql.login
(
    loginId                     VARCHAR(10) NOT NULL,
    password                    VARCHAR(20) NOT NULL,
    CONSTRAINT PRIMARY KEY (loginId)
);

-- lessonlist
CREATE TABLE test_mysql.lessonlist
(
    userId                      VARCHAR(10) NOT NULL,
    userFirstName               VARCHAR(20) NOT NULL,
    userLastName                VARCHAR(20) NOT NULL,
    lesson1st                   VARCHAR(20) NOT NULL,
    lesson2nd                   VARCHAR(20),
    CONSTRAINT PRIMARY KEY (userId)
);

-- language
CREATE TABLE test_mysql.language
(
    language                    VARCHAR(30) NOT NULL,
    information                 VARCHAR(30),
    CONSTRAINT PRIMARY KEY (language)
);