bfw: sql/init.sql@95ee596c03c5 (annotated)

0 4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	1	-- phpMyAdmin SQL Dump
19 95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	2	-- version 4.4.6
0 4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	3	-- http://www.phpmyadmin.net
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	4	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	5	-- Host: 127.0.0.1
19 95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	6	-- Erstellungszeit: 13. Nov 2015 um 18:50
95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	7	-- Server-Version: 5.6.24
95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	8	-- PHP-Version: 5.6.8
0 4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	9
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	10	SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	11	SET time_zone = "+00:00";
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	12
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	13
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	14	/!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	15	/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	16	/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
19 95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	17	/!40101 SET NAMES utf8 /;
0 4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	18
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	19	--
19 95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	20	-- Datenbank: `bfw`
0 4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	21	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	22
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	23	-- --------------------------------------------------------
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	24
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	25	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	26	-- Tabellenstruktur für Tabelle `t_group`
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	27	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	28
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	29	CREATE TABLE IF NOT EXISTS `t_group` (
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	30	`id` bigint(20) unsigned NOT NULL,
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	31	`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	32	) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	33
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	34	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	35	-- Daten für Tabelle `t_group`
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	36	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	37
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	38	INSERT INTO `t_group` (`id`, `name`) VALUES
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	39	(1, 'System'),
19 95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	40	(2, 'Admin');
0 4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	41
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	42	-- --------------------------------------------------------
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	43
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	44	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	45	-- Tabellenstruktur für Tabelle `t_user`
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	46	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	47
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	48	CREATE TABLE IF NOT EXISTS `t_user` (
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	49	`id` bigint(20) unsigned NOT NULL,
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	50	`group_id` bigint(20) unsigned NOT NULL DEFAULT '1',
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	51	`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	52	`password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	53	`firstname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	54	`lastname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	55	) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	56
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	57	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	58	-- Daten für Tabelle `t_user`
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	59	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	60
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	61	INSERT INTO `t_user` (`id`, `group_id`, `username`, `password`, `firstname`, `lastname`) VALUES
19 95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	62	(1, 1, 'system@testbox.de', '115f89503138416a242f40fb7d7f338e', 'System', 'Datensatz'),
95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	63	(2, 2, 'broeker@testbox.de', '098f6bcd4621d373cade4e832627b4f6', 'Markus', 'Bröker');
0 4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	64
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	65	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	66	-- Indizes der exportierten Tabellen
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	67	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	68
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	69	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	70	-- Indizes für die Tabelle `t_group`
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	71	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	72	ALTER TABLE `t_group`
19 95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	73	ADD PRIMARY KEY (`id`);
0 4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	74
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	75	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	76	-- Indizes für die Tabelle `t_user`
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	77	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	78	ALTER TABLE `t_user`
19 95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	79	ADD PRIMARY KEY (`id`),
0 4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	80	ADD UNIQUE KEY `co_username` (`username`),
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	81	ADD KEY `fk_t_group` (`group_id`);
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	82
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	83	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	84	-- AUTO_INCREMENT für exportierte Tabellen
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	85	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	86
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	87	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	88	-- AUTO_INCREMENT für Tabelle `t_group`
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	89	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	90	ALTER TABLE `t_group`
19 95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	91	MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
0 4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	92	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	93	-- AUTO_INCREMENT für Tabelle `t_user`
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	94	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	95	ALTER TABLE `t_user`
19 95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	96	MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
0 4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	97	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	98	-- Constraints der exportierten Tabellen
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	99	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	100
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	101	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	102	-- Constraints der Tabelle `t_user`
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	103	--
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	104	ALTER TABLE `t_user`
19 95ee596c03c5 Setup Dateien und initiales Datenbank Layout Markus Bröker <broeker.markus@googlemail.com> parents: 6 diff changeset	105	ADD CONSTRAINT `fk_t_group` FOREIGN KEY (`group_id`) REFERENCES `t_group` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
0 4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	106
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	107	/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	108	/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
4869aea77e21 Bröker-Framework BFW-1 Markus BrÃ¶ker <broeker.markus@googlemail.com> parents: diff changeset	109	/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;

author	Markus Bröker <broeker.markus@googlemail.com>
	Fri, 13 Nov 2015 22:14:54 +0100
changeset 19	95ee596c03c5
parent 6	6c23ee543e0e
permissions	-rw-r--r--