mirror of
https://github.com/latentPrion/cppbessot.git
synced 2026-04-18 02:54:23 +00:00
24 lines
541 B
SQL
24 lines
541 B
SQL
/* This file was generated by ODB, object-relational mapping (ORM)
|
|
* compiler for C++.
|
|
*/
|
|
|
|
DROP TABLE IF EXISTS "Agent" CASCADE;
|
|
|
|
DROP TABLE IF EXISTS "schema_version";
|
|
|
|
CREATE TABLE "Agent" (
|
|
"id" TEXT NOT NULL PRIMARY KEY,
|
|
"role" TEXT NOT NULL,
|
|
"persistent" BOOLEAN NOT NULL,
|
|
"displayName" TEXT NOT NULL);
|
|
|
|
CREATE TABLE "schema_version" (
|
|
"name" TEXT NOT NULL PRIMARY KEY,
|
|
"version" BIGINT NOT NULL,
|
|
"migration" BOOLEAN NOT NULL);
|
|
|
|
INSERT INTO "schema_version" (
|
|
"name", "version", "migration")
|
|
VALUES ('', 1, FALSE);
|
|
|