Parašė 123456788999999999· 2008 Gru. 20 03:12:04
#1
Sveiki Visi, turiu tokia problema yra Tokia Modifkacija Fantazy sport tačiau nesuprantu yra joje klaida kažkur įvelta su Sql Msql Kodais įsirašiau ją atlikau viska kaip reikia
CREATE TABLE fusion_fs_sports (
sport_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
sport_name VARCHAR(200) DEFAULT '' NOT NULL,
sport_icon VARCHAR(200) DEFAULT '' NOT NULL,
PRIMARY KEY (sport_id)
) TYPE=MyISAM;
CREATE TABLE fusion_fs_teams (
team_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
team_sport TINYINT(5) DEFAULT '' NOT NULL,
team_name VARCHAR(200) DEFAULT '' NOT NULL,
PRIMARY KEY (team_id)
) TYPE=MyISAM;
CREATE TABLE fusion_fs_games (
game_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
game_sport TINYINT(5) DEFAULT '' NOT NULL,
game_home TINYINT(5) DEFAULT '' NOT NULL,
game_guest TINYINT(5) DEFAULT '' NOT NULL,
game_winner TINYINT(5) DEFAULT '' NOT NULL,
game_time VARCHAR(200) DEFAULT '' NOT NULL,
PRIMARY KEY (game_id)
) TYPE=MyISAM;
CREATE TABLE fusion_fs_bets (
bet_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
bet_sport TINYINT(5) DEFAULT '' NOT NULL,
bet_game TINYINT(5) DEFAULT '' NOT NULL,
bet_user TINYINT(5) DEFAULT '' NOT NULL,
bet_bet TINYINT(5) DEFAULT '' NOT NULL,
PRIMARY KEY (bet_id)
) TYPE=MyISAM;
CREATE TABLE fusion_fs_jackpot (
jackpot_id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,
jackpot_game TINYINT(5) DEFAULT '' NOT NULL,
jackpot_jackpot TINYINT(5) DEFAULT '' NOT NULL,
PRIMARY KEY (jackpot_id)
) TYPE=MyISAM;
Čia msql kodai o tačiau kaip einu pridėti rungtynių man rašo šita :(
Table 'eurolyga.fusion_fs_teams' doesn't exist
There are no teams in the database.
Table 'eurolyga.fusion_fs_games' doesn't exist
There are no games in the database.
Ar galite kas padedi atsilyginsiu:s
Parašė MAnjack· 2008 Gru. 20 10:12:27
#2
Abėjoju ar atliki sukūrimą :D Nes rodo, akd nėra.