summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat (limited to 'sql/gosbs-www.sql')
-rw-r--r--sql/gosbs-www.sql475
1 files changed, 0 insertions, 475 deletions
diff --git a/sql/gosbs-www.sql b/sql/gosbs-www.sql
deleted file mode 100644
index 4bc9b21..0000000
--- a/sql/gosbs-www.sql
+++ /dev/null
@@ -1,475 +0,0 @@
--- phpMyAdmin SQL Dump
--- version 4.7.7
--- https://www.phpmyadmin.net/
---
--- Värd: localhost
--- Tid vid skapande: 05 apr 2020 kl 16:56
--- Serverversion: 10.2.22-MariaDB
--- PHP-version: 7.2.12
-
-SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
-SET AUTOCOMMIT = 0;
-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 */;
-
---
--- Databas: `gosbs-www`
---
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `auth_group`
---
-
-CREATE TABLE `auth_group` (
- `id` int(11) NOT NULL,
- `name` varchar(150) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `auth_group_permissions`
---
-
-CREATE TABLE `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;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `auth_permission`
---
-
-CREATE TABLE `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;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `auth_user`
---
-
-CREATE TABLE `auth_user` (
- `id` int(11) NOT NULL,
- `password` varchar(128) NOT NULL,
- `last_login` datetime(6) DEFAULT NULL,
- `is_superuser` tinyint(1) NOT NULL,
- `username` varchar(150) NOT NULL,
- `first_name` varchar(30) NOT NULL,
- `last_name` varchar(150) NOT NULL,
- `email` varchar(254) NOT NULL,
- `is_staff` tinyint(1) NOT NULL,
- `is_active` tinyint(1) NOT NULL,
- `date_joined` datetime(6) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `auth_user_groups`
---
-
-CREATE TABLE `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;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `auth_user_user_permissions`
---
-
-CREATE TABLE `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;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `django_admin_log`
---
-
-CREATE TABLE `django_admin_log` (
- `id` int(11) NOT NULL,
- `action_time` datetime(6) NOT NULL,
- `object_id` longtext DEFAULT NULL,
- `object_repr` varchar(200) NOT NULL,
- `action_flag` smallint(5) UNSIGNED NOT NULL,
- `change_message` longtext NOT NULL,
- `content_type_id` int(11) DEFAULT NULL,
- `user_id` int(11) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `django_content_type`
---
-
-CREATE TABLE `django_content_type` (
- `id` int(11) NOT NULL,
- `app_label` varchar(100) NOT NULL,
- `model` varchar(100) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `django_migrations`
---
-
-CREATE TABLE `django_migrations` (
- `id` int(11) NOT NULL,
- `app` varchar(255) NOT NULL,
- `name` varchar(255) NOT NULL,
- `applied` datetime(6) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `django_session`
---
-
-CREATE TABLE `django_session` (
- `session_key` varchar(40) NOT NULL,
- `session_data` longtext NOT NULL,
- `expire_date` datetime(6) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `pages`
---
-
-CREATE TABLE `pages` (
- `id` int(11) NOT NULL,
- `title` varchar(200) NOT NULL,
- `description` varchar(200) NOT NULL,
- `name` varchar(100) NOT NULL,
- `view` tinyint(1) NOT NULL,
- `sort` int(11) NOT NULL,
- `url` varchar(200) NOT NULL,
- `arg` varchar(50) NOT NULL,
- `access` tinyint(1) NOT NULL,
- `sub` tinyint(1) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `posts`
---
-
-CREATE TABLE `posts` (
- `id` int(11) NOT NULL,
- `title` varchar(200) NOT NULL,
- `url` varchar(200) NOT NULL,
- `text` text NOT NULL,
- `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE current_timestamp()
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `site_settings`
---
-
-CREATE TABLE `site_settings` (
- `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
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `sponsors`
---
-
-CREATE TABLE `sponsors` (
- `id` int(11) NOT NULL,
- `name` varchar(200) NOT NULL,
- `img` varchar(100) NOT NULL,
- `link` varchar(100) NOT NULL,
- `title` varchar(30) NOT NULL,
- `alt` varchar(200) NOT NULL,
- `weight` int(11) NOT NULL,
- `active` tinyint(1) NOT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-
--- --------------------------------------------------------
-
---
--- Tabellstruktur `sub_pages`
---
-
-CREATE TABLE `sub_pages` (
- `id` int(11) NOT NULL,
- `title` varchar(200) NOT NULL,
- `description` varchar(200) NOT NULL,
- `name` varchar(100) NOT NULL,
- `view` tinyint(1) NOT NULL,
- `sort` int(11) NOT NULL,
- `url` varchar(200) NOT NULL,
- `arg` varchar(50) NOT NULL,
- `page_id` int(11) NOT NULL,
- `access` tinyint(1) NOT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
---
--- Index för dumpade tabeller
---
-
---
--- Index för tabell `auth_group`
---
-ALTER TABLE `auth_group`
- ADD PRIMARY KEY (`id`),
- ADD UNIQUE KEY `name` (`name`);
-
---
--- Index för tabell `auth_group_permissions`
---
-ALTER TABLE `auth_group_permissions`
- ADD PRIMARY KEY (`id`),
- ADD UNIQUE KEY `auth_group_permissions_group_id_permission_id_0cd325b0_uniq` (`group_id`,`permission_id`),
- ADD KEY `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` (`permission_id`);
-
---
--- Index för tabell `auth_permission`
---
-ALTER TABLE `auth_permission`
- ADD PRIMARY KEY (`id`),
- ADD UNIQUE KEY `auth_permission_content_type_id_codename_01ab375a_uniq` (`content_type_id`,`codename`);
-
---
--- Index för tabell `auth_user`
---
-ALTER TABLE `auth_user`
- ADD PRIMARY KEY (`id`),
- ADD UNIQUE KEY `username` (`username`);
-
---
--- Index för tabell `auth_user_groups`
---
-ALTER TABLE `auth_user_groups`
- ADD PRIMARY KEY (`id`),
- ADD UNIQUE KEY `auth_user_groups_user_id_group_id_94350c0c_uniq` (`user_id`,`group_id`),
- ADD KEY `auth_user_groups_group_id_97559544_fk_auth_group_id` (`group_id`);
-
---
--- Index för tabell `auth_user_user_permissions`
---
-ALTER TABLE `auth_user_user_permissions`
- ADD PRIMARY KEY (`id`),
- ADD UNIQUE KEY `auth_user_user_permissions_user_id_permission_id_14a6b632_uniq` (`user_id`,`permission_id`),
- ADD KEY `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` (`permission_id`);
-
---
--- Index för tabell `django_admin_log`
---
-ALTER TABLE `django_admin_log`
- ADD PRIMARY KEY (`id`),
- ADD KEY `django_admin_log_content_type_id_c4bce8eb_fk_django_co` (`content_type_id`),
- ADD KEY `django_admin_log_user_id_c564eba6_fk_auth_user_id` (`user_id`);
-
---
--- Index för tabell `django_content_type`
---
-ALTER TABLE `django_content_type`
- ADD PRIMARY KEY (`id`),
- ADD UNIQUE KEY `django_content_type_app_label_model_76bd3d3b_uniq` (`app_label`,`model`);
-
---
--- Index för tabell `django_migrations`
---
-ALTER TABLE `django_migrations`
- ADD PRIMARY KEY (`id`);
-
---
--- Index för tabell `django_session`
---
-ALTER TABLE `django_session`
- ADD PRIMARY KEY (`session_key`),
- ADD KEY `django_session_expire_date_a5c62663` (`expire_date`);
-
---
--- Index för tabell `pages`
---
-ALTER TABLE `pages`
- ADD PRIMARY KEY (`id`);
-
---
--- Index för tabell `posts`
---
-ALTER TABLE `posts`
- ADD PRIMARY KEY (`id`);
-
---
--- Index för tabell `site_settings`
---
-ALTER TABLE `site_settings`
- ADD PRIMARY KEY (`id`);
-
---
--- Index för tabell `sponsors`
---
-ALTER TABLE `sponsors`
- ADD PRIMARY KEY (`id`);
-
---
--- Index för tabell `sub_pages`
---
-ALTER TABLE `sub_pages`
- ADD PRIMARY KEY (`id`),
- ADD KEY `sub_pages_page_id_39ff3612_fk_pages_page_id` (`page_id`);
-
---
--- AUTO_INCREMENT för dumpade tabeller
---
-
---
--- AUTO_INCREMENT för tabell `auth_group`
---
-ALTER TABLE `auth_group`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
-
---
--- AUTO_INCREMENT för tabell `auth_group_permissions`
---
-ALTER TABLE `auth_group_permissions`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
-
---
--- AUTO_INCREMENT för tabell `auth_permission`
---
-ALTER TABLE `auth_permission`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
-
---
--- AUTO_INCREMENT för tabell `auth_user`
---
-ALTER TABLE `auth_user`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
-
---
--- AUTO_INCREMENT för tabell `auth_user_groups`
---
-ALTER TABLE `auth_user_groups`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
-
---
--- AUTO_INCREMENT för tabell `auth_user_user_permissions`
---
-ALTER TABLE `auth_user_user_permissions`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
-
---
--- AUTO_INCREMENT för tabell `django_admin_log`
---
-ALTER TABLE `django_admin_log`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
-
---
--- AUTO_INCREMENT för tabell `django_content_type`
---
-ALTER TABLE `django_content_type`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
-
---
--- AUTO_INCREMENT för tabell `django_migrations`
---
-ALTER TABLE `django_migrations`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
-
---
--- AUTO_INCREMENT för tabell `posts`
---
-ALTER TABLE `posts`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
-
---
--- AUTO_INCREMENT för tabell `sponsors`
---
-ALTER TABLE `sponsors`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
-
---
--- AUTO_INCREMENT för tabell `sub_pages`
---
-ALTER TABLE `sub_pages`
- MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
-
---
--- Restriktioner för dumpade tabeller
---
-
---
--- Restriktioner för tabell `auth_group_permissions`
---
-ALTER TABLE `auth_group_permissions`
- ADD CONSTRAINT `auth_group_permissio_permission_id_84c5c92e_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
- ADD CONSTRAINT `auth_group_permissions_group_id_b120cbf9_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`);
-
---
--- Restriktioner för tabell `auth_permission`
---
-ALTER TABLE `auth_permission`
- ADD CONSTRAINT `auth_permission_content_type_id_2f476e4b_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`);
-
---
--- Restriktioner för tabell `auth_user_groups`
---
-ALTER TABLE `auth_user_groups`
- ADD CONSTRAINT `auth_user_groups_group_id_97559544_fk_auth_group_id` FOREIGN KEY (`group_id`) REFERENCES `auth_group` (`id`),
- ADD CONSTRAINT `auth_user_groups_user_id_6a12ed8b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
-
---
--- Restriktioner för tabell `auth_user_user_permissions`
---
-ALTER TABLE `auth_user_user_permissions`
- ADD CONSTRAINT `auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm` FOREIGN KEY (`permission_id`) REFERENCES `auth_permission` (`id`),
- ADD CONSTRAINT `auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
-
---
--- Restriktioner för tabell `django_admin_log`
---
-ALTER TABLE `django_admin_log`
- ADD CONSTRAINT `django_admin_log_content_type_id_c4bce8eb_fk_django_co` FOREIGN KEY (`content_type_id`) REFERENCES `django_content_type` (`id`),
- ADD CONSTRAINT `django_admin_log_user_id_c564eba6_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`);
-
---
--- Restriktioner för tabell `sub_pages`
---
-ALTER TABLE `sub_pages`
- ADD CONSTRAINT `sub_pages_page_id_39ff3612_fk_pages_page_id` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`);
-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 */;