Skip to content

ilyafanat/Users

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

27 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Users

Создать бд 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;

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages