· 8 years ago · Feb 05, 2018, 02:16 PM
1-- phpMyAdmin SQL Dump
2-- version 4.2.12deb2+deb8u2
3-- http://www.phpmyadmin.net
4--
5-- Host: 10.3.70.233
6-- Generation Time: Feb 05, 2018 at 02:50 PM
7-- Server version: 5.5.57-0+deb8u1-log
8-- PHP Version: 5.6.30-0+deb8u1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `maldo`
15--
16
17-- --------------------------------------------------------
18
19--
20-- Table structure for table `integration_service_history`
21--
22
23CREATE TABLE IF NOT EXISTS `integration_service_history` (
24`integration_service_history_id` int(11) NOT NULL,
25 `integration_id` int(11) NOT NULL,
26 `service_code` int(11) NOT NULL,
27 `date_added` datetime NOT NULL,
28 `user_type` varchar(20) CHARACTER SET utf8 NOT NULL,
29 `user_id` int(11) NOT NULL,
30 `user_name` varchar(100) CHARACTER SET utf8 NOT NULL,
31 `action` text CHARACTER SET utf8 NOT NULL
32) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
33
34--
35-- Indexes for dumped tables
36--
37
38--
39-- Indexes for table `integration_service_history`
40--
41ALTER TABLE `integration_service_history`
42 ADD PRIMARY KEY (`integration_service_history_id`);
43
44--
45-- AUTO_INCREMENT for dumped tables
46--
47
48--
49-- AUTO_INCREMENT for table `integration_service_history`
50--
51ALTER TABLE `integration_service_history`
52MODIFY `integration_service_history_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=37;