RdsGV4e8

1CREATE TABLE IF NOT EXISTS `users` (
2    `user_id` INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
3    `user_login` VARCHAR(20) NOT NULL,
4    `user_password` VARCHAR(64) NOT NULL,
5    `user_name` VARCHAR(50) NOT NULL,
6    `user_email` VARCHAR(50) NOT NULL,
7    `user_ip` INT UNSIGNED,
8    `user_group` int UNSIGNED,
9    `updated_at` TIMESTAMP NOT NULL DEFAULT NOW() ON UPDATE NOW(),
10    `created_at` TIMESTAMP NOT NULL DEFAULT NOW()
11) ENGINE=InnoDB DEFAULT CHARSET=utf8;
12
13INSERT INTO `users` VALUE (null,'Admin','1234','Sergey','admin@bmbf3.ru',INET_ATON('192.168.0.2'),2,null,null);
14
15UPDATE `users` SET `user_password`='4321' WHERE `user_id`=1;