Raised This Month: $42 Target: $400
 10% 

help, superhero mysql database


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Neon123
Senior Member
Join Date: Jan 2016
Old 03-23-2021 , 16:55   help, superhero mysql database
Reply With Quote #1

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_KEYvarchar(32binary 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_NUMBERtinyint(3unsigne' 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 [email protected];
*/

#----------------------------------------------------
# Start: Create the tables
#----------------------------------------------------

CREATE TABLE IF NOT EXISTS `sh_savexp` (
    `
SH_KEYvarchar(32binary NOT NULL default '',
    `
PLAYER_NAMEvarchar(32binary NOT NULL default '',
    `
LAST_PLAY_DATEtimestamp(14NOT NULL,
    `
XPint(10NOT NULL default '0',
    `
HUDHELPtinyint(3unsigned NOT NULL default '1',
    `
SKILL_COUNTtinyint(3unsigned 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 [email protected];
*/
CREATE TABLE IF NOT EXISTS `sh_saveskills` (
    `
SH_KEYvarchar(32binary NOT NULL default '',
    `
SKILL_NUMBERtinyint(3unsigned NOT NULL default '0',
    `
HERO_NAMEvarchar(25NOT 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 [email protected];

FLUSH PRIVILEGES;
*/
#----------------------------------------------------
# Stop
#---------------------------------------------------- 

Last edited by Neon123; 03-26-2021 at 17:15. Reason: solved
Neon123 is offline
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 20:24.


Powered by vBulletin®
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Theme made by Freecode