INTRODUCING THE CONTACTS DATABASE

 Copy  this code and execute/import it in your database.

-- phpMyAdmin SQL Dump

-- version 5.2.0

-- https://www.phpmyadmin.net/

--

-- Host: 127.0.0.1

-- Generation Time: Sep 23, 2024 at 06:22 PM

-- Server version: 10.4.24-MariaDB

-- PHP Version: 8.1.6

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: `dbcontacts`

--

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

--

-- Table structure for table `tblcontacts`

--

CREATE TABLE `tblcontacts` (

  `contact_id` int(11) NOT NULL,

  `contact_userId` int(11) NOT NULL,

  `contact_name` varchar(100) NOT NULL,

  `contact_phone` varchar(15) NOT NULL,

  `contact_email` varchar(100) NOT NULL,

  `contact_address` varchar(100) NOT NULL,

  `contact_group` int(11) NOT NULL,

  `contact_image` varchar(50) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--

-- Table structure for table `tblgroups`

--

CREATE TABLE `tblgroups` (

  `grp_id` int(11) NOT NULL,

  `grp_name` varchar(100) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--

-- Table structure for table `tblusers`

--

CREATE TABLE `tblusers` (

  `usr_id` int(11) NOT NULL,

  `usr_username` varchar(30) NOT NULL,

  `usr_password` varchar(30) NOT NULL,

  `usr_fullname` varchar(60) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--

-- Indexes for dumped tables

--

--

-- Indexes for table `tblcontacts`

--

ALTER TABLE `tblcontacts`

  ADD PRIMARY KEY (`contact_id`),

  ADD KEY `ndxUserId` (`contact_userId`),

  ADD KEY `ndGroup` (`contact_group`);

--

-- Indexes for table `tblgroups`

--

ALTER TABLE `tblgroups`

  ADD PRIMARY KEY (`grp_id`);

--

-- Indexes for table `tblusers`

--

ALTER TABLE `tblusers`

  ADD PRIMARY KEY (`usr_id`),

  ADD UNIQUE KEY `ndxUsername` (`usr_username`);

--

-- AUTO_INCREMENT for dumped tables

--

--

-- AUTO_INCREMENT for table `tblcontacts`

--

ALTER TABLE `tblcontacts`

  MODIFY `contact_id` int(11) NOT NULL AUTO_INCREMENT;

--

-- AUTO_INCREMENT for table `tblgroups`

--

ALTER TABLE `tblgroups`

  MODIFY `grp_id` int(11) NOT NULL AUTO_INCREMENT;

--

-- AUTO_INCREMENT for table `tblusers`

--

ALTER TABLE `tblusers`

  MODIFY `usr_id` int(11) NOT NULL AUTO_INCREMENT;

--

-- Constraints for dumped tables

--

--

-- Constraints for table `tblcontacts`

--

ALTER TABLE `tblcontacts`

  ADD CONSTRAINT `tblcontacts_ibfk_1` FOREIGN KEY (`contact_userId`) REFERENCES `tblusers` (`usr_id`),

  ADD CONSTRAINT `tblcontacts_ibfk_2` FOREIGN KEY (`contact_group`) REFERENCES `tblgroups` (`grp_id`) ON DELETE NO ACTION ON UPDATE NO ACTION;

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