diff options
| author | Jonathan Bauer | 2022-04-29 14:26:32 +0200 |
|---|---|---|
| committer | Jonathan Bauer | 2022-04-29 14:26:32 +0200 |
| commit | 589a297dccc0212b1172560fad1a3af98a75ec89 (patch) | |
| tree | 17f7b824485445d19439de2c9b19aca02dc6b008 /db_structure.sql | |
| parent | set versions requirements.txt as min versions (diff) | |
| download | bwlp-statistics-589a297dccc0212b1172560fad1a3af98a75ec89.tar.gz bwlp-statistics-589a297dccc0212b1172560fad1a3af98a75ec89.tar.xz bwlp-statistics-589a297dccc0212b1172560fad1a3af98a75ec89.zip | |
add 'basesystem' db table
Diffstat (limited to 'db_structure.sql')
| -rw-r--r-- | db_structure.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/db_structure.sql b/db_structure.sql index 7d513ca..62c89ae 100644 --- a/db_structure.sql +++ b/db_structure.sql @@ -99,6 +99,14 @@ CREATE VIEW reports_newest AS ON (((r.ip = rm.ip) and (r.date = rm.date))) ); +CREATE TABLE `basesystem` ( + `report` bigint(20) NOT NULL, + `days` bigint(20) NOT NULL, + `system` varchar(50) COLLATE utf8mb3_bin NOT NULL, + `count` bigint(20) NOT NULL, + PRIMARY KEY (`report`,`days`,`system`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_bin + ALTER TABLE dozmod ADD PRIMARY KEY (report,days); |