MissingPage

Beschreibung

Beinhaltet Aufrufe von 404-Seiten.

altes missingpage-Model

old migration

CREATE TABLE `pyou_systemlogs` (
    `systemlog_uuid` varchar(36) NOT NULL,
    `systemlog_type` varchar(255) DEFAULT NULL,
    `systemlog_info` varchar(255) DEFAULT NULL,
    `systemlog_details` text,
    `systemlog_timestamp` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`systemlog_uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

neues Address-Model

Anmerkung

• Functionality
• Implementierung: ✅
• Erweiterung:
• kleinere Anpassungen

Model (json)

{
    "class": "App\\Models\\MissingPage",
    "database": "mysql",
    "table": "missing_pages",
    "policy": null,
    "attributes": [
    {
    "name": "id",
    "type": "bigint unsigned",
    "increments": true,
    "nullable": false,
    "default": null,
    "unique": true,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": "int"
    },
    {
    "name": "route_name",
    "type": "string(255)",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "url",
    "type": "string(500)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "method",
    "type": "string(255)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "code",
    "type": "integer",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "data",
    "type": "text(65535)",
    "increments": false,
    "nullable": false,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": null
    },
    {
    "name": "created_at",
    "type": "datetime",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": "datetime"
    },
    {
    "name": "updated_at",
    "type": "datetime",
    "increments": false,
    "nullable": true,
    "default": null,
    "unique": false,
    "fillable": true,
    "hidden": false,
    "appended": null,
    "cast": "datetime"
    }
    ],
    "relations": [],
    "observers": []
}

übergeordnetes Thema

2.6 Datenstruktur