SQL example for File Upload

zarza

Hello there,

I was checking the tutorial for https://editor.datatables.net/examples/advanced/upload.html but there is no SQL example and I want to know if it should be there some columns for "'filename' , 'filesize', 'web_path', 'system_path'" as shown in there.

Thank you for any feedback.

allan

Indeed there is - for MySQL the table is:

CREATE TABLE `files` (
  `id` int NOT NULL AUTO_INCREMENT,
  `filename` varchar(250) NOT NULL,
  `filesize` int NOT NULL,
  `web_path` varchar(250) NOT NULL,
  `system_path` varchar(250) NOT NULL,
  PRIMARY KEY (`id`)
) AUTO_INCREMENT=1;

That and the rest of the SQL we use for our demos can be found here.

Allan