# phpMyAdmin SQL Dump
# version 2.5.4
# http://www.phpmyadmin.net
#
# : localhost
# : 2004  08  23  11:49
# 汾: 4.0.16
# PHP 汾: 4.3.4
# 
# ݿ : `game`
# 

# --------------------------------------------------------

#
# Ľṹ `game_announcement`
#

CREATE TABLE `game_announcement` (
  `aID` int(10) unsigned NOT NULL auto_increment,
  `aTitle` varchar(255) NOT NULL default '',
  `aContent` text NOT NULL,
  `aDate` int(10) unsigned NOT NULL default '0',
  `aUsername` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`aID`),
  KEY `aID` (`aID`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;

#
# е `game_announcement`
#

INSERT INTO `game_announcement` VALUES (2, 'վʵ:йվվ', 'վʵ:йվվ<BR>\r\nַ:http://www.com818.com/down<BR><BR><!--LAST--><i>༭tomkin</i>', 1073210819, '123');
INSERT INTO `game_announcement` VALUES (5, 'վ:cnmzc.com', 'cnmzc.com<BR>\r\ncom818.com  <BR>\r\n51efu.com<BR>\r\n1efu.comΪʱص<BR><BR><!--LAST--><i>༭tomkin</i>', 1077852723, '123');
INSERT INTO `game_announcement` VALUES (7, 'λйվվ!!!                                վͶָ!!!             վķչû֧!!!!!!', ',ҵ,ǵ', 1092992349, '123');

# --------------------------------------------------------

#
# Ľṹ `game_badlink`
#

CREATE TABLE `game_badlink` (
  `badID` int(10) unsigned NOT NULL auto_increment,
  `softID` int(10) unsigned NOT NULL default '0',
  `note` text NOT NULL,
  PRIMARY KEY  (`badID`),
  KEY `badID` (`badID`),
  KEY `softID` (`softID`)
) TYPE=MyISAM AUTO_INCREMENT=2 ;

#
# е `game_badlink`
#


# --------------------------------------------------------

#
# Ľṹ `game_bannedip`
#

CREATE TABLE `game_bannedip` (
  `bannedID` int(10) unsigned NOT NULL auto_increment,
  `bannedIP` varchar(15) NOT NULL default '',
  `bannedReason` text NOT NULL,
  PRIMARY KEY  (`bannedID`),
  KEY `bannedID` (`bannedID`),
  KEY `bannedIP` (`bannedIP`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# е `game_bannedip`
#


# --------------------------------------------------------

#
# Ľṹ `game_category`
#

CREATE TABLE `game_category` (
  `category_id` int(10) NOT NULL auto_increment,
  `category_name` varchar(20) NOT NULL default '',
  `category_total` int(10) NOT NULL default '0',
  PRIMARY KEY  (`category_id`),
  KEY `category_id` (`category_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# е `game_category`
#


# --------------------------------------------------------

#
# Ľṹ `game_class`
#

CREATE TABLE `game_class` (
  `class_id` int(10) NOT NULL auto_increment,
  `class_category_id` int(10) NOT NULL default '0',
  `class_name` varchar(20) NOT NULL default '',
  `class_total` int(10) NOT NULL default '0',
  PRIMARY KEY  (`class_id`),
  KEY `class_id` (`class_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# е `game_class`
#


# --------------------------------------------------------

#
# Ľṹ `game_online`
#

CREATE TABLE `game_online` (
  `cookieID` varchar(32) NOT NULL default '',
  `userName` varchar(50) NOT NULL default '',
  `userAgent` varchar(255) NOT NULL default '',
  `lastIP` varchar(15) NOT NULL default '',
  `lastTime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cookieID`)
) TYPE=MyISAM;

#
# е `game_online`
#


# --------------------------------------------------------

#
# Ľṹ `game_review`
#

CREATE TABLE `game_review` (
  `reviewID` int(10) unsigned NOT NULL auto_increment,
  `reviewTitle` varchar(255) NOT NULL default '',
  `reviewIP` varchar(20) NOT NULL default '',
  `softID` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`reviewID`),
  KEY `reviewID` (`reviewID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# е `game_review`
#


# --------------------------------------------------------

#
# Ľṹ `game_soft`
#

CREATE TABLE `game_soft` (
  `soft_id` int(10) NOT NULL auto_increment,
  `soft_name` varchar(255) NOT NULL default '',
  `soft_class_id` int(10) NOT NULL default '0',
  `soft_category_id` int(10) NOT NULL default '0',
  `soft_user_id` int(10) NOT NULL default '0',
  `soft_type` varchar(10) NOT NULL default '',
  `soft_system` varchar(255) NOT NULL default '',
  `soft_download_url` text NOT NULL,
  `soft_note` text NOT NULL,
  `soft_img` varchar(200) NOT NULL default '',
  `soft_date` varchar(14) NOT NULL default '',
  `soft_grade` tinyint(1) NOT NULL default '0',
  `soft_size` varchar(15) NOT NULL default '',
  `soft_hits_today` int(10) NOT NULL default '0',
  `soft_hits_week` int(10) NOT NULL default '0',
  `soft_hits_total` int(10) NOT NULL default '0',
  `soft_poll_times` int(10) NOT NULL default '0',
  `soft_poll_mark` float(10,2) NOT NULL default '0.00',
  `soft_author` varchar(15) NOT NULL default '',
  `soft_relation_url` varchar(50) NOT NULL default '',
  `soft_show_url` text NOT NULL,
  `soft_chinese` text NOT NULL,
  `soft_crack` text NOT NULL,
  `soft_is_commend` tinyint(1) NOT NULL default '0',
  `soft_hits_day` int(8) NOT NULL default '0',
  `soft_display` tinyint(1) NOT NULL default '0',
  `soft_byuser` varchar(50) NOT NULL default 'iZz Studio',
  `soft_keyword` varchar(50) binary NOT NULL default '',
  PRIMARY KEY  (`soft_id`),
  KEY `soft_id` (`soft_id`),
  KEY `soft_class_id` (`soft_class_id`),
  KEY `soft_category_id` (`soft_category_id`),
  KEY `soft_user_id` (`soft_user_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

#
# е `game_soft`
#


# --------------------------------------------------------

#
# Ľṹ `game_user`
#

CREATE TABLE `game_user` (
  `id` tinyint(5) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `password` varchar(20) NOT NULL default '',
  `groupid` tinyint(2) NOT NULL default '1',
  `userEmail` varchar(100) NOT NULL default '',
  `addCount` int(10) unsigned NOT NULL default '0',
  KEY `id` (`id`),
  KEY `id_2` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=18 ;

#
# е `game_user`
#

INSERT INTO `game_user` VALUES (16, 'admin', 'admin', 1, 'info@com818.com', 60);
INSERT INTO `game_user` VALUES (17, '123', '123', 1, 'admin@cnmzc.com', 0);

# --------------------------------------------------------

#
# Ľṹ `game_usergroup`
#

CREATE TABLE `game_usergroup` (
  `groupID` int(10) unsigned NOT NULL auto_increment,
  `groupName` varchar(255) NOT NULL default '',
  `canAdd` tinyint(1) NOT NULL default '0',
  `canEdit` tinyint(1) NOT NULL default '0',
  `canDelete` tinyint(1) NOT NULL default '0',
  `canMCC` tinyint(1) NOT NULL default '0',
  `canSeting` tinyint(1) NOT NULL default '0',
  `canAnnounce` tinyint(1) NOT NULL default '0',
  `canUser` tinyint(1) NOT NULL default '0',
  `canDatabase` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`groupID`),
  KEY `groupID` (`groupID`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

#
# е `game_usergroup`
#

INSERT INTO `game_usergroup` VALUES (1, 'Administrator', 1, 1, 1, 1, 1, 1, 1, 1);
INSERT INTO `game_usergroup` VALUES (2, 'Ա', 1, 1, 1, 1, 0, 1, 0, 0);
