Installation des Nachrichtenskripts V1.0

1. MySQL-Tabellen

Das Script benötigt drei Tabellen mit dem Namen users, mailbox und user_mailboxes.

1.1 Tabelle [users]

1. user_id [INT] [AUTOINCREMENT]
2. username [VARCHAR]
3. user_password [CHAR]
4. user_level [VARCHAR]

1.2 Tabelle [mailbox]

1. message_id [INT] [AUTOINCREMENT]
2. message [TEXT]
3. message_title [VARCHAR]
4. sent_by_id [INT]
5. sent_to_id [INT]
6. sent_by_username [VARCHAR]
7. sent_to_username [VARCHAR]
8. message_created [DATETIME]
9. FOREIGN KEY (`sent_by_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
10. FOREIGN KEY (`sent_to_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE

1.3 Tabelle [user_mailboxes]

1. id [INT] [AUTOINCREMENT]
2. user [INT]
3. mailbox [VARCHAR]
4. message_status [INT]
5. message_id [INT]
6. FOREIGN KEY (`message_id`) REFERENCES `mailbox` (`message_id`) ON DELETE CASCADE ON UPDATE CASCADE
7. FOREIGN KEY (`user`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE

Alternativ kann auch der unten aufgeführte SQL-Code über phpMyAdmin eingefügt werden.

CREATE TABLE `users` (
`user_id` int(10) NOT NULL AUTO_INCREMENT,
`username` varchar(30) NOT NULL,
`user_password` char(255) NOT NULL,
`user_level` varchar(50) NOT NULL DEFAULT 'user',
PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci

CREATE TABLE `mailbox` (
`message_id` int(10) NOT NULL AUTO_INCREMENT,
`message` text NOT NULL,
`message_title` varchar(150) NOT NULL,
`sent_by_id` int(10) NOT NULL,
`sent_to_id` int(10) NOT NULL,
`sent_by_username` varchar(30) NOT NULL,
`sent_to_username` varchar(30) NOT NULL,
`message_created` datetime NOT NULL,
PRIMARY KEY (`message_id`),
KEY `sent_by` (`sent_by_id`),
KEY `sent_to` (`sent_to_id`),
CONSTRAINT `mailbox_ibfk_1` FOREIGN KEY (`sent_by_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `mailbox_ibfk_2` FOREIGN KEY (`sent_to_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci

CREATE TABLE `user_mailboxes` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`user` int(10) NOT NULL,
`mailbox` varchar(25) NOT NULL,
`message_status` int(1) NOT NULL,
`message_id` int(10) NOT NULL,
PRIMARY KEY (`id`),
KEY `message_id` (`message_id`),
KEY `user` (`user`),
CONSTRAINT `user_mailboxes_ibfk_1` FOREIGN KEY (`message_id`) REFERENCES `mailbox` (`message_id`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `user_mailboxes_ibfk_2` FOREIGN KEY (`user`) REFERENCES `users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci

2. Verbindungsaufbau zur Datenbank

Der Verbindungsaufbau zur Datenbank erfolgt über [includes/db.php] [Z4-7], wo Name des Servers, Name der Datenbank, Nutzername und Passwort eingetragen werden müssen.

3. Administrationszugang und Registrierung

Ein Administrationszugang wird angelegt, indem man sich über [signup.php] registriert und dann über phpMyAdmin das [user_level] von [user] auf [administrator] ändert.

4. Changelog

Zurzeit ist noch nichts geändert worden.