01/07/03 06:53am  
Status: offline

Esteban

Forum User
Newbie
Registered: 07/22/02
Posts: 11
Someone go and look at www.ultramonkey.co.uk and tell me how to fix the problem. I have dropped the gl_sessions table as it was corrupt and now I dunno how to recreate it. It would be great if someone could post the SQL to regenerate it. Thanks in advance.
 01/07/03 09:13am  
Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073

It's all in sql/mysqltableanddata.php:

Text Formatted Code
CREATE TABLE gl_sessions (
  sess_id int(10) unsigned NOT NULL default '0',      
  start_time int(10) unsigned NOT NULL default '0',
  remote_ip varchar(15) NOT NULL default '',
  uid mediumint(8) NOT NULL default '1',
  md5_sess_id varchar(128) default NULL,
  PRIMARY KEY  (sess_id),
  KEY sess_id (sess_id),
  KEY start_time (start_time),          
  KEY remote_ip (remote_ip)
) TYPE=MyISAM

bye, Dirk