· 4 years ago · Jan 12, 2021, 03:28 PM
1
2SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
3SET time_zone = "+00:00";
4
5
6
7CREATE TABLE IF NOT EXISTS `users_id` (
8`Id` int(18) NOT NULL,
9 `first_name` varchar(55) NOT NULL,
10 `first_name_o` varchar(55) NOT NULL,
11 `first_name_1` varchar(55) NOT NULL,
12 `last_name` varchar(55) NOT NULL,
13 `last_name_m` varchar(55) NOT NULL,
14 `city_name` varchar(55) NOT NULL,
15 `email` varchar(50) NOT NULL
16) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
17
18
19ALTER TABLE `users_id`
20 ADD PRIMARY KEY (`Id`);
21
22
23ALTER TABLE `users_id`
24MODIFY `Id` int(18) NOT NULL AUTO_INCREMENT;
25