Changeset 906 for eu.playstartrek.wcf.ranksystem/install.sql

Timestamp:

07/03/09 22:43:25 (4 years ago)

Author:

MDMAN

Message:

neue Version eu.playstartrek.wcf.ranksystem

Files:

• eu.playstartrek.wcf.ranksystem/install.sql (modified) (2 diffs)

eu.playstartrek.wcf.ranksystem/install.sql

@@ -31 +31 @@
   `name` VARCHAR(45) NULL ,
 
+  `remark` VARCHAR(255) NULL ,
+
+  `sortOrder` INT(10) NOT NULL,
+
   PRIMARY KEY (`rankID`) ,
 
@@ -622 +626 @@
 
  ENGINE=MyISAM  DEFAULT CHARSET=utf8 ;
+
+INSERT INTO `wcf1_pst_ranks`
+(`rankID`, `name`, `remark`, `sortOrder`)
+VALUES
+( '', 'Fleetadmiral', '', '1' ),
+( '', 'Admiral', '', '2'),
+( '', 'Viceadmiral', '', '3' ),
+( '', 'Rearadmiral', '', '4' ),
+( '', 'Commodore', '', '5' ),
+( '', 'Captain', '', '6' ),
+( '', 'Commander', '', '7' ),
+( '', 'Lieutenant Commander', '', '8' ),
+( '', 'Lieutenant', '', '9' ),
+( '', 'Lieutenant Junior Grade', '', '10' ),
+( '', 'Ensign', '', '11' ),
+( '', 'Kadett fourthClass', '', '12' ),
+( '', 'Kadett thirdClass', '', '13' ),
+( '', 'Kadett secondClass', '', '14' ),
+( '', 'Kadett firstClass', '', '15' )