1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / msk /
Filename : projects_msk (1).sql
back
-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 08, 2024 at 01:44 PM
-- Server version: 10.4.27-MariaDB
-- PHP Version: 7.4.33

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

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

--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `number` varchar(255) NOT NULL,
  `message` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `create_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `name`, `email`, `number`, `message`, `status`, `create_at`) VALUES
(1, 'yukesh kumar', 'yukeshaddobyte@gmail.com', '6356458915', 'msk party', '1', '2024-03-27 09:29:26');

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

--
-- Table structure for table `events`
--

CREATE TABLE `events` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `content` longtext NOT NULL,
  `image` varchar(255) NOT NULL,
  `events` varchar(255) NOT NULL,
  `date` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `create_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `title`, `content`, `image`, `events`, `date`, `status`, `create_at`) VALUES
(1, 'Protest protest against Somasundaram sports promotion', 'For more than 60 years, families living in and around the Nagar have been playing football and soccer at the Nagar Somasundaram playground. We request the families living in and around the city to fix the Nagar Somasundaram Sports Complex..Somasundaram protest for the maintenance of the ground protest against the attention of the government and municipal authorities who are showing reluctance despite many petitions, until the ground is repaired.Somasundaram protest for the maintenance of the ground protest against the attention of the government and municipal authorities who are showing reluctance despite many petitions, until the ground is repaired.Somasundaram protest for the maintenance of the ground protest against the attention of the government and municipal authorities who are showing reluctance despite many petitions, until the ground is repaired. Fix it! Fix it!.For more than 30 years, families living in and around the Nagar have been playing football and soccer at the Nagar Somasundaram playground. We request the families living in and around the city to fix the Nagar Somasundaram Sports Complex.', '13700450031692487401.jpg', '660b9de404832.jpg,660b9de404b3f.jpg,660b9de404e3f.jpg', '2014-02-16', '1', '2024-04-02 05:55:48'),
(2, 'Alternative financial aid', 'Micro-dots:\r\n\r\nAchieving rich academic, community service, and empowered activities for high school students.\r\nSites like Raise Me can play on college credit bars in the mornings students reach for them.\r\nCourse Credit Options:\r\n\r\nBlock loan options are available for courses such as high school studies above the age of eighteen.\r\nStates that achieve the rules and honored statuses will attain its set as gambling.\r\nJob Structure Loan Options:\r\n\r\nMany popular companies offer read permission in their orders.\r\nIt would be reasonable to give them permission to do a list of work while studying.\r\nLoan options used on education:\r\n\r\nPrincipal credit options for non-enrollment courses may provide credit for courses with experience.\r\nArt and life also take place in language.\r\nLoan options for eighteen uses:\r\n\r\nEighteen useful loan options can provide loans for courses with a wealth of experience.\r\nStates that achieve a set of eighteen benefits while studying', '170745786394593366.jpg', '660ba824cf80c.jpg,660ba824cfad8.jpg', '2009-08-28', '1', '2024-04-02 06:39:32'),
(3, 'Gandhian Sasi Perumal\'s ninaivu anjali', 'Police argue with protesters who protested against late Gandhian Sasi Perumal\'s ninaivu anjali meeting near Marina Gandhi.', '12695464851425890736.jpg', '660badc0c5d67.jpg,660badc0c619c.jpg,660badc0c659f.jpg', '2015-08-04', '1', '2024-04-02 07:03:28'),
(4, 'sasiperumal memory', 'Chennai court has issued a ban on driving motorized fish carts. Cancel the ban on motorized fish carts We have sent a letter to the Hon\'ble Chief Minister of Tamil Nadu.', '14448113081136862555.jpg', '660bb3159cefc.jpg,660bb3159d1de.jpg,660bb3159d478.jpg,660bb3159d7b1.jpg', '2016-08-28', '1', '2024-04-02 07:26:13');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `id` int(11) NOT NULL,
  `description` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `create_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`id`, `description`, `image`, `status`, `create_at`) VALUES
(1, 'Somasundaram sports drama', '193247495583664909.jpg', '1', '2024-03-27 12:49:10'),
(2, 'Somasundaram sports drama', '11663293231037333781.jpg', '1', '2024-03-27 12:49:51'),
(3, 'Somasundaram sports drama', '13868980421949370348.jpg', '1', '2024-03-27 12:50:23'),
(4, 'Somasundaram sports drama', '118301868020508005.jpg', '1', '2024-03-27 12:50:45'),
(5, 'differently abled Financial Assistance', '18268266311374396015.jpg', '1', '2024-03-27 12:52:27'),
(6, 'differently abled Financial Assistance', '6824460382089319535.jpg', '1', '2024-03-27 12:52:37'),
(7, 'differently abled Financial Assistance', '1057791378862794588.jpg', '1', '2024-03-27 12:52:46'),
(8, 'Abdul Kalam Memories', '1114863124817870766.jpg', '1', '2024-03-27 12:57:33'),
(9, 'Abdul Kalam Memories', '10922047052144806323.jpg', '1', '2024-03-27 12:57:57'),
(10, 'Abdul Kalam Memories', '2834037651424534894.jpg', '1', '2024-03-27 12:58:06'),
(11, 'Abdul Kalam Memories', '656831456692645870.jpg', '1', '2024-03-27 12:58:18'),
(12, 'Abdul Kalam Memories', '10080036031313243860.jpg', '1', '2024-03-27 12:58:42'),
(13, 'Abdul Kalam Memories', '1870065486552460181.jpg', '1', '2024-03-27 12:58:49'),
(14, 'Abdul Kalam Memories', '1394629242079300772.jpg', '1', '2024-03-27 12:58:57'),
(15, 'In memory of Sasiperumal', '1755641268979847700.jpg', '1', '2024-03-27 13:03:34'),
(16, 'In memory of Sasiperumal', '860471883970769310.jpg', '1', '2024-03-27 13:03:52'),
(17, 'In memory of Sasiperumal', '14476684841899420689.jpg', '1', '2024-03-27 13:04:05'),
(18, 'In memory of Sasiperumal', '19356676261782370830.jpg', '1', '2024-03-27 13:05:13'),
(19, 'In memory of Sasiperumal', '20544775611941397432.jpg', '1', '2024-03-27 13:05:27'),
(20, 'Sasiperumal is afraid of Madhu Villa India', '13794417071592956941.jpg', '1', '2024-03-27 13:16:30'),
(21, 'Sasiperumal is afraid of Madhu Villa India', '11550540901540214812.jpg', '1', '2024-03-27 13:16:48'),
(22, 'Sasiperumal is afraid of Madhu Villa India', '17018927491910276300.jpg', '1', '2024-03-27 13:16:57'),
(23, 'Financial assistance to women', '11074960261812832649.jpg', '1', '2024-03-27 13:21:31'),
(24, 'Financial assistance to women', '586135555319332048.jpg', '1', '2024-03-27 13:21:40'),
(25, 'Financial assistance to women', '1205640211561611967.jpg', '1', '2024-03-27 13:21:54'),
(26, 'Financial assistance to women', '9709363581312444151.jpg', '1', '2024-03-27 13:22:05'),
(27, 'Financial assistance to women', '1913432824959629.jpg', '1', '2024-03-27 13:22:15'),
(28, 'Inauguration of Auto Stand', '16754594381925982483.jpg', '1', '2024-03-27 13:25:39'),
(29, 'Inauguration of Auto Stand', '2107188151978513728.jpg', '1', '2024-03-27 13:25:49'),
(30, 'Inauguration of Auto Stand', '1934713727382391056.jpg', '1', '2024-03-27 13:26:01'),
(31, 'Inauguration of Auto Stand', '867630995923651539.jpg', '0', '2024-03-27 13:26:21'),
(32, 'Abdul Kalam Memories', '868913779431567311.jpeg', '1', '2024-03-30 04:55:14'),
(33, 'Abdul Kalam Memories', '2044083028710383359.jpeg', '1', '2024-03-30 05:18:23'),
(34, 'Abdul Kalam Memories', '8328419891878387799.jpeg', '1', '2024-03-30 05:18:32'),
(35, 'Abdul Kalam Memories', '14834157581653806288.jpeg', '1', '2024-03-30 05:18:40'),
(36, 'Traffic Ramasamy', '880850380712752101.jpeg', '1', '2024-03-30 05:24:08');

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

--
-- Table structure for table `login`
--

CREATE TABLE `login` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `create_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `login`
--

INSERT INTO `login` (`id`, `username`, `password`, `create_at`) VALUES
(1, 'admin', 'pass@123', '2024-03-22 11:26:00');

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

--
-- Table structure for table `members`
--

CREATE TABLE `members` (
  `id` int(11) NOT NULL,
  `fullname` varchar(255) DEFAULT NULL,
  `ward_no` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `age` varchar(255) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `gender` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `create_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `members`
--

INSERT INTO `members` (`id`, `fullname`, `ward_no`, `email`, `phone`, `age`, `address`, `gender`, `status`, `create_at`) VALUES
(1, 'yukesh kumar', '233', 'yukeshaddobyte@gmail.com', '634578594', '23', 'vadapalani,,chennai', 'male', '1', '2024-03-25 10:42:46'),
(2, 'testing', '233', 'testing@gmail.com', '9768452345', '10', 'vadapalani,,chennai', 'male', '1', '2024-03-29 12:19:37'),
(3, 'water quality/lab', '233', 'yukeshaddobyte@gmail.com', '5484564218', '15', 'vadapalani,,chennai', 'male', '1', '2024-03-29 12:20:49');

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

--
-- Table structure for table `petition`
--

CREATE TABLE `petition` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `ward_no` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `message` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `create_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `petition`
--

INSERT INTO `petition` (`id`, `name`, `ward_no`, `mobile`, `message`, `image`, `status`, `create_at`) VALUES
(1, 'testing', '11', '6545895645', 'water problem', '10410591801295556594.jpg', '1', '2024-03-28 12:59:16');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `gallery`
--
ALTER TABLE `gallery`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `login`
--
ALTER TABLE `login`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `petition`
--
ALTER TABLE `petition`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
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 */;