-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jun 10, 2024 at 08:45 AM
-- Server version: 10.3.39-MariaDB
-- PHP Version: 8.1.28

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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: `webduckserver_fgm`
--

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

--
-- Table structure for table `Admin`
--

CREATE TABLE `Admin` (
  `admin_nbr` int(10) UNSIGNED NOT NULL,
  `admin_fname` text NOT NULL,
  `admin_lname` text NOT NULL,
  `admin_title` text NOT NULL,
  `admin_permission` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `admin_email` text NOT NULL,
  `admin_pass` text NOT NULL,
  `admin_time` int(11) NOT NULL DEFAULT 0,
  `admin_status` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `Admin`
--

INSERT INTO `Admin` (`admin_nbr`, `admin_fname`, `admin_lname`, `admin_title`, `admin_permission`, `admin_email`, `admin_pass`, `admin_time`, `admin_status`) VALUES
(3, 'Tait', 'Chambers', 'Web Developer', 2, 'tait@webduckdesigns.com', 'd033e22ae348aeb5660fc2140aec35850c4da997', 1203797740, 1);

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

--
-- Table structure for table `Admin_Categories`
--

CREATE TABLE `Admin_Categories` (
  `admin_category_nbr` int(11) NOT NULL,
  `admin_category_name` text NOT NULL,
  `admin_category_description` text NOT NULL,
  `admin_category_directory` text NOT NULL,
  `admin_category_page` text NOT NULL,
  `admin_category_status` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `Admin_Categories`
--

INSERT INTO `Admin_Categories` (`admin_category_nbr`, `admin_category_name`, `admin_category_description`, `admin_category_directory`, `admin_category_page`, `admin_category_status`) VALUES
(1, 'Navigation', 'Functions to manipulate the admin panel navigation categories and options', 'navigation', 'navigation.php', 1),
(2, 'Admin', 'Administrative options for managing virtual talent marketplace website administrators', 'administrative', 'administrative.php', 1),
(20, 'Gallery', 'Manage the website photo gallery', 'gallery', 'gallery.php', 1),
(21, 'CMS', 'Add, modify and delete content managed pages', 'content-manager', 'manage-pages.php', 1),
(30, 'FAQs', 'manage the faqs', 'faqs', 'manage-faqs.php', 1),
(31, 'Services', 'This is to manage the different services', 'services', 'manage-services.php', 1),
(32, 'Testimonials', 'This is to manage the client testimonials', 'testimonials', 'manage-testimonials.php', 1),
(33, 'Team', 'manage the staff or our team pages', 'staff', 'manage-staff.php', 1),
(34, 'Resources', 'Manage resources', 'resources', 'manage-resources.php', 1),
(37, 'Documents', 'Manage documents and uploads', 'documents', 'manage-documents.php', 1),
(38, 'Banners', 'manage home page banners', 'banners', 'manage-banners.php', 1),
(39, 'Events', 'Manage the events', 'events', 'manage-events.php', 1),
(40, 'Links', 'manage a links page', 'links', 'manage-links.php', 1);

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

--
-- Table structure for table `Admin_Options`
--

CREATE TABLE `Admin_Options` (
  `admin_option_nbr` int(11) NOT NULL,
  `admin_option_category` int(11) NOT NULL,
  `admin_option_name` text NOT NULL,
  `admin_option_description` text NOT NULL,
  `admin_option_page` text NOT NULL,
  `admin_option_visible` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `Admin_Options`
--

INSERT INTO `Admin_Options` (`admin_option_nbr`, `admin_option_category`, `admin_option_name`, `admin_option_description`, `admin_option_page`, `admin_option_visible`) VALUES
(1, 1, 'Add Category', 'Add a new category navigation link', 'add-category.php', 1),
(2, 1, 'Manage Categories', 'Modify / Delete navigation categories', 'manage-categories.php', 1),
(3, 1, 'Add Category Option', 'Add a new option to an existing navigation category', 'add-option.php', 1),
(4, 1, 'Manage Category Options', 'Modify / Delete navigation category options', 'manage-options.php', 1),
(5, 2, 'Manage Your Account Info', 'Options to change email address, password and other administrative account information', 'manage-account.php', 1),
(11, 2, 'Change Your Password', 'Change the password you use to log into the admin panel', 'change-password.php', 1),
(12, 2, 'Add New Administrator', 'Add a new administrator to the admin panel', 'add-administrator.php', 1),
(13, 2, 'Modify Administrator', 'Modify information for an administrator', 'modify-administrator.php', 1),
(14, 2, 'Manage Administrators', 'Mange all the admin administrators', 'manage-administrators.php', 1),
(15, 20, 'Add Photos', 'Add photos to the photo gallery', 'add-photos.php', 1),
(16, 20, 'Manage Photo Gallery', 'Mange the photos and albums of the photogallery', 'gallery.php', 1),
(17, 1, 'Add New Content Managed Page', 'Add a new content managed page', 'new-page.php', 1),
(35, 34, 'Resource Page Categories', 'manage the resource page categories', 'manage-categories.php', 1),
(37, 37, 'Document Categories', 'manage document categories', 'manage-categories.php', 1);

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

--
-- Table structure for table `Albums`
--

CREATE TABLE `Albums` (
  `album_nbr` int(10) UNSIGNED NOT NULL,
  `album_name` text NOT NULL,
  `album_date_created` int(11) NOT NULL,
  `album_display_image` int(11) NOT NULL,
  `album_status` tinyint(1) NOT NULL,
  `album_category` int(11) NOT NULL,
  `album_description` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `Albums`
--

INSERT INTO `Albums` (`album_nbr`, `album_name`, `album_date_created`, `album_display_image`, `album_status`, `album_category`, `album_description`) VALUES
(499, 'Album 1 Category 1', 1688581137, 0, 0, 39, ''),
(500, 'Album 2 Category 1', 1688581144, 0, 0, 39, ''),
(501, 'Album 3 Category 1', 1688581158, 0, 0, 39, ''),
(502, 'Album 4 Category 1', 1688581192, 0, 0, 39, ''),
(503, 'Album 5 Category 1', 1688581218, 0, 0, 39, ''),
(504, 'Album 1 Category 2', 1688581228, 0, 0, 40, ''),
(505, 'Album 1 Category 3', 1688581236, 0, 0, 41, ''),
(506, 'Album 1 Category 4', 1688581242, 0, 0, 42, ''),
(507, 'Album 1 Category 5', 1688581250, 0, 0, 43, '');

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

--
-- Table structure for table `Album_Categories`
--

CREATE TABLE `Album_Categories` (
  `album_category_nbr` int(10) UNSIGNED NOT NULL,
  `album_category_name` text NOT NULL,
  `album_category_status` tinyint(1) NOT NULL,
  `album_category_display_image` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `Album_Categories`
--

INSERT INTO `Album_Categories` (`album_category_nbr`, `album_category_name`, `album_category_status`, `album_category_display_image`) VALUES
(39, 'Test Category 1', 0, 0),
(40, 'Test Category 2', 0, 0),
(41, 'Test Category 3', 0, 0),
(42, 'Test Category 4', 0, 0),
(43, 'Test Category 5', 0, 0);

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

--
-- Table structure for table `Banners`
--

CREATE TABLE `Banners` (
  `banner_nbr` int(10) UNSIGNED NOT NULL,
  `banner_file` text NOT NULL,
  `banner_text` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `Documents`
--

CREATE TABLE `Documents` (
  `doc_nbr` int(10) UNSIGNED NOT NULL,
  `doc_category` int(11) NOT NULL,
  `doc_name` text NOT NULL,
  `doc_hidden` tinyint(1) NOT NULL,
  `doc_desc` text NOT NULL,
  `doc_file` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `Document_Categories`
--

CREATE TABLE `Document_Categories` (
  `doc_category_nbr` int(10) UNSIGNED NOT NULL,
  `doc_category_name` text NOT NULL,
  `doc_category_hidden` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `Events`
--

CREATE TABLE `Events` (
  `event_nbr` int(10) UNSIGNED NOT NULL,
  `event_name` text NOT NULL,
  `event_start_date` int(11) NOT NULL,
  `event_end_date` int(11) NOT NULL,
  `event_details` text NOT NULL,
  `event_image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `FAQs`
--

CREATE TABLE `FAQs` (
  `faq_nbr` int(10) UNSIGNED NOT NULL,
  `faq_category` int(11) NOT NULL,
  `faq_question` text NOT NULL,
  `faq_answer` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `FAQ_Categories`
--

CREATE TABLE `FAQ_Categories` (
  `faq_cat_nbr` int(10) UNSIGNED NOT NULL,
  `faq_cat_name` text NOT NULL,
  `faq_cat_img` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `Images`
--

CREATE TABLE `Images` (
  `image_nbr` int(10) UNSIGNED NOT NULL,
  `image_album` int(11) NOT NULL,
  `image_album_category` int(11) NOT NULL,
  `image_name` text NOT NULL,
  `image_desc` text NOT NULL,
  `image_status` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `Images`
--

INSERT INTO `Images` (`image_nbr`, `image_album`, `image_album_category`, `image_name`, `image_desc`, `image_status`) VALUES
(10025, 499, 39, '1688581503_3828.jpg', '', 1),
(10026, 499, 39, '1688581512_b1duck002.jpg', '', 1),
(10027, 499, 39, '1688581517_b3_birds002.jpg', '', 1),
(10028, 499, 39, '1688581525_baliice.jpg', '', 1),
(10029, 499, 39, '1688581531_bend-ducks-1.jpg', '', 1),
(10030, 499, 39, '1688581545_brooklyn_botanic_garden_ducks.jpg', '', 1),
(10031, 500, 39, '1688581563_draft_party_2008_041.JPG', '', 1),
(10032, 501, 39, '1688581577_draft_party_2008_043.JPG', '', 1),
(10033, 502, 39, '1688581590_draft_party_2008_047.JPG', '', 1),
(10034, 503, 39, '1688581613_duck_3.jpg', '', 1),
(10035, 504, 40, '1688581640_ducks_1920x1200.jpg', '', 1),
(10036, 505, 41, '1688581657_ducks69.jpg', '', 1),
(10037, 506, 42, '1688581677_GJR_3825_mchwtmk.jpg', '', 1),
(10038, 507, 43, '1688581709_iStock_000003206371Small.jpg', '', 1),
(10039, 499, 39, '1695668800_Wood.duck.750pix.jpg', 'Test', 1);

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

--
-- Table structure for table `Links`
--

CREATE TABLE `Links` (
  `link_nbr` int(10) UNSIGNED NOT NULL,
  `link_name` text NOT NULL,
  `link_desc` text NOT NULL,
  `link_link` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `Pages`
--

CREATE TABLE `Pages` (
  `page_nbr` int(10) UNSIGNED NOT NULL,
  `page_name` text NOT NULL,
  `page_title_tag` text NOT NULL,
  `page_keywords_tag` text NOT NULL,
  `page_description_tag` text NOT NULL,
  `page_content` blob NOT NULL,
  `page_date_created` int(11) NOT NULL,
  `page_status` tinyint(1) NOT NULL,
  `page_last_update` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `Pages`
--

INSERT INTO `Pages` (`page_nbr`, `page_name`, `page_title_tag`, `page_keywords_tag`, `page_description_tag`, `page_content`, `page_date_created`, `page_status`, `page_last_update`) VALUES
(7, 'Company Info', 'Company Name', 'keywords go here', '',  , 1674754676, 1, 1685480847),
(13, 'Policies', '', '', '', '', 0, 1, 0),
(9, 'Careers', 'Career Opportunites', '', 'description tag text here',  , 1674754693, 1, 1685480795);

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

--
-- Table structure for table `Resource_Categories`
--

CREATE TABLE `Resource_Categories` (
  `res_cat_nbr` int(10) UNSIGNED NOT NULL,
  `res_cat_name` text NOT NULL,
  `res_cat_image` text NOT NULL,
  `res_cat_url` text NOT NULL,
  `res_cat_status` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `Resource_Category_Resources`
--

CREATE TABLE `Resource_Category_Resources` (
  `res_cat_res_nbr` int(10) UNSIGNED NOT NULL,
  `res_cat_res_category` int(11) NOT NULL,
  `res_cat_res_resource` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `Resource_Pages`
--

CREATE TABLE `Resource_Pages` (
  `res_nbr` int(10) UNSIGNED NOT NULL,
  `res_name` text NOT NULL,
  `res_url` text NOT NULL,
  `res_keywords_tag` text NOT NULL,
  `res_description_tag` text NOT NULL,
  `res_content` text NOT NULL,
  `res_date_created` int(11) NOT NULL,
  `res_status` tinyint(1) NOT NULL,
  `res_last_update` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `Services`
--

CREATE TABLE `Services` (
  `service_nbr` int(10) UNSIGNED NOT NULL,
  `service_category` int(11) NOT NULL,
  `service_name` text NOT NULL,
  `service_url` text NOT NULL,
  `service_keywords_tag` text NOT NULL,
  `service_description_tag` text NOT NULL,
  `service_listing_description` text NOT NULL,
  `service_content` text NOT NULL,
  `service_img` text NOT NULL,
  `service_status` tinyint(1) NOT NULL,
  `service_gallery_album` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `Service_Categories`
--

CREATE TABLE `Service_Categories` (
  `service_category_nbr` int(10) UNSIGNED NOT NULL,
  `service_category_name` text NOT NULL,
  `service_category_url` text NOT NULL,
  `service_category_image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `Staff`
--

CREATE TABLE `Staff` (
  `staff_nbr` int(10) UNSIGNED NOT NULL,
  `staff_name` text NOT NULL,
  `staff_title` text NOT NULL,
  `staff_phone` text NOT NULL,
  `staff_email` text NOT NULL,
  `staff_img` text NOT NULL,
  `staff_bio` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `States`
--

CREATE TABLE `States` (
  `state_nbr` int(10) UNSIGNED NOT NULL,
  `state_name` text NOT NULL,
  `state_abbr` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `States`
--

INSERT INTO `States` (`state_nbr`, `state_name`, `state_abbr`) VALUES
(1, 'Alabama', 'AL'),
(2, 'Alaska', 'AK'),
(3, 'Arizona', 'AZ'),
(4, 'Arkansas', 'AR'),
(5, 'California', 'CA'),
(6, 'Colorado', 'CO'),
(7, 'Connecticut', 'CT'),
(8, 'Delaware', 'DE'),
(9, 'Florida', 'FL'),
(10, 'Georgia', 'GA'),
(11, 'Hawaii', 'HI'),
(12, 'Idaho', 'ID'),
(13, 'Illinois', 'IL'),
(14, 'Indiana', 'IN'),
(15, 'Iowa', 'IA'),
(16, 'Kansas', 'KS'),
(17, 'Kentucky', 'KY'),
(18, 'Louisiana', 'LA'),
(19, 'Maine', 'ME'),
(20, 'Maryland', 'MD'),
(21, 'Massachusetts', 'MA'),
(22, 'Michigan', 'MI'),
(23, 'Minnesota', 'MN'),
(24, 'Mississippi', 'MS'),
(25, 'Missouri', 'MO'),
(26, 'Montana', 'MT'),
(27, 'Nebraska', 'NE'),
(28, 'Nevada', 'NV'),
(29, 'New Hampshire', 'NH'),
(30, 'New Jersey', 'NJ'),
(31, 'New Mexico', 'NM'),
(32, 'New York', 'NY'),
(33, 'North Carolina', 'NC'),
(34, 'North Dakota', 'ND'),
(35, 'Ohio', 'OH'),
(36, 'Oklahoma', 'OK'),
(37, 'Oregon', 'OR'),
(38, 'Pennsylvania', 'PA'),
(39, 'Rhode Island', 'RI'),
(40, 'South Carolina', 'SC'),
(41, 'South Dakota', 'SD'),
(42, 'Tennessee', 'TN'),
(43, 'Texas', 'TX'),
(44, 'Utah', 'UT'),
(45, 'Vermont', 'VT'),
(46, 'Virginia', 'VA'),
(47, 'Washington', 'WA'),
(48, 'West Virginia', 'WV'),
(49, 'Wisconsin', 'WI'),
(50, 'Wyoming', 'WY'),
(51, 'District Of Columbia', 'DC'),
(52, 'Puerto Rico', 'PR'),
(53, 'Canada', 'CN');

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

--
-- Table structure for table `Testimonials`
--

CREATE TABLE `Testimonials` (
  `testimonial_nbr` int(10) UNSIGNED NOT NULL,
  `testimonial_info` text NOT NULL,
  `testimonial_name` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Admin`
--
ALTER TABLE `Admin`
  ADD PRIMARY KEY (`admin_nbr`);

--
-- Indexes for table `Admin_Categories`
--
ALTER TABLE `Admin_Categories`
  ADD PRIMARY KEY (`admin_category_nbr`);

--
-- Indexes for table `Admin_Options`
--
ALTER TABLE `Admin_Options`
  ADD PRIMARY KEY (`admin_option_nbr`);

--
-- Indexes for table `Albums`
--
ALTER TABLE `Albums`
  ADD PRIMARY KEY (`album_nbr`);

--
-- Indexes for table `Album_Categories`
--
ALTER TABLE `Album_Categories`
  ADD PRIMARY KEY (`album_category_nbr`);

--
-- Indexes for table `Banners`
--
ALTER TABLE `Banners`
  ADD PRIMARY KEY (`banner_nbr`);

--
-- Indexes for table `Documents`
--
ALTER TABLE `Documents`
  ADD PRIMARY KEY (`doc_nbr`);

--
-- Indexes for table `Document_Categories`
--
ALTER TABLE `Document_Categories`
  ADD PRIMARY KEY (`doc_category_nbr`);

--
-- Indexes for table `Events`
--
ALTER TABLE `Events`
  ADD PRIMARY KEY (`event_nbr`);

--
-- Indexes for table `FAQs`
--
ALTER TABLE `FAQs`
  ADD PRIMARY KEY (`faq_nbr`);

--
-- Indexes for table `FAQ_Categories`
--
ALTER TABLE `FAQ_Categories`
  ADD PRIMARY KEY (`faq_cat_nbr`);

--
-- Indexes for table `Images`
--
ALTER TABLE `Images`
  ADD PRIMARY KEY (`image_nbr`);

--
-- Indexes for table `Links`
--
ALTER TABLE `Links`
  ADD PRIMARY KEY (`link_nbr`);

--
-- Indexes for table `Pages`
--
ALTER TABLE `Pages`
  ADD PRIMARY KEY (`page_nbr`);

--
-- Indexes for table `Resource_Categories`
--
ALTER TABLE `Resource_Categories`
  ADD PRIMARY KEY (`res_cat_nbr`);

--
-- Indexes for table `Resource_Category_Resources`
--
ALTER TABLE `Resource_Category_Resources`
  ADD PRIMARY KEY (`res_cat_res_nbr`);

--
-- Indexes for table `Resource_Pages`
--
ALTER TABLE `Resource_Pages`
  ADD PRIMARY KEY (`res_nbr`);

--
-- Indexes for table `Services`
--
ALTER TABLE `Services`
  ADD PRIMARY KEY (`service_nbr`);

--
-- Indexes for table `Service_Categories`
--
ALTER TABLE `Service_Categories`
  ADD PRIMARY KEY (`service_category_nbr`);

--
-- Indexes for table `Staff`
--
ALTER TABLE `Staff`
  ADD PRIMARY KEY (`staff_nbr`);

--
-- Indexes for table `States`
--
ALTER TABLE `States`
  ADD PRIMARY KEY (`state_nbr`);

--
-- Indexes for table `Testimonials`
--
ALTER TABLE `Testimonials`
  ADD PRIMARY KEY (`testimonial_nbr`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `Admin`
--
ALTER TABLE `Admin`
  MODIFY `admin_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `Admin_Categories`
--
ALTER TABLE `Admin_Categories`
  MODIFY `admin_category_nbr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=41;

--
-- AUTO_INCREMENT for table `Admin_Options`
--
ALTER TABLE `Admin_Options`
  MODIFY `admin_option_nbr` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `Albums`
--
ALTER TABLE `Albums`
  MODIFY `album_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=508;

--
-- AUTO_INCREMENT for table `Album_Categories`
--
ALTER TABLE `Album_Categories`
  MODIFY `album_category_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;

--
-- AUTO_INCREMENT for table `Banners`
--
ALTER TABLE `Banners`
  MODIFY `banner_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `Documents`
--
ALTER TABLE `Documents`
  MODIFY `doc_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `Document_Categories`
--
ALTER TABLE `Document_Categories`
  MODIFY `doc_category_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `Events`
--
ALTER TABLE `Events`
  MODIFY `event_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `FAQs`
--
ALTER TABLE `FAQs`
  MODIFY `faq_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `FAQ_Categories`
--
ALTER TABLE `FAQ_Categories`
  MODIFY `faq_cat_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `Images`
--
ALTER TABLE `Images`
  MODIFY `image_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10040;

--
-- AUTO_INCREMENT for table `Links`
--
ALTER TABLE `Links`
  MODIFY `link_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `Pages`
--
ALTER TABLE `Pages`
  MODIFY `page_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `Resource_Categories`
--
ALTER TABLE `Resource_Categories`
  MODIFY `res_cat_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `Resource_Category_Resources`
--
ALTER TABLE `Resource_Category_Resources`
  MODIFY `res_cat_res_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=178;

--
-- AUTO_INCREMENT for table `Resource_Pages`
--
ALTER TABLE `Resource_Pages`
  MODIFY `res_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `Services`
--
ALTER TABLE `Services`
  MODIFY `service_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `Service_Categories`
--
ALTER TABLE `Service_Categories`
  MODIFY `service_category_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `Staff`
--
ALTER TABLE `Staff`
  MODIFY `staff_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT for table `States`
--
ALTER TABLE `States`
  MODIFY `state_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- AUTO_INCREMENT for table `Testimonials`
--
ALTER TABLE `Testimonials`
  MODIFY `testimonial_nbr` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
COMMIT;

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