Просмотр архива CIFullCalendar v3

-- CIFullCalendar v3 SQL Dump
-- version 3.1.8.0
--
http://www.cifullcalendar.com/v3
--
-- Host: localhost
-- Generation Time:
Apr 02, 2016 at 04:27 AM
-- Server version: 5.6.26
-- PHP Version:
5.6.12

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

--
-- Database: `apps_cifullcalendar`
--

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

--
-- Table
structure for table `ic_captcha`
--

CREATE TABLE IF NOT EXISTS
`ic_captcha` (
  `captcha_id` bigint(13) unsigned NOT NULL,
 
`captcha_time` int(10) unsigned NOT NULL,
  `ip_address` varchar(16)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `word`
varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
)
ENGINE=InnoDB AUTO_INCREMENT=379 DEFAULT CHARSET=utf8;


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

--
-- Table
structure for table `ic_category`
--

CREATE TABLE IF NOT EXISTS
`ic_category` (
  `category_id` int(11) NOT NULL,
  `username` varchar(11)
NOT NULL,
  `category_name` varchar(50) NOT NULL,
  `category_desc` text
NOT NULL,
  `backgroundColor` varchar(11) NOT NULL,
  `borderColor`
varchar(11) NOT NULL,
  `textColor` varchar(11) NOT NULL
) ENGINE=InnoDB
AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

--
-- Dumping data for table
`ic_category`
--

INSERT INTO `ic_category` (`category_id`, `username`,
`category_name`, `category_desc`, `backgroundColor`, `borderColor`,
`textColor`) VALUES
(28, 'admin', 'Meetings', 'Daily Meetings', '#db0448',
'#ffffff', '#ffffff'),
(29, 'user', 'New Category', 'New Category',
'#05b0dc', '#ffffff', '#ffffff'),
(30, 'user', 'Web Project', 'My New
Project', '#d0db04', '#ffffff', '#ffffff');

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

--
-- Table
structure for table `ic_events`
--

CREATE TABLE IF NOT EXISTS `ic_events`
(
  `eid` int(11) NOT NULL,
  `gid` int(11) NOT NULL,
  `id` int(11) NOT
NULL,
  `category` int(11) NOT NULL,
  `username` varchar(12) DEFAULT
NULL,
  `title` text,
  `backgroundColor` varchar(11) NOT NULL,
 
`borderColor` varchar(11) NOT NULL,
  `textColor` varchar(11) NOT NULL,
 
`description` text,
  `start` datetime NOT NULL,
  `end` datetime NOT
NULL,
  `url` varchar(255) NOT NULL,
  `allDay` enum('true','false') NOT
NULL DEFAULT 'true',
  `rendering` varchar(10) NOT NULL,
  `overlap`
enum('true','false') NOT NULL DEFAULT 'true',
  `recurdays` int(4) NOT
NULL,
  `recurend` date NOT NULL,
  `location` varchar(255) NOT NULL,
 
`latitude` double NOT NULL,
  `longitude` double NOT NULL,
  `filename`
varchar(250) NOT NULL,
  `pubDate` timestamp NOT NULL DEFAULT
CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB
AUTO_INCREMENT=1796 DEFAULT CHARSET=utf8;

--
-- Dumping data for table
`ic_events`
--

INSERT INTO `ic_events` (`eid`, `gid`, `id`, `category`,
`username`, `title`, `backgroundColor`, `borderColor`, `textColor`,
`description`, `start`, `end`, `url`, `allDay`, `rendering`, `overlap`,
`recurdays`, `recurend`, `location`, `latitude`, `longitude`, `filename`,
`pubDate`) VALUES
(1788, 0, 1907624, 28, 'admin', 'Meetings', '#db0448',
'#ffffff', '#ffffff', 'Daily Meetings', '2016-04-15 14:00:00', '2016-04-15
15:20:00', '', 'false', '', 'true', 0, '0000-00-00', '4441 Collins Ave,
Miami Beach, FL 33140, USA', 25.817901, -80.12205399999999, '', '2016-04-02
02:15:22'),
(1790, 0, 8749631, 28, 'admin', 'Meetings', '#db0448',
'#ffffff', '#ffffff', 'Daily Meetings', '2016-04-11 14:00:00', '2016-04-11
19:20:00', '', 'false', '', 'true', 0, '0000-00-00', '4441 Collins Ave,
Miami Beach, FL 33140, USA', 25.81773859347429, -80.12203478051771, '',
'2016-04-02 02:15:14'),
(1794, 1, 2683195, 30, 'user', 'Web Project',
'#d0db04', '#ffffff', '#ffffff', 'My New Project', '2016-04-12 00:00:00',
'2016-04-12 00:00:00', '', 'true', '', 'true', 0, '0000-00-00', 'Alice
Eldemire Dr, Montego Bay, Jamaica', 18.45990000664849, -77.94890697131348,
'', '2016-04-02 02:20:19'),
(1795, -3, 6185942, 29, 'user', 'New York
Tour', '#05b0dc', '#ffffff', '#ffffff', 'New York Tour Category',
'2016-04-14 00:00:00', '2016-04-14 00:00:00', '', 'true', '', 'true', 0,
'0000-00-00', '188-11 Suffolk Dr, Jamaica, NY 11412, USA',
40.69434770142757, -73.76424966171874, '', '2016-04-02 02:25:29');

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

--
-- Table
structure for table `ic_eventsources`
--

CREATE TABLE IF NOT EXISTS
`ic_eventsources` (
  `source_id` int(11) NOT NULL,
  `username`
varchar(20) NOT NULL,
  `source_name` varchar(90) NOT NULL,
  `source_url`
varchar(255) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT
CHARSET=utf8;

--
-- Dumping data for table `ic_eventsources`
--

INSERT
INTO `ic_eventsources` (`source_id`, `username`, `source_name`,
`source_url`) VALUES
(1, 'admin', 'Canadian Holidays',
'canadian__en@holiday.calendar.google.com'),
(2, 'admin', 'USA Holidays',
'usa__en@holiday.calendar.google.com'),
(3, 'admin', 'Jamaican Holiday',
'jm__en@holiday.calendar.google.com');

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

--
-- Table
structure for table `ic_eventsqueues`
--

CREATE TABLE IF NOT EXISTS
`ic_eventsqueues` (
  `eid` int(11) NOT NULL,
  `gid` int(11) NOT NULL,
 
`id` int(11) NOT NULL,
  `category` int(11) NOT NULL,
  `username`
varchar(12) DEFAULT NULL,
  `title` text,
  `backgroundColor` varchar(11)
NOT NULL,
  `borderColor` varchar(11) NOT NULL,
  `textColor` varchar(11)
NOT NULL,
  `description` text,
  `start` datetime NOT NULL,
  `end`
datetime NOT NULL,
  `url` varchar(255) NOT NULL,
  `allDay`
enum('true','false') NOT NULL DEFAULT 'true',
  `rendering` varchar(10) NOT
NULL,
  `overlap` enum('true','false') NOT NULL DEFAULT 'true',
 
`recurdays` int(4) NOT NULL,
  `recurend` date NOT NULL,
  `location`
varchar(255) NOT NULL,
  `latitude` double NOT NULL,
  `longitude` double
NOT NULL,
  `filename` varchar(250) NOT NULL,
  `pubDate` timestamp NOT
NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB
AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

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

--
-- Table
structure for table `ic_groups`
--

CREATE TABLE IF NOT EXISTS `ic_groups`
(
  `id` mediumint(8) unsigned NOT NULL,
  `name` varchar(20) NOT NULL,
 
`description` varchar(100) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=6
DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ic_groups`
--

INSERT
INTO `ic_groups` (`id`, `name`, `description`) VALUES
(1, 'admin',
'Administrator'),
(2, 'members', 'General User'),
(5, 'staff', 'Company
staff members');

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

--
-- Table
structure for table `ic_login_attempts`
--

CREATE TABLE IF NOT EXISTS
`ic_login_attempts` (
  `id` int(11) unsigned NOT NULL,
  `ip_address`
varchar(15) NOT NULL,
  `login` varchar(100) NOT NULL,
  `time` int(11)
unsigned DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT
CHARSET=utf8;

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

--
-- Table
structure for table `ic_markers`
--

CREATE TABLE IF NOT EXISTS
`ic_markers` (
  `markers_id` int(11) NOT NULL,
  `markers_category_id`
int(11) NOT NULL,
  `event_id` int(11) NOT NULL,
  `username` varchar(25)
NOT NULL,
  `markers_name` varchar(45) NOT NULL,
  `markers_logo`
varchar(80) NOT NULL,
  `markers_address` varchar(255) NOT NULL,
 
`markers_lat` double NOT NULL,
  `markers_lng` double NOT NULL,
 
`markers_url` varchar(110) NOT NULL,
  `markers_desc` text NOT NULL,
 
`pubDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT
CHARSET=utf8;

--
-- Dumping data for table `ic_markers`
--

INSERT INTO
`ic_markers` (`markers_id`, `markers_category_id`, `event_id`, `username`,
`markers_name`, `markers_logo`, `markers_address`, `markers_lat`,
`markers_lng`, `markers_url`, `markers_desc`, `pubDate`) VALUES
(1, 28,
1907624, 'admin', 'Meetings', 'pin3.png', '4441 Collins Ave, Miami Beach,
FL 33140, USA', 25.817901, -80.12205399999999, '', 'Daily Meetings',
'2016-04-02 02:15:22'),
(5, 28, 8749631, 'admin', 'Meetings', 'pin3.png',
'4441 Collins Ave, Miami Beach, FL 33140, USA', 25.81773859347429,
-80.12203478051771, '', 'Daily Meetings', '2016-04-02 02:15:14'),
(6, 30,
2683195, 'user', 'Web Project', 'pin3.png', 'Alice Eldemire Dr, Montego
Bay, Jamaica', 18.45990000664849, -77.94890697131348, '', 'My New Project',
'2016-04-02 02:20:19'),
(7, 29, 6185942, 'user', 'New York Tour',
'pin3.png', '188-11 Suffolk Dr, Jamaica, NY 11412, USA', 40.69434770142757,
-73.76424966171874, '', 'New York Tour Category', '2016-04-02
02:25:03');

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

--
-- Table
structure for table `ic_pages`
--

CREATE TABLE IF NOT EXISTS `ic_pages` (

 `id` int(11) NOT NULL,
  `uname` varchar(25) NOT NULL,
  `title`
varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `seo`
varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 
`content` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
 
`meta_keywords` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL,
  `meta_description` varchar(250) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL,
  `access` int(3) NOT NULL,
  `pubdates`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data
for table `ic_pages`
--

INSERT INTO `ic_pages` (`id`, `uname`, `title`,
`seo`, `content`, `meta_keywords`, `meta_description`, `access`,
`pubdates`) VALUES
(4, 'admin', 'About us''', 'about-us', '<p>About
us page</p>', 'cifullcalendar,scheduler', 'CIFullCalendar is a
responsive web application that gives you the “Super Saiyan Fusion”
power of organizing, planning, grouping and sharing your events.', 0,
'2016-03-29 21:11:49'),
(5, 'admin', 'Hi share with staff',
'hi-share-with-staff', '<p>Hi staff</p>', '', '', 1,
'2016-03-29 19:36:35'),
(6, 'admin', 'this is members', 'this-is-members',
'Members only', 'cifullcalendar,scheduler', 'CIFullCalendar is a responsive
web application that gives you the “Super Saiyan Fusion” power of
organizing, planning, grouping and sharing your events.', 2, '2016-03-29
19:39:25');

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

--
-- Table
structure for table `ic_sessions`
--

CREATE TABLE IF NOT EXISTS
`ic_sessions` (
  `id` varchar(40) NOT NULL,
  `ip_address` varchar(45) NOT
NULL,
  `user_agent` varchar(150) NOT NULL,
  `timestamp` int(10) unsigned
NOT NULL DEFAULT '0',
  `data` blob NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;
 

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

--
-- Table
structure for table `ic_setting`
--

CREATE TABLE IF NOT EXISTS
`ic_setting` (
  `id` int(11) NOT NULL,
  `name` varchar(255) COLLATE
utf8_unicode_ci NOT NULL,
  `value` varchar(2048) COLLATE utf8_unicode_ci
NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;

--
-- Dumping data for table
`ic_setting`
--

INSERT INTO `ic_setting` (`id`, `name`, `value`)
VALUES
(1, 'site_name', 'CIFullCalendar v3'),
(2, 'site_logo',
'logo.png'),
(3, 'site_email', 'andre@sirdre.com'),
(4, 'site_timezone',
'America/Jamaica'),
(5, 'site_language', 'en'),
(6, 'site_latitude',
'18.473790323586805'),
(7, 'site_longitude', '-77.92278243655392'),
(8,
'meta_description', 'CIFullCalendar is a server-side dynamic web
application that is responsive to any layout of a viewing screen. The
“Super Saiyan Fusion” power of CIFullCalendar allows users to organize,
plan and share events to everyone.'),
(9, 'meta_keywords', 'cifullcalendar,
agenda, meeting, personal organizer, fullcalendar, codeigniter, jquery,
scheduler, cms, maps, location'),
(10, 'current_theme', 'bootlaces'),
(11,
'captcha_verification', '1'),
(12, 'debug', '1'),
(13,
'profile_max_upload_width', '1200'),
(14, 'profile_max_upload_height',
'1200'),
(15, 'profile_max_upload_filesize', '25000'),
(16,
'profile_allowed_extensions', 'gif|jpg|png'),
(17, 'attach_max_size',
'150096'),
(18, 'attach_allowed_extension',
'gif|jpg|png|docx|pptx|ppt|xls|accdb|psd|txt|pdf|zip|ics'),
(19,
'sync_max_size', '4096'),
(20, 'sync_allowed_extension', 'ics|ical'),
(21,
'sync_path_location', './assets/ics/'),
(22, 'cal_defaultview',
'list'),
(23, 'cal_header_left', 'month,agendaWeek,basicDay,list'),
(24,
'cal_header_center', 'title'),
(25, 'cal_header_right',
'prev,next,today'),
(26, 'cal_editable', 'true'),
(27, 'cal_isrtl',
'false'),
(28, 'cal_weeknumbers', 'true'),
(29, 'cal_eventlimit',
'true'),
(30, 'cal_alldayslot', 'true'),
(31, 'cal_hiddendays', ''),
(32,
'cal_slotduration', '01:30:00'),
(34, 'cal_firstday', '0'),
(36,
'cal_businessdays', '1,2,3,4,5'),
(37, 'cal_businessstart', '09:50'),
(38,
'cal_businessend', '17:30'),
(39, 'cal_aspectratio', '1.35'),
(40,
'cal_slotlabeling', 'true'),
(41, 'cal_apikey', ''),
(42,
'current_version', '3.1.8.0');

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

--
-- Table
structure for table `ic_templates`
--

CREATE TABLE IF NOT EXISTS
`ic_templates` (
  `id` int(11) NOT NULL,
  `types` varchar(150) COLLATE
utf8_unicode_ci NOT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci
DEFAULT NULL,
  `body` text COLLATE utf8_unicode_ci NOT NULL,
  `pubdate`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8
COLLATE=utf8_unicode_ci;

--
-- Dumping data for table
`ic_templates`
--

INSERT INTO `ic_templates` (`id`, `types`, `subject`,
`body`, `pubdate`) VALUES
(1, 'registration', 'Registration successful',
'<div style="height: 2px; background-color:
#535353;"></div><div style="border-radius: 5px 5px
5px 5px; padding:20px; margin-top:45px; background-color:#FFFFFF;
font-family:Open Sans, Helvetica, sans-serif;
font-size:13px;">Thanks for joining {SITE_NAME}. The following
details below is your login information. Please keep in mind this
information is sensitive.<br>To open your {SITE_NAME} homepage,
please follow this link:<br><big><b><a
href="{SITE_URL}">{SITE_NAME}
Account!</a></b></big><br>Link doesn''t work? Copy
the following link to your browser address bar:<br><a
href="{SITE_URL}">{SITE_URL}</a><br>Your username:
{USERNAME}<br>Your email address: {EMAIL}<br>Your password:
{PASSWORD}<p>Enjoy!<br>{SITE_NAME}</p></div><div
style="height: 2px; background-color: #535353;"></div>',
'2015-10-22 18:04:58'),
(2, 'notify_message', 'Notification Message',
'<div style="height: 2px; background-color:
#535353;"></div> <div style="border-radius: 5px 5px
5px 5px; padding:20px; margin-top:45px; background-color:#FFFFFF;
font-family:Open Sans, Helvetica, sans-serif;
font-size:13px;"><p>Hi {RECIPIENT},</p><p>You
have received a notification:
</p><blockquote>{MESSAGE}</blockquote><br><big><b><a
href="{SITE_URL}">Go to
Account</a></b></big><br><br>Regards<br>{SITE_NAME}</div><div
style="height: 2px; background-color: #535353;"></div>',
'2015-10-22 19:18:19'),
(3, 'change_email', 'Change Email', '<div
style="height: 2px; background-color:
#535353;"></div>\r\n<div style="border-radius: 5px
5px 5px 5px; padding:20px; margin-top:45px; background-color:#FFFFFF;
font-family:Open Sans, Helvetica, sans-serif; font-size:13px;">You
have changed your email address for {SITE_NAME}.<br>Follow this link
to confirm your new email address:<br><big><b><a
href="{KEY_URL}">Confirm your new
email</a></b></big><br>Copy the following link to
your browser address bar if the link above did not work:<br><a
href="{KEY_URL}">{KEY_URL}</a><br><br>Your
new email address: {NEW_EMAIL}<br><br>You received this email,
because it was requested.&nbsp;If you have received this by mistake,
please DO NOT click the confirmation link, and simply delete this
email.<br><br>Thank
you,<br>{SITE_NAME}</div>\r\n<div style="height: 2px;
background-color: #535353;"></div>', '2015-10-22
19:53:24'),
(4, 'reset_email', 'New Email', '<div style="height:
2px; background-color: #535353;"></div><div
style="border-radius: 5px 5px 5px 5px; padding:20px; margin-top:45px;
background-color:#FFFFFF; font-family:Open Sans, Helvetica, sans-serif;
font-size:13px;"><p>You have changed your email
from&nbsp;<span style="line-height: 18.5714px;">{EMAIL}
to&nbsp;</span><span style="line-height:
18.5714px;">{NEW_EMAIL} successfully</span><span
style="line-height: 1.42857;">.</span><span
style="line-height:
1.42857;">&nbsp;</span></p><br>Thank
you,<br>{SITE_NAME}</div><div style="height: 2px;
background-color: #535353;"></div>', '2015-10-22
19:54:13'),
(5, 'forgot_password', 'Forgot Password', '<div
style="height: 2px; background-color:
#535353;"></div>\r\n<div style="border-radius: 5px
5px 5px 5px; padding:20px; margin-top:45px; background-color:#FFFFFF;
font-family:Open Sans, Helvetica, sans-serif; font-size:13px;">You
received this email because it was requested by a member of <a
href="{SITE_URL}">{SITE_NAME}</a>.<p>To create a
new password, click the follow link
below:<br><big><b><a
href="{KEY_URL}">Change
password</a></b></big><br> If the link doesn''t
work simply copy the following link to your browser address
bar:<br><a
href="{KEY_URL}">{KEY_URL}</a></p>\r\n<p></p>\r\n<p><span
style="line-height: 18.5714px;">You received this email,
because it was requested.&nbsp;If you have received this by mistake,
please DO NOT click the confirmation link, and simply delete this
email.</span><br></p>\r\n<br>Thank
you,<br>{SITE_NAME}</div>\r\n\r\n<div style="height:
2px; background-color: #535353;"></div>', '2015-10-22
19:53:53'),
(6, 'reset_password', 'New Password', '<div
style="height: 2px; background-color:
#535353;"></div><div style="border-radius: 5px 5px
5px 5px; padding:20px; margin-top:45px; background-color:#FFFFFF;
font-family:Open Sans, Helvetica, sans-serif;
font-size:13px;"><p>You have changed your
password.<br>Please keep records secure.<br></p>Your
username: {USERNAME}<br>Your email address: {EMAIL}<br>Your new
password: {NEW_PASSWORD}<br><br>Thank
you,<br>{SITE_NAME}</div><div style="height: 2px;
background-color: #535353;"></div>', '2015-10-22
19:47:41');

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

--
-- Table
structure for table `ic_users`
--

CREATE TABLE IF NOT EXISTS `ic_users` (

 `id` int(11) unsigned NOT NULL,
  `ip_address` varchar(15) NOT NULL,
 
`username` varchar(100) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
 
`salt` varchar(255) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
 
`activation_code` varchar(40) DEFAULT NULL,
  `forgotten_password_code`
varchar(40) DEFAULT NULL,
  `forgotten_password_time` int(11) unsigned
DEFAULT NULL,
  `remember_code` varchar(40) DEFAULT NULL,
  `created_on`
int(11) unsigned NOT NULL,
  `last_login` int(11) unsigned DEFAULT NULL,
 
`last_page` varchar(255) NOT NULL,
  `active` tinyint(1) unsigned DEFAULT
NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50)
DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `phone` varchar(20)
DEFAULT NULL,
  `image` varchar(255) NOT NULL DEFAULT 'default.png',
 
`lang` varchar(6) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL
DEFAULT 'en',
  `cal_timezone` varchar(70) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL DEFAULT 'America/Jamaica',
  `cal_defaultview`
varchar(12) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT
'month',
  `cal_header_left` varchar(95) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL DEFAULT 'month,agendaWeek,basicDay,agendaList',
 
`cal_header_center` varchar(95) CHARACTER SET utf8 COLLATE utf8_unicode_ci
NOT NULL DEFAULT 'title',
  `cal_header_right` varchar(95) CHARACTER SET
utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'prev,next,today',
 
`cal_editable` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT
NULL DEFAULT 'true',
  `cal_firstday` int(2) NOT NULL DEFAULT '0',
 
`cal_businessstart` varchar(9) CHARACTER SET utf8 COLLATE utf8_unicode_ci
NOT NULL,
  `cal_businessend` varchar(9) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL,
  `cal_businessdays` varchar(12) CHARACTER SET
utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `cal_hiddendays`
varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT
'-1',
  `cal_isrtl` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci
NOT NULL DEFAULT 'false',
  `cal_weeknumbers` varchar(5) CHARACTER SET utf8
COLLATE utf8_unicode_ci NOT NULL DEFAULT 'true',
  `cal_eventlimit`
varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT
'true',
  `cal_alldayslot` varchar(5) CHARACTER SET utf8 COLLATE
utf8_unicode_ci NOT NULL DEFAULT 'true',
  `cal_slotduration` varchar(9)
CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '00:30:00',
 
`cal_slotlabeling` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci
NOT NULL DEFAULT 'false',
  `cal_aspectratio` float NOT NULL DEFAULT
'1.45'
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
--
Dumping data for table `ic_users`
--

INSERT INTO `ic_users` (`id`,
`ip_address`, `username`, `password`, `salt`, `email`, `activation_code`,
`forgotten_password_code`, `forgotten_password_time`, `remember_code`,
`created_on`, `last_login`, `last_page`, `active`, `first_name`,
`last_name`, `company`, `phone`, `image`, `lang`, `cal_timezone`,
`cal_defaultview`, `cal_header_left`, `cal_header_center`,
`cal_header_right`, `cal_editable`, `cal_firstday`, `cal_businessstart`,
`cal_businessend`, `cal_businessdays`, `cal_hiddendays`, `cal_isrtl`,
`cal_weeknumbers`, `cal_eventlimit`, `cal_alldayslot`, `cal_slotduration`,
`cal_slotlabeling`, `cal_aspectratio`) VALUES
(1, '127.0.0.1', 'admin',
'$2y$07$j/EczsMGm8Pkxk.pePct8uzNwwKUfkPDtTylPiAtLvZyrYjCSY1oi', '',
'admin@sirdre.com', '', 'QPArQN7hvJoccD9NddTMie1b50fc5b566dfeb588',
1451852903, NULL, 1268889823, 1459563917, 'profile', 1, 'Admin',
'istrator', 'sirdre', '9799805200', 'pro_png_18423095_png_86752094.png',
'en', 'America/Jamaica', 'month', 'month,agendaWeek,agendaDay,agendaList',
'title', 'prevMonth,prev,next,nextMonth,today', 'true', 1, '', '', '',
'-1', 'false', 'true', 'true', 'true', '00:40:00', 'false', 2.45),
(8,
'::1', 'user',
'$2y$08$rinqEuqhx1hoYCllYayCLO0YS6MYhTmxqKSSsM.OSLy15wYoS863q', NULL,
'user@sirdre.com', NULL, NULL, NULL, NULL, 1452912693, 1459563810,
'profile', 1, 'John', 'Smith', '', '', 'default.png', 'en',
'America/Jamaica', 'month', 'month,agendaWeek,basicDay,agendaList',
'title', 'prev,next,today', 'true', 0, '', '', '', '-1', 'false', 'true',
'true', 'true', '00:30:00', 'false', 2.45);

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

--
-- Table
structure for table `ic_users_groups`
--

CREATE TABLE IF NOT EXISTS
`ic_users_groups` (
  `id` int(11) unsigned NOT NULL,
  `user_id` int(11)
unsigned NOT NULL,
  `group_id` mediumint(8) unsigned NOT NULL
)
ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;

--
-- Dumping data
for table `ic_users_groups`
--

INSERT INTO `ic_users_groups` (`id`,
`user_id`, `group_id`) VALUES
(64, 1, 1),
(41, 8, 2);

--
-- Indexes for
dumped tables
--

--
-- Indexes for table `ic_captcha`
--
ALTER TABLE
`ic_captcha`
  ADD PRIMARY KEY (`captcha_id`),
  ADD KEY `word`
(`word`);

--
-- Indexes for table `ic_category`
--
ALTER TABLE
`ic_category`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table
`ic_events`
--
ALTER TABLE `ic_events`
  ADD PRIMARY KEY (`eid`);

--
--
Indexes for table `ic_eventsources`
--
ALTER TABLE `ic_eventsources`
  ADD
PRIMARY KEY (`source_id`),
  ADD UNIQUE KEY `source_id`
(`source_id`);

--
-- Indexes for table `ic_eventsqueues`
--
ALTER TABLE
`ic_eventsqueues`
  ADD PRIMARY KEY (`eid`),
  ADD UNIQUE KEY `eid`
(`eid`);

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

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

--
-- Indexes for table `ic_markers`
--
ALTER TABLE `ic_markers`
 
ADD PRIMARY KEY (`markers_id`),
  ADD UNIQUE KEY `event_id`
(`event_id`);

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

--
-- Indexes for table
`ic_sessions`
--
ALTER TABLE `ic_sessions`
  ADD KEY
`ci_sessions_timestamp` (`timestamp`);

--
-- Indexes for table
`ic_setting`
--
ALTER TABLE `ic_setting`
  ADD PRIMARY KEY (`id`),
  ADD
UNIQUE KEY `name` (`name`);

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

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

--
-- Indexes for table `ic_users_groups`
--
ALTER
TABLE `ic_users_groups`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY
`uc_users_groups` (`user_id`,`group_id`),
  ADD KEY
`fk_users_groups_users1_idx` (`user_id`),
  ADD KEY
`fk_users_groups_groups1_idx` (`group_id`);

--
-- AUTO_INCREMENT for
dumped tables
--

--
-- AUTO_INCREMENT for table `ic_captcha`
--
ALTER
TABLE `ic_captcha`
  MODIFY `captcha_id` bigint(13) unsigned NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=379;
--
-- AUTO_INCREMENT for table
`ic_category`
--
ALTER TABLE `ic_category`
  MODIFY `category_id` int(11)
NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT for table
`ic_events`
--
ALTER TABLE `ic_events`
  MODIFY `eid` int(11) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=1796;
--
-- AUTO_INCREMENT for table
`ic_eventsources`
--
ALTER TABLE `ic_eventsources`
  MODIFY `source_id`
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for
table `ic_eventsqueues`
--
ALTER TABLE `ic_eventsqueues`
  MODIFY `eid`
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for
table `ic_groups`
--
ALTER TABLE `ic_groups`
  MODIFY `id` mediumint(8)
unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for
table `ic_login_attempts`
--
ALTER TABLE `ic_login_attempts`
  MODIFY `id`
int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
--
AUTO_INCREMENT for table `ic_markers`
--
ALTER TABLE `ic_markers`
  MODIFY
`markers_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8;
--
--
AUTO_INCREMENT for table `ic_pages`
--
ALTER TABLE `ic_pages`
  MODIFY `id`
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for
table `ic_setting`
--
ALTER TABLE `ic_setting`
  MODIFY `id` int(11) NOT
NULL AUTO_INCREMENT,AUTO_INCREMENT=44;
--
-- AUTO_INCREMENT for table
`ic_templates`
--
ALTER TABLE `ic_templates`
  MODIFY `id` int(11) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table
`ic_users`
--
ALTER TABLE `ic_users`
  MODIFY `id` int(11) unsigned NOT
NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table
`ic_users_groups`
--
ALTER TABLE `ic_users_groups`
  MODIFY `id` int(11)
unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=65;
--
-- Constraints for
dumped tables
--

--
-- Constraints for table `ic_users_groups`
--
ALTER
TABLE `ic_users_groups`
  ADD CONSTRAINT `fk_users_groups_groups1` FOREIGN
KEY (`group_id`) REFERENCES `ic_groups` (`id`) ON DELETE CASCADE ON UPDATE
NO ACTION,
  ADD CONSTRAINT `fk_users_groups_users1` FOREIGN KEY
(`user_id`) REFERENCES `ic_users` (`id`) ON DELETE CASCADE ON UPDATE NO
ACTION;

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