Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 06:10 am EDT

Geeklog Forums

broken MySQL table


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.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany

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

 Quote

All times are EDT. The time is now 06:10 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content