· 6 years ago · Aug 10, 2019, 09:26 AM
1CREATE TABLE IF NOT EXISTS `global_unison_new` (
2 `Id` int(10) NOT NULL AUTO_INCREMENT,
3 `cmduser` varchar(32) NOT NULL,
4 `cmdpw` varchar(32) NOT NULL,
5 `NAME` varchar(32) NOT NULL,
6 `DOLLAR` int(20) NOT NULL,
7 `C1` int(20) NOT NULL,
8 `C2` int(20) NOT NULL,
9 `C3` int(20) NOT NULL,
10 `C4` int(20) NOT NULL,
11 `C5` int(20) NOT NULL,
12 `C6` int(20) NOT NULL,
13`C7` int(20) NOT NULL,
14`C8` int(20) NOT NULL,
15`C9` int(20) NOT NULL,
16`C10` int(20) NOT NULL,
17`C11` int(20) NOT NULL,
18`C12` int(20) NOT NULL,
19`C13` int(20) NOT NULL,
20`C14` int(20) NOT NULL,
21`C15` int(20) NOT NULL,
22`C16` int(20) NOT NULL,
23`C17` int(20) NOT NULL,
24`C18` int(20) NOT NULL,
25 `K` int(20) NOT NULL,
26 `W1` int(20) NOT NULL,
27 `W2` int(20) NOT NULL,
28 `W3` int(20) NOT NULL,
29 `W4` int(20) NOT NULL,
30 `W5` int(20) NOT NULL,
31 `W6` int(20) NOT NULL,
32 `W7` int(20) NOT NULL,
33 `W8` int(20) NOT NULL,
34 `W9` int(20) NOT NULL,
35 `W10` int(20) NOT NULL,
36 `W11` int(20) NOT NULL,
37 `W12` int(20) NOT NULL,
38 `W13` int(20) NOT NULL,
39 `W14` int(20) NOT NULL,
40 `W15` int(20) NOT NULL,
41 `W16` int(20) NOT NULL,
42 `W17` int(20) NOT NULL,
43 `W18` int(20) NOT NULL,
44 `W19` int(20) NOT NULL,
45 `W20` int(20) NOT NULL,
46 `W21` int(20) NOT NULL,
47 `W22` int(20) NOT NULL,
48 `W23` int(20) NOT NULL,
49 `W24` int(20) NOT NULL,
50 `W25` int(20) NOT NULL,
51 `W26` int(20) NOT NULL,
52 `W27` int(20) NOT NULL,
53 `W28` int(20) NOT NULL,
54 `W29` int(20) NOT NULL,
55 `W30` int(20) NOT NULL,
56 `W31` int(20) NOT NULL,
57 `W32` int(20) NOT NULL,
58 `W33` int(20) NOT NULL,
59 `W34` int(20) NOT NULL,
60 `W35` int(20) NOT NULL,
61 `W36` int(20) NOT NULL,
62 `W37` int(20) NOT NULL,
63 `W38` int(20) NOT NULL,
64 `W39` int(20) NOT NULL,
65 `W40` int(20) NOT NULL,
66 `W41` int(20) NOT NULL,
67 `W42` int(20) NOT NULL,
68 `W43` int(20) NOT NULL,
69 `W44` int(20) NOT NULL,
70 `W45` int(20) NOT NULL,
71 `W46` int(20) NOT NULL,
72 `W47` int(20) NOT NULL,
73 `W48` int(20) NOT NULL,
74 `W49` int(20) NOT NULL,
75 `W50` int(20) NOT NULL,
76 `W51` int(20) NOT NULL,
77 `W52` int(20) NOT NULL,
78 `W53` int(20) NOT NULL,
79 `W54` int(20) NOT NULL,
80 `W55` int(20) NOT NULL,
81 `W56` int(20) NOT NULL,
82 `W57` int(20) NOT NULL,
83 `W58` int(20) NOT NULL,
84 `W59` int(20) NOT NULL,
85 `W60` int(20) NOT NULL,
86 `W61` int(20) NOT NULL,
87 `W62` int(20) NOT NULL,
88 `W63` int(20) NOT NULL,
89 `W64` int(20) NOT NULL,
90 `W65` int(20) NOT NULL,
91 `W66` int(20) NOT NULL,
92 `W67` int(20) NOT NULL,
93 `W68` int(20) NOT NULL,
94 `W69` int(20) NOT NULL,
95 `W70` int(20) NOT NULL,
96 `W71` int(20) NOT NULL,
97 `W72` int(20) NOT NULL,
98 `W73` int(20) NOT NULL,
99 `W74` int(20) NOT NULL,
100 `W75` int(20) NOT NULL,
101 `W76` int(20) NOT NULL,
102 `W77` int(20) NOT NULL,
103 `W78` int(20) NOT NULL,
104 `W79` int(20) NOT NULL,
105 `W80` int(20) NOT NULL,
106 `W81` int(20) NOT NULL,
107 `W82` int(20) NOT NULL,
108 `W83` int(20) NOT NULL,
109 `W84` int(20) NOT NULL,
110 `W85` int(20) NOT NULL,
111 `W86` int(20) NOT NULL,
112 `W87` int(20) NOT NULL,
113 `W88` int(20) NOT NULL,
114 `W89` int(20) NOT NULL,
115 `W90` int(20) NOT NULL,
116 `W91` int(20) NOT NULL,
117 `W92` int(20) NOT NULL,
118 `W93` int(20) NOT NULL,
119 `W94` int(20) NOT NULL,
120 `W95` int(20) NOT NULL,
121 `W96` int(20) NOT NULL,
122 `W97` int(20) NOT NULL,
123 `W98` int(20) NOT NULL,
124 `W99` int(20) NOT NULL,
125 `W100` int(20) NOT NULL,
126 `W101` int(20) NOT NULL,
127 `W102` int(20) NOT NULL,
128 `W103` int(20) NOT NULL,
129 `W104` int(20) NOT NULL,
130 `W105` int(20) NOT NULL,
131 `W106` int(20) NOT NULL,
132 `W107` int(20) NOT NULL,
133 `W108` int(20) NOT NULL,
134 `W109` int(20) NOT NULL,
135 `W110` int(20) NOT NULL,
136 `W111` int(20) NOT NULL,
137 `W112` int(20) NOT NULL,
138 `W113` int(20) NOT NULL,
139 `W114` int(20) NOT NULL,
140 `W115` int(20) NOT NULL,
141 `W116` int(20) NOT NULL,
142 `W117` int(20) NOT NULL,
143 `W118` int(20) NOT NULL,
144 `W119` int(20) NOT NULL,
145 `W120` int(20) NOT NULL,
146`W121` int(20) NOT NULL,
147`W122` int(20) NOT NULL,
148`W123` int(20) NOT NULL,
149`W124` int(20) NOT NULL,
150`W125` int(20) NOT NULL,
151`W126` int(20) NOT NULL,
152`W127` int(20) NOT NULL,
153`W128` int(20) NOT NULL,
154`W129` int(20) NOT NULL,
155`W131` int(20) NOT NULL,
156`W132` int(20) NOT NULL,
157`W133` int(20) NOT NULL,
158`W134` int(20) NOT NULL,
159`W135` int(20) NOT NULL,
160`W136` int(20) NOT NULL,
161`W137` int(20) NOT NULL,
162`W138` int(20) NOT NULL,
163`W139` int(20) NOT NULL,
164`W140` int(20) NOT NULL,
165`W141` int(20) NOT NULL,
166`W142` int(20) NOT NULL,
167`W143` int(20) NOT NULL,
168`W144` int(20) NOT NULL,
169`W145` int(20) NOT NULL,
170`W146` int(20) NOT NULL,
171`W147` int(20) NOT NULL,
172`W148` int(20) NOT NULL,
173`W149` int(20) NOT NULL,
174`W150` int(20) NOT NULL,
175`W151` int(20) NOT NULL,
176`W152` int(20) NOT NULL,
177`W153` int(20) NOT NULL,
178`W154` int(20) NOT NULL,
179`W155` int(20) NOT NULL,
180`W156` int(20) NOT NULL,
181`W157` int(20) NOT NULL,
182`W158` int(20) NOT NULL,
183`W159` int(20) NOT NULL,
184`W160` int(20) NOT NULL,
185`W161` int(20) NOT NULL,
186`W162` int(20) NOT NULL,
187`W163` int(20) NOT NULL,
188`W164` int(20) NOT NULL,
189 `ACT` int(20) NOT NULL,
190 `KILLS` int(20) NOT NULL,
191 `RANK` int(20) NOT NULL,
192 PRIMARY KEY (`Id`)
193) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;