--
-- Table structure for table `social_access`
--

CREATE TABLE IF NOT EXISTS `social_access` (
  `id` CHAR(36) NOT NULL,
  `accessor_id` CHAR(36) NOT NULL,
  `accessor_model` VARCHAR(128) NOT NULL,
  `object_id` CHAR(36) NOT NULL,
  `object_model` VARCHAR(128) NOT NULL,
  `denied` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `social_access`
--

INSERT INTO `social_access` (`id`, `accessor_id`, `accessor_model`, `object_id`, `object_model`, `denied`) VALUES
('golum-access-1', 'golum-list-1', 'SocialList', 'golum-object-1', 'SocialObject', 0),
('golum-access-2', 'burzum', 'User', 'golum-object-1', 'SocialObject', 0),
('bbe6d1be-b368-11e4-ba02-ac220bc9d83b', 'golum-list-4', 'SocialList', 'golum-object-1', 'SocialObject', 1),
('ed0266ba-b367-11e4-ba02-ac220bc9d83b', 'user3', 'User', 'golum-list-1', 'SocialObject', 1);

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

--
-- Table structure for table `social_lists`
--

CREATE TABLE IF NOT EXISTS `social_lists` (
  `id` CHAR(36) NOT NULL,
  `user_id` CHAR(36) NOT NULL,
  `name` VARCHAR(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `social_lists`
--

INSERT INTO `social_lists` (`id`, `user_id`, `name`) VALUES
('golum-list-1', 'golum', 'golums list 1'),
('golum-list-2', 'golum', 'golums list 2'),
('burzum-list-1', 'burzum', 'burzums list 1');

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

--
-- Table structure for table `social_lists_users`
--

CREATE TABLE IF NOT EXISTS `social_lists_users` (
  `id` CHAR(36) NOT NULL,
  `user_id` CHAR(36) NOT NULL,
  `social_list_id` VARCHAR(36) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `social_lists_users`
--

INSERT INTO `social_lists_users` (`id`, `user_id`, `social_list_id`) VALUES
('7f1af70e-b368-11e4-ba02-ac220bc9d83b', 'user4', 'golum-list-2'),
('ebb5095e-b255-11e4-ba02-ac220bc9d83b', 'burzum', 'golum-list-1'),
('ebb5165c-b255-11e4-ba02-ac220bc9d83b', 'golum', 'burzum-list-1');

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

--
-- Table structure for table `social_objects`
--

CREATE TABLE IF NOT EXISTS `social_objects` (
  `id` CHAR(36) NOT NULL,
  `user_id` CHAR(36) NOT NULL,
  `foreign_key` CHAR(36) NOT NULL,
  `model` VARCHAR(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `social_objects`
--

INSERT INTO `social_objects` (`id`, `user_id`, `foreign_key`, `model`) VALUES
('golum-object-1', 'golum', 'test', 'test'),
('burzum-object-1', 'burzum', 'test', 'test');

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` CHAR(36) NOT NULL,
  `username` VARCHAR(64) NOT NULL,
  `email` VARCHAR(255) NOT NULL,
  `email_token` VARCHAR(64) DEFAULT NULL,
  `email_verified` tinyint(1) NOT NULL,
  `email_token_expires` datetime DEFAULT NULL,
  `active` tinyint(1) NOT NULL,
  `password` VARCHAR(64) NOT NULL,
  `password_token` VARCHAR(64) DEFAULT NULL,
  `password_token_expires` datetime DEFAULT NULL,
  `role` VARCHAR(32) DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `username`, `email`, `email_token`, `email_verified`, `email_token_expires`, `active`, `password`, `password_token`, `password_token_expires`, `role`, `last_login`, `created`, `modified`) VALUES
('golum', 'golum', 'golum@lotr.com', '', 1, '2014-11-02 23:20:03', 1, '', NULL, NULL, NULL, NULL, '2014-11-01 23:20:03', '2014-11-01 23:20:03'),
('burzum', 'burzum', 'burzum@lotr.com', '', 1, '2014-11-02 23:17:32', 1, '', NULL, NULL, NULL, NULL, '2014-11-01 23:17:32', '2014-11-01 23:17:32'),
('user3', 'user3', 'user3@user3.com', NULL, 1, NULL, 1, '', NULL, NULL, NULL, NULL, '2015-02-13 00:00:00', '2015-02-13 00:00:00'),
('user4', 'user4', 'user4@user4.com\r\n\r\n', NULL, 1, NULL, 1, '', NULL, NULL, NULL, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `social_access`
--
ALTER TABLE `social_access`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `social_lists`
--
ALTER TABLE `social_lists`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `social_lists_users`
--
ALTER TABLE `social_lists_users`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `social_objects`
--
ALTER TABLE `social_objects`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
 ADD PRIMARY KEY (`id`), ADD KEY `username` (`username`,`email`);