XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Q and A 
  4.  / Need SQL related help.
Register
1
shibby
Need SQL related help.

  • 2004/3/7 10:47

  • shibby

  • Just popping in

  • Posts: 25

  • Since: 2004/2/14


I deleted my xoops_session table, does anyone have the query to create it?

Thanks
2
Mithrandir
Re: Need SQL related help.

Found in root/install/sql/mysql.structure.sql:
#
# Table structure for table `session`
#

CREATE TABLE session (
  sess_id varchar(32) NOT NULL default '',
  sess_updated int(10) unsigned NOT NULL default '0',
  sess_ip varchar(15) NOT NULL default '',
  sess_data text NOT NULL,
  PRIMARY KEY  (sess_id),
  KEY updated (sess_updated)
) TYPE=MyISAM;


If you run the query manually, remember to add your database table prefix to session
3
shibby
Re: Need SQL related help.

  • 2004/3/7 11:27

  • shibby

  • Just popping in

  • Posts: 25

  • Since: 2004/2/14


You're a life saver.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

910 user(s) are online (292 user(s) are browsing Support Forums)

Members: 0

Guests: 910

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits