test123.sql

武侠世界Flash版

create database if not exists `test123`;

USE `test123`;



DROP TABLE IF EXISTS `bags`;

CREATE TABLE `bags` (
  `GLOBAL_BAGITEM_ID` int(11) NOT NULL auto_increment,
  `USER_CHARACTER_ID` int(11) NOT NULL default '-1',
  `USER_ITEM_ID` int(11) NOT NULL default '-1',
  `ITEM_POSITION` int(11) NOT NULL default '-1',
  `ITEM_COUNTS` int(11) NOT NULL default '-1',
  `GLOBAL_ID` int(11) NOT NULL default '0',
  PRIMARY KEY  (`GLOBAL_BAGITEM_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `caijiinfos`;

CREATE TABLE `caijiinfos` (
  `GLOBAL_CAIJIDIAN_ID` int(11) NOT NULL auto_increment,
  `CAIJIDIAN_ID` int(11) NOT NULL default '-1',
  `CAIJIDIAN_NAME` varchar(32) NOT NULL default '',
  `CAIJIDIAN_TYPE` int(4) NOT NULL default '-1',
  `CAIJIDIAN_FLAG` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM1` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM2` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM3` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM4` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM5` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM6` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM7` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM8` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM9` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM10` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM11` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM12` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM13` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM14` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM15` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM16` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM17` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM18` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM19` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ITEM20` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS1` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS2` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS3` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS4` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS5` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS6` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS7` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS8` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS9` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS10` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS11` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS12` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS13` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS14` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS15` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS16` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS17` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS18` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS19` int(11) NOT NULL default '-1',
  `CAIJIDIAN_ODDS20` int(11) NOT NULL default '-1',
  PRIMARY KEY  (`GLOBAL_CAIJIDIAN_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


insert into `caijiinfos` values 
(1,100102,'乡间小路鱼塘2',0,25,1222003,1222007,1222006,1222019,1111001,1111001,1111001,1111001,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211004,1211005,1222104,1222204,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(2,100201,'扬州城东大街鱼塘1',0,25,1222003,1222010,1222013,1222018,1111001,1111001,1111001,1111001,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211000,1211001,1222104,1222204,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(3,100202,'扬州城东大街鱼塘2',0,25,1222003,1222013,1222010,1222018,1111001,1111001,1111001,1111001,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211002,1211003,1222104,1222204,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(4,100301,'扬州城广场鱼塘1',0,25,1222003,1222015,1222016,1222018,1111001,1111001,1111001,1111001,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211004,1211005,1222104,1222204,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(5,100302,'扬州城广场鱼塘2',0,25,1222003,1222016,1222015,1222018,1111001,1111001,1111001,1111001,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211000,1211001,1222104,1222204,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(6,100501,'青柯坪鱼塘1',0,25,1222001,1222014,1222012,1222021,1111102,1111102,1111002,1111002,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211008,1211009,1222105,1222205,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(7,100502,'青柯坪鱼塘2',0,25,1222001,1222012,1222014,1222021,1111102,1111102,1111002,1111002,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211010,1211011,1222106,1222206,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(8,100503,'青柯坪鱼塘2',0,25,1222001,1222012,1222014,1222021,1111102,1111102,1111002,1111002,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211012,1211013,1222106,1222206,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(9,100701,'星宿海鱼塘1',0,25,1222002,1222017,1222011,1222020,1111102,1111102,1111002,1111002,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211014,1211015,1222107,1222207,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(10,100702,'星宿海鱼塘2',0,25,1222002,1222011,1222017,1222020,1111102,1111102,1111002,1111002,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211016,1211017,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(11,100703,'星宿海鱼塘2',0,25,1222002,1222011,1222017,1222020,1111102,1111102,1111002,1111002,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211018,1211019,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(12,100901,'翠竹林鱼塘1',0,25,1222002,1222008,1222009,1222020,1111102,1111102,1111002,1111002,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211020,1211021,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(13,100902,'翠竹林鱼塘2',0,25,1222002,1222009,1222008,1222020,1111102,1111102,1111002,1111002,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211022,1211023,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(14,100903,'翠竹林鱼塘2',0,25,1222002,1222009,1222008,1222020,1111102,1111102,1111002,1111002,1111101,1111101,1111101,1111101,1111101,1111101,1201000,1201003,1211006,1211007,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(15,1100001,'龙门村矿点1',1,25,1222200,1222241,1222202,1222235,1121001,1120002,1121001,1120002,1121001,1120002,1121101,1120102,1121101,1120102,1201000,1201003,1211000,1211001,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(16,1100002,'龙门村矿点2',1,25,1222200,1222202,1222241,1222235,1121001,1120002,1121001,1120002,1121001,1120002,1121101,1120102,1121101,1120102,1201000,1201003,1211002,1211003,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(17,1100101,'乡间小路矿点1',1,25,1222200,1222207,1222206,1222236,1121001,1120002,1121001,1120002,1121001,1120002,1121101,1120102,1121101,1120102,1201000,1201003,1211002,1211003,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(18,1100102,'乡间小路矿点2',1,25,1222200,1222206,1222207,1222236,1121001,1120002,1121001,1120002,1121001,1120002,1121101,1120102,1121101,1120102,1201000,1201003,1211004,1211005,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(19,1200103,'乡间小路矿点3',1,25,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2),
(20,1100501,'青柯坪矿点1',1,25,1222200,1222209,1222210,1222237,1121001,1120002,1121001,1120002,1121003,1120004,1121003,1120004,1121103,1120104,1201000,1201003,1211008,1211009,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(21,1100502,'青柯坪矿点2',1,25,1222200,1222210,1222209,1222238,1121001,1120002,1121001,1120002,1121003,1120004,1121003,1120004,1121103,1120104,1201000,1201003,1211010,1211011,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(22,1200503,'青柯坪矿点3',1,25,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,1800,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2),
(23,1100701,'星宿海矿点1',1,25,1222200,1222213,1222214,1222239,1121001,1120002,1121001,1120002,1121003,1120004,1121003,1120004,1121103,1120104,1201000,1201003,1211014,1211015,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),