1
2
3
4
5
6
7
8
9
10
| -- 新增影片來源紀錄需求的table --
|
| CREATE TABLE omo.access_analysis (
| id bigserial NOT NULL,
| "source" varchar NOT NULL,
| event_type varchar NOT NULL,
| created_date timestamp NOT NULL,
| ip varchar NULL,
| CONSTRAINT access_analysis_pk PRIMARY KEY (id)
| );
|
|