Details | Last modification | View Log | RSS feed
| Rev | Author | Line No. | Line |
|---|---|---|---|
| 4 | daniel-mar | 1 | -- phpMyAdmin SQL Dump |
| 2 | -- version 5.1.1 |
||
| 3 | -- https://www.phpmyadmin.net/ |
||
| 4 | -- |
||
| 5 | -- Host: localhost |
||
| 6 | -- Erstellungszeit: 09. Jan 2022 um 01:11 |
||
| 7 | -- Server-Version: 10.3.31-MariaDB-0+deb10u1-log |
||
| 8 | -- PHP-Version: 7.3.31-1~deb10u1 |
||
| 9 | |||
| 10 | SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; |
||
| 11 | START TRANSACTION; |
||
| 12 | SET time_zone = "+00:00"; |
||
| 13 | |||
| 14 | |||
| 15 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
||
| 16 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
||
| 17 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
||
| 18 | /*!40101 SET NAMES utf8mb4 */; |
||
| 19 | |||
| 20 | -- |
||
| 21 | -- Datenbank: `daniel-marschall` |
||
| 22 | -- |
||
| 23 | |||
| 24 | -- -------------------------------------------------------- |
||
| 25 | |||
| 26 | -- |
||
| 27 | -- Tabellenstruktur für Tabelle `counter_reloadsperre` |
||
| 28 | -- |
||
| 29 | |||
| 30 | CREATE TABLE `counter_reloadsperre` ( |
||
| 31 | `id` INT(11) NOT NULL, |
||
| 32 | `fk_counter` INT(11) NOT NULL, |
||
| 33 | `ip` VARCHAR(50) NOT NULL, |
||
| 34 | `tsLastVisit` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() |
||
| 35 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
||
| 36 | |||
| 37 | -- |
||
| 38 | -- Indizes der exportierten Tabellen |
||
| 39 | -- |
||
| 40 | |||
| 41 | -- |
||
| 42 | -- Indizes für die Tabelle `counter_reloadsperre` |
||
| 43 | -- |
||
| 44 | ALTER TABLE `counter_reloadsperre` |
||
| 45 | ADD PRIMARY KEY (`id`), |
||
| 46 | ADD KEY `fk_counter` (`fk_counter`); |
||
| 47 | |||
| 48 | -- |
||
| 49 | -- AUTO_INCREMENT für exportierte Tabellen |
||
| 50 | -- |
||
| 51 | |||
| 52 | -- |
||
| 53 | -- AUTO_INCREMENT für Tabelle `counter_reloadsperre` |
||
| 54 | -- |
||
| 55 | ALTER TABLE `counter_reloadsperre` |
||
| 56 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
| 57 | |||
| 58 | -- |
||
| 59 | -- Constraints der exportierten Tabellen |
||
| 60 | -- |
||
| 61 | |||
| 62 | -- |
||
| 63 | -- Constraints der Tabelle `counter_reloadsperre` |
||
| 64 | -- |
||
| 65 | ALTER TABLE `counter_reloadsperre` |
||
| 66 | ADD CONSTRAINT `counter_reloadsperre_ibfk_1` FOREIGN KEY (`fk_counter`) REFERENCES `counter_visitors` (`id`) ON DELETE CASCADE ON UPDATE CASCADE; |
||
| 67 | COMMIT; |
||
| 68 | |||
| 69 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
||
| 70 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
||
| 71 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |