Code: Select all
ALTER TABLE "snapshots" ALTER COLUMN "date" DEFAULT CURRENT_DATE
Am I doing something wrong? Is this the good path for my goal?1: Wrong data type: DEFAULT in statement [ALTER TABLE "snapshots" ALTER COLUMN "date" DEFAULT]
If necessary, here's the scheme:
Code: Select all
SET DATABASE COLLATION "Latin1_General"
CREATE SCHEMA PUBLIC AUTHORIZATION DBA
CREATE CACHED TABLE "snapshots"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"date" DATE,"date_id" TINYINT,"bg_bar_len" SMALLINT NOT NULL)
CREATE UNIQUE INDEX "date_date_id" ON "snapshots"("date","date_id")
CREATE CACHED TABLE "traits"("ID" INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,"name" VARCHAR_IGNORECASE(50) NOT NULL)
CREATE CACHED TABLE "snapshots_traits"("snapshot_id" INTEGER NOT NULL,"trait_id" INTEGER NOT NULL,"value" SMALLINT NOT NULL,PRIMARY KEY("snapshot_id","trait_id"),CONSTRAINT SYS_FK_70 FOREIGN KEY("trait_id") REFERENCES "traits"("ID") ON DELETE CASCADE ON UPDATE CASCADE,CONSTRAINT SYS_FK_73 FOREIGN KEY("snapshot_id") REFERENCES "snapshots"("ID") ON DELETE CASCADE ON UPDATE CASCADE)
CREATE CACHED TABLE "tables_fields_description"("table_name" VARCHAR_IGNORECASE(50) NOT NULL,"field_name" VARCHAR_IGNORECASE(50) NOT NULL,"description" VARCHAR(1024) NOT NULL,PRIMARY KEY("table_name","field_name"))
ALTER TABLE "snapshots" ALTER COLUMN "ID" RESTART WITH 0
ALTER TABLE "traits" ALTER COLUMN "ID" RESTART WITH 0