-- http://www.phpmyadmin.net
--




--
-- Database: `agw`
--

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

--
-- Table structure for table `about_text`
--

CREATE TABLE `about_text` (
  `id` int(11) NOT NULL,
  `section_1_title` varchar(255) NOT NULL,
  `section_1_image` varchar(255) NOT NULL,
  `section_1_text` text NOT NULL,
  `section_2_title` varchar(255) NOT NULL,
  `section_2_image` varchar(255) NOT NULL,
  `section_2_text` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `about_text`
--

INSERT INTO `about_text` (`id`, `section_1_title`, `section_1_image`, `section_1_text`, `section_2_title`, `section_2_image`, `section_2_text`) VALUES
(1, 'About our approach', 'about-image-1.png', 'We aim at having a positive impact on our community. We do so by helping family businesses to thrive at both economic and emotional levels.\r\n\r\nIn our work, we listen, educate, facilitate, mediate and challenge. We renew trust and unlock the creativity of family businesses.\r\n\r\nWe work from the inside to the outside to develop actionable solutions that best fit the specific needs and challenges of the client.\r\n\r\nWe bring otherness to our work to reach higher levels of excellence. By otherness, we mean diversity, different perspectives from other disciplines such as acting, coaching, philosophy.', 'About our name', 'about-image-2.png', 'AGW. A Glass of Water. A glass of water quenches thirst, can be seen as half empty or half full, is a simple and universal gesture of hospitality.\r\n\r\nA glass of water is transparent and at the same time can act as a mirror. With all these meanings and qualities, a glass of water symbolizes the richness and complexities of families working together.\r\n\r\nAt AGW, we recognize this complexity and navigate with the family to structure the business in a way that will best support their aspirations. We do so with an open heart, integrity and by building trust.');

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

--
-- Table structure for table `client_testimonials`
--

CREATE TABLE `client_testimonials` (
  `id` int(11) NOT NULL,
  `image` varchar(255) NOT NULL,
  `text` text NOT NULL,
  `person` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `client_testimonials`
--

INSERT INTO `client_testimonials` (`id`, `image`, `text`, `person`, `company`) VALUES
(1, '1495111349-AGW-clients-thumbnails.jpg', '\r\nI approached Chérine because she is an expert in family business coaching and she has also experienced the life of a family business. Chérine helped me achieving a better understanding of the communication in a family business and how each member of the family business plays many different roles. The result was astonishing and surprised me, and it was quite a fantastic one. One thing I liked was that she was flexible in her coaching style and also encouraged me to go to places that I had never dared to explore alone. I would recommend Chérine to people who need coaching in a family business environment, she is a one of a kind.', 'A Family Business', 'BILAL J. KABALAN'),
(2, '1495111372-AGW-clients-thumbnails.jpg', '\r\nChérine’s calm, reassuring and insightful coaching was a tremendous boost to me personally and professionally at a period of immense change and uncertainty in my business life. She helped me focus on key issues pertinent to family businesses, which is where her expertise lies. Her guidance was instrumental in my decision to go back to study and embark on an Executive MBA.', 'A Family Business ', 'CK, Managing Director'),
(3, 'AGW-clients-thumbnail-Technica.jpg', 'At first I was a bit skeptical. We had never done any guided family discussions before and I didn’t know how would an external person to the family affect the conversation. The concern lifted straight away at the intro. Chérine and Arthur came well prepared, the agenda was shared to guide the course for all sessions and it was validated with everyone that we were at ease with the subjects, timing and pace. Guidelines were established to make sure we all felt safe to express ourselves and we learned techniques to convey our thoughts on delicate matters. More importantly, Chérine and Arthur displayed great skill in managing tense situations in a constructive manner and direct back the focus to reaching a result rather than getting caught in the argument. All in all it was a great experience. I believe we are in a better place than we would’ve been had we tried to start it on our own.', 'Technica', 'Cyril Haddad, Head of Spare Parts'),
(4, '1495111523-AGW-clients-thumbnail-Technica.jpg', '\r\nOn behalf of the family, I want to thank you for the excellent workshops we had and the professional consultancy services done. The workshops have brought the family closer together and broken all communication barriers. The consultancy you gave has designed a clear road map to move forward in succession planning and corporate governance.', 'Technica ', 'Tony Haddad, General Manager'),
(5, '1495111539-AGW-clients-thumbnail-Technica.jpg', '\r\nThe process applied helped our family discuss very sensitive matters in a healthy environment. With the help of Chérine and Arthur we established a communication methodology between the family to discuss the business issues in an efficient and productive way. No more elephants in the room!', 'Technica', 'Cynthia Abou Khater, Strategy Management Officer');

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

--
-- Table structure for table `columns`
--

CREATE TABLE `columns` (
  `id` int(11) UNSIGNED NOT NULL,
  `table_name` varchar(255) NOT NULL DEFAULT '',
  `column` varchar(255) NOT NULL DEFAULT '',
  `column_type` varchar(255) DEFAULT '',
  `display` tinyint(4) NOT NULL DEFAULT '0',
  `required` tinyint(4) DEFAULT '0',
  `select_values` varchar(255) DEFAULT NULL,
  `foreign_table` varchar(255) DEFAULT NULL,
  `foreign_column` varchar(255) DEFAULT NULL,
  `thumb_generate` tinyint(4) DEFAULT '0',
  `thumb_column` varchar(255) DEFAULT NULL,
  `wysiwyg` tinyint(4) DEFAULT '0',
  `year_default` int(11) DEFAULT NULL,
  `year_min` int(4) DEFAULT NULL,
  `year_max` int(4) DEFAULT NULL,
  `multi_foreign_table` varchar(255) NOT NULL,
  `multi_foreign_column` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `columns`
--

INSERT INTO `columns` (`id`, `table_name`, `column`, `column_type`, `display`, `required`, `select_values`, `foreign_table`, `foreign_column`, `thumb_generate`, `thumb_column`, `wysiwyg`, `year_default`, `year_min`, `year_max`, `multi_foreign_table`, `multi_foreign_column`) VALUES
(1, 'homepage_text', 'title', 'text', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(2, 'homepage_text', 'text', 'textarea', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(3, 'about_text', 'section_1_title', 'text', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(4, 'about_text', 'section_1_image', 'single_upload', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(5, 'about_text', 'section_1_text', 'textarea', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(6, 'about_text', 'section_2_title', 'text', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(7, 'about_text', 'section_2_image', 'single_upload', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(8, 'about_text', 'section_2_text', 'textarea', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(9, 'services_text', 'section_1_title', 'text', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(10, 'services_text', 'section_1_image', 'single_upload', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(11, 'services_text', 'section_1_text', 'textarea', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(12, 'services_text', 'section_2_title', 'text', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(13, 'services_text', 'section_2_image', 'single_upload', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(14, 'services_text', 'section_2_text', 'textarea', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(15, 'services_text', 'section_3_title', 'text', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(16, 'services_text', 'section_3_image', 'single_upload', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(17, 'services_text', 'section_3_text', 'textarea', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(18, 'services_text', 'section_4_title', 'text', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(19, 'services_text', 'section_4_image', 'single_upload', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(20, 'services_text', 'section_4_text', 'textarea', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(21, 'team_members', 'title', 'text', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(22, 'team_members', 'position', 'text', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(23, 'team_members', 'image', 'single_upload', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(24, 'team_members', 'text', 'textarea', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(25, 'client_testimonials', 'image', 'single_upload', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(26, 'client_testimonials', 'text', 'textarea', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(27, 'client_testimonials', 'person', 'text', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(28, 'client_testimonials', 'company', 'text', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(29, 'clients', 'image', 'single_upload', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(30, 'clients', 'title', 'text', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(31, 'resources_categories', 'category', 'text', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(32, 'resources', 'date', 'text', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(33, 'resources', 'title', 'text', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(34, 'resources', 'image', 'single_upload', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(35, 'resources', 'text', 'textarea', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(36, 'resources', 'external_link', 'text', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(37, 'resources', 'category', 'foreign', 0, 0, NULL, 'resources_categories', 'category', 0, NULL, 0, NULL, NULL, NULL, '', ''),
(38, 'homepage_image', 'image', 'single_upload', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(39, 'resources', 'tags', 'text', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(40, 'resources', 'file', 'single_upload', 0, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(41, 'social_icons', 'icon', 'single_upload', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(42, 'social_icons', 'link', 'text', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(43, 'page_titles', 'title', 'text', 1, 1, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', ''),
(44, 'page_titles', 'subtitle', 'textarea', 1, 0, NULL, NULL, NULL, 0, NULL, 0, NULL, NULL, NULL, '', '');

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

--
-- Table structure for table `homepage_image`
--

CREATE TABLE `homepage_image` (
  `id` int(11) NOT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `homepage_image`
--

INSERT INTO `homepage_image` (`id`, `image`) VALUES
(1, 'AGW-homepage-image.jpg');

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

--
-- Table structure for table `homepage_text`
--

CREATE TABLE `homepage_text` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `text` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `homepage_text`
--

INSERT INTO `homepage_text` (`id`, `title`, `text`) VALUES
(1, 'AGW is a family business advisory', 'AGW is a family business advisory firm that focuses on transforming family dynamics for a stronger business. Our expertise ranges from family business governance to conflict resolution and from succession planning to board efficiency.');

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

--
-- Table structure for table `page_titles`
--

CREATE TABLE `page_titles` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `subtitle` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `page_titles`
--

INSERT INTO `page_titles` (`id`, `title`, `subtitle`) VALUES
(1, 'about us', ''),
(2, 'services', 'Our services range from implementing strong governance, to planning for succession as well as leadership development.'),
(3, 'meet the team', 'We are a team not because we work together, we are a team because we respect and love each other.'),
(4, 'clients', 'From a couple’s start-up to a multi-generational family business, our clients’ specificity is to have bonds that go beyond the business.'),
(5, 'contact us', 'We would love to hear from you for any questions or queries.'),
(6, 'resources', '');

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

--
-- Table structure for table `positions`
--

CREATE TABLE `positions` (
  `id` int(11) UNSIGNED NOT NULL,
  `table` varchar(255) DEFAULT NULL,
  `position_column` varchar(255) DEFAULT '',
  `image_column` varchar(255) DEFAULT NULL,
  `text_column` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `relationships`
--

CREATE TABLE `relationships` (
  `id` int(11) UNSIGNED NOT NULL,
  `parent` varchar(255) DEFAULT NULL,
  `parent_column` varchar(255) DEFAULT NULL,
  `child` varchar(255) DEFAULT NULL,
  `child_column` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `resources`
--

CREATE TABLE `resources` (
  `id` int(11) NOT NULL,
  `date` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `text` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `external_link` varchar(255) NOT NULL,
  `category` int(11) NOT NULL,
  `tags` text NOT NULL,
  `file` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resources`
--

INSERT INTO `resources` (`id`, `date`, `title`, `text`, `image`, `external_link`, `category`, `tags`, `file`) VALUES
(1, '10 NOVEMBER 2014', 'FINDING A NON-FAMILY CEO', 'The Debbas family business recently celebrated its 100th anniversary. For decades the family name has stood for providing quality lighting solutions in Lebanon and the Middle East and today the family works in the fields of energy, MEP contracting, lighting, integrated systems, manufacturing and trading.', 'resources-image-1.png', 'http://google.com', 1, 'non-family, family, CEO', 'Debbas_E.pdf'),
(4, '1 MAY 2014', 'TRANSFORMING FAMILY RELATIONSHIPS', 'Maintaining good relationships between family members is no easy task and yet it is one of the most important ingredients to the success of a family firm. Family members who are in business together have to assume multiple roles (family, ownership, and management), and therefore must pay close attention to the quality of their relationships.', '1494499102-resources-image-2.png', '', 2, '', 'Tmag22_C02_s.pdf');

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

--
-- Table structure for table `resources_categories`
--

CREATE TABLE `resources_categories` (
  `id` int(11) NOT NULL,
  `category` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `resources_categories`
--

INSERT INTO `resources_categories` (`id`, `category`) VALUES
(1, 'Governance'),
(2, 'Succession'),
(3, 'Culture');

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

--
-- Table structure for table `services_text`
--

CREATE TABLE `services_text` (
  `id` int(11) NOT NULL,
  `section_1_title` varchar(255) NOT NULL,
  `section_1_image` varchar(255) NOT NULL,
  `section_1_text` text NOT NULL,
  `section_2_title` varchar(255) NOT NULL,
  `section_2_image` varchar(255) NOT NULL,
  `section_2_text` text NOT NULL,
  `section_3_title` varchar(255) NOT NULL,
  `section_3_image` varchar(255) NOT NULL,
  `section_3_text` text NOT NULL,
  `section_4_title` varchar(255) NOT NULL,
  `section_4_image` varchar(255) NOT NULL,
  `section_4_text` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `services_text`
--

INSERT INTO `services_text` (`id`, `section_1_title`, `section_1_image`, `section_1_text`, `section_2_title`, `section_2_image`, `section_2_text`, `section_3_title`, `section_3_image`, `section_3_text`, `section_4_title`, `section_4_image`, `section_4_text`) VALUES
(1, 'GOVERNANCE', 'services-image-1.jpg', 'Governance implementation becomes a tool for growth when the family and/or the business grow in size and complexity. Governance structures that are adapted to the size and needs of the family and the business bring more effective strategies, better control for the business, clarified roles and interactions for family members as well as renewed trust. We develop, educate and implement governance structures that will best fit the needs of our clients.\r\n', 'SUCCESSION', 'AGW-services-image-2.jpg', 'Succession is often a challenging time that may bring out insecurities for family members, managers and employees as well as external stakeholders. We look at succession planning as a process that includes inter-generational communication, aligning the family and the business around a common vision and supporting our clients in developing a sound succession plan.', 'CULTURE', 'services-image-3.jpg', 'With an increased number of employees, the business culture might not reflect the values of the family anymore and can lead to frustration and under-performance. We work closely with families to define and align their values, develop processes that will help them manage disagreements and support best decision-making. We then ensure the business culture truly reflects those values.', 'NEXT GENERATION', '1494303349-services-image-2.jpg', 'Next Generation family members experience specific challenges due to the many roles they need to juggle. More often than not they are a family member, a business manager, an owner and an heir. Their personal aspirations may clash with the expectations of the family or the business. We assist family members with individual coaching sessions to develop their personal leadership, impact and effectiveness in any endeavor they wish to pursue.');

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

--
-- Table structure for table `social_icons`
--

CREATE TABLE `social_icons` (
  `id` int(11) NOT NULL,
  `icon` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `social_icons`
--

INSERT INTO `social_icons` (`id`, `icon`, `link`) VALUES
(1, 'footer-facebook.png', 'http://facebook.com'),
(2, 'footer-linkedin.png', 'https://www.linkedin.com/company-beta/18077381/'),
(3, 'footer-twitter.png', 'http://twitter.com');

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

--
-- Table structure for table `tables`
--

CREATE TABLE `tables` (
  `id` int(11) UNSIGNED NOT NULL,
  `table` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL COMMENT '1 for dynamic (rows can be added), 2 for static (only editable)'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tables`
--

INSERT INTO `tables` (`id`, `table`, `type`) VALUES
(1, 'homepage_text', 2),
(2, 'about_text', 2),
(3, 'services_text', 2),
(4, 'team_members', 1),
(5, 'client_testimonials', 1),
(7, 'resources_categories', 1),
(8, 'resources', 1),
(9, 'homepage_image', 2),
(10, 'social_icons', 1),
(11, 'page_titles', 2);

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

--
-- Table structure for table `team_members`
--

CREATE TABLE `team_members` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL,
  `text` text NOT NULL,
  `image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `team_members`
--

INSERT INTO `team_members` (`id`, `title`, `position`, `text`, `image`) VALUES
(1, 'Chérine Debbas', 'Co-Founder', 'Chérine Debbas is a family business advisor and an executive coach. Her area of expertise is in family and corporate governance as well as in executive and systemic coaching. She brings her skills, experience and passion to support her clients in delivering on their objectives.\r\nChérine also serves her family’s 100-year old business in the capacity of corporate secretary and board member. She experienced first hand the joys and challenges of growing up in a family business.\r\nChérine has also worked for a leading multinational firm where she held several positions in marketing and human resources.\r\nChérine is certified as a Professional Co-active Coach (CPCC), in Organization and Relationship Systems Coaching (ORSCC) and also as a Senior Professional in Human Resources (SPHR). She also holds a Master of Science in Management from HEC France.', 'team-member-1.png'),
(2, 'Arthur Lestrange', 'Co-Founder', 'Arthur Lestrange is an educator, dramatist, and researcher in the field of applied linguistics and coaching. After a rich experience in the field of teaching (Drama, English, French), he became a member of an international traveling theatre company before founding his own performing arts entity. He has devised and directed festive and immersive performances in Europe and Africa for children and adults, dancers and musicians, actors and performers from all walks of life. Today, with Chérine Debbas, he is co-creating a new inventive force in the field of consulting and coaching to bring an empowering and transformational experience to their clients.\r\n', 'team-member-2.png');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about_text`
--
ALTER TABLE `about_text`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `client_testimonials`
--
ALTER TABLE `client_testimonials`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `columns`
--
ALTER TABLE `columns`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;
--
-- AUTO_INCREMENT for table `homepage_image`
--
ALTER TABLE `homepage_image`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `homepage_text`
--
ALTER TABLE `homepage_text`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `page_titles`
--
ALTER TABLE `page_titles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
--
-- AUTO_INCREMENT for table `positions`
--
ALTER TABLE `positions`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `relationships`
--
ALTER TABLE `relationships`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `resources`
--
ALTER TABLE `resources`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `resources_categories`
--
ALTER TABLE `resources_categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `services_text`
--
ALTER TABLE `services_text`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `social_icons`
--
ALTER TABLE `social_icons`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `tables`
--
ALTER TABLE `tables`
  MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `team_members`
--
ALTER TABLE `team_members`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
