|
Last change
on this file was 7, checked in by george, 16 years ago |
|
Opraveno: Nemožnost editace serveru s názvem obsaženým v jiném názvu.
|
|
File size:
358 bytes
|
| Line | |
|---|
| 1 | ALTER TABLE `servers` DROP `online_checks`;
|
|---|
| 2 |
|
|---|
| 3 | ALTER TABLE `servers` CHANGE `online` `online` FLOAT NULL DEFAULT '0';
|
|---|
| 4 |
|
|---|
| 5 | CREATE TABLE `servers_online` (
|
|---|
| 6 | `server` int(11) NOT NULL,
|
|---|
| 7 | `time` datetime NOT NULL,
|
|---|
| 8 | `state` tinyint(1) NOT NULL,
|
|---|
| 9 | `players_count` int(11) NOT NULL,
|
|---|
| 10 | KEY `server` (`server`)
|
|---|
| 11 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
