@@ -154,18 +154,18 @@ |
||
| 154 | 154 | } |
| 155 | 155 | $name = strtolower($name); |
| 156 | 156 | foreach ([ |
| 157 | - 'descr' => 'xs:string', |
|
| 158 | - 'name' => 'eveNameType', |
|
| 159 | - 'balance' => 'eveISKType', |
|
| 160 | - 'isk' => 'eveISKType', |
|
| 161 | - 'tax' => 'eveISKType', |
|
| 162 | - 'timeefficiency' => 'xs:unsignedByte', |
|
| 163 | - 'date' => 'eveNEDTType', |
|
| 164 | - 'time' => 'eveNEDTType', |
|
| 165 | - 'until' => 'eveNEDTType', |
|
| 166 | - 'errorcode' => 'xs:unsignedShort', |
|
| 167 | - 'level' => 'xs:unsignedShort' |
|
| 168 | - ] as $search => $replace) { |
|
| 157 | + 'descr' => 'xs:string', |
|
| 158 | + 'name' => 'eveNameType', |
|
| 159 | + 'balance' => 'eveISKType', |
|
| 160 | + 'isk' => 'eveISKType', |
|
| 161 | + 'tax' => 'eveISKType', |
|
| 162 | + 'timeefficiency' => 'xs:unsignedByte', |
|
| 163 | + 'date' => 'eveNEDTType', |
|
| 164 | + 'time' => 'eveNEDTType', |
|
| 165 | + 'until' => 'eveNEDTType', |
|
| 166 | + 'errorcode' => 'xs:unsignedShort', |
|
| 167 | + 'level' => 'xs:unsignedShort' |
|
| 168 | + ] as $search => $replace) { |
|
| 169 | 169 | if (false !== strpos($name, $search)) { |
| 170 | 170 | return $replace; |
| 171 | 171 | } |
@@ -166,16 +166,16 @@ |
||
| 166 | 166 | $name = strtolower($name); |
| 167 | 167 | $column = 'null'; |
| 168 | 168 | foreach ([ |
| 169 | - 'descr' => '\'\'', |
|
| 170 | - 'name' => '\'\'', |
|
| 171 | - 'balance' => '\'0.0\'', |
|
| 172 | - 'isk' => '\'0.0\'', |
|
| 173 | - 'tax' => '\'0.0\'', |
|
| 174 | - 'timeefficiency' => 'null', |
|
| 175 | - 'date' => '\'1970-01-01 00:00:01\'', |
|
| 176 | - 'time' => '\'1970-01-01 00:00:01\'', |
|
| 177 | - 'until' => '\'1970-01-01 00:00:01\'' |
|
| 178 | - ] as $search => $replace) { |
|
| 169 | + 'descr' => '\'\'', |
|
| 170 | + 'name' => '\'\'', |
|
| 171 | + 'balance' => '\'0.0\'', |
|
| 172 | + 'isk' => '\'0.0\'', |
|
| 173 | + 'tax' => '\'0.0\'', |
|
| 174 | + 'timeefficiency' => 'null', |
|
| 175 | + 'date' => '\'1970-01-01 00:00:01\'', |
|
| 176 | + 'time' => '\'1970-01-01 00:00:01\'', |
|
| 177 | + 'until' => '\'1970-01-01 00:00:01\'' |
|
| 178 | + ] as $search => $replace) { |
|
| 179 | 179 | if (false !== strpos($name, $search)) { |
| 180 | 180 | return $replace; |
| 181 | 181 | } |
@@ -228,24 +228,24 @@ |
||
| 228 | 228 | } |
| 229 | 229 | $name = strtolower($name); |
| 230 | 230 | foreach ([ |
| 231 | - 'descr' => 'TEXT NOT NULL', |
|
| 232 | - 'name' => 'CHAR(100) NOT NULL', |
|
| 233 | - 'balance' => 'DECIMAL(17, 2) NOT NULL', |
|
| 234 | - 'isk' => 'DECIMAL(17, 2) NOT NULL', |
|
| 235 | - 'tax' => 'DECIMAL(17, 2) NOT NULL', |
|
| 236 | - 'timeefficiency' => 'TINYINT(3) UNSIGNED NOT NULL', |
|
| 237 | - 'date' => 'DATETIME NOT NULL DEFAULT \'1970-01-01 00:00:01\'', |
|
| 238 | - 'time' => 'DATETIME NOT NULL DEFAULT \'1970-01-01 00:00:01\'', |
|
| 239 | - 'until' => 'DATETIME NOT NULL DEFAULT \'1970-01-01 00:00:01\'', |
|
| 240 | - 'errorcode' => 'SMALLINT(4) UNSIGNED NOT NULL', |
|
| 241 | - 'level' => 'SMALLINT(4) UNSIGNED NOT NULL', |
|
| 242 | - 'logoncount' => 'BIGINT(20) UNSIGNED NOT NULL', |
|
| 243 | - 'logonminutes' => 'BIGINT(20) UNSIGNED NOT NULL', |
|
| 244 | - 'trainingend' => 'DATETIME NOT NULL DEFAULT \'1970-01-01 00:00:01\'', |
|
| 245 | - 'skillintraining' => 'BIGINT(20) UNSIGNED NOT NULL', |
|
| 246 | - 'trainingdestinationsp' => 'BIGINT(20) UNSIGNED NOT NULL', |
|
| 247 | - 'trainingstartsp' => 'BIGINT(20) UNSIGNED NOT NULL' |
|
| 248 | - ] as $search => $replace) { |
|
| 231 | + 'descr' => 'TEXT NOT NULL', |
|
| 232 | + 'name' => 'CHAR(100) NOT NULL', |
|
| 233 | + 'balance' => 'DECIMAL(17, 2) NOT NULL', |
|
| 234 | + 'isk' => 'DECIMAL(17, 2) NOT NULL', |
|
| 235 | + 'tax' => 'DECIMAL(17, 2) NOT NULL', |
|
| 236 | + 'timeefficiency' => 'TINYINT(3) UNSIGNED NOT NULL', |
|
| 237 | + 'date' => 'DATETIME NOT NULL DEFAULT \'1970-01-01 00:00:01\'', |
|
| 238 | + 'time' => 'DATETIME NOT NULL DEFAULT \'1970-01-01 00:00:01\'', |
|
| 239 | + 'until' => 'DATETIME NOT NULL DEFAULT \'1970-01-01 00:00:01\'', |
|
| 240 | + 'errorcode' => 'SMALLINT(4) UNSIGNED NOT NULL', |
|
| 241 | + 'level' => 'SMALLINT(4) UNSIGNED NOT NULL', |
|
| 242 | + 'logoncount' => 'BIGINT(20) UNSIGNED NOT NULL', |
|
| 243 | + 'logonminutes' => 'BIGINT(20) UNSIGNED NOT NULL', |
|
| 244 | + 'trainingend' => 'DATETIME NOT NULL DEFAULT \'1970-01-01 00:00:01\'', |
|
| 245 | + 'skillintraining' => 'BIGINT(20) UNSIGNED NOT NULL', |
|
| 246 | + 'trainingdestinationsp' => 'BIGINT(20) UNSIGNED NOT NULL', |
|
| 247 | + 'trainingstartsp' => 'BIGINT(20) UNSIGNED NOT NULL' |
|
| 248 | + ] as $search => $replace) { |
|
| 249 | 249 | if (false !== strpos($name, $search)) { |
| 250 | 250 | return $replace; |
| 251 | 251 | } |