File: create_table.sql

package info (click to toggle)
gnuais 0.3.3-8
  • links: PTS, VCS
  • area: main
  • in suites: bullseye, buster, sid
  • size: 564 kB
  • sloc: ansic: 5,784; sql: 33; makefile: 4; sh: 3
file content (39 lines) | stat: -rwxr-xr-x 771 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

drop table if exists `ais_nmea`;
drop table if exists `ais_position`;
drop table if exists `ais_vesseldata`;
drop table if exists `ais_basestation`;

create table ais_nmea (
	id int not null primary key auto_increment,
	time bigint, message varchar(200)
);

create table ais_position (
	id int not null primary key auto_increment,
	time bigint,
	mmsi int,
	latitude float,
	longitude float,
	heading float,
	course float,
	speed float
);

create table ais_vesseldata (
	id int not null primary key auto_increment,
	time bigint,
	mmsi int,
	name varchar(21),
	destination varchar(21),
	draught float,
	A int, B int, C int, D int
);

create table ais_basestation (
	id int not null primary key auto_increment,
	time bigint,
	mmsi int,
	latitude float, longitude float
);