any one here has the sql for rpg game...
Sql for rpg game
Collapse
X
-
PHP Code:--
-- Table structure for table `ibwf_rpg`
--
CREATE TABLE IF NOT EXISTS `ibwf_rpg` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`bet` int(10) NOT NULL DEFAULT '0',
`byuid` int(10) NOT NULL DEFAULT '0',
`touid` int(10) NOT NULL DEFAULT '0',
`actime` int(10) NOT NULL DEFAULT '0',
`accept` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `ibwf_rpg`
--
-- --------------------------------------------------------
--
-- Table structure for table `ibwf_rpgame`
--
CREATE TABLE IF NOT EXISTS `ibwf_rpgame` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`bet` int(10) NOT NULL DEFAULT '0',
`uid` int(10) NOT NULL DEFAULT '0',
`who` int(10) NOT NULL DEFAULT '0',
`owner` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=73 ;
--
-- Dumping data for table `ibwf_rpgame`
--
Last edited by metulj; 09.08.10, 16:42.
-
Why are all INT datatype? Use tinyint,smallint,mediumint then use unsigned modifer. If it does not cover then use int.
Read this
MySQL :: MySQL 5.0 Reference Manual :: 10.2 Numeric Types
Comment
Comment