I thought if i drop/delet the tabels would be better
DROP TABLE `music_album` ,
`music_artist` ,
`music_cat` ,
`music_logo` ,
`music_news` ,
`music_setting` ,
`music_song` ;
- After i drop those tables i get these msg
Database error in vBulletin 3.6.8:
Invalid SQL:
CREATE TABLE IF NOT EXISTS music_album (
id int(10) NOT NULL auto_increment,
name varchar(200) NOT NULL default '',
artistid int(11) NOT NULL default '0',
info text NOT NULL default '',
image varchar(250) NOT NULL default '',
catid int(11) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
MySQL Error : Invalid default value for 'catid'
Error Number : 1067
Date : Tuesday, December 4th 2007 @ 12:49:27 PM
|