HmcGjrr9

1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 21, 2016 at 05:00 PM
7-- Server version: 5.5.52-0ubuntu0.14.04.1
8-- PHP Version: 5.5.9-1ubuntu4.20
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `www.hellmanfriedman.dev`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `role`
27--
28
29CREATE TABLE IF NOT EXISTS `role` (
30  `rid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key: Unique role ID.',
31  `name` varchar(64) NOT NULL DEFAULT '' COMMENT 'Unique role name.',
32  `weight` int(11) NOT NULL DEFAULT '0' COMMENT 'The weight of this role in listings and the user interface.',
33  PRIMARY KEY (`rid`),
34  UNIQUE KEY `name` (`name`),
35  KEY `name_weight` (`name`,`weight`)
36) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COMMENT='Stores user roles.' AUTO_INCREMENT=5 ;
37
38-- --------------------------------------------------------
39
40--
41-- Table structure for table `role_permission`
42--
43
44CREATE TABLE IF NOT EXISTS `role_permission` (
45  `rid` int(10) unsigned NOT NULL COMMENT 'Foreign Key: role.rid.',
46  `permission` varchar(128) NOT NULL DEFAULT '' COMMENT 'A single permission granted to the role identified by rid.',
47  `module` varchar(255) NOT NULL DEFAULT '' COMMENT 'The module declaring the permission.',
48  PRIMARY KEY (`rid`,`permission`),
49  KEY `permission` (`permission`)
50) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores the permissions assigned to user roles.';
51
52-- --------------------------------------------------------
53
54--
55-- Table structure for table `users`
56--
57
58CREATE TABLE IF NOT EXISTS `users` (
59  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Primary Key: Unique user ID.',
60  `name` varchar(60) NOT NULL DEFAULT '' COMMENT 'Unique user name.',
61  `pass` varchar(128) NOT NULL DEFAULT '' COMMENT 'User’s password (hashed).',
62  `mail` varchar(254) DEFAULT '' COMMENT 'User’s e-mail address.',
63  `theme` varchar(255) NOT NULL DEFAULT '' COMMENT 'User’s default theme.',
64  `signature` varchar(255) NOT NULL DEFAULT '' COMMENT 'User’s signature.',
65  `signature_format` varchar(255) DEFAULT NULL COMMENT 'The filter_format.format of the signature.',
66  `created` int(11) NOT NULL DEFAULT '0' COMMENT 'Timestamp for when user was created.',
67  `access` int(11) NOT NULL DEFAULT '0' COMMENT 'Timestamp for previous time user accessed the site.',
68  `login` int(11) NOT NULL DEFAULT '0' COMMENT 'Timestamp for user’s last login.',
69  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Whether the user is active(1) or blocked(0).',
70  `timezone` varchar(32) DEFAULT NULL COMMENT 'User’s time zone.',
71  `language` varchar(12) NOT NULL DEFAULT '' COMMENT 'User’s default language.',
72  `picture` int(11) NOT NULL DEFAULT '0' COMMENT 'Foreign key: file_managed.fid of user’s picture.',
73  `init` varchar(254) DEFAULT '' COMMENT 'E-mail address used for initial account creation.',
74  `data` longblob COMMENT 'A serialized array of name value pairs that are related to the user. Any form values posted during user edit are stored and are loaded into the $user object during user_load(). Use of this field is discouraged and it will likely disappear in a future...',
75  `uuid` char(36) NOT NULL DEFAULT '' COMMENT 'The Universally Unique Identifier.',
76  PRIMARY KEY (`uid`),
77  UNIQUE KEY `name` (`name`),
78  KEY `access` (`access`),
79  KEY `created` (`created`),
80  KEY `mail` (`mail`),
81  KEY `picture` (`picture`),
82  KEY `uuid` (`uuid`)
83) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Stores user data.';
84
85-- --------------------------------------------------------
86
87--
88-- Table structure for table `users_roles`
89--
90
91CREATE TABLE IF NOT EXISTS `users_roles` (
92  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Primary Key: users.uid for user.',
93  `rid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Primary Key: role.rid for role.',
94  PRIMARY KEY (`uid`,`rid`),
95  KEY `rid` (`rid`)
96) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Maps users to roles.';
97
98/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
99/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
100/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;