UAC/uac.sql at master · clark21/UAC · GitHub

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
-- phpMyAdmin SQL Dump
-- version 3.4.8
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Feb 17, 2015 at 11:07 AM
-- Server version: 5.6.17
-- PHP Version: 5.6.2

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: `uac`
--

-- --------------------------------------------------------

--
-- Table structure for table `dev`
--

CREATE TABLE IF NOT EXISTS `dev` (
  `dev_id` int(11) NOT NULL AUTO_INCREMENT,
  `dev_user` int(11) NOT NULL,
  `dev_server` int(11) NOT NULL,
  `dev_status` int(11) NOT NULL DEFAULT '1',
  `dev_role` varchar(255) NOT NULL,
  `dev_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`dev_id`),
  KEY `dev_user` (`dev_user`,`dev_server`,`dev_status`,`dev_role`,`dev_created`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Table structure for table `server`
--

CREATE TABLE IF NOT EXISTS `server` (
  `server_id` int(11) NOT NULL AUTO_INCREMENT,
  `server_name` varchar(255) NOT NULL,
  `server_root` varchar(255) NOT NULL DEFAULT 'root',
  `server_pass` varchar(255) NOT NULL,
  `server_ip` varchar(255) NOT NULL,
  `server_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`server_id`),
  KEY `server_name` (`server_name`,`server_root`,`server_pass`,`server_ip`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `server`
--

INSERT INTO `server` (`server_id`, `server_name`, `server_root`, `server_pass`, `server_ip`, `server_created`) VALUES
(2, 'Dummy', 'root', 'aD1FQ2N2MlVsaEdW', '192.155.82.69', '2015-02-05 17:21:57');

-- --------------------------------------------------------

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `user_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_email` varchar(255) NOT NULL,
  `user_name` varchar(255) NOT NULL,
  `user_first` varchar(255) NOT NULL,
  `user_last` varchar(255) NOT NULL,
  `user_pass` varchar(255) NOT NULL,
  `user_role` int(10) NOT NULL,
  `user_active` int(10) NOT NULL DEFAULT '0',
  `user_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_id`),
  KEY `user_email` (`user_email`,`user_name`,`user_pass`,`user_role`,`user_active`,`user_created`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`user_id`, `user_email`, `user_name`, `user_first`, `user_last`, `user_pass`, `user_role`, `user_active`, `user_created`) VALUES
(1, 'cgalgo@openovate.com', 'clark21', 'clark', 'galgo', 'aD1RM2NsR2R6Vkdk', 1, 1, '2015-01-23 11:53:36'),
(8, 'hackpswrd21@gmail.com', 'testing', 'test', 'test', '', 1, 0, '2015-02-05 15:51:35');

/*!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 */;