1#@!#!123s

: / usr / local / psa / admin / plib / modules / galileo / resources / migrations /

Filename : 202503310000_InitialSchema.sql

back

-- Copyright 1999-2025. WebPros International GmbH. All rights reserved.
CREATE TABLE IF NOT EXISTS Traffic (
    `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
    `domainId` INTEGER NOT NULL,
    `date` CHAR(8) NOT NULL,
    `countryCode` CHAR(2) NOT NULL,
    `bytes` INTEGER NOT NULL
);

CREATE INDEX IF NOT EXISTS Traffic_Domain_Date ON Traffic(`domainId`, `date`);