/app
/cron (cron task script folder)
/nuts (core folder)
/library (library folder js, php, media)
/themes (theme folder)
/plugin (plugin folder)
/uploads (plugin uploads folder)
/vendor (vendor folder for composer)
/x_includes (auto include files)
Your table must respect these minimal rules :
Deleted ENUM (' YES ',' NO ') DEFAULT' NO 'INDEXED'
CREATE TABLE `MyTable`
(
`ID` INT UNSIGNED NOT NULL AUTO_INCREMENT,
`Col1` VARCHAR(255) NULL,
`Deleted` ENUM('YES','NO') NOT NULL DEFAULT 'NO',
PRIMARY KEY (`ID`),
INDEX `Deleted` (`Deleted`)
);