Создать бд Users, в ней таблицу user
CREATE TABLE user
(
id
int(10) unsigned NOT NULL AUTO_INCREMENT,
login
varchar(40) COLLATE utf8_unicode_ci DEFAULT NULL,
password
char(60) COLLATE utf8_unicode_ci DEFAULT NULL,
email
varchar(254) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (id
),
KEY login
(login
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
CREATE TABLE time
(
id
int(10) NOT NULL AUTO_INCREMENT,
logged_at
datetime DEFAULT NULL,
id_user
int(10) unsigned NOT NULL DEFAULT '0',
ip
int(11) DEFAULT '0',
logouted_at
datetime DEFAULT NULL,
PRIMARY KEY (id
),
KEY fk_time_1_idx
(id_user
),
CONSTRAINT fk_time_1
FOREIGN KEY (id_user
) REFERENCES user
(id
) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=116 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;