i9CAwaiy

1SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
2SET time_zone = "+00:00";
3CREATE DATABASE IF NOT EXISTS `efcc` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
4USE `efcc`;
5
6CREATE TABLE `name_04_07_2018` (
7  `id` int(10) NOT NULL,
8  `oid` int(10) NOT NULL,
9  `appt` time NOT NULL,
10  `dob` varchar(25) NOT NULL,
11  `name` varchar(25) NOT NULL,
12  `phone` varchar(25) NOT NULL,
13  `status` varchar(25) NOT NULL
14) ENGINE=InnoDB DEFAULT CHARSET=latin1;
15
16
17ALTER TABLE `name_04_07_2018`
18  ADD PRIMARY KEY (`id`);
19
20
21ALTER TABLE `name_04_07_2018`
22  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;