Changeset 8630 for trunk/L2J_DataPack/dist/sql/game/olympiad_nobles.sql

Timestamp:

Jan 16, 2012 7:56:19 AM (4 months ago)

Author:

MELERIX

Message:

STABLE: Sync with BETA [8629]

Location:

trunk/L2J_DataPack

Files:

• . (modified) (1 prop)
• dist/sql/game/olympiad_nobles.sql (modified) (1 diff)

trunk/L2J_DataPack/dist/sql/game/olympiad_nobles.sql

@@ -1 +1 @@
 CREATE TABLE IF NOT EXISTS `olympiad_nobles` (
-  `charId` INT UNSIGNED NOT NULL default 0,
-  `class_id` tinyint(3) unsigned NOT NULL default 0,
-  `olympiad_points` int(10) NOT NULL default 0,
-  `competitions_done` smallint(3) NOT NULL default 0,
-  `competitions_won` smallint(3) NOT NULL default 0,
-  `competitions_lost` smallint(3) NOT NULL default 0,
-  `competitions_drawn` smallint(3) NOT NULL default 0,
-  `competitions_done_week` tinyint(3) NOT NULL default 0,
-  `competitions_done_week_classed` tinyint(3) NOT NULL default 0,
-  `competitions_done_week_non_classed` tinyint(3) NOT NULL default 0,
-  `competitions_done_week_team` tinyint(3) NOT NULL default 0,
+  `charId` int(10) unsigned NOT NULL DEFAULT 0,
+  `class_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
+  `olympiad_points` int(10) unsigned NOT NULL DEFAULT 0,
+  `competitions_done` smallint(3) unsigned NOT NULL DEFAULT 0,
+  `competitions_won` smallint(3) unsigned NOT NULL DEFAULT 0,
+  `competitions_lost` smallint(3) unsigned NOT NULL DEFAULT 0,
+  `competitions_drawn` smallint(3) unsigned NOT NULL DEFAULT 0,
+  `competitions_done_week` tinyint(3) unsigned NOT NULL DEFAULT 0,
+  `competitions_done_week_classed` tinyint(3) unsigned NOT NULL DEFAULT 0,
+  `competitions_done_week_non_classed` tinyint(3) unsigned NOT NULL DEFAULT 0,
+  `competitions_done_week_team` tinyint(3) unsigned NOT NULL DEFAULT 0,
   PRIMARY KEY (`charId`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;