DESCRIBE categories
Field
Type
Null
Key
Default
Extra
Checkcode
varchar(25)
NO
PRI

Reference
int(8)
NO

TIMER
timestamp
NO
CURRENT_TIMESTAMP
on update CURRENT_TIMESTAMP
TITLE
varchar(80)
NO

URL
varchar(500)
NO

CATEGORY
varchar(25)
NO
MUL


'1ACCOUNT','1','2020-05-15 23:44:22','TITLETEXT','https://www.domain.com/Updates/News-Folder/more_directory','ACCOUNT'
'1AGENT','1','2020-05-15 23:44:22','TITLETEXT','https://www.domain.com/Updates/News-Folder/more_directory','AGENT'
'1CLOSED','1','2020-05-15 23:44:22','TITLETEXT','https://www.domain.com/Updates/News-Folder/more_directory','CLOSED'


'2PUGS','2','2020-05-15 23:44:22','TITLETEXT2','https://www.domain.com/Updates2/News-Folder/more_directory','PUGS'
'2GREEN','2','2020-05-15 23:44:22','TITLETEXT2','https://www.domain.com/Updates2/News-Folder/more_directory','GREEN'
'2APPLES','2','2020-05-15 23:44:22','TITLETEXT2','https://www.domain.com/Updates2/News-Folder/more_directory','APPLES'


'3ACCOUNT','3','2020-05-15 23:44:22','TITLETEXT3','https://www.domain.com/Updates3/News-Folder/more_directory','ACCOUNT'
'3FINANCE','3','2020-05-15 23:44:22','TITLETEXT3','https://www.domain.com/Updates3/News-Folder/more_directory','FINANCE'
'3MONEY','3','2020-05-15 23:44:22','TITLETEXT3','https://www.domain.com/Updates3/News-Folder/more_directory','MONEY'

CREATE TABLE `categories` (
 `Checkcode` varchar(20) NOT NULL,
 `Reference` int(8) NOT NULL,
 `TIMER` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 `TITLE` varchar(20) NOT NULL,
 `URL` varchar(500) NOT NULL,
 `CATEGORY` varchar(15) NOT NULL,
 UNIQUE KEY `INDEXED` (`Checkcode`),
 KEY `Categoryindex` (`CATEGORY`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1