whos_online table deleted. Need help creating new one.

[Veeps]

I have an error with my whos_online table. I tried to repair it and deleted it by accident. How do I create a new one?

[user99999999]

Go to phpMyAdmin sql box and paste the followin in then click go.

 

You can fine all the sql in the install dir of osc zip "oscommerce.sql"

 

DROP TABLE IF EXISTS whos_online;
CREATE TABLE whos_online (
 customer_id int,
 full_name varchar(64) NOT NULL,
 session_id varchar(128) NOT NULL,
 ip_address varchar(15) NOT NULL,
 time_entry varchar(14) NOT NULL,
 time_last_click varchar(14) NOT NULL,
 last_page_url varchar(64) NOT NULL
);

[Veeps]

awesome! Thanks for the quick response and help. My site is up and running again.