123456789101112 |
- CREATE TABLE "topic" (
- "id" serial NOT NULL PRIMARY KEY,
- "forum_id" integer NOT NULL,
- "subject" varchar(255) NOT NULL
- );
- ALTER TABLE "topic"
- ADD CONSTRAINT forum_id FOREIGN KEY ("forum_id")
- REFERENCES "forum" ("id");
- -- Initials
- insert into "topic" ("forum_id", "subject")
- values (2, 'D''artagnian');
|