[Planeshift-cvs] CVS: planeshift/src/server/database/mysql export.sql,1.4,1.5

[Keith F. <ven...@us...>]

Update of /cvsroot/planeshift/planeshift/src/server/database/mysql
In directory usw-pr-cvs1:/tmp/cvs-serv19300

Modified Files:
	export.sql 
Log Message:
Changed tables slightly.  You must drop your existing tables and run this
in order for guild commands to work.

Index: export.sql
===================================================================
RCS file: /cvsroot/planeshift/planeshift/src/server/database/mysql/export.sql,v
retrieving revision 1.4
retrieving revision 1.5
diff -C2 -d -r1.4 -r1.5
*** export.sql	23 Feb 2002 23:41:02 -0000	1.4
--- export.sql	4 Mar 2002 00:38:23 -0000	1.5
***************
*** 16,22 ****
    PRIMARY KEY (id),
    KEY id_2 (id),
!   KEY username_2 (username),
    UNIQUE id (id),
!   UNIQUE username (username)
  );
  
--- 16,22 ----
    PRIMARY KEY (id),
    KEY id_2 (id),
!   KEY id_2 (username),
    UNIQUE id (id),
!   UNIQUE id (username)
  );
  
***************
*** 29,34 ****
--- 29,58 ----
  INSERT INTO accounts VALUES("2","matze","matthias","","");
  INSERT INTO accounts VALUES("3","guest","guest","","");
+ #
+ # Table structure for table 'guildlevels'
+ #
+ 
+ CREATE TABLE guildlevels (
+   guild_id int(11) unsigned NOT NULL DEFAULT '0' ,
+   level smallint(3) unsigned NOT NULL DEFAULT '0' ,
+   level_name varchar(25) NOT NULL DEFAULT '0' ,
+   PRIMARY KEY (guild_id,level)
+ );
+ 
  
  #
+ # Dumping data for table 'guildlevels'
+ #
+ 
+ INSERT INTO guildlevels VALUES("5","7","Grand Master");
+ INSERT INTO guildlevels VALUES("5","6","High Master");
+ INSERT INTO guildlevels VALUES("5","5","Master");
+ INSERT INTO guildlevels VALUES("5","4","VengesLevel");
+ INSERT INTO guildlevels VALUES("5","3","TestLevel");
+ INSERT INTO guildlevels VALUES("5","2","Novice");
+ INSERT INTO guildlevels VALUES("5","1","Apprentice");
+ INSERT INTO guildlevels VALUES("5","8","Mogul");
+ INSERT INTO guildlevels VALUES("5","9","Maximus");
+ #
  # Table structure for table 'guilds'
  #
***************
*** 52,58 ****
  #
  
! INSERT INTO guilds VALUES("1","BlackClaws","1","2002-02-23 02:41:36","0","0");
! INSERT INTO guilds VALUES("2","HeroicFew","1","2002-02-23 02:42:00","0","0");
! INSERT INTO guilds VALUES("3","FansOfTalad","1","2002-02-23 02:44:02","0","0");
  #
  # Table structure for table 'players'
--- 76,80 ----
  #
  
! INSERT INTO guilds VALUES("5","TestGuild","3","2002-03-03 14:29:39","0","0");
  #
  # Table structure for table 'players'
***************
*** 74,77 ****
--- 96,100 ----
    guild_member_of int(10) ,
    acct_id int(8) unsigned NOT NULL DEFAULT '0' ,
+   guild_level tinyint(1) unsigned DEFAULT '0' ,
    PRIMARY KEY (id),
    KEY id (id),
***************
*** 84,89 ****
  #
  
! 
! INSERT INTO players VALUES("1","Vengeance","0","0","0","0","0","0","0","N","","","","1");
! INSERT INTO players VALUES("2","CelGod","0","0","0","0","0","0","0","N","0000-00-00 00:00:00","0","","2");
! INSERT INTO players VALUES("3","guest","0","0","0","0","0","0","0","N","0000-00-00 00:00:00","0","","3");
--- 107,111 ----
  #
  
! INSERT INTO players VALUES("1","Vengeance","0","0","0","0","0","0","0","N","","","5","1","8");
! INSERT INTO players VALUES("2","CelGod","0","0","0","0","0","0","0","N","0000-00-00 00:00:00","0","","2","0");
! INSERT INTO players VALUES("3","guest","0","0","0","0","0","0","0","N","0000-00-00 00:00:00","0","5","3","9");