32 lines
963 B
MySQL
32 lines
963 B
MySQL
|
-- CreateTable
|
||
|
|
CREATE TABLE "Data" (
|
||
|
|
"id" SERIAL NOT NULL,
|
||
|
|
"desc" VARCHAR NOT NULL DEFAULT '',
|
||
|
|
"img" VARCHAR NOT NULL DEFAULT '/Pjob.jpb',
|
||
|
|
"time" VARCHAR NOT NULL DEFAULT '',
|
||
|
|
"pay" INTEGER NOT NULL DEFAULT 1,
|
||
|
|
|
||
|
|
CONSTRAINT "Data_pkey" PRIMARY KEY ("id")
|
||
|
|
);
|
||
|
|
|
||
|
|
-- CreateTable
|
||
|
|
CREATE TABLE "Job" (
|
||
|
|
"id" SERIAL NOT NULL,
|
||
|
|
"name" VARCHAR NOT NULL,
|
||
|
|
"worktime" VARCHAR NOT NULL,
|
||
|
|
"createTime" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
"updateTime" TIMESTAMP(3) NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
||
|
|
"pin" BOOLEAN NOT NULL DEFAULT true,
|
||
|
|
"dataId" INTEGER,
|
||
|
|
"place" VARCHAR NOT NULL DEFAULT 'in',
|
||
|
|
"area" VARCHAR NOT NULL DEFAULT 'in',
|
||
|
|
|
||
|
|
CONSTRAINT "Job_pkey" PRIMARY KEY ("id")
|
||
|
|
);
|
||
|
|
|
||
|
|
-- CreateIndex
|
||
|
|
CREATE UNIQUE INDEX "Job_dataId_key" ON "Job"("dataId");
|
||
|
|
|
||
|
|
-- AddForeignKey
|
||
|
|
ALTER TABLE "Job" ADD CONSTRAINT "Job_dataId_fkey" FOREIGN KEY ("dataId") REFERENCES "Data"("id") ON DELETE NO ACTION ON UPDATE NO ACTION;
|