[gentoo-commits] proj/tinderbox-cluster-www:master commit in: sql/
commit: 674eb6c38dd1b4ed0fabf901173c9cd97afd0919 Author: Magnus Granberg gentoo org> AuthorDate: Mon Feb 15 16:37:01 2016 + Commit: Magnus Granberg gentoo org> CommitDate: Mon Feb 15 16:37:01 2016 + URL: https://gitweb.gentoo.org/proj/tinderbox-cluster-www.git/commit/?id=674eb6c3 add full db of the web sql/gentoo-www_full.sql | 651 1 file changed, 651 insertions(+) diff --git a/sql/gentoo-www_full.sql b/sql/gentoo-www_full.sql new file mode 100644 index 000..b8f7ae0 --- /dev/null +++ b/sql/gentoo-www_full.sql @@ -0,0 +1,651 @@ +-- phpMyAdmin SQL Dump +-- version 4.2.13 +-- http://www.phpmyadmin.net +-- +-- Host: localhost +-- Generation Time: Feb 15, 2016 at 03:53 PM +-- Server version: 10.0.22-MariaDB-log +-- PHP Version: 5.6.16-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 `auth_group` +-- + +CREATE TABLE IF NOT EXISTS `auth_group` ( +`id` int(11) NOT NULL, + `name` varchar(80) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- + +-- +-- Table structure for table `auth_group_permissions` +-- + +CREATE TABLE IF NOT EXISTS `auth_group_permissions` ( +`id` int(11) NOT NULL, + `group_id` int(11) NOT NULL, + `permission_id` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- + +-- +-- Table structure for table `auth_permission` +-- + +CREATE TABLE IF NOT EXISTS `auth_permission` ( +`id` int(11) NOT NULL, + `name` varchar(255) NOT NULL, + `content_type_id` int(11) NOT NULL, + `codename` varchar(100) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `auth_permission` +-- + +INSERT INTO `auth_permission` (`id`, `name`, `content_type_id`, `codename`) VALUES +(1, 'Can add permission', 1, 'add_permission'), +(2, 'Can change permission', 1, 'change_permission'), +(3, 'Can delete permission', 1, 'delete_permission'), +(4, 'Can add group', 2, 'add_group'), +(5, 'Can change group', 2, 'change_group'), +(6, 'Can delete group', 2, 'delete_group'), +(7, 'Can add user', 3, 'add_user'), +(8, 'Can change user', 3, 'change_user'), +(9, 'Can delete user', 3, 'delete_user'), +(10, 'Can add content type', 4, 'add_contenttype'), +(11, 'Can change content type', 4, 'change_contenttype'), +(12, 'Can delete content type', 4, 'delete_contenttype'), +(13, 'Can add session', 5, 'add_session'), +(14, 'Can change session', 5, 'change_session'), +(15, 'Can delete session', 5, 'delete_session'), +(16, 'Can add site', 6, 'add_site'), +(17, 'Can change site', 6, 'change_site'), +(18, 'Can delete site', 6, 'delete_site'); + +-- + +-- +-- Table structure for table `auth_user` +-- + +CREATE TABLE IF NOT EXISTS `auth_user` ( +`id` int(11) NOT NULL, + `password` varchar(128) NOT NULL, + `last_login` datetime DEFAULT NULL, + `is_superuser` tinyint(1) NOT NULL, + `username` varchar(30) NOT NULL, + `first_name` varchar(30) NOT NULL, + `last_name` varchar(30) NOT NULL, + `email` varchar(254) NOT NULL, + `is_staff` tinyint(1) NOT NULL, + `is_active` tinyint(1) NOT NULL, + `date_joined` datetime NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- + +-- +-- Table structure for table `auth_user_groups` +-- + +CREATE TABLE IF NOT EXISTS `auth_user_groups` ( +`id` int(11) NOT NULL, + `user_id` int(11) NOT NULL, + `group_id` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- + +-- +-- Table structure for table `auth_user_user_permissions` +-- + +CREATE TABLE IF NOT EXISTS `auth_user_user_permissions` ( +`id` int(11) NOT NULL, + `user_id` int(11) NOT NULL, + `permission_id` int(11) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- + +-- +-- Table structure for table `django_content_type` +-- + +CREATE TABLE IF NOT EXISTS `django_content_type` ( +`id` int(11) NOT NULL, + `app_label` varchar(100) NOT NULL, + `model` varchar(100) NOT NULL +) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +-- +-- Dumping data for table `django_content_type` +-- + +INSERT INTO `django_content_type` (`id`, `app_label`, `model`) VALUES +(2, 'auth', 'group'), +(1, 'auth', 'permission'), +(3, 'auth', 'user'), +(4, 'contenttypes', 'contenttype'), +(5, 'sessions', 'session'), +(6, 'sites', 'site'); + +-- + +-- +-- Table structure
[gentoo-commits] proj/tinderbox-cluster-www:master commit in: sql/
commit: b925e8fe2fd13bb5ad8abbaa5299d74413a2704b Author: Magnus Granberg zorry AT gentoo DOT org AuthorDate: Tue Jul 14 19:00:04 2015 + Commit: Magnus Granberg zorry AT gentoo DOT org CommitDate: Tue Jul 14 19:00:04 2015 + URL: https://gitweb.gentoo.org/proj/tinderbox-cluster-www.git/commit/?id=b925e8fe add sql structur and data sql/gentoo-www.sql | 244 sql/gentoo-www_data.sql | 106 + 2 files changed, 350 insertions(+) diff --git a/sql/gentoo-www.sql b/sql/gentoo-www.sql new file mode 100644 index 000..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,