· 5 years ago · Feb 01, 2020, 10:00 PM
1 /* Create SQL statement */
2 char sql[6000] = { 0 };
3 sprintf_s(sql, "CREATE TABLE IF NOT EXISTS friends ( \
4 ID SERIAL PRIMARY KEY NOT NULL, \
5 NAME VARCHAR(64) NOT NULL, \
6 SPAWNID INT NOT NULL DEFAULT 0, \
7 PETID INT NOT NULL DEFAULT 0, \
8 ZoneID INT NOT NULL DEFAULT 0, \
9 STATUS VARCHAR(64) NOT NULL, \
10 CONNECTED BOOL NOT NULL DEFAULT FALSE, \
11 LASTCHANGE BIGINT UNSIGNED NOT NULL DEFAULT 0, \
12 LASTCHECK BIGINT UNSIGNED NOT NULL DEFAULT 0, \
13 NOTES VARCHAR(2048) NOT NULL DEFAULT '',\
14 AEGO BIGINT UNSIGNED NOT NULL DEFAULT 0, \
15 HASTE BIGINT UNSIGNED NOT NULL DEFAULT 0, \
16 SKIN BIGINT UNSIGNED NOT NULL DEFAULT 0, \
17 FOCUS BIGINT UNSIGNED NOT NULL DEFAULT 0, \
18 REGEN BIGINT UNSIGNED NOT NULL DEFAULT 0, \
19 SYMBOL BIGINT UNSIGNED NOT NULL DEFAULT 0, \
20 CLARITY BIGINT UNSIGNED NOT NULL DEFAULT 0, \
21 PRED BIGINT UNSIGNED NOT NULL DEFAULT 0, \
22 STRENGTH BIGINT UNSIGNED NOT NULL DEFAULT 0, \
23 BRELLS BIGINT UNSIGNED NOT NULL DEFAULT 0, \
24 SV BIGINT UNSIGNED NOT NULL DEFAULT 0, \
25 SE BIGINT UNSIGNED NOT NULL DEFAULT 0, \
26 HybridHP BIGINT UNSIGNED NOT NULL DEFAULT 0, \
27 Growth BIGINT UNSIGNED NOT NULL DEFAULT 0, \
28 Rune BIGINT UNSIGNED NOT NULL DEFAULT 0, \
29 Rune2 BIGINT UNSIGNED NOT NULL DEFAULT 0, \
30 Shining BIGINT UNSIGNED NOT NULL DEFAULT 0, \
31 Fero BIGINT UNSIGNED NOT NULL DEFAULT 0, \
32 Retort BIGINT UNSIGNED NOT NULL DEFAULT 0, \
33 SpellHaste BIGINT UNSIGNED NOT NULL DEFAULT 0, \
34 MeleeProc BIGINT UNSIGNED NOT NULL DEFAULT 0, \
35 SpellProc BIGINT UNSIGNED NOT NULL DEFAULT 0, \
36 KillShotProc BIGINT UNSIGNED NOT NULL DEFAULT 0, \
37 DefensiveProc BIGINT UNSIGNED NOT NULL DEFAULT 0, \
38 MoveSpeed BIGINT UNSIGNED NOT NULL DEFAULT 0, \
39 Levitate BIGINT UNSIGNED NOT NULL DEFAULT 0, \
40 IVU BIGINT UNSIGNED NOT NULL DEFAULT 0, \
41 Invis BIGINT UNSIGNED NOT NULL DEFAULT 0, \
42 Preincarnation BIGINT UNSIGNED NOT NULL DEFAULT 0, \
43 Malo BIGINT UNSIGNED NOT NULL DEFAULT 0, \
44 Tash BIGINT UNSIGNED NOT NULL DEFAULT 0, \
45 Slow BIGINT UNSIGNED NOT NULL DEFAULT 0, \
46 Root BIGINT UNSIGNED NOT NULL DEFAULT 0, \
47 Snare BIGINT UNSIGNED NOT NULL DEFAULT 0, \
48 Mez BIGINT UNSIGNED NOT NULL DEFAULT 0, \
49 DS BIGINT UNSIGNED NOT NULL DEFAULT 0, \
50 RevDS BIGINT UNSIGNED NOT NULL DEFAULT 0, \
51 Cripple BIGINT UNSIGNED NOT NULL DEFAULT 0, \
52 Charm BIGINT UNSIGNED NOT NULL DEFAULT 0, \
53 Concuss BIGINT UNSIGNED NOT NULL DEFAULT 0, \
54 DeepSleep BIGINT UNSIGNED NOT NULL DEFAULT 0, \
55 MindFroze BIGINT UNSIGNED NOT NULL DEFAULT 0, \
56 TotalCounters INT NOT NULL DEFAULT 0, \
57 CountersDisease INT NOT NULL DEFAULT 0, \
58 CountersPoison INT NOT NULL DEFAULT 0, \
59 CountersCurse INT NOT NULL DEFAULT 0, \
60 CountersCorruption INT NOT NULL DEFAULT 0, \
61 TotalCounters INT NOT NULL DEFAULT 0, \
62 );");