将 SQL 语句写入 src/commonMain/sqldelight 目录下的 .sq 文件中。 通常,.sq 文件中的第一条语句用于创建表,但您也可以创建索引或设置默认内容。
sql
CREATE TABLE hockeyPlayer (
player_number INTEGER PRIMARY KEY NOT NULL,
full_name TEXT NOT NULL
);
CREATE INDEX hockeyPlayer_full_name ON hockeyPlayer(full_name);
INSERT INTO hockeyPlayer (player_number, full_name)
VALUES (15, 'Ryan Getzlaf');