steam-discover/postgres-init.sql at master · OpenSourceLAN/steam-discover · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

-- postgres db init script

DROP TABLE clientinfo;
DROP TABLE accountinfo;

CREATE TABLE clientinfo (
	id bigserial PRIMARY KEY,
	steamid bigint null,
	data jsonb,
	batchid int null,
	time timestamp DEFAULT current_timestamp
);

CREATE TABLE accountinfo (
	id bigserial PRIMARY KEY,
	steamid bigint null,
	data jsonb,
	batchid int null,
	time timestamp DEFAULT current_timestamp
);

CREATE INDEX  IF NOT EXISTS clientinfo_steamid ON clientinfo ( steamid );
CREATE INDEX  IF NOT EXISTS accountinfo_steamid ON accountinfo ( steamid );