1、环境准备，安装sqlite3软件

sudo apt-get install sqlite3

2、编写sql执行脚本（更新操作），每条sql语句以分号结束，sql.sql文件内容：

ALTER TABLE "GameDeviceInfo" ADD "Delay" INTEGER NOT NULL DEFAULT 0;

ALTER TABLE "GameDeviceInfo" ADD "Signal" INTEGER NOT NULL DEFAULT 0;

INSERT INTO "__EFMigrationsHistory" ("MigrationId", "ProductVersion")
VALUES ('20200528094030_add-signal-column', '2.1.4-rtm-31024');

3、编写shell脚本：updatedb.sh

1 #!/bin/bash
2 
3 SQL_FILE=/usr/local/sql/sql.sql
4 
5 DB_FILE=/usr/local/sql/test.db
6 
7 sqlite3 -init ${SQL_FILE} ${DB_FILE}  << EOF
8 .quit
9 EOF