-
Notifications
You must be signed in to change notification settings - Fork 22
Expand file tree
/
Copy pathiadmin.sql
More file actions
132 lines (109 loc) · 12.7 KB
/
iadmin.sql
File metadata and controls
132 lines (109 loc) · 12.7 KB
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
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
-- phpMyAdmin SQL Dump
-- version 4.0.10deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 26, 2016 at 06:06 PM
-- Server version: 5.5.49-0ubuntu0.14.04.1
-- PHP Version: 5.5.9-1ubuntu4.19
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `iadmin`
--
DROP DATABASE IF EXISTS iadmin;
CREATE DATABASE IF NOT EXISTS iadmin;
USE iadmin;
-- --------------------------------------------------------
--
-- Table structure for table `admin_log`
--
CREATE TABLE IF NOT EXISTS `admin_log` (
`id` tinyint(4) NOT NULL AUTO_INCREMENT,
`username` varchar(255) COLLATE latin1_general_ci NOT NULL,
`password` varchar(255) COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=2 COMMENT="This is a current users table. Will be removed in future";
--
-- Dumping data for table `admin_log`
--
INSERT INTO `admin_log` (`id`, `username`, `password`) VALUES
(1, 'admin', '21232f297a57a5a743894a0e4a801fc3');
-- --------------------------------------------------------
--
-- Table structure for table `MapData`
--
CREATE TABLE IF NOT EXISTS `MapData` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`description` text COLLATE utf8_unicode_ci NOT NULL,
`lattitude` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`longitude` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=34 COMMENT="This is a table with rich content";
--
-- Dumping data for table `MapData`
--
INSERT INTO `MapData` (`id`, `name`, `description`, `lattitude`, `longitude`) VALUES
(13, 'hyder', 'Birla Mandir<br>\nHill Fort Rd, Hyderabad, Telangana 500004<br>', '17.406287', '78.469095'),
(24, 'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(25,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(26,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(27,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(28,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(29,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(32,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(33,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(34,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(35,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(36,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(37,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(38,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(39,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(40,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(43,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(42,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(41,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(44,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(45,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(46,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(47,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(48,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(18,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(49,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(17,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(16,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(98,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(58,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(64,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(66,'hyderabad', '<img src="https://picsum.photos/800/300" height="70" width="140"><br><p class="text-warning text-capitalize">Hi Minion</p>Mobile<strong>88888</strong><br><div class="label label-primary">OPENS AT :7:50</div><div class="label label-success">CLOSED AT :9:59</div>', '17.454576', '78.384980'),
(19,'hyder', '<img src="https://random.imagecdn.app/800/350" width="140" height="70"><br><p class="text-warning text-capitalize">fghd</p>Mobile<strong>ddgh</strong><br><div class="label label-primary">OPENS AT :dfghdfh</div><div class="label label-success">CLOSED AT :dgh</div>', '17.450473', '78.380979');
-- --------------------------------------------------------
--
-- Table structure for table `test`
--
CREATE TABLE IF NOT EXISTS `test` (
`id` tinyint(4) NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE latin1_general_ci NOT NULL,
`address` text COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=14 COMMENT="This is a basic table";
--
-- Dumping data for table `test`
--
INSERT INTO `test` (`id`, `name`, `address`) VALUES
(2, 'your name goes here', 'address hurry'),
(3, 'its me my name', 'and here is my address. Is it works or ..........How it works??web test completed.'),
(7, 'hi1', 'hi1'),
(8, 'hi2', 'hi2'),
(9, 'hi3', 'hi3'),
(10, 'h6', 'h6'),
(11, 'hu7', 'hu7'),
(12, 'Minion ', 'here is text area which is auto generate');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;