FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
Playtesters.API/sql/playtesters.sql at master · DevD4v3/Playtesters.API · GitHub
DevD4v3
/
Playtesters.API
Public
Notifications
You must be signed in to change notification settings
Fork
0
Star
6
Code
Issues
0
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Issues
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
Playtesters.API
/
sql
/
playtesters.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
51 lines (51 loc) · 1.76 KB
Breadcrumbs
Playtesters.API
/
sql
/
playtesters.sql
Copy path
File metadata and controls
51 lines (51 loc) · 1.76 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
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
BEGIN
TRANSACTION;
CREATE
TABLE
IF
NOT EXISTS
"
AccessValidationHistory
"
(
"
Id
"
INTEGER
NOT NULL
,
"
TesterId
"
INTEGER
NOT NULL
,
"
CheckedAt
"
TEXT
NOT NULL
,
"
IpAddress
"
TEXT
NOT NULL
,
"
City
"
TEXT
NOT NULL
DEFAULT
'
'
COLLATE NOCASE,
"
Country
"
TEXT
NOT NULL
DEFAULT
'
'
COLLATE NOCASE,
CONSTRAINT
"
PK_AccessValidationHistory
"
PRIMARY KEY
(
"
Id
"
AUTOINCREMENT),
CONSTRAINT
"
FK_AccessValidationHistory_Tester_TesterId
"
FOREIGN KEY
(
"
TesterId
"
)
REFERENCES
"
Tester
"
(
"
Id
"
)
ON DELETE CASCADE
);
CREATE
TABLE
IF
NOT EXISTS
"
IpGeoCache
"
(
"
Id
"
INTEGER
NOT NULL
,
"
IpAddress
"
TEXT
NOT NULL
,
"
Country
"
TEXT
NOT NULL
,
"
City
"
TEXT
NOT NULL
,
CONSTRAINT
"
PK_IpGeoCache
"
PRIMARY KEY
(
"
Id
"
AUTOINCREMENT)
);
CREATE
TABLE
IF
NOT EXISTS
"
Tester
"
(
"
Id
"
INTEGER
NOT NULL
,
"
Name
"
TEXT
NOT NULL
COLLATE NOCASE,
"
AccessKey
"
TEXT
,
"
TotalHoursPlayed
"
REAL
NOT NULL
DEFAULT
0
.
0
,
"
CreatedAt
"
TEXT
NOT NULL
,
CONSTRAINT
"
PK_Tester
"
PRIMARY KEY
(
"
Id
"
AUTOINCREMENT)
);
CREATE
INDEX
IF
NOT EXISTS
"
IX_AccessValidationHistory_CheckedAt
"
ON
"
AccessValidationHistory
"
(
"
CheckedAt
"
);
CREATE
INDEX
IF
NOT EXISTS
"
IX_AccessValidationHistory_City
"
ON
"
AccessValidationHistory
"
(
"
City
"
COLLATE NOCASE
);
CREATE
INDEX
IF
NOT EXISTS
"
IX_AccessValidationHistory_Country
"
ON
"
AccessValidationHistory
"
(
"
Country
"
COLLATE NOCASE
);
CREATE
INDEX
IF
NOT EXISTS
"
IX_AccessValidationHistory_IpAddress
"
ON
"
AccessValidationHistory
"
(
"
IpAddress
"
);
CREATE
INDEX
IF
NOT EXISTS
"
IX_AccessValidationHistory_TesterId
"
ON
"
AccessValidationHistory
"
(
"
TesterId
"
);
CREATE
UNIQUE INDEX
IF
NOT EXISTS
"
IX_Tester_Name
"
ON
"
Tester
"
(
"
Name
"
COLLATE NOCASE
);
CREATE
UNIQUE INDEX
IF
NOT EXISTS
"
IX_Tester_AccessKey
"
ON
"
Tester
"
(
"
AccessKey
"
);
CREATE
UNIQUE INDEX
IF
NOT EXISTS
"
IX_IpGeoCache_IpAddress
"
ON
"
IpGeoCache
"
(
"
IpAddress
"
);
COMMIT
;
Back
|
FazBrowse Home
|
New Git URL