www.pudn.com > loseserver.rar > lindb.sql

/* 
LoSE - MySQL Backup file 
Source Host:           localhost 
Source Server Version: 4.0.20a-nt 
Source Database:       lindb 
Date:                  2004-09-03 12:45:25 
*/ 
DROP DATABASE IF EXISTS lindb; 
create database lindb; 
 
use lindb; 
GRANT ALL PRIVILEGES ON *.* TO 'lose'@'%' IDENTIFIED BY 'lose' with GRANT OPTION; 
 
SET FOREIGN_KEY_CHECKS=0; 
#---------------------------- 
# Table structure for account 
#---------------------------- 
DROP TABLE IF EXISTS account; 
CREATE TABLE account ( 
  id int(11) NOT NULL auto_increment, 
  name text NOT NULL, 
  password text NOT NULL, 
  email text NOT NULL, 
  admin int(1) NOT NULL default '0', 
  online int(11) NOT NULL default '0', 
  PRIMARY KEY  (id) 
) TYPE=MyISAM; 
 
#---------------------------- 
# Table structure for characters 
#---------------------------- 
DROP TABLE IF EXISTS characters; 
CREATE TABLE characters ( 
  id int(11) NOT NULL auto_increment, 
  accountid text NOT NULL, 
  name text NOT NULL, 
  clanname text NOT NULL, 
  class int(11) NOT NULL default '0', 
  gender int(11) NOT NULL default '0', 
  lawful int(11) NOT NULL default '0', 
  hp int(11) NOT NULL default '0', 
  maxhp int(11) NOT NULL default '0', 
  mp int(11) NOT NULL default '0', 
  maxmp int(11) NOT NULL default '0', 
  level int(11) NOT NULL default '0', 
  armor int(11) NOT NULL default '0', 
  str int(11) NOT NULL default '0', 
  dex int(11) NOT NULL default '0', 
  con int(11) NOT NULL default '0', 
  wis int(11) NOT NULL default '0', 
  cha int(11) NOT NULL default '0', 
  intel int(11) NOT NULL default '0', 
  locx int(11) NOT NULL default '0', 
  locy int(11) NOT NULL default '0', 
  exp int(11) NOT NULL default '0', 
  nutrition int(11) NOT NULL default '0', 
  weight int(11) NOT NULL default '0', 
  fireres int(11) NOT NULL default '0', 
  windres int(11) NOT NULL default '0', 
  airres int(11) NOT NULL default '0', 
  earthres int(11) NOT NULL default '0', 
  isgm int(11) NOT NULL default '0', 
  charclasslistid int(11) NOT NULL default '0', 
  mapid int(11) NOT NULL default '0', 
  heading int(11) NOT NULL default '0', 
  title text NOT NULL, 
  PRIMARY KEY  (id) 
) TYPE=MyISAM; 
 
#---------------------------- 
# Table structure for serversettings 
#---------------------------- 
DROP TABLE IF EXISTS serversettings; 
CREATE TABLE serversettings ( 
  id int(11) NOT NULL auto_increment, 
  servertime double(50,0) NOT NULL default '0', 
  clienttime double(50,0) NOT NULL default '0', 
  idsused double NOT NULL default '0', 
  setting int(1) NOT NULL default '0', 
  PRIMARY KEY  (id) 
) TYPE=MyISAM; 
#---------------------------- 
# Records for table serversettings 
#---------------------------- 
insert  into serversettings values  
(1, 0, 0, 10000, 0);