xGTUNGEf

1-- --------------------------------------------------------
2-- Host:                         10.60.180.29
3-- Server version:               5.6.36-82.1 - Percona Server (GPL), Release 82.1, Revision 1a00d79
4-- Server OS:                    Linux
5-- HeidiSQL Version:             10.2.0.5599
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for smot
16CREATE DATABASE IF NOT EXISTS `smot` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `smot`;
18
19-- Dumping structure for table smot.services
20CREATE TABLE IF NOT EXISTS `services` (
21  `id` int(11) NOT NULL AUTO_INCREMENT,
22  `name` varchar(255) DEFAULT NULL,
23  `description` text,
24  `classification` enum('top critical','critical','important') DEFAULT NULL,
25  `manager_dev` varchar(50) DEFAULT NULL,
26  `manager_dev_position` varchar(50) DEFAULT NULL,
27  `manager_ops` varchar(50) DEFAULT NULL,
28  `dept_ops` varchar(50) DEFAULT NULL,
29  `cots` varchar(50) DEFAULT NULL,
30  `expenditure` varchar(50) DEFAULT NULL,
31  `capex_amount` double DEFAULT NULL,
32  `capex_year` date DEFAULT NULL,
33  `opex_amount` double DEFAULT NULL,
34  `opex_year` date DEFAULT NULL,
35  `commander_dev` int(11) DEFAULT NULL,
36  `opt_sla` varchar(50) DEFAULT NULL,
37  `ats_amount` double DEFAULT NULL,
38  `mng_service_amount` double DEFAULT NULL,
39  `maintenance_service_amount` double DEFAULT NULL,
40  `op_year` year(4) DEFAULT NULL,
41  `id_tenant` int(11) DEFAULT NULL,
42  `service_status` varchar(255) DEFAULT NULL,
43  `deleted` int(1) DEFAULT NULL,
44  `deleted_at` datetime DEFAULT NULL,
45  `created_by` int(11) DEFAULT NULL,
46  `created_at` datetime DEFAULT NULL,
47  `updated_at` datetime DEFAULT NULL,
48  `development_by` int(11) DEFAULT NULL,
49  `development_requested_at` datetime DEFAULT NULL,
50  `development_approved_by` int(11) DEFAULT NULL,
51  `development_approved_at` datetime DEFAULT NULL,
52  `development_note` varchar(255) DEFAULT NULL,
53  `deployment_by` int(11) DEFAULT NULL,
54  `deployment_requested_at` datetime DEFAULT NULL,
55  `deployment_approved_by` int(11) DEFAULT NULL,
56  `deployment_approved_at` datetime DEFAULT NULL,
57  `deployment_note` varchar(255) DEFAULT NULL,
58  `operated_by` int(11) DEFAULT NULL,
59  `operated_requested_at` datetime DEFAULT NULL,
60  `operated_approved_by` int(11) DEFAULT NULL,
61  `operated_approved_at` datetime DEFAULT NULL,
62  `operated_note` varchar(255) DEFAULT NULL,
63  `retirement_date` date DEFAULT NULL,
64  `retirement_by` int(11) DEFAULT NULL,
65  PRIMARY KEY (`id`) USING BTREE
66) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Status => 0.nothing 1. draft 2.reserved';
67
68-- Dumping data for table smot.services: ~0 rows (approximately)
69/*!40000 ALTER TABLE `services` DISABLE KEYS */;
70/*!40000 ALTER TABLE `services` ENABLE KEYS */;
71
72/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
73/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
74/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;