Go Back   EQEmulator Home > EQEmulator Forums > Support > Support::Windows Servers
Reload this Page MYSQL help plz :D

Support::Windows Servers Support forum for Windows EQEMu users.

Reply
 
Thread Tools Display Modes
  #1  
Old 09-27-2007, 12:50 AM
Theeper
Discordant
  
Join Date: May 2004
Posts: 290
Default
NOT NULL and zero default is ok, the problem is that you haven't specified that it's columns you are adding. The syntax should be like this ..

ALTER TABLE items ADD COLUMN `id` int(11) NOT NULL DEFAULT 0, ADD COLUMN `minstatus` int (11) NOT NULL DEFAULT 0 ... etc
Reply With Quote
  #2  
Old 09-28-2007, 01:20 AM
daryl
Fire Beetle
  
Join Date: Jun 2005
Posts: 24
Thumbs up
thanks Theeper
had to change the '0', to just 0 lol but could only get one to work at a time took a while but its sorted now
thanks again man
now on to the rest of the db
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode

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 01:45 AM.

EQEmulator - Archive - Top

 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3