EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)
-   -   Rev 922 group_leaders error (https://www.eqemulator.org/forums/showthread.php?t=29242)

Xenerox 08-15-2009 09:35 PM

Rev 922 group_leaders error
 
hello i just made my db and everything works xcept the group leaders table is missing and when i try to execute it it wont work

Taurinus 08-15-2009 09:36 PM

Code:

CREATE TABLE `group_leaders` (
`gid` int(4) NOT NULL,
`leadername` varchar(64) NOT NULL,
PRIMARY KEY (`gid`)
)
ENGINE = InnoDB;


Xenerox 08-16-2009 04:46 PM

thanks man

Taurinus 08-16-2009 05:10 PM

Not a problem. The problem bugged me once, until I found an old KLS changelog via Google in which the table description appeared. Now I just keep a copy of group_leaders.sql on hand.

cavedude 08-18-2009 10:21 AM

That schema above is outdated. The current is:

Code:

-- ----------------------------
CREATE TABLE `group_leaders` (
  `gid` int(4) NOT NULL,
  `leadername` varchar(64) NOT NULL,
  `marknpc` VARCHAR( 64 ) NOT NULL DEFAULT '',
  `leadershipaa` TINYBLOB NOT NULL DEFAULT '',
  PRIMARY KEY  (`gid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Or, just use PEQ SVN.


All times are GMT -4. The time now is 02:33 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.