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_visitors` |
||
| 28 | -- |
||
| 29 | |||
| 30 | CREATE TABLE `counter_visitors` ( |
||
| 31 | `id` INT(11) NOT NULL, |
||
| 32 | `idstr` VARCHAR(255) NOT NULL, |
||
| 33 | `counter` INT(11) NOT NULL DEFAULT 0, |
||
| 34 | `tsCreated` TIMESTAMP NULL DEFAULT NULL, |
||
| 35 | `tsLastVisit` TIMESTAMP NULL DEFAULT NULL |
||
| 36 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
||
| 37 | |||
| 38 | -- |
||
| 39 | -- Indizes der exportierten Tabellen |
||
| 40 | -- |
||
| 41 | |||
| 42 | -- |
||
| 43 | -- Indizes für die Tabelle `counter_visitors` |
||
| 44 | -- |
||
| 45 | ALTER TABLE `counter_visitors` |
||
| 46 | ADD PRIMARY KEY (`id`), |
||
| 47 | ADD UNIQUE KEY `idstr` (`idstr`); |
||
| 48 | |||
| 49 | -- |
||
| 50 | -- AUTO_INCREMENT für exportierte Tabellen |
||
| 51 | -- |
||
| 52 | |||
| 53 | -- |
||
| 54 | -- AUTO_INCREMENT für Tabelle `counter_visitors` |
||
| 55 | -- |
||
| 56 | ALTER TABLE `counter_visitors` |
||
| 57 | MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT; |
||
| 58 | COMMIT; |
||
| 59 | |||
| 60 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
||
| 61 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
||
| 62 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |