Файловый менеджер - Редактировать - /home/fenix/domains/fenixsportsassociation.com/public_html/database/fenixacademy.sql
Назад
-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Oct 27, 2023 at 02:26 AM -- Server version: 10.4.25-MariaDB -- PHP Version: 8.1.10 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: `fenixacademy` -- -- -------------------------------------------------------- -- -- Table structure for table `eventphoto` -- CREATE TABLE `eventphoto` ( `id` int(11) NOT NULL, `image` varchar(500) NOT NULL, `cid` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Table structure for table `events` -- CREATE TABLE `events` ( `id` int(11) NOT NULL, `title` varchar(500) NOT NULL, `date` varchar(500) NOT NULL, `time` varchar(500) NOT NULL, `image` varchar(1500) NOT NULL, `content` varchar(2500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `events` -- INSERT INTO `events` (`id`, `title`, `date`, `time`, `image`, `content`) VALUES (1, 'Karate Fest', '2023-10-04', '08.00AM', 'img/karate-coaching.jpg', 'Karate Fest at Karaikudi'), (2, 'Archery Programme', '2023-10-03', '08.00AM', 'img/archery-training.jpg', 'Archery Program in Karaikudi'), (3, 'Silambam Fest', '2023-10-03', '08.00AM', 'img/silambam-training-in-karaikudi.jpg', 'Silambam Festival'), (4, 'Skating Programme', '2023-10-26', '08.00AM', 'img/skating-training.jpg', 'Skating Programme in Karaikudi'); -- -------------------------------------------------------- -- -- Table structure for table `gallery` -- CREATE TABLE `gallery` ( `id` int(11) NOT NULL, `content` varchar(1500) NOT NULL, `image` varchar(500) NOT NULL, `cid` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `gallery` -- INSERT INTO `gallery` (`id`, `content`, `image`, `cid`) VALUES (1, 'Silambam', 'img/silambam-training-in-karaikudi.jpg', '1'), (2, 'Archery', 'img/archery-training.jpg', '2'), (3, 'Air Rifle', 'img/air-rifle.jpg', '3'), (4, 'Air Rifle', 'img/air-rifle-coaching.jpg', '3'), (5, 'Air Rifle', 'img/air-rifle-training-in-karaikudi.jpg', '3'), (6, 'Karate', 'img/karate-coaching.jpg', '4'), (7, 'Karate', 'img/karate-training.jpg', '4'), (8, 'Skating', 'img/skate.jpg', '5'); -- -------------------------------------------------------- -- -- Table structure for table `gallery_category` -- CREATE TABLE `gallery_category` ( `id` int(11) NOT NULL, `category` varchar(500) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `gallery_category` -- INSERT INTO `gallery_category` (`id`, `category`) VALUES (1, 'Silambam'), (2, 'Archery'), (3, 'Air Rifle'), (4, 'Karate'), (5, 'Skating'); -- -------------------------------------------------------- -- -- 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=latin1; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `username`, `password`) VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3'); -- -- Indexes for dumped tables -- -- -- Indexes for table `eventphoto` -- ALTER TABLE `eventphoto` 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 `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 `eventphoto` -- ALTER TABLE `eventphoto` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT; -- -- 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=9; -- -- AUTO_INCREMENT for table `gallery_category` -- ALTER TABLE `gallery_category` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- 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 */;
| ver. 1.4 |
Github
|
.
| PHP 8.1.28 | Генерация страницы: 0 |
proxy
|
phpinfo
|
Настройка