createguildinfo.sql

天之炼狱OpenDE_SQL.tar.gz

-- MySQL dump 8.22
--
-- Host: 61.78.53.167    Database: DARKEDEN
---------------------------------------------------------
-- Server version	3.23.54-log

--
-- Table structure for table 'GuildInfo'
--

CREATE TABLE GuildInfo (
  GuildID int(10) unsigned NOT NULL default '0',
  GuildName varchar(20) NOT NULL default '',
  GuildType tinyint(3) unsigned NOT NULL default '0',
  GuildRace tinyint(3) unsigned NOT NULL default '0',
  GuildState tinyint(3) unsigned NOT NULL default '0',
  ServerGroupID tinyint(3) unsigned NOT NULL default '0',
  GuildZoneID smallint(5) unsigned NOT NULL default '0',
  Master varchar(10) NOT NULL default '',
  MemberCount int(10) unsigned NOT NULL default '0',
  Date varchar(11) NOT NULL default '',
  Fame int(10) unsigned NOT NULL default '0',
  Notoriety int(10) unsigned NOT NULL default '0',
  Gold int(10) unsigned NOT NULL default '0',
  Intro text NOT NULL,
  PRIMARY KEY  (GuildName),
  UNIQUE KEY GuildInfo_u1 (GuildID)
) TYPE=MyISAM;

--
-- Dumping data for table 'GuildInfo'
--