Repository navigation
Expand file tree
/
Copy path_dbstru.php
More file actions
530 lines (496 loc) · 16.1 KB
/
Copy path_dbstru.php
File metadata and controls
530 lines (496 loc) · 16.1 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
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
<?php
$_dbstru = array(
'Cfg' =>
"Module varchar(60) ,
Prop varchar(20),
Val text,
UNIQUE KEY (Module, Prop)",
'SchemaState' =>
"ssKey varchar(32) not null,
ssVersion varchar(32) not null,
ssUpdatedAt bigint unsigned default 0,
PRIMARY KEY (ssKey)",
'SchemaMigrations' =>
"smID varchar(80) not null,
smChecksum char(64) not null,
smFromVersion varchar(32) not null,
smToVersion varchar(32) not null,
smClassification varchar(24) not null,
smStatus varchar(16) not null,
smAppVersion varchar(32) not null,
smStartedAt bigint unsigned default 0,
smFinishedAt bigint unsigned default 0,
smErrorCode varchar(64) default '',
smErrorSummary varchar(500) default '',
PRIMARY KEY (smID),
KEY SMSTATUS (smStatus, smStartedAt)",
'UpdateRuns' =>
"urID char(32) not null,
urManifestChecksum char(64) not null,
urSourceVersion varchar(32) not null,
urTargetVersion varchar(32) not null,
urSourceSchemaVersion varchar(32) not null,
urTargetSchemaVersion varchar(32) not null,
urClassification varchar(24) not null,
urState varchar(16) not null,
urMessageCode varchar(64) default '',
urMessageSummary varchar(500) default '',
urCreatedAt bigint unsigned default 0,
urUpdatedAt bigint unsigned default 0,
urFinishedAt bigint unsigned default 0,
PRIMARY KEY (urID),
KEY URSTATE (urState, urUpdatedAt)",
'ApiTokens' =>
"atID int(10) auto_increment,
atuID int(10) not null,
atName varchar(100) default '',
atTokenHash char(64) not null,
atScopes varchar(500) default '*',
atState int(1) default 1,
atCreatedAt bigint unsigned default 0,
atExpiresAt bigint unsigned default 0,
atLastUsedAt bigint unsigned default 0,
atLastIP varchar(45) default '',
PRIMARY KEY (atID),
UNIQUE KEY ATTOKENHASH (atTokenHash),
KEY ATUSER (atuID, atState)",
'ApiRateLimits' =>
"arlKey char(64) not null,
arlWindow bigint unsigned not null,
arlCount int unsigned default 0,
arlUpdatedAt bigint unsigned default 0,
PRIMARY KEY (arlKey, arlWindow),
KEY ARLUPDATED (arlUpdatedAt)",
'Installations' =>
"tiID bigint unsigned auto_increment,
tiPublicID char(36) not null,
tiDomain varchar(253) not null,
tiVersion varchar(32) not null,
tiInstalledAt bigint unsigned default 0,
tiRegisteredAt bigint unsigned default 0,
tiLastSeenAt bigint unsigned default 0,
tiLastReportAt bigint unsigned default 0,
tiLastReportedAt bigint unsigned default 0,
tiLastSequence bigint unsigned default 0,
tiTokenHash char(64) not null,
tiStatsConsent int(1) default 0,
tiState int(1) default 1,
tiLastIP varchar(45) default '',
tiDataSource varchar(32) not null default 'external-self-reported',
tiDnsStatus varchar(16) not null default 'unresolved',
tiDnsAddresses json,
tiDnsCheckedAt bigint unsigned default 0,
tiDnsExpiresAt bigint unsigned default 0,
tiDnsErrorCode varchar(64) not null default '',
tiDomainVerifiedAt bigint unsigned not null default 0,
tiDomainVerifiedUntil bigint unsigned not null default 0,
tiDomainProofHash char(64) not null default '',
tiDomainProofExpiresAt bigint unsigned not null default 0,
tiDomainProofAttemptAt bigint unsigned not null default 0,
tiDomainProofError varchar(64) not null default '',
PRIMARY KEY (tiID),
UNIQUE KEY TIPUBLICID (tiPublicID),
UNIQUE KEY TITOKENHASH (tiTokenHash),
KEY TIDOMAIN (tiDomain),
KEY TILASTSEEN (tiState, tiLastSeenAt),
KEY TIVERSION (tiVersion),
KEY TIVERSIONLIST (tiVersion, tiState, tiLastSeenAt),
KEY TIREPORTSTATE (tiState, tiLastReportAt, tiLastSeenAt),
KEY TISTATSCONSENT (tiStatsConsent, tiState, tiLastSeenAt),
KEY TIDNSSTATUS (tiDnsStatus, tiState, tiLastSeenAt),
KEY TIIPLIST (tiLastIP, tiState, tiLastSeenAt)",
'InstallationReports' =>
"tirID bigint unsigned auto_increment,
tirInstallationID bigint unsigned not null,
tirDay char(10) not null,
tirSequence bigint unsigned default 0,
tirReportedAt bigint unsigned default 0,
tirVersion varchar(32) not null,
tirStats json,
tirPayloadHash char(64) not null default '',
tirDataSource varchar(32) not null default 'self-reported',
tirCreatedAt bigint unsigned default 0,
tirUpdatedAt bigint unsigned default 0,
PRIMARY KEY (tirID),
UNIQUE KEY TIRDAY (tirInstallationID, tirDay),
UNIQUE KEY TIRSEQUENCE (tirInstallationID, tirSequence),
KEY TIRUPDATED (tirUpdatedAt)",
'InstallationIpHistory' =>
"tihID bigint unsigned auto_increment,
tihInstallationID bigint unsigned not null,
tihIP varchar(45) not null,
tihFirstSeenAt bigint unsigned default 0,
tihLastSeenAt bigint unsigned default 0,
tihRequestCount bigint unsigned default 0,
PRIMARY KEY (tihID),
UNIQUE KEY TIHIP (tihInstallationID, tihIP),
KEY TIHLASTSEEN (tihInstallationID, tihLastSeenAt)",
'InstallationDomainEvents' =>
"tdeID bigint unsigned auto_increment,
tdeInstallationID bigint unsigned not null,
tdeOldDomain varchar(253) not null,
tdeNewDomain varchar(253) not null,
tdeObservedIP varchar(45) not null,
tdeCreatedAt bigint unsigned default 0,
PRIMARY KEY (tdeID),
KEY TDEINSTALLATION (tdeInstallationID, tdeCreatedAt)",
'TelemetryIngestionCounters' =>
"ticDay char(10) not null,
ticCode varchar(64) not null,
ticCount bigint unsigned default 0,
ticFirstAt bigint unsigned default 0,
ticLastAt bigint unsigned default 0,
PRIMARY KEY (ticDay, ticCode),
KEY TICLAST (ticLastAt)",
'TelemetryServiceTokens' =>
"tstID int(10) auto_increment,
tstuID int(10) not null,
tstName varchar(100) default '',
tstTokenHash char(64) not null,
tstTokenPrefix varchar(16) default '',
tstScope varchar(64) default 'telemetry:read',
tstState int(1) default 1,
tstCreatedAt bigint unsigned default 0,
tstExpiresAt bigint unsigned default 0,
tstLastUsedAt bigint unsigned default 0,
tstLastIP varchar(45) default '',
PRIMARY KEY (tstID),
UNIQUE KEY TSTTOKENHASH (tstTokenHash),
KEY TSTSTATE (tstState, tstExpiresAt),
KEY TSTUSER (tstuID)",
'Jobs' =>
"jID int(10) auto_increment,
jType varchar(50) not null,
jPayload text not null,
jState int(1) default 0,
jAttempts int(2) default 0,
jMaxAttempts int(2) default 3,
jCTS bigint(14) default 0,
jPTS bigint(14) default 0,
jDTS bigint(14) default 0,
jError text,
PRIMARY KEY (jID),
KEY JSTATE (jState, jCTS),
KEY JTYPE (jType, jState)",
'Hist' =>
"hID int(10) auto_increment,
hTS bigint(14) default 0,
hOper varchar(10) default '',
huID int(10) default 0,
hIP varchar(15),
hcID int(2) default 0,
hSum decimal(13,6) default 0,
hParams text,
hTag int(10) default 0,
hMemo varchar(60),
hoID int(10) default 0,
PRIMARY KEY (hID),
KEY HTS (hTS),
KEY HTAG (hTag,hMemo)",
'Users' =>
"uID int(10) auto_increment,
uGroup varchar(40) default '',
uLogin varchar(40) default '',
uPass varchar(255) default '',
uPass2 varchar(255) default '',
uMail varchar(60) default '',
uPIN varchar(255) default '',
uState int(1) default 0,
uBTS bigint(14),
uLevel int(2) default 0,
uLang varchar(10) default 'en',
uMode varchar(10) default '',
uTheme varchar(10) default '',
uRef int(10) default 0,
uBal decimal(13,6) default 0,
uWDDisable int(1) default 0,
uLTS bigint(14),
uLIP varchar(15),
uLSess varchar(32),
uPTS bigint(14) default 0,
uBFC int(1) default 0,
PRIMARY KEY (uID),
UNIQUE KEY ULOGIN (uLogin),
UNIQUE KEY UMAIL (uMail),
KEY UREF (uRef),
KEY ULTS (uLTS)",
'AddInfo' =>
"auID int(10) ,
aName varchar(60) default '',
aCTS bigint(14) default 0,
aCIP varchar(15) default '',
aSQuestion varchar(60),
aSAnswer varchar(255),
aPerc text,
aDPerc text,
aPPerc text,
aIPSec int(1) default 0,
aFailedLoginThreshold smallint unsigned NULL DEFAULT NULL,
aSessIP int(1) default 0,
aSessUniq int(1) default 0,
aTimeOut int(3) default 0,
aOIDs text,
aMenuPins text,
aTZ int(4) default 0,
aBD bigint(14) default 0,
aCountry varchar(40) default '',
aCity varchar(60) default '',
aTel varchar(20) default '',
aAvatar int(1) default 0,
aDefCurr int(2) default 0,
aNoMail int(1) default 0,
aGA varchar(100),
aNeedReConfig int(1) default 1,
CONSTRAINT chk_account_login_threshold CHECK (aFailedLoginThreshold IS NULL OR aFailedLoginThreshold BETWEEN 1 AND 100),
PRIMARY KEY (auID)",
'News' =>
"nID int(5) auto_increment,
nDBegin bigint(14) default 0,
nDEnd bigint(14) default 0,
nTS bigint(14) default 0,
nTopic varchar(1000) default '',
nAnnounce text,
nText text,
nAttn int(1),
PRIMARY KEY (nID)",
'PaymentProviders' => (require __DIR__ . '/resources/payment-provider-schema.php')['PaymentProviders'],
'PaymentProviderCredentials' => (require __DIR__ . '/resources/payment-provider-schema.php')['PaymentProviderCredentials'],
'Currs' => // CID - Currency ID (see PaymentManager) -> Name, Curr
"cID int(2) auto_increment,
cDisabled int(1) default 1,
cHidden int(1) default 0,
cCID varchar(4) default '',
cCurrID varchar(10) default '',
cProviderID int unsigned NULL DEFAULT NULL,
cProviderSelected tinyint unsigned NOT NULL DEFAULT 0,
cArchivedAt bigint unsigned NULL DEFAULT NULL,
cName varchar(120) default '',
cCurr varchar(60) default '',
cParams text,
cParamsSCI text,
cParamsAPI text,
cPaymentRoutes text,
cNumDec int(1) default 0,
cCASHINMode int(1) default 1,
cCASHINMin decimal(13,6) default 0,
cCASHINMax decimal(13,6) default 0,
cCASHINInt int(1) default 0,
cCASHINComis decimal(6,2) default 0,
cCASHINComisMin decimal(13,6) default 00,
cCASHINComisMax decimal(13,6) default 00,
cCASHOUTMode int(1) default 0,
cCASHOUTMin decimal(13,6) default 0,
cCASHOUTMax decimal(13,6) default 0,
cCASHOUTInt int(1) default 0,
cCASHOUTComis decimal(6,2) default 0,
cCASHOUTComisMin decimal(13,6) default 00,
cCASHOUTComisMax decimal(13,6) default 00,
cCASHOUTLimitPer int(3) default 0,
cCASHOUTLimit decimal(13,6) default 0,
cEXMode int(1) default 0,
cEXOut decimal(10,6) default 0,
cEXIn decimal(10,6) default 0,
cEXMin decimal(13,6) default 0,
cEXMax decimal(13,6) default 0,
cEXInt int(1) default 0,
cEXComis decimal(6,2) default 0,
cEXComisMin decimal(13,6) default 00,
cEXComisMax decimal(13,6) default 00,
cTRMode int(1) default 0,
cTRMin decimal(13,6) default 0,
cTRMax decimal(13,6) default 0,
cTRInt int(1) default 0,
cTRComis decimal(6,2) default 0,
cTRComisMin decimal(13,6) default 00,
cTRComisMax decimal(13,6) default 00,
cBUYMode int(1) default 0,
cSELLMode int(1) default 0,
cBUY2Mode int(1) default 0,
cSELL2Mode int(1) default 0,
cGIVEMode int(1) default 0,
cTAKEMode int(1) default 0,
cMTS bigint(14),
cBalMin decimal(13,6) default 0,
cBal decimal(13,6) default 0,
cBalTS bigint(14),
PRIMARY KEY (cID),
UNIQUE KEY uq_currency_provider_fiat (cProviderID,cCurrID),
CONSTRAINT fk_currency_provider FOREIGN KEY (cProviderID) REFERENCES PaymentProviders(ppID) ON DELETE RESTRICT ON UPDATE RESTRICT,
CONSTRAINT chk_currency_provider CHECK ((cProviderID IS NULL AND cProviderSelected=0 AND (cCID IS NULL OR cCID<>'PAW')) OR (cProviderID IS NOT NULL AND cCID IS NOT NULL AND cCID='PAW' AND cProviderSelected IN (0,1))),
CONSTRAINT chk_paw_configuration_only CHECK (cProviderID IS NULL OR (cDisabled IS NOT NULL AND cDisabled=1 AND cCASHINMode IS NOT NULL AND cCASHINMode=0 AND cCASHOUTMode IS NOT NULL AND cCASHOUTMode=0))", // cParams - IN (public) wallet, cParams2 - OUT (private) wallet
'Wallets' =>
"wcID int(2) default 0,
wuID int(10) default 0,
wBal decimal(13,6) default 0,
wLock decimal(13,6) default 0,
wOut decimal(13,6) default 0,
wParams text,
wMTS bigint(14),
PRIMARY KEY (wcID,wuID)",
'Opers' =>
"oID int(10) auto_increment,
oCTS bigint(14),
oATS bigint(14),
ouID int(10),
oOper varchar(10),
ocID int(2),
oSum decimal(13,6) default 0,
oComis decimal(13,6) default 0,
oParams text,
oParams2 text,
oBatch varchar(40),
oTag varchar(60),
oTS bigint(14),
oState int(1) default 0,
oPTS bigint(14) default 0,
oMemo varchar(120),
oNTS bigint(14),
PRIMARY KEY (oID),
KEY OBATCH (ocID,oBatch),
KEY OTAG (oTag)", // oParams2 - additional parameters (for ex. deposit)
'Calend'=>
"cID int(6) auto_increment,
cTS bigint(14) default 0,
cYear int(4),
cMonth int(2),
cDay int(2),
cType int(1),
cPerc decimal(7,2) default 0,
PRIMARY KEY (cID),
KEY CTS (cTS),
KEY CDAY (cYear,cMonth,cDay)",
/*'Banners' =>
"rID int(10) auto_increment,
rDisabled int(1) default 1,
rDBegin bigint(14) ,
rDEnd bigint(14) ,
rPlace int(4),
rName varchar(120),
rPictURL varchar(500),
rGoURL varchar(500),
rWeeks int(3),
PRIMARY KEY (rID)",*/
'Plans' =>
"pID int(3) auto_increment,
pHidden int(1) default 0,
pNoCalc int(1) default 0,
pGroup int(2) default 0,
pGroupReq int(2) default 0,
pMaxCount int(3) default 0,
pName varchar(400) default '',
pDescr varchar(1000) default '',
pMin decimal(13,6) default 1.00,
pMax decimal(13,6) default 0,
pDays int(5) default 0,
pWDays int(1) default 0,
pPerc decimal(7,2) default 0,
pCompndMin decimal(7,2) default 0,
pCompndMax decimal(7,2) default 0,
pPer int(6) default 0,
pNPer int(5) default 0,
pReturn decimal(7,2) default 100.00,
pMPer int(5) default 0,
pClPer int(5) default 0,
pClComis decimal(7,2) default 100.00,
pBonus decimal(7,2) default 0,
pEnAdd int(1) default 0,
pMinAdd decimal(13,6) default 1.00,
pDPerc text,
pPPerc text,
pPClndr int(1) default 0,
pmndID int(10) default 0,
pmndIDdone int(10) default 0,
pmnPerc decimal(7,2) default 0,
PRIMARY KEY (pID)",
'Deps' =>
"dID int(10) auto_increment,
duID int(10) default 0,
dState int(1) default 0,
dpID int(3) default 0,
dCTS bigint(14) default 0,
dETS bigint(14) default 0,
dcID int(2) default 0,
dZ0 decimal(13,6) default 0,
dZD decimal(13,6) default 0,
dCompnd decimal(7,2) default 0,
dZC decimal(13,6) default 0,
dNTS bigint(14) default 0,
dLTS bigint(14) default 0,
dZP decimal(13,6) default 0,
dNPer int(5) default 0,
PRIMARY KEY (dID),
KEY AUID (duID),
KEY ACTS (dCTS)",
'Review' =>
"oID int(10) auto_increment,
oTS bigint(14) default 0,
ouID int(10) default 0,
oAuthor varchar(40) default '',
oText text,
oRating tinyint unsigned NOT NULL default 5,
oOrder int(3) default 0,
oState int(1) default 0,
PRIMARY KEY (oID)",
'FAQ' =>
"fID int(5) auto_increment,
fHidden int(1) default 0,
fCTS bigint(14) default 0,
fCat varchar(100) default '',
fOrder int(3) default 0,
fQuestion varchar(2000) default '',
fAnswer text,
PRIMARY KEY (fID)",
'Tickets' =>
"tID int(10) auto_increment,
tuID int(10) default 0,
tTS bigint(14) default 0,
tTID varchar(32) default '',
tName varchar(60) default '',
tMail varchar(60) default '',
tCat varchar(100) default '',
tTopic varchar(200),
tText text,
tPriority int(1),
tState int(1),
tLang varchar(10) default 'en',
tLTS bigint(14),
PRIMARY KEY (tID),
KEY TUID (tuID)",
'TMsg' =>
"mID int(10) auto_increment,
mtID int(10) default 0,
muID int(10) default 0,
mTS bigint(14) default 0,
mText text,
mRTS bigint(14),
PRIMARY KEY (mID),
KEY MTID (mtID)",
'Msg' =>
"mID int(10) auto_increment,
muID int(10) default 0,
mTS bigint(14) default 0,
mMail varchar(60) default '',
mAttn int(1),
mTopic varchar(120) default 0,
mText text,
mLang varchar(10) default 'en',
mGroup int(10) default 0,
mTo text,
mToCnt int(6) default 0,
PRIMARY KEY (mID),
KEY MUID (muID)",
'MBox' =>
"bID int(10) auto_increment,
buID int(10) default 0,
bmID int(10) default 0,
bRe int(10) default 0,
buID2 int(10) default 0,
bMail varchar(60) default '',
bRTS bigint(14) default 0,
bDeleted int(1) default 0,
PRIMARY KEY (bID),
KEY BUID (buID),
KEY BUID2 (buID2),
KEY BMID (bmID)",
'IdempotencyKeys' => require __DIR__ . '/resources/idempotency-schema.php'
);