0L5EmEd3

1CREATE TABLE IF NOT EXISTS `table` (
2  `id`            INT UNSIGNED  NOT NULL AUTO_INCREMENT PRIMARY KEY,
3  `name`          TEXT      NOT NULL,
4  `description`   TEXT      NOT NULL,
5  `login`         TEXT      NOT NULL,
6  `password`      TEXT      NOT NULL,
7  `old_passwords` TEXT      NOT NULL,
8  `last_update`   TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
9  `created`       TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
10);
11	
12INSERT INTO `table` (name, description, login, password, old_passwords, last_update, created)
13VALUES ("name", "description", "login", "pass", "oldPasswords", CURRENT_TIMESTAMP, CURRENT_TIMESTAMP)
14ON DUPLICATE KEY UPDATE name = "n", description = "d", login = "l", password = "p", old_passwords = "oldp", last_update = CURRENT_TIMESTAMP;