`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
