Changeset 124 for trunk/sql

Timestamp:

Feb 22, 2009, 9:41:58 PM (15 years ago)

Author:

maron

Message:

Překladatelské týmy (změna struktury)

Location:

trunk/sql

Files:

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

trunk/sql/structure.sql

@@ -498 +498 @@
   PRIMARY KEY  (`ID`)
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=551 ;
+
+ALTER TABLE `user` ADD `team` INT NOT NULL ;
+
+ALTER TABLE `user` ADD INDEX ( `team` ) ;
+
+
+-- --------------------------------------------------------
+
+--
+-- Struktura tabulky `team`
+--
+
+CREATE TABLE IF NOT EXISTS `team` (
+  `ID` int(11) NOT NULL auto_increment,
+  `name` text NOT NULL,
+  `description` text NOT NULL,
+  PRIMARY KEY  (`ID`)
+) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+