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