· 8 years ago · Aug 15, 2018, 05:06 AM
1automatically update mySQL entries when files are changed
2CREATE TABLE IF NOT EXISTS file
3(
4 ID INT NOT NULL AUTO_INCREMENT,
5 path VARCHAR(150),
6 size INT,
7 creationDate TIMESTAMP DEFAULT NOW(),
8 modificationDate TIMESTAMP(8),
9 destructionDate TIMESTAMP(8),
10 PRIMARY KEY(ID)
11)ENGINE=InnoDB