xSBDNX6t

1-- Adminer 4.2.2 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `buildings`;
9CREATE TABLE `buildings` (
10  `id` int(11) NOT NULL AUTO_INCREMENT,
11  `description` text COLLATE utf8_unicode_ci NOT NULL,
12  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
13  `address` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
14  `plan` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
15  PRIMARY KEY (`id`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
17
18INSERT INTO `buildings` (`id`, `description`, `name`, `address`, `plan`) VALUES
19(1,	'Building Plandfd',	'dfgdfgd',	'Addresssdfdsf',	'Plan 25sdf'),
20(2,	'sd',	'sf',	'sdfdddddgg',	'sdf'),
21(3,	'sd',	'sf',	'sdf',	'sdf'),
22(4,	'sd',	'sf',	'sdfdssdf',	'sdf'),
23(5,	'Macho man',	'Bahadur Builders',	'Ranip',	'2 storey');
24
25-- 2016-11-07 11:13:04