Answer the question
In order to leave comments, you need to log in
SQL query error?
To create tables in the database, the following query is generated in the database
CREATE TABLE IF NOT EXISTS `grtgh_message` (
`id_message` mediumint(9) NOT NULL AUTO_INCREMENT,
`time_message` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`title` varchar(128) DEFAULT NULL,
`phone` varchar(64) NOT NULL,
`email` varchar(64) DEFAULT NULL,
`send_name` varchar(64) DEFAULT NULL,
`text` varchar(600) DEFAULT NULL,
UNIQUE KEY `id_message` (`id_message`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `grtgh_texts` (
`id_message` mediumint(9) NOT NULL AUTO_INCREMENT,
`time_message` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`field_name` varchar(64) NOT NULL,
`field_text` longtext,
UNIQUE KEY `id_message` (`id_message`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `grtgh_users` (
`id` mediumint(9) NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`user_pass` varchar(64) NOT NULL,
`user_login` varchar(64) NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question