Changeset 64 for trunk/sql

Timestamp:

Feb 5, 2009, 10:39:11 AM (15 years ago)

Author:

george

Message:

• Přidáno: Import textů z dbc souborů. Přidány překladové skupiny gametips a spell.

Location:

trunk/sql

Files:

• full.sql (deleted)
• text_table_init_structure.sql (modified) (1 diff)
• updates/63.sql (modified) (1 diff)
• updates/64.sql (added)

trunk/sql/text_table_init_structure.sql

@@ -14 +14 @@
   KEY `Take` (`Take`),
   KEY `Language` ( `Language` ),
-  KEY `Complete` ( `Complete` ),
+  KEY `Complete` ( `Complete` )
 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
 

trunk/sql/updates/63.sql

@@ -1 +1 @@
 CREATE TABLE `news` (
-`Id` INT NOT NULL ,
+`Id` INT NOT NULL auto_increment,
 `Time` DATETIME NOT NULL ,
 `User` INT NOT NULL ,
-`Text` TEXT NOT NULL
-) ENGINE = MYISAM ;
+`Text` TEXT NOT NULL,
+PRIMARY KEY  (`Id`)
+) ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;