diff options
Diffstat (limited to 'sql/gosbs-www.sql')
-rw-r--r-- | sql/gosbs-www.sql | 475 |
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 */; |