13 lines
450 B
SQL
13 lines
450 B
SQL
-- CreateTable
|
|
CREATE TABLE "car_dataset" (
|
|
"id" INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
|
|
"manufacturer" TEXT NOT NULL,
|
|
"model" TEXT NOT NULL,
|
|
"bodyType" TEXT NOT NULL,
|
|
"isActive" BOOLEAN NOT NULL DEFAULT true,
|
|
"createdDate" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
"updateDate" DATETIME NOT NULL
|
|
);
|
|
|
|
-- CreateIndex
|
|
CREATE UNIQUE INDEX "car_dataset_manufacturer_model_key" ON "car_dataset"("manufacturer", "model"); |