数据库常用语句

https://blog.csdn.net/weixin_55972781/article/details/118399532

创建表

CREATE TABLE table1 (
materialId TEXT,
resourceType TEXT,
localPath TEXT,
remoteUrl TEXT,
status INTEGER,
fileHash TEXT,
fileVersion Integer,
fileSize Integer,
PRIMARY KEY(materialId, resourceType),
constraint foreign_key foreign key(materialId) references material_basic(materialInfoId)
);