13 lines
339 B
SQL
13 lines
339 B
SQL
-- CreateTable
|
|
CREATE TABLE "friends" (
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
"name" TEXT NOT NULL,
|
|
"email" TEXT,
|
|
"avatar" TEXT,
|
|
"site_name" TEXT NOT NULL,
|
|
"site_url" TEXT NOT NULL,
|
|
"description" TEXT NOT NULL,
|
|
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"deletedAt" DATETIME
|
|
);
|