· 9 years ago · Oct 28, 2016, 01:36 PM
1DROP TABLE IF EXISTS users_online;
2CREATE TABLE users_online(
3 user_id int NOT NULL,
4 lastvisittime DATETIME NOT NULL,
5 PRIMARY KEY(user_id),
6 CONSTRAINT FOREIGN KEY(user_id) REFERENCES user_list(user_id) ON DELETE SET NULL
7
8);