This repository was archived by the owner on Oct 2, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathRank_Table.sql
More file actions
117 lines (105 loc) · 2.8 KB
/
Rank_Table.sql
File metadata and controls
117 lines (105 loc) · 2.8 KB
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
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
--
-- File generated with SQLiteStudio v3.1.1 on Fri Feb 24 21:02:26 2017
--
-- Text encoding used: System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;
-- Table: rank
CREATE TABLE IF NOT EXISTS rank (
rankId INTEGER PRIMARY KEY,
rankName VARCHAR (250),
pointValue INTEGER
);
INSERT INTO rank (
rankId,
rankName,
pointValue
)
VALUES (
146724317785358337,
'Officer',
8
);
INSERT INTO rank (
rankId,
rankName,
pointValue
)
VALUES (
146725461727117314,
'Cadet',
0
);
INSERT INTO rank (
rankId,
rankName,
pointValue
)
VALUES (
236544208545120256,
'Squadron Lieutenant',
90
);
INSERT INTO rank (
rankId,
rankName,
pointValue
)
VALUES (
282699878897811466,
'Chief Petty Officer',
15
);
INSERT INTO rank (
rankId,
rankName,
pointValue
)
VALUES (
282699926230532098,
'Warrant Officer',
25
);
INSERT INTO rank (
rankId,
rankName,
pointValue
)
VALUES (
282699976151269376,
'Ensign',
40
);
INSERT INTO rank (
rankId,
rankName,
pointValue
)
VALUES (
282700000629358605,
'Lieutenant',
65
);
INSERT INTO rank (
rankId,
rankName,
pointValue
)
VALUES (
282700054798663691,
'Lieutenant Commander',
100
);
INSERT INTO rank (
rankId,
rankName,
pointValue
)
VALUES (
282700120091262976,
'Post Commander',
150
);
COMMIT TRANSACTION;
PRAGMA foreign_keys = on;