Changeset 555 for trunk/sql

Timestamp:

Mar 29, 2009, 4:21:14 PM (16 years ago)

Author:

george

Message:

• Přidáno: Mimo RSS kanál článků přidány kanály ticketů a finančních příspěvků.

File:

• trunk/sql/structure.sql (modified) (5 diffs)

trunk/sql/structure.sql

@@ -83 +83 @@
   `date` timestamp NOT NULL default '0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=115 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=117 ;
 
 -- --------------------------------------------------------
@@ -117 +117 @@
   `ip` varchar(16) collate utf8_czech_ci NOT NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=63 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=91 ;
 
 -- --------------------------------------------------------
@@ -132 +132 @@
   PRIMARY KEY  (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `debug`
+--
+
+CREATE TABLE IF NOT EXISTS `debug` (
+  `Id` int(11) NOT NULL auto_increment,
+  `Time` datetime NOT NULL,
+  `Backtrace` mediumtext collate latin2_czech_cs NOT NULL,
+  `Log` text collate latin2_czech_cs NOT NULL,
+  `MangosVersion` varchar(255) collate latin2_czech_cs NOT NULL,
+  `DbVersion` varchar(255) collate latin2_czech_cs NOT NULL,
+  `MaxPlayerCount` int(11) NOT NULL,
+  `Uptime` int(11) NOT NULL,
+  `ErrorLog` text collate latin2_czech_cs NOT NULL,
+  `DbErrors` text collate latin2_czech_cs NOT NULL,
+  `Configuration` text collate latin2_czech_cs NOT NULL,
+  PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------
@@ -147 +168 @@
   `ip` varchar(16) collate utf8_czech_ci NOT NULL,
   PRIMARY KEY  (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=18 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=41 ;
 
 -- --------------------------------------------------------
@@ -174 +195 @@
   `odmena` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL,
   KEY `ID` (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=127 ;
+) ENGINE=MyISAM  DEFAULT CHARSET=latin2 COLLATE=latin2_czech_cs AUTO_INCREMENT=128 ;
 
 -- --------------------------------------------------------