blob: 8419384a0f422098bcd2cde75aa7b13a88f8633b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
|
CREATE TABLE director_activity_log_remark (
first_related_activity bigint NOT NULL,
last_related_activity bigint NOT NULL,
remark TEXT NOT NULL,
PRIMARY KEY (first_related_activity, last_related_activity),
CONSTRAINT activity_log_remark_begin
FOREIGN KEY (first_related_activity)
REFERENCES director_activity_log (id)
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT activity_log_remark_end
FOREIGN KEY (last_related_activity)
REFERENCES director_activity_log (id)
ON DELETE CASCADE
ON UPDATE CASCADE
);
CREATE INDEX first_related_activity ON director_activity_log_remark (first_related_activity);
CREATE INDEX last_related_activity ON director_activity_log_remark (last_related_activity);
INSERT INTO director_schema_migration
(schema_version, migration_time)
VALUES (178, NOW());
|
