Файл: CloudBox-main/CloudBox/db_fus.sql
Строк: 603
-- phpMyAdmin SQL Dump
-- version 4.2.7.1
--
http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Jun 26,
2016 at 12:02 PM
-- Server version: 5.6.20
-- PHP Version: 5.5.15
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: `db_fus`
--
--
--------------------------------------------------------
--
-- Table
structure for table `tbl_access_lebel`
--
CREATE TABLE IF NOT EXISTS
`tbl_access_lebel` (
`access_lebel_id` int(2) NOT NULL,
`access_lebel_name` varchar(100) NOT NULL,
`access_lebel` tinyint(1) NOT
NULL,
`block_or_suspend` tinyint(1) NOT NULL,
`edit` tinyint(1) NOT
NULL,
`delete` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=4 ;
--
-- Dumping data for table
`tbl_access_lebel`
--
INSERT INTO `tbl_access_lebel` (`access_lebel_id`,
`access_lebel_name`, `access_lebel`, `block_or_suspend`, `edit`, `delete`)
VALUES
(1, 'Super Admin', 1, 1, 1, 1),
(2, 'Admin', 2, 0, 1, 1),
(3,
'User', 3, 0, 1, 0);
--
--------------------------------------------------------
--
-- Table
structure for table `tbl_file`
--
CREATE TABLE IF NOT EXISTS `tbl_file`
(
`file_id` int(11) NOT NULL,
`folder_id` int(11) NOT NULL,
`file_title` varchar(255) NOT NULL,
`file_name` varchar(255) NOT NULL,
`file_description` text NOT NULL,
`deletion_status` tinyint(1) NOT NULL
DEFAULT '0',
`date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
--
-- Dumping data
for table `tbl_file`
--
INSERT INTO `tbl_file` (`file_id`, `folder_id`,
`file_title`, `file_name`, `file_description`, `deletion_status`,
`date_added`) VALUES
(1, 1, '', 'doc_1_-_Copy.xlsx', '', 0, '2016-06-16
07:12:14'),
(2, 1, '', 'shahid.docx', '', 0, '2016-06-16 07:12:42'),
(3, 1,
'', 'w_doc_2.docx', '', 0, '2016-06-16 07:12:42'),
(4, 1, '', 'w_doc.docx',
'', 0, '2016-06-16 07:12:42'),
(5, 1, '', 'doc_21.xlsx', '', 0, '2016-06-16
07:12:42'),
(6, 1, '', 'w_doc_-3_.docx', '', 0, '2016-06-16 07:12:42'),
(7,
1, '', 'doc_1_-_Copy1.xlsx', '', 0, '2016-06-16 07:12:42'),
(8, 1, '',
'doc_1.xlsx', '', 0, '2016-06-16 07:12:42'),
(9, 1, '', 'doc_22.xlsx', '',
0, '2016-06-16 07:16:01'),
(10, 1, '', 'shahid1.docx', '', 0, '2016-06-16
08:34:46'),
(11, 1, '', 'shahid2.docx', '', 0, '2016-06-16 08:35:06'),
(12,
3, '', 'w_doc1.docx', '', 0, '2016-06-18 08:06:41'),
(13, 3, '',
'doc_11.xlsx', '', 0, '2016-06-18 08:08:44'),
(14, 3, '',
'w_doc_-3_1.docx', '', 0, '2016-06-26 07:09:50');
--
--------------------------------------------------------
--
-- Table
structure for table `tbl_folder`
--
CREATE TABLE IF NOT EXISTS
`tbl_folder` (
`folder_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`folder_title` varchar(255) NOT NULL,
`deletion_status` tinyint(1) NOT
NULL,
`date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data
for table `tbl_folder`
--
INSERT INTO `tbl_folder` (`folder_id`,
`user_id`, `folder_title`, `deletion_status`, `date_added`) VALUES
(1, 1,
'Employee', 0, '2016-06-18 06:53:48'),
(2, 1, 'Students', 0, '2016-06-18
07:40:51'),
(3, 1, 'Teachers', 0, '2016-06-18 07:46:30');
--
--------------------------------------------------------
--
-- Table
structure for table `tbl_general_settings`
--
CREATE TABLE IF NOT EXISTS
`tbl_general_settings` (
`id` int(2) NOT NULL,
`site_name` varchar(50)
NOT NULL,
`admin_email` varchar(100) NOT NULL,
`logo` varchar(255) NOT
NULL,
`favicon` varchar(255) NOT NULL,
`app_vrs` varchar(20) NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data
for table `tbl_general_settings`
--
INSERT INTO `tbl_general_settings`
(`id`, `site_name`, `admin_email`, `logo`, `favicon`, `app_vrs`) VALUES
(1,
'Atique IT', 'admin@atiqueit.com', 'STACScholarshipFundLogo-1.png',
'pYKz7gE1.jpg', '2.0.1');
--
--------------------------------------------------------
--
-- Table
structure for table `tbl_mail_inbox`
--
CREATE TABLE IF NOT EXISTS
`tbl_mail_inbox` (
`inbox_mail_id` int(11) NOT NULL,
`full_name`
varchar(100) NOT NULL,
`from` varchar(100) NOT NULL,
`subject`
varchar(100) NOT NULL,
`message` longtext NOT NULL,
`reading_status`
tinyint(1) NOT NULL,
`deletion_status` tinyint(1) NOT NULL,
`date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table
`tbl_mail_inbox`
--
INSERT INTO `tbl_mail_inbox` (`inbox_mail_id`,
`full_name`, `from`, `subject`, `message`, `reading_status`,
`deletion_status`, `date_added`) VALUES
(1, 'Shahid Nawaz',
'msnawazbd@gmail.com', 'welcome message', 'New members in a group are an
added advantage to spread motive and business of the group. Welcoming new
members to a group or an organization would make them feel good and
special. one can welcome them with welcome wishes given with gifts to
encourage them to work for the motive of the group. One can also arrange
surprises for the new members which would make the welcoming much more
special.\r\n\r\n “Dear new member, I welcome you to the Save Forest
group with much love. I hope you would work for the motive of the group as
much as other members and save our forests.”', 0, 0, '2016-06-05
05:47:41'),
(2, 'Arshadul Haque', 'noyon2nil@gmail.com', 'Messages for
Friends', 'Friends are the special companions of life. They are there by
any moment of a person life, be it happiness or sorrow. Friends are
welcomed with much fervor as they look into a healthy friendship forever.
\r\n\r\n “I welcome you friend to our group of five and look forward
to a beautiful and healthy friendship forever. May we cherish every moment
of our friendship always and create beautiful moments in
life.”\r\nFriends are the special companions of life. They are there by
any moment of a person life, be it happiness or sorrow. Friends are
welcomed with much fervor as they look into a healthy friendship forever.
\r\n\r\n “I welcome you friend to our group of five and look forward
to a beautiful and healthy friendship forever. May we cherish every moment
of our friendship always and create beautiful moments in
life.”\r\nFriends are the special companions of life. They are there by
any moment of a person life, be it happiness or sorrow. Friends are
welcomed with much fervor as they look into a healthy friendship forever.
\r\n\r\n “I welcome you friend to our group of five and look forward
to a beautiful and healthy friendship forever. May we cherish every moment
of our friendship always and create beautiful moments in life.”\r\n', 1,
0, '2016-06-05 05:49:01');
--
--------------------------------------------------------
--
-- Table
structure for table `tbl_mail_settings`
--
CREATE TABLE IF NOT EXISTS
`tbl_mail_settings` (
`mail_set_id` int(2) NOT NULL,
`activation_subj`
varchar(255) NOT NULL,
`activation_body` text NOT NULL,
`forgot_subj`
varchar(255) NOT NULL,
`forgot_body` text NOT NULL,
`add_user_subj`
varchar(255) NOT NULL,
`add_user_body` text NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Dumping data for table
`tbl_mail_settings`
--
INSERT INTO `tbl_mail_settings` (`mail_set_id`,
`activation_subj`, `activation_body`, `forgot_subj`, `forgot_body`,
`add_user_subj`, `add_user_body`) VALUES
(1, '', '', 'No reply-Reset
Passwords1', 'Your reset code is given below. Go to this link to reset your
password.1', 'No reply-You have been added as a member12', 'You have been
added12');
--
--------------------------------------------------------
--
-- Table
structure for table `tbl_privacy_terms`
--
CREATE TABLE IF NOT EXISTS
`tbl_privacy_terms` (
`privacy_terms_id` int(2) NOT NULL,
`privacy` text
NOT NULL,
`terms` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8
AUTO_INCREMENT=2 ;
--
-- Dumping data for table
`tbl_privacy_terms`
--
INSERT INTO `tbl_privacy_terms`
(`privacy_terms_id`, `privacy`, `terms`) VALUES
(1, '<img k="
style=">
This is privacy222
', '
This is terms and
conditions222');
--
--------------------------------------------------------
--
-- Table
structure for table `tbl_sent_mail`
--
CREATE TABLE IF NOT EXISTS
`tbl_sent_mail` (
`sent_mail_id` int(11) NOT NULL,
`user_id` int(11) NOT
NULL,
`to` varchar(100) NOT NULL,
`from` varchar(100) NOT NULL,
`cc`
varchar(255) NOT NULL,
`subject` varchar(255) NOT NULL,
`message`
longtext NOT NULL,
`recipents_name` varchar(100) NOT NULL,
`sender_name` varchar(100) NOT NULL,
`deletion_status` tinyint(1) NOT
NULL,
`date_added` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data
for table `tbl_sent_mail`
--
INSERT INTO `tbl_sent_mail` (`sent_mail_id`,
`user_id`, `to`, `from`, `cc`, `subject`, `message`, `recipents_name`,
`sender_name`, `deletion_status`, `date_added`) VALUES
(1, 1,
'msnawazbd@gmail.com', 'noyon2nil@gmail.com', '', 'welcome message', 'The
Entrepreneurship Center at AOU was another notable accomplishment we made
in the past year. In the changing dynamics of the world, we believe our
students have a role in the economic cycle and we work very hard in
bringing out both the potential and the Entrepreneurs in each and every one
of you. We welcome you to join the center and benefit from the training
programs and mentorship we are offering so you can give yourself the chance
to be the next entrepreneurship success story. The first entrepreneurs as
a result of the training started their own business including Swaleen
Abboud (Ibtikart), Toni Abou Madi (Tabkit Mama), Sarkis Magarian and Jihane
Nader (Loyal Services), and Adel Al Saady (Finish Line Online). We have
witnessed more businesses this year including a company by AOU student
George Ghafari which won the Berytech entrepreneurship Award. \r\n\r\nOn
the community level, we are very pleased to have hosted the 1st
Mediterranean Interdisciplinary Forum on Social Sciences and Humanities in
April 2014. An academic summit aimed at bringing together researchers in
the area of social sciences and humanities, who by presenting their
scientific attainments will contribute to the development of the
interdisciplinary concept in higher education. As a leading academic
institution we strive to alleviate to the quality of education worldwide
and play an instrumental role in making breakthrough progress for the
well-being of the generations to come.', '', '', 0, '2016-06-05
07:08:40'),
(2, 1, 'admin@gmail.com', 'demo@gmail.com', '',
'Entrepreneurship ', 'The Entrepreneurship Center at AOU was another
notable accomplishment we made in the past year. In the changing dynamics
of the world, we believe our students have a role in the economic cycle and
we work very hard in bringing out both the potential and the Entrepreneurs
in each and every one of you. We welcome you to join the center and benefit
from the training programs and mentorship we are offering so you can give
yourself the chance to be the next entrepreneurship success story. The
first entrepreneurs as a result of the training started their own business
including Swaleen Abboud (Ibtikart), Toni Abou Madi (Tabkit Mama), Sarkis
Magarian and Jihane Nader (Loyal Services), and Adel Al Saady (Finish Line
Online). We have witnessed more businesses this year including a company by
AOU student George Ghafari which won the Berytech entrepreneurship Award.
\r\n\r\nOn the community level, we are very pleased to have hosted the 1st
Mediterranean Interdisciplinary Forum on Social Sciences and Humanities in
April 2014. An academic summit aimed at bringing together researchers in
the area of social sciences and humanities, who by presenting their
scientific attainments will contribute to the development of the
interdisciplinary concept in higher education. As a leading academic
institution we strive to alleviate to the quality of education worldwide
and play an instrumental role in making breakthrough progress for the
well-being of the generations to come.', '', '', 0, '2016-06-05
07:08:40'),
(3, 0, 'ms@gmail.com', 'msnawazbd@gmail.com', '', 'Welcome',
'Message for email\r\n ', '', 'Shahid
Nawaz', 0, '2016-06-06 11:10:31'),
(4, 1, 'user@gmail.com',
'admin@gmail.com', 'cc@gmail.com', 'Welcomw message', 'Welcome messages are
sent to new members to welcome them to the family \r\nor any group or
association. They are a way of introducing them and \r\nfamiliarizing them
of the members of the family or the group. The \r\nmessages also tell them
about the group or provide a brief description \r\nof the family. One can
send the messages in different ways. Be it in \r\npaper or a beautifully
decorated ornate, instead of forwarding text \r\nmessages one can send the
welcome messages beautifully.\r\n ', '',
'Atique It', 0, '2016-06-06 11:12:52');
--
--------------------------------------------------------
--
-- Table
structure for table `tbl_user_login_info`
--
CREATE TABLE IF NOT EXISTS
`tbl_user_login_info` (
`user_id` int(11) NOT NULL,
`full_name`
varchar(100) NOT NULL,
`email_address` varchar(100) NOT NULL,
`user_password` varchar(100) NOT NULL,
`access_label` tinyint(1) NOT
NULL,
`activation_status` tinyint(1) NOT NULL,
`deletion_status`
tinyint(1) NOT NULL,
`date_added` timestamp NOT NULL DEFAULT
CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5
;
--
-- Dumping data for table `tbl_user_login_info`
--
INSERT INTO
`tbl_user_login_info` (`user_id`, `full_name`, `email_address`,
`user_password`, `access_label`, `activation_status`, `deletion_status`,
`date_added`) VALUES
(1, 'Super Admin', 'super_admin@gmail.com',
'3b712de48137572f3849aabd5666a4e3', 1, 1, 0, '2016-06-06 12:07:04'),
(2,
'Admin', 'admin@gmail.com', '3b712de48137572f3849aabd5666a4e3', 2, 1, 0,
'2016-06-06 12:07:04'),
(3, 'User', 'user@gmail.com',
'3b712de48137572f3849aabd5666a4e3', 3, 1, 0, '2016-06-06 12:07:28'),
(4,
'Nawaz', 'nawaz@gmail.com', '1bbd886460827015e5d605ed44252251', 3, 1, 0,
'2016-06-06 12:31:22');
--
--------------------------------------------------------
--
-- Table
structure for table `tbl_user_profile_info`
--
CREATE TABLE IF NOT EXISTS
`tbl_user_profile_info` (
`pro_id` int(11) NOT NULL,
`user_id` int(11)
NOT NULL,
`first_name` varchar(50) NOT NULL,
`last_name` varchar(50)
NOT NULL,
`address_1` varchar(255) NOT NULL,
`address_2` varchar(255)
NOT NULL,
`state` varchar(50) NOT NULL,
`city` varchar(50) NOT NULL,
`zip` varchar(20) NOT NULL,
`country` varchar(50) NOT NULL,
`phone`
varchar(20) NOT NULL,
`profile_picture` varchar(255) NOT NULL,
`facebook` varchar(255) NOT NULL,
`twitter` varchar(255) NOT NULL,
`linkedin` varchar(255) NOT NULL,
`google_plus` varchar(255) NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data
for table `tbl_user_profile_info`
--
INSERT INTO `tbl_user_profile_info`
(`pro_id`, `user_id`, `first_name`, `last_name`, `address_1`, `address_2`,
`state`, `city`, `zip`, `country`, `phone`, `profile_picture`, `facebook`,
`twitter`, `linkedin`, `google_plus`) VALUES
(1, 1, '', '', '', '', '', '',
'', '', '', '', '', '', '', ''),
(2, 2, '', '', '', '', '', '', '', '', '',
'', '', '', '', ''),
(3, 3, '', '', '', '', '', '', '', '', '', '', '', '',
'', ''),
(4, 4, '', '', '', '', '', '', '', '', '', '', '', '', '',
'');
--
-- Indexes for dumped tables
--
--
-- Indexes for table
`tbl_access_lebel`
--
ALTER TABLE `tbl_access_lebel`
ADD PRIMARY KEY
(`access_lebel_id`);
--
-- Indexes for table `tbl_file`
--
ALTER TABLE
`tbl_file`
ADD PRIMARY KEY (`file_id`);
--
-- Indexes for table
`tbl_folder`
--
ALTER TABLE `tbl_folder`
ADD PRIMARY KEY
(`folder_id`);
--
-- Indexes for table `tbl_general_settings`
--
ALTER
TABLE `tbl_general_settings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for
table `tbl_mail_inbox`
--
ALTER TABLE `tbl_mail_inbox`
ADD PRIMARY KEY
(`inbox_mail_id`);
--
-- Indexes for table `tbl_mail_settings`
--
ALTER
TABLE `tbl_mail_settings`
ADD PRIMARY KEY (`mail_set_id`);
--
-- Indexes
for table `tbl_privacy_terms`
--
ALTER TABLE `tbl_privacy_terms`
ADD
PRIMARY KEY (`privacy_terms_id`);
--
-- Indexes for table
`tbl_sent_mail`
--
ALTER TABLE `tbl_sent_mail`
ADD PRIMARY KEY
(`sent_mail_id`);
--
-- Indexes for table `tbl_user_login_info`
--
ALTER
TABLE `tbl_user_login_info`
ADD PRIMARY KEY (`user_id`);
--
-- Indexes
for table `tbl_user_profile_info`
--
ALTER TABLE `tbl_user_profile_info`
ADD PRIMARY KEY (`pro_id`);
--
-- AUTO_INCREMENT for dumped
tables
--
--
-- AUTO_INCREMENT for table `tbl_access_lebel`
--
ALTER TABLE
`tbl_access_lebel`
MODIFY `access_lebel_id` int(2) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table
`tbl_file`
--
ALTER TABLE `tbl_file`
MODIFY `file_id` int(11) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table
`tbl_folder`
--
ALTER TABLE `tbl_folder`
MODIFY `folder_id` int(11) NOT
NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table
`tbl_general_settings`
--
ALTER TABLE `tbl_general_settings`
MODIFY `id`
int(2) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for
table `tbl_mail_inbox`
--
ALTER TABLE `tbl_mail_inbox`
MODIFY
`inbox_mail_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
--
AUTO_INCREMENT for table `tbl_mail_settings`
--
ALTER TABLE
`tbl_mail_settings`
MODIFY `mail_set_id` int(2) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table
`tbl_privacy_terms`
--
ALTER TABLE `tbl_privacy_terms`
MODIFY
`privacy_terms_id` int(2) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
--
AUTO_INCREMENT for table `tbl_sent_mail`
--
ALTER TABLE
`tbl_sent_mail`
MODIFY `sent_mail_id` int(11) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table
`tbl_user_login_info`
--
ALTER TABLE `tbl_user_login_info`
MODIFY `user_id`
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for
table `tbl_user_profile_info`
--
ALTER TABLE `tbl_user_profile_info`
MODIFY
`pro_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
/*!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 */;