You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
14 lines
382 B
14 lines
382 B
2 years ago
|
create table if not exists camera_status_offline_log
|
||
|
|
(
|
||
|
|
id serial not null,
|
||
|
|
camera_id integer not null,
|
||
|
|
status varchar(32) not null,
|
||
|
|
time timestamp not null,
|
||
|
|
constraint camera_status_offline_log_pk
|
||
|
|
primary key (id)
|
||
|
|
);
|
||
|
|
|
||
|
|
create unique index if not exists camera_status_offline_log_id_uindex
|
||
|
|
on camera_status_offline_log (id);
|
||
|
|
|