Changeset 138 for trunk/sql

Timestamp:

Mar 2, 2009, 8:36:58 PM (15 years ago)

Author:

maron

Message:

Verzování češtiny pro clienta na pár kliknutí (Změna struktury), menší opravy generování levelu

Location:

trunk/sql

Files:

• structure.sql (modified) (1 diff)
• updates/138.sql (added)

trunk/sql/structure.sql

@@ -520 +520 @@
 CHANGE `description` `description` TEXT CHARACTER SET utf8 COLLATE utf8_czech_ci NOT NULL 
 
+
+CREATE TABLE IF NOT EXISTS `verseclient` (
+  `ID` int(11) NOT NULL auto_increment,
+  `verse` text collate utf8_czech_ci NOT NULL,
+  `date` datetime NOT NULL,
+  `text` text collate utf8_czech_ci NOT NULL,
+  `user` int(11) NOT NULL,
+  PRIMARY KEY  (`ID`),
+  KEY `user` (`user`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ;