 |
|
Member
|
10-19-2013
, 10:57
Re: SuperHero MySQL save
|
#5
|
Quote:
#----------------------------------------------------
# Start: Create the tables
#----------------------------------------------------
CREATE TABLE IF NOT EXISTS `sh_savexp` (
`SH_KEY` varchar(32) binary NOT NULL default '',
`PLAYER_NAME` varchar(32) binary NOT NULL default '',
`LAST_PLAY_DATE` timestamp(30) NOT NULL,
`XP` int(10) NOT NULL default '0',
`HUDHELP` tinyint(3) unsigned NOT NULL default '1',
`SKILL_COUNT` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`SH_KEY`)
) TYPE=MyISAM COMMENT='SUPERHERO XP Saving Table';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON `sh_savexp` TO np67233_xp;
CREATE TABLE IF NOT EXISTS `sh_saveskills` (
`SH_KEY` varchar(32) binary NOT NULL default '',
`SKILL_NUMBER` tinyint(3) unsigned NOT NULL default '0',
`HERO_NAME` varchar(25) NOT NULL default '',
PRIMARY KEY (`SH_KEY`,`SKILL_NUMBER`)
) TYPE=MyISAM COMMENT='SUPERHERO Skill Saving Table';
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON `sh_saveskills` TO np67233_xp;
FLUSH PRIVILEGES;
#----------------------------------------------------
# Stop
#----------------------------------------------------
|
Who can fix that? My database:
sh_mysql_host "localhost"
sh_mysql_user "np67233_xp"
sh_mysql_pass "Bans123"
sh_mysql_db "np67233_xp"
sh_mysql_persistent 0
|
|
|
|