1CREATE TABLE manoeuvre_history (
2 sensing_time timestamp NOT NULL,
3 sid_num smallint NOT NULL,
4 product bigint NOT NULL,
5 acc_comp_1 double precision NOT NULL,
6 acc_comp_2 double precision NOT NULL,
7 acc_comp_3 double precision NOT NULL,
8 rec_flag smallint NOT NULL
9);
10ALTER TABLE manoeuvre_history ADD CONSTRAINT manoeuvre_history_c PRIMARY KEY (sid_num,sensing_time);