diff options
Diffstat (limited to 'sql/gentoo-www.sql')
| -rw-r--r-- | sql/gentoo-www.sql | 244 |
1 files changed, 244 insertions, 0 deletions
diff --git a/sql/gentoo-www.sql b/sql/gentoo-www.sql new file mode 100644 index 0000000..9c1d758 --- /dev/null +++ b/sql/gentoo-www.sql @@ -0,0 +1,244 @@ +-- phpMyAdmin SQL Dump +-- version 4.2.13 +-- http://www.phpmyadmin.net +-- +-- Host: localhost +-- Generation Time: Jul 14, 2015 at 04:57 PM +-- Server version: 10.0.15-MariaDB-log +-- PHP Version: 5.6.10-pl0-gentoo + +SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; +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 utf8 */; + +-- +-- Database: `gentoo-www` +-- + +-- -------------------------------------------------------- + +-- +-- Table structure for table `layout` +-- + +CREATE TABLE IF NOT EXISTS `layout` ( +`layout_id` int(11) NOT NULL, + `layout` varchar(20) NOT NULL, + `layout_file` varchar(20) NOT NULL +) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `pages` +-- + +CREATE TABLE IF NOT EXISTS `pages` ( +`page_id` int(11) NOT NULL, + `nav_title` varchar(200) NOT NULL, + `title` varchar(200) NOT NULL, + `description` varchar(200) NOT NULL, + `nav1` varchar(100) NOT NULL, + `nav1_show` tinyint(1) NOT NULL, + `nav1_weight` int(11) NOT NULL, + `meta` varchar(200) NOT NULL, + `url` varchar(200) NOT NULL, + `inlinejs` varchar(200) NOT NULL, + `body_class` varchar(20) NOT NULL, + `layout_id` int(11) NOT NULL, + `sub_menu` tinyint(1) NOT NULL +) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `posts` +-- + +CREATE TABLE IF NOT EXISTS `posts` ( +`post_id` int(11) NOT NULL, + `title` varchar(200) NOT NULL, + `url` varchar(200) NOT NULL, + `text` text NOT NULL, + `time_stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP +) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `site_settings` +-- + +CREATE TABLE IF NOT EXISTS `site_settings` ( +`site_id` int(11) NOT NULL, + `site` varchar(20) NOT NULL, + `title` varchar(50) NOT NULL, + `email` varchar(50) NOT NULL, + `description` varchar(100) NOT NULL, + `url` varchar(50) NOT NULL, + `contact` varchar(50) NOT NULL, + `cdnurl` varchar(100) NOT NULL, + `layout_path` varchar(11) NOT NULL, + `download_url` varchar(100) NOT NULL +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `sponsors` +-- + +CREATE TABLE IF NOT EXISTS `sponsors` ( +`sponsors_id` int(11) NOT NULL, + `name` varchar(200) NOT NULL, + `ads_name` varchar(100) NOT NULL, + `img` varchar(100) NOT NULL, + `ads_img` varchar(100) NOT NULL, + `link` varchar(100) NOT NULL, + `ads_link` varchar(100) NOT NULL, + `blurb` text NOT NULL, + `ads_blure` varchar(200) NOT NULL, + `ads_alt_name` varchar(200) NOT NULL, + `weight` int(11) NOT NULL, + `active` tinyint(1) NOT NULL, + `ads_active` tinyint(1) NOT NULL +) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `subsub_pages` +-- + +CREATE TABLE IF NOT EXISTS `subsub_pages` ( +`subsub_page_id` int(11) NOT NULL, + `nav_title` varchar(200) NOT NULL, + `title` varchar(200) NOT NULL, + `description` varchar(200) NOT NULL, + `sub_page_id` int(11) NOT NULL, + `nav3` varchar(100) NOT NULL, + `nav3_show` tinyint(1) NOT NULL, + `nav3_weight` int(11) NOT NULL, + `meta` varchar(200) NOT NULL, + `url` varchar(200) NOT NULL, + `inlinejs` varchar(200) NOT NULL, + `layout_id` varchar(100) NOT NULL, + `body_class` varchar(20) NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- -------------------------------------------------------- + +-- +-- Table structure for table `sub_pages` +-- + +CREATE TABLE IF NOT EXISTS `sub_pages` ( +`sub_page_id` int(11) NOT NULL, + `nav_title` varchar(200) NOT NULL, + `title` varchar(200) NOT NULL, + `description` varchar(200) NOT NULL, + `page_id` int(11) NOT NULL, + `nav2` varchar(100) NOT NULL, + `nav2_show` tinyint(1) NOT NULL, + `nav2_weight` int(11) NOT NULL, + `meta` varchar(200) NOT NULL, + `url` varchar(200) NOT NULL, + `inlinejs` varchar(200) NOT NULL, + `layout_id` int(11) NOT NULL, + `body_class` varchar(20) NOT NULL, + `sub_menu` tinyint(1) NOT NULL +) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8; + +-- +-- Indexes for dumped tables +-- + +-- +-- Indexes for table `layout` +-- +ALTER TABLE `layout` + ADD PRIMARY KEY (`layout_id`); + +-- +-- Indexes for table `pages` +-- +ALTER TABLE `pages` + ADD PRIMARY KEY (`page_id`); + +-- +-- Indexes for table `posts` +-- +ALTER TABLE `posts` + ADD PRIMARY KEY (`post_id`); + +-- +-- Indexes for table `site_settings` +-- +ALTER TABLE `site_settings` + ADD PRIMARY KEY (`site_id`); + +-- +-- Indexes for table `sponsors` +-- +ALTER TABLE `sponsors` + ADD PRIMARY KEY (`sponsors_id`); + +-- +-- Indexes for table `subsub_pages` +-- +ALTER TABLE `subsub_pages` + ADD PRIMARY KEY (`subsub_page_id`); + +-- +-- Indexes for table `sub_pages` +-- +ALTER TABLE `sub_pages` + ADD PRIMARY KEY (`sub_page_id`); + +-- +-- AUTO_INCREMENT for dumped tables +-- + +-- +-- AUTO_INCREMENT for table `layout` +-- +ALTER TABLE `layout` +MODIFY `layout_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=8; +-- +-- AUTO_INCREMENT for table `pages` +-- +ALTER TABLE `pages` +MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9; +-- +-- AUTO_INCREMENT for table `posts` +-- +ALTER TABLE `posts` +MODIFY `post_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3; +-- +-- AUTO_INCREMENT for table `site_settings` +-- +ALTER TABLE `site_settings` +MODIFY `site_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2; +-- +-- AUTO_INCREMENT for table `sponsors` +-- +ALTER TABLE `sponsors` +MODIFY `sponsors_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=7; +-- +-- AUTO_INCREMENT for table `subsub_pages` +-- +ALTER TABLE `subsub_pages` +MODIFY `subsub_page_id` int(11) NOT NULL AUTO_INCREMENT; +-- +-- AUTO_INCREMENT for table `sub_pages` +-- +ALTER TABLE `sub_pages` +MODIFY `sub_page_id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=25; +/*!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 */; |