afoserver/createdb.sql at master · flyinghead/afoserver · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
CREATE TABLE RANKING (
	SCORE INTEGER NOT NULL,
	PLAYER_NAME VARCHAR(8) NOT NULL,
	ARCADE_NAME VARCHAR(8),
	CITY VARCHAR(8),
	STATE VARCHAR(8),
	DATE INTEGER
);
CREATE UNIQUE INDEX RANKING_IDX ON RANKING(PLAYER_NAME, ARCADE_NAME, CITY, STATE);

INSERT INTO RANKING (PLAYER_NAME, SCORE, ARCADE_NAME, CITY, STATE, DATE) VALUES ('FLY2'   , 137000, 'FLYCAST', 'PARIS', '', strftime('%s', '2023-04-16T08:46:35.167'));
INSERT INTO RANKING (PLAYER_NAME, SCORE, ARCADE_NAME, CITY, STATE, DATE) VALUES ('FLYHEAD', 117000, 'FLYCAST', 'PARIS', 'FR', strftime('%s', '2023-04-16T09:00:40.403'));
INSERT INTO RANKING (PLAYER_NAME, SCORE, ARCADE_NAME, CITY, STATE, DATE) VALUES ('ISAAC'  , 216000, 'FLYCAST', 'GOTHAM CITY', 'TX', strftime('%s', '2023-04-17T00:59:01.363'));
INSERT INTO RANKING (PLAYER_NAME, SCORE, ARCADE_NAME, CITY, STATE, DATE) VALUES ('PUP'    , 245700, 'FLYCAST', 'GOTHAM CITY', '', strftime('%s', '2023-05-09T21:00:49.425'));
INSERT INTO RANKING (PLAYER_NAME, SCORE, ARCADE_NAME, CITY, STATE, DATE) VALUES ('PUP'    , 115000, 'FLYCAST', 'ROANOKE', 'VA', strftime('%s', '2024-05-30T01:40:36.169'));
INSERT INTO RANKING (PLAYER_NAME, SCORE, ARCADE_NAME, CITY, STATE, DATE) VALUES ('BLANK'  , 131500, 'FLYCAST', 'GOTHAM CITY', '', strftime('%s', '2025-01-04T11:25:13.952'));
INSERT INTO RANKING (PLAYER_NAME, SCORE, ARCADE_NAME, CITY, STATE, DATE) VALUES ('OM3GA'  , 209000, 'FLYCAST', 'GOTHAM CITY', '', strftime('%s', '2025-01-26T23:44:41.913'));
INSERT INTO RANKING (PLAYER_NAME, SCORE, ARCADE_NAME, CITY, STATE, DATE) VALUES ('OM3GA'  , 197000, 'FLYCAST', 'CAMPECHE', 'MX', strftime('%s', '2025-01-28T00:23:30.494'));
INSERT INTO RANKING (PLAYER_NAME, SCORE, ARCADE_NAME, CITY, STATE, DATE) VALUES ('ABC'    , 92000 , 'FLYCAST', 'PARIS', 'FR', strftime('%s', '2025-06-25T15:41:47.326'));
INSERT INTO RANKING (PLAYER_NAME, SCORE, ARCADE_NAME, CITY, STATE, DATE) VALUES ('DFG'    , 68000 , 'FLYCAST', 'PARIS', 'FR', strftime('%s', '2025-06-25T15:41:52.095'));
INSERT INTO RANKING (PLAYER_NAME, SCORE, ARCADE_NAME, CITY, STATE, DATE) VALUES ('AAB'    , 79000 , 'FLYCAST', 'PARIS', 'FR', strftime('%s', '2025-06-25T15:52:23.563'));