Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Can someone help meCreate new database table called visitors


santacruz04

Recommended Posts

Im not sure what it means by creat a new database table called visitors :::

 

1) Create new database table called visitors:

 

CREATE TABLE visitors (

browser_id int(5) NOT NULL auto_increment,

date datetime NOT NULL default '0000-00-00 00:00:00',

counter int(12) NOT NULL default '1',

browser_ip varchar(15) NOT NULL default '',

browser_language varchar(16) NOT NULL default '',

language varchar(16) NOT NULL default '',

referer varchar(96) NOT NULL default '',

uri varchar(96) NOT NULL default '',

PRIMARY KEY (browser_id)

) TYPE=MyISAM;

 

 

--------------------------------------------------------------

If you can help me please do.... Post to me how I make this database *P.M. me or respond to me, either way*

Link to comment
Share on other sites

What that will do is ...

 

When in phpMyAdmin ...

 

Go to your MySQL database and click on SQL ...

 

Paste that in the Box all by itself and click Go ...

 

That will now create a new table called visitor for whatever add-on you are working with.

 

That table with store various info based on whatever the add-on needs to run.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...