`Name` varchar(255) DEFAULT NULL, `Type` varchar(255) NOT NULL, `ShortDescription` varchar(255) NOT NULL, `Server` varchar(255) DEFAULT NULL, `Port` varchar(8) DEFAULT NULL, `Path` varchar(255) DEFAULT NULL, `Username` varchar(255) NOT NULL, `Password` varchar(255) NOT NULL, `Mounted` tinyint(4) NOT NULL DEFAULT \'0\', PRIMARY KEY (`ID`) ) '); } // Create FSFolder table for MySQL doors $t = new DbTable('FSFolder'); if (!$t->load()) { $SqlDatabase->Query(' CREATE TABLE `FSFolder` ( `ID` bigint(20) NOT NULL AUTO_INCREMENT, `FilesystemID` bigint(20) NOT NULL, `FolderID` bigint(20) NOT NULL, `UserID` bigint(20) NOT NULL, `Name` varchar(255) NOT NULL, `Permissions` varchar(255) NOT NULL, `DateModified` datetime NOT NULL, `DateCreated` datetime NOT NULL, PRIMARY KEY (`ID`) ) '); } // Create FSFile table for MySQL doors