| Server IP : 108.170.25.35 / Your IP : 52.15.37.74 Web Server : Apache/2 System : Linux gains.winzonesoftech.com 4.18.0-513.24.1.el8_9.x86_64 #1 SMP Mon Apr 8 11:23:13 EDT 2024 x86_64 User : teamspirit ( 1601) PHP Version : 8.1.28 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/teamspirit/domains/teamspiritacademy.com/private_html/database/ |
Upload File : |
-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jan 21, 2024 at 08:49 AM -- Server version: 10.4.24-MariaDB -- PHP Version: 7.4.29 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: `teamspirit` -- -- -------------------------------------------------------- -- -- Table structure for table `faculty` -- CREATE TABLE `faculty` ( `id` int(11) NOT NULL, `image` varchar(500) NOT NULL, `name` varchar(500) NOT NULL, `designation` varchar(500) NOT NULL, `pdf` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `faculty` -- INSERT INTO `faculty` (`id`, `image`, `name`, `designation`, `pdf`) VALUES (1, 'img/21-01-2024-1705820158-21-01-2024-1705820014-team-1.jpg', 'Miss. V.Priya', 'Maths Faculty', 'img/profile.pdf'); -- -------------------------------------------------------- -- -- Table structure for table `gallery` -- CREATE TABLE `gallery` ( `id` int(11) NOT NULL, `image` varchar(500) NOT NULL, `title` varchar(500) NOT NULL, `cid` varchar(500) NOT NULL, `createddate` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), `date` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `gallery` -- INSERT INTO `gallery` (`id`, `image`, `title`, `cid`, `createddate`, `date`) VALUES (1, 'img/infra.jpg', 'Infrastructures', '1', '2024-01-21 06:30:44', ''), (2, 'img/pongal.jpg', 'Pongal Festival ', '2', '2024-01-21 06:22:36', ''), (3, 'img/International-Womens-Day.webp', 'Womens Day ', '3', '2024-01-21 06:27:52', '2024-03-08'); -- -------------------------------------------------------- -- -- Table structure for table `gallery_category` -- CREATE TABLE `gallery_category` ( `id` int(11) NOT NULL, `category` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `gallery_category` -- INSERT INTO `gallery_category` (`id`, `category`) VALUES (1, 'Campus Infrastructure'), (2, 'Festival Celebration '), (3, 'Events'); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE `user` ( `id` int(11) NOT NULL, `username` varchar(500) NOT NULL, `password` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `username`, `password`) VALUES (1, 'admin', '62d0e988002d5842f248b86fb4af88bf'); -- -- Indexes for dumped tables -- -- -- Indexes for table `faculty` -- ALTER TABLE `faculty` ADD PRIMARY KEY (`id`); -- -- Indexes for table `gallery` -- ALTER TABLE `gallery` ADD PRIMARY KEY (`id`); -- -- Indexes for table `gallery_category` -- ALTER TABLE `gallery_category` ADD PRIMARY KEY (`id`); -- -- Indexes for table `user` -- ALTER TABLE `user` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `faculty` -- ALTER TABLE `faculty` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `gallery` -- ALTER TABLE `gallery` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `gallery_category` -- ALTER TABLE `gallery_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4; -- -- AUTO_INCREMENT for table `user` -- ALTER TABLE `user` 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 */;