-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Dec 02, 2024 at 02:12 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.1.25

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

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

--
-- Table structure for table `google_sheets`
--

CREATE TABLE `google_sheets` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `style_option` varchar(15) NOT NULL DEFAULT 'No Style Table',
  `style_header` text DEFAULT NULL,
  `style_first_column` text DEFAULT NULL,
  `style_general` text DEFAULT NULL,
  `table_id` varchar(255) DEFAULT NULL,
  `colored_values` tinyint(1) DEFAULT 0,
  `custom_code` text DEFAULT NULL,
  `cache_expiration` int(11) DEFAULT 600
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `google_sheets`
--

INSERT INTO `google_sheets` (`id`, `title`, `link`, `style_option`, `style_header`, `style_first_column`, `style_general`, `table_id`, `colored_values`, `custom_code`, `cache_expiration`) VALUES
(5, 'loltoppcplayer', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vTuqzxOEbkXS6lTlx4Zl6b6AJRUqlxzJosozGDD95Ei2645bH_aRR1OV6jnjMRsTiOrMO98aOKeNjDh/pub?gid=201992263&single=true&output=csv', 'Styled Table', NULL, NULL, NULL, NULL, 0, NULL, 600),
(6, 'loltopplayer-ranks', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vTuqzxOEbkXS6lTlx4Zl6b6AJRUqlxzJosozGDD95Ei2645bH_aRR1OV6jnjMRsTiOrMO98aOKeNjDh/pub?gid=649228222&single=true&output=csv', 'Styled Table', NULL, NULL, NULL, NULL, 0, NULL, 600),
(9, 'lolranks3', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vTuqzxOEbkXS6lTlx4Zl6b6AJRUqlxzJosozGDD95Ei2645bH_aRR1OV6jnjMRsTiOrMO98aOKeNjDh/pub?gid=649228222&single=true&output=csv', 'Styled Table', '', '', '', NULL, 0, NULL, 600),
(10, 'no stype test', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vTuqzxOEbkXS6lTlx4Zl6b6AJRUqlxzJosozGDD95Ei2645bH_aRR1OV6jnjMRsTiOrMO98aOKeNjDh/pub?gid=1389901037&single=true&output=csv', 'Styled Table', '', '', '', NULL, 0, NULL, 600),
(14, 'rankspercentagelol', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vTuqzxOEbkXS6lTlx4Zl6b6AJRUqlxzJosozGDD95Ei2645bH_aRR1OV6jnjMRsTiOrMO98aOKeNjDh/pub?gid=44335791&single=true&output=csv', 'Styled Table', '', '', '', NULL, 0, NULL, 600),
(16, 'lolcurrentsession', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vTuqzxOEbkXS6lTlx4Zl6b6AJRUqlxzJosozGDD95Ei2645bH_aRR1OV6jnjMRsTiOrMO98aOKeNjDh/pub?gid=2089836871&single=true&output=csv', 'Styled Table', '', '', '', NULL, 0, NULL, 600),
(17, 'whensessionend', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vTuqzxOEbkXS6lTlx4Zl6b6AJRUqlxzJosozGDD95Ei2645bH_aRR1OV6jnjMRsTiOrMO98aOKeNjDh/pub?gid=1433384893&single=true&output=csv', 'No Style Table', '', '', '', NULL, 0, NULL, 600),
(18, 'lolnumber1player', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vTuqzxOEbkXS6lTlx4Zl6b6AJRUqlxzJosozGDD95Ei2645bH_aRR1OV6jnjMRsTiOrMO98aOKeNjDh/pub?gid=1389901037&single=true&output=csv', 'No Style Table', '', '', '', NULL, 0, '', 600),
(19, 'with image', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vSFf2ODyBFRuBh068j_2OSsqxF8Iivkik7zywzY4B5fw-kCUmA0FI4jHE7IglPCnqEdoIO8Zak06auV/pub?gid=1563178434&single=true&output=csv', 'No Style Table', '', '', '', NULL, 0, NULL, 600),
(20, 'lol ranks with image', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vTuqzxOEbkXS6lTlx4Zl6b6AJRUqlxzJosozGDD95Ei2645bH_aRR1OV6jnjMRsTiOrMO98aOKeNjDh/pub?gid=271770012&single=true&output=csv', 'Styled Table', 'background-color: #B30000;\r\ncolor: white !important;\r\ntext-align: center;\r\nfont-size:18px !important;', 'background-color: #ce8804;\r\ncolor: white;\r\nfont-family: \\\'Monomaniac One\\\', sans-serif;', '', NULL, 0, NULL, 600),
(21, 'MORTAL KOMBAT 11', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vREf92q8rNShzVYGQ3n99vU8DU-s8C6XlgK-MmovC4Gq4QI88fOuNh0IdBuaOv1U4H6I2c8gZdqfZcZ/pub?gid=477093561&single=true&output=csv', 'Styled Table', 'background-color: #B30000;\r\ncolor: white !important;\r\ntext-align: center;\r\n', 'background-color: #ce8804;\r\ncolor: white;', '', NULL, 1, NULL, 600),
(24, 'ROBLOX ID CODES', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vRdSVqq-iOyi5uVl_ot7gLzWHeGKTtwYamRWlhW89d8ghmdXLKM0MV6BEBNtvWkCA68H3MW6SK2NhW8/pub?gid=0&single=true&output=csv', 'Styled Table', 'background-color: #B30000;\r\ncolor: white !important;\r\nfont-size:18px !important;', '', '', NULL, 0, NULL, 600),
(25, 'ARIANA GRANDE ROBLOX ID', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vRdSVqq-iOyi5uVl_ot7gLzWHeGKTtwYamRWlhW89d8ghmdXLKM0MV6BEBNtvWkCA68H3MW6SK2NhW8/pub?gid=1319007927&single=true&output=csv', 'Styled Table', 'background-color: #B30000;\r\ncolor: white !important;\r\nfont-size:18px !important;', '', 'font-weight:bold;', NULL, 0, NULL, 600),
(26, 'Top Guns in Warzone 2', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQBDruFS2I0d_WwtK3RoKlSNthWkdotcpcTPl49jx6XOXZ8taDteXqa2yv6xWiH5ZyncDpRoSKWV9Xw/pub?gid=1508184044&single=true&output=csv', 'Styled Table', 'background-color: #B30000;\r\ncolor: white !important;\r\nfont-size:18px !important;', 'background-color: #ce8804;\r\ncolor: white;\r\nfont-weight:bold;\r\ntext-align:center;\r\n', 'font-family:\\\'Geologica\\\', sans-serif;\r\nfont-weight:bold;', NULL, 0, '<style>\r\ntable td img {\r\nfilter: invert(100%);\r\nwidth: 150px;\r\nheight:auto;\r\n}\r\n\r\n  #my-table-26 th {\r\nbackground-color: #B30000;\r\ncolor: white !important;\r\nfont-size:18px !important;\r\nfont-weight:bold;\r\n  }\r\n\r\n  /* Style for the first row */\r\n  #my-table-26 tr:first-child {\r\nbackground-color: #ce8804 !important;\r\ncolor: white !important;\r\nfont-weight:bold !important;\r\ntext-align:center !important;\r\n  }\r\n\r\n\r\n@media (max-width: 768px) {\r\ntable td img {\r\nfilter: invert(100%);\r\nwidth: 50px;\r\nheight:auto;\r\n}  \r\n}\r\n</style>', 600),
(27, 'top1 warzone', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQBDruFS2I0d_WwtK3RoKlSNthWkdotcpcTPl49jx6XOXZ8taDteXqa2yv6xWiH5ZyncDpRoSKWV9Xw/pub?gid=1887615479&single=true&output=csv', 'Styled Table', '', '', '', NULL, 0, '<style>\ntable th img {\nfilter: invert(100%);\nwidth: 150px;\nheight:auto;\n}\n@media (max-width: 768px) {\ntable td img {\nfilter: invert(100%);\nwidth: 50px;\nheight:auto;\n}  \n}\n</style>', 600),
(31, 'top-1-head', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQBDruFS2I0d_WwtK3RoKlSNthWkdotcpcTPl49jx6XOXZ8taDteXqa2yv6xWiH5ZyncDpRoSKWV9Xw/pub?gid=83548789&single=true&output=csv', 'No Style Table', '', '', '', NULL, 0, '', 1440),
(32, 'top2-head', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQBDruFS2I0d_WwtK3RoKlSNthWkdotcpcTPl49jx6XOXZ8taDteXqa2yv6xWiH5ZyncDpRoSKWV9Xw/pub?gid=1313626344&single=true&output=csv', 'No Style Table', '', '', '', NULL, 0, '', 1440),
(33, 'top2-head', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQBDruFS2I0d_WwtK3RoKlSNthWkdotcpcTPl49jx6XOXZ8taDteXqa2yv6xWiH5ZyncDpRoSKWV9Xw/pub?gid=1313626344&single=true&output=csv', 'Styled Table', '', '', '', NULL, 0, '', 60),
(34, 'top2-paragraph', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQBDruFS2I0d_WwtK3RoKlSNthWkdotcpcTPl49jx6XOXZ8taDteXqa2yv6xWiH5ZyncDpRoSKWV9Xw/pub?gid=1597915094&single=true&output=csv', 'No Style Table', '', '', '', NULL, 0, '', 60),
(35, 'overwatch 2 down', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vRxgPZuga4ePwYZAI5RXErh34Of3Py6UmCGGjC1w9lvq8jeajzJ4bBWfwtw3JNVaOiw3HVgW1ZZWCC1/pub?gid=17160518&single=true&output=csv', 'Styled Table', 'background-color: #B30000;\r\ncolor: white !important;\r\nfont-size:18px !important;\r\ntext-align:left !important;\r\nfont-weight:bold;', 'background-color: #ce8804;\r\ncolor: white;\r\nfont-weight:bold;\r\ntext-align:center;\r\n', '', NULL, 0, '<style>\r\ntable td img {\r\nfilter: invert(100%);\r\nwidth: 150px;\r\nheight:auto;\r\n}\r\n\r\n  #my-table-26 th {\r\nbackground-color: #B30000;\r\ncolor: white !important;\r\nfont-size:18px !important;\r\nfont-weight:bold;\r\n  }\r\n\r\n  /* Style for the first row */\r\n  #my-table-26 tr:first-child {\r\nbackground-color: #ce8804 !important;\r\ncolor: white !important;\r\nfont-weight:bold !important;\r\ntext-align:center !important;\r\n  }\r\n\r\n\r\n@media (max-width: 768px) {\r\ntable td img {\r\nfilter: invert(100%);\r\nwidth: 50px;\r\nheight:auto;\r\n}  \r\n}\r\n</style>', 30),
(36, 'Taylor Swift Roblox ID Codes', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vRdSVqq-iOyi5uVl_ot7gLzWHeGKTtwYamRWlhW89d8ghmdXLKM0MV6BEBNtvWkCA68H3MW6SK2NhW8/pub?gid=1621613074&single=true&output=csv', 'Styled Table', 'background-color: #B30000;\r\ncolor: white !important;\r\nfont-size:18px !important;', '', 'font-weight:bold;', NULL, 0, '', 600),
(37, 'lol top 100 final', 'https://docs.google.com/spreadsheets/d/e/2PACX-1vSX_5YTBlzxdw0bnPZ88Ch5GCfOe5RRXuNH5QzrCpglcpjSuohlwsSpAyQBHdAspnXncXIh4xDJUi7c/pub?output=csv', 'No Style Table', '', '', '', NULL, 0, '', 600),
(38, 'Rainbow Six Down Detector', 'https://docs.google.com/spreadsheets/d/1x1T80fm0MmYSTUz4LECDScInX_OYOxxIkDsCzB07t7k/edit#gid=1109001858', 'No Style Table', '', '', '', NULL, 0, '', 60);

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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