import sqlite3

conn = sqlite3.connect('courses.db')
print ("数据库打开成功")
c = conn.cursor()

# c.execute('''CREATE TABLE COURSE_LIST
#        (ID INT PRIMARY KEY     NOT NULL,
#        TITLE           VARCHAR(50)    NOT NULL,
#        DESCRIPTION     TEXT NOT NULL);''')

c.execute('''CREATE TABLE COURSE_DATA
       (MESSAGE_ID      VARCHAR(50) PRIMARY KEY     NOT NULL,
        COURSE_ID       INT                         NOT NULL,
        CATEGORY        VARCHAR(20)                 NOT NULL,
        CREATED_AT      TIMESTAMP                   NOT NULL,
        ATTACHMENT_ID   VARCHAR(50)                 NOT NULL);''')

c.execute('''CREATE TABLE COURSE_ATTACHMENT
       (ID              VARCHAR(50) PRIMARY KEY     NOT NULL,
        ATTACHMENT_NAME VARCHAR(20)                 NOT NULL,
        ATTACHMENT_URL  TEXT                        NOT NULL,
        ATTACHMENT_TEXT TEXT                        NOT NULL);''')

print ("数据表创建成功")
conn.commit()
conn.close()