SQL

SQL file for "Post Office"

Copy the following code and run the query in your phpMyAdmin/HeidiSQL/...:

CREATE TABLE IF NOT EXISTS `postoffice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `identifier` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sender` varchar(50) DEFAULT 'Office',
  `rewardtype` varchar(50) DEFAULT NULL,
  `reward` varchar(50) DEFAULT NULL,
  `rewardamount` bigint(20) DEFAULT 0,
  `date` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=697 DEFAULT CHARSET=utf8mb4;

ALTER TABLE `users`
ADD COLUMN `receivedparcels` int(11) DEFAULT 0;