-
Notifications
You must be signed in to change notification settings - Fork 2
/
db_contact-latest.sql
47 lines (39 loc) · 1.89 KB
/
db_contact-latest.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
CREATE TABLE `tbl_contact` (
`Id` int(11) NOT NULL,
`fldName` varchar(50) NOT NULL,
`fldEmail` varchar(150) NOT NULL,
`fldPhone` varchar(15) NOT NULL,
`fldMessage` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `tbl_contact`
--
INSERT INTO `tbl_contact` (`Id`, `fldName`, `fldEmail`, `fldPhone`, `fldMessage`) VALUES
(1, 'John', '[email protected]', '9958576071', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. '),
(2, 'luwis', '[email protected]', '9958579075', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. '),
(3, 'martin', '[email protected]', '9958579075', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. '),
(4, 'andrew', '[email protected]', '9958579222', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. '),
(5, 'tonny', '[email protected]', '9958579223', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. '),
(6, 'ammy', '[email protected]', '9958579242', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. '),
(7, 'ammy jacson', '[email protected]', '9958589240', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. '),
(8, 'randy', '[email protected]', '99585792999', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. '),
(9, 'johnson', '[email protected]', '99585722222', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. '),
(10, 'johnsonandjohnson', '[email protected]', '99585722233', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. '),
(11, 'Mustafa Khan', '[email protected]', '99580799999', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit.');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `tbl_contact`
--
ALTER TABLE `tbl_contact`
ADD PRIMARY KEY (`Id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `tbl_contact`
--
ALTER TABLE `tbl_contact`
MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
COMMIT;