[SQLite] テーブルの新規作成
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0t_6Tm_FDozWOvjrJUjvi8GAXJI9BmjsywEfIHB19fzT-SCh79JKaEpULUwDB9YEb4x3tjs04NmY5Bi8CM8AKKUVV_iTP2DTyiaYKIae9K4fP2HOWpnCF6C9uJPHodHwL_dINlqJNb28Ajv3naGbn1cP5iyIVumY-Ncp0lR1C8bc5m856uLJEfZHP/s1600/sqlite.png)
テーブル新規作成
CREATE TABLE %作成するテーブル名 (
id INTEGER PRIMARY KEY,
name TEXT NOT NULL,
create_at TIMESTAMP DEFAULT (datetime(CURRENT_TIMESTAMP, 'localtime')),
update_at TIMESTAMP DEFAULT (datetime(CURRENT_TIMESTAMP, 'localtime'))
);