]]jkjjgdjffksdkdfdkfjgsldkfhgjkgjkhjkgjkdascxvxcvxcvjdklfgjslkdfgjlskdfgjdskfgj

-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jun 24, 2023 at 08:31 AM -- Server version: 10.4.21-MariaDB -- PHP Version: 8.0.12 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: `xavier_bls` -- -- -------------------------------------------------------- -- -- Table structure for table `bannertab` -- CREATE TABLE `bannertab` ( `id` int(100) NOT NULL, `nimg` varchar(100) NOT NULL, `imgfile` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `bannertab` -- INSERT INTO `bannertab` (`id`, `nimg`, `imgfile`) VALUES (50, 'Xavier High School Balasore', 'sld6.jpg'), (51, 'Xavier High School Balasore', 'sld7.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `contacttab` -- CREATE TABLE `contacttab` ( `id` int(100) NOT NULL, `coname` varchar(100) NOT NULL, `cophone` varchar(100) NOT NULL, `coemail` varchar(100) NOT NULL, `cosub` varchar(255) NOT NULL, `comes` varchar(5000) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -------------------------------------------------------- -- -- Table structure for table `fboard` -- CREATE TABLE `fboard` ( `id` int(100) NOT NULL, `fimg` varchar(250) NOT NULL, `fname` varchar(100) NOT NULL, `des` varchar(100) NOT NULL, `qual` varchar(100) NOT NULL, `exp` varchar(100) NOT NULL, `specia` varchar(250) NOT NULL, `mob` varchar(250) NOT NULL, `email` varchar(250) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `fboard` -- INSERT INTO `fboard` (`id`, `fimg`, `fname`, `des`, `qual`, `exp`, `specia`, `mob`, `email`) VALUES (91, 'prii.png', 'Prasanta Kumar Nayak', 'Principal', 'Mtech', '10 years', 'English', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `gallerytab` -- CREATE TABLE `gallerytab` ( `id` int(100) NOT NULL, `nimg` varchar(100) NOT NULL, `fileimg` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `gallerytab` -- INSERT INTO `gallerytab` (`id`, `nimg`, `fileimg`) VALUES (87, 'Xavier High School Balasore', 'p1.jpg'), (88, 'Xavier High School Balasore', 'p2.jpg'), (89, 'Xavier High School Balasore', 'p5.jpg'), (90, 'Xavier High School Balasore', 'p6.jpg'), (91, 'Xavier High School Balasore', 'p8.jpg'), (92, 'Xavier High School Balasore', 'p10.jpg'), (93, 'Xavier High School Balasore', 'p12.jpg'), (94, 'Xavier High School Balasore', 'p13.jpg'), (95, 'Xavier High School Balasore', 'p46.jpg'), (98, 'Xavier High School Balasore', 'p39.JPG'), (99, 'Xavier High School Balasore', 'p36.JPG'), (100, 'Xavier High School Balasore', 'p33.JPG'), (101, 'Xavier High School Balasore', 'p22.JPG'), (102, 'Xavier High School Balasore', 'p27.jpg'), (103, 'Xavier High School Balasore', 'p43.jpg'); -- -------------------------------------------------------- -- -- Table structure for table `nboard` -- CREATE TABLE `nboard` ( `id` int(100) NOT NULL, `date` varchar(255) NOT NULL, `ntext` varchar(200) NOT NULL, `nurl` varchar(200) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `nboard` -- INSERT INTO `nboard` (`id`, `date`, `ntext`, `nurl`) VALUES (18, '22/04/2022', 'Welcome to Xaviers ', ''); -- -------------------------------------------------------- -- -- Table structure for table `publicdis` -- CREATE TABLE `publicdis` ( `id` int(100) NOT NULL, `pdsl` varchar(100) NOT NULL, `pdsub` varchar(100) NOT NULL, `pdurl` varchar(100) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `publicdis` -- INSERT INTO `publicdis` (`id`, `pdsl`, `pdsub`, `pdurl`) VALUES (7, '1', 'SCHOOL DETAILS', 'SCHHOL-DETAILS.pdf'), (9, '2', 'ADDITIONAL-INFORMATION', 'ADDITIONAL-INFORMATION.pdf'), (10, '3', 'AFFILATION LETTER', 'AFFILATION-LATTER.pdf'), (11, '4', 'BUILDIND SEFTY CERTIFICATE', 'BUILDIND-SEFTY -CERTIFICARE.pdf'), (12, '5', 'BUILDING PLAN', 'BUILDING-PLAN.pdf'), (13, '6', 'CERTIFICATE OF LAND', 'CERTIFICATE-OF-LAND.pdf'), (14, '7', 'COR', 'COR.pdf'), (15, '8', 'FACULTY DETAILS', 'FACULTY DETAILS.pdf'), (16, '9', 'FEE STRCTURE', 'Fee structure.pdf'), (17, '10', 'LOCATION DETAILS', 'location details.pdf'), (18, '11', 'MID-DAY-MEAL-INFORMATION', 'MID-DAY-MEAL-INFORMATION.pdf'), (19, '12', 'PHYSICAL-FACILITIES-AND-EQUIPMENTS', 'PHYSICAL-FACILITIES-AND-EQUIPMENTS.pdf'), (20, '13', 'SELECT-SUBJECTS-OFFERED-IN-OUR-SCHOOL', 'SELECT SUBJECTS OFFERED IN YOUR SCHOOL.pdf'), (21, '14', 'STUDENT DETAILS', 'Student-details.pdf'), (22, '15', 'TRUST-DEED', 'TRUST-DEED.pdf'), (23, '16', 'VITAL INFORMATION', 'VITAL INFORMATION.pdf'), (24, '17', 'STAFF DETAILS', 'STAFF-DETAILS-1.pdf'), (25, '17', 'STAFF DETAILS', 'STAFF-DETAILS-1.pdf'), (26, '18', 'TC DETAILS', 'TC-DETAILS.pdf'), (27, '19', 'CORRESPONDENT DETAIL AND SMC', 'amc.pdf'); -- -------------------------------------------------------- -- -- Table structure for table `register` -- CREATE TABLE `register` ( `id` int(11) NOT NULL, `username` varchar(50) CHARACTER SET latin1 NOT NULL, `email` varchar(50) CHARACTER SET latin1 NOT NULL, `password` varchar(50) CHARACTER SET latin1 NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Dumping data for table `register` -- INSERT INTO `register` (`id`, `username`, `email`, `password`) VALUES (7, 'Xavier Balasore', 'admin@stxaviersbalasore.com', 'xavierbls@123'); -- -- Indexes for dumped tables -- -- -- Indexes for table `bannertab` -- ALTER TABLE `bannertab` ADD PRIMARY KEY (`id`); -- -- Indexes for table `contacttab` -- ALTER TABLE `contacttab` ADD PRIMARY KEY (`id`); -- -- Indexes for table `fboard` -- ALTER TABLE `fboard` ADD PRIMARY KEY (`id`); -- -- Indexes for table `gallerytab` -- ALTER TABLE `gallerytab` ADD PRIMARY KEY (`id`); -- -- Indexes for table `nboard` -- ALTER TABLE `nboard` ADD PRIMARY KEY (`id`); -- -- Indexes for table `publicdis` -- ALTER TABLE `publicdis` ADD PRIMARY KEY (`id`); -- -- Indexes for table `register` -- ALTER TABLE `register` ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `usertype` (`id`,`username`,`email`,`password`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `bannertab` -- ALTER TABLE `bannertab` MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52; -- -- AUTO_INCREMENT for table `contacttab` -- ALTER TABLE `contacttab` MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT for table `fboard` -- ALTER TABLE `fboard` MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=93; -- -- AUTO_INCREMENT for table `gallerytab` -- ALTER TABLE `gallerytab` MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=105; -- -- AUTO_INCREMENT for table `nboard` -- ALTER TABLE `nboard` MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT for table `publicdis` -- ALTER TABLE `publicdis` MODIFY `id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28; -- -- AUTO_INCREMENT for table `register` -- ALTER TABLE `register` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; 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 */;