Subversion Repositories webcounter

Rev

Blame | Last modification | View Log | RSS feed

  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 */;
  63.