$inf_newtable[1] = ARTISTS." (
artist_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
artist_name VARCHAR(70) DEFAULT '' NOT NULL,
artist_bio TEXT DEFAULT '' NOT NULL,
artist_record_company VARCHAR(150) DEFAULT '' NOT NULL,
PRIMARY KEY (artist_id)
) TYPE=MyISAM;";
$inf_newtable[2] = ALBUMS." (
artist_id INT(11) DEFAULT '' NOT NULL,
album_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
album_name VARCHAR(70) DEFAULT '' NOT NULL,
album_tracks SMALLINT(5) NOT NULL,
PRIMARY KEY (album_id)
) TYPE=MyISAM;";
$inf_newtable[3] = PLAYLISTS." (
playlist_id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
user_id MEDIUMINT(8) DEFAULT '' NOT NULL,
playlist_name VARCHAR(70) DEFAULT '' NOT NULL,
playlist_date INT(10) DEFAULT '' NOT NULL,
playlist_modified INT(10) DEFAULT '' NOT NULL,
PRIMARY KEY (playlist_id)
) TYPE=MyISAM;";
$inf_newtable[4] = PLAYLISTS_ITEMS." (
playlist_id INT(11) DEFAULT '' NOT NULL,
track_id INT(11) DEFAULT '' NOT NULL
) TYPE=MyISAM;";
$inf_newtable[5] = TRACKS." (
track_id INT(11) DEFAULT '' NOT NULL AUTO_INCREMENT,
artist_id INT(11) DEFAULT '' NOT NULL,
track_name VARCHAR(70) DEFAULT '' NOT NULL,
track_url VARCHAR(150) DEFAULT '' NOT NULL,
PRIMARY KEY (track_id)
) TYPE=MyISAM;";
Quote
KasteR wrote:
If you're using MySQL 5.5.8, then you should change TYPE=MyISAM to ENGINE=MyISAM. Perhaps that may have something to do with it as well..
artist_id INT(11) DEFAULT '' NOT NULL,
artist_id INT(11) DEFAULT '0' NOT NULL,
Category Forum
Modifications and Requests - 8Labels
None yet
Statistics
5 participants
Notifications
You are not receiving notifications from this thread.
Related Questions