hi, i have too much problems creating a db for superhero mod, anyone can help me ?
PHP Code:
#1426 - Too-big precision 14 specified for 'LAST_PLAY_DATE'. Maximum is 6.
PHP Code:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM COMMENT='SUPERHERO XP Saving Table'' at line 9
PHP Code:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `sh_saveskills` (
`SH_KEY` varchar(32) binary NOT N' at line 12
PHP Code:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `sh_saveskills` (
`SKILL_NUMBER` tinyint(3) unsigne' at line 12
PHP Code:
# Created by...: Kevin [email protected]
# Description..: SuperHeroMod MySQL Install Script
# Orig Date....: 08/01/03
# Modified Date: 08/11/08
#
# Reference: Linux: See MySQL_README_LINUX - SECTION 2.0
# Windows: See MySQL_README_WINDOWS - SECTION 2.0
#
# Start: Create the database
/*CREATE DATABASE IF NOT EXISTS SHeroDB;
USE SHeroDB;
GRANT SELECT ON `SHeroDB`.* TO SuperHeroModUser@localhost;
*/
#----------------------------------------------------
# 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(14) 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 SuperHeroModUser@localhost;
*/
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 SuperHeroModUser@localhost;
FLUSH PRIVILEGES;
*/
#----------------------------------------------------
# Stop
#----------------------------------------------------