These screenshots should help as an example of what to enter. In this example, I put the driver files into my CrushFTP program folder. You could also use absolute paths. Just separate multiple files with a semicolon.
This is the URL format for my example. The URL format could be different if its MS SQL 2000 or MS SQL 2005+.
/* Script for MS SQL to make the DB tables needed for CrushFTP. */ CREATE TABLE DOMAIN_ROOT_LIST ( userid int NOT NULL default '0', domain varchar(255) default NULL, path varchar(255) default NULL ) CREATE TABLE EVENTS5 ( userid int NOT NULL default '0', event_name varchar(255) NOT NULL default '', prop_name varchar(255) NOT NULL default '', prop_value text NOT NULL ) CREATE TABLE INHERITANCE ( userid int default NULL, inherit_username varchar(255) default NULL, sort_order int default NULL ) CREATE TABLE IP_RESTRICTIONS ( userid int NOT NULL default '0', start_ip varchar(255) default NULL, type varchar(1) default NULL, stop_ip varchar(255) default NULL, sort_order int default NULL ) CREATE TABLE USER_PROPERTIES ( userid int default NULL, prop_name varchar(255) default NULL, prop_value varchar(2000) default NULL ) CREATE TABLE USERS ( userid int NOT NULL IDENTITY (1, 1) NOT FOR REPLICATION, username varchar(255) default NULL, password varchar(255) default NULL, server_group varchar(50) default NULL, PRIMARY KEY (userid) ) CREATE TABLE VFS ( userid int default NULL, url varchar(255) default NULL, type varchar(50) default NULL, path varchar(255) default NULL, sort_order int default NULL ) CREATE TABLE VFS_PERMISSIONS ( userid int default NULL, path varchar(255) default NULL, privs varchar(255) default NULL ) CREATE TABLE WEB_BUTTONS ( userid int NOT NULL default '0', sql_field_key varchar(255) default NULL, sql_field_value varchar(255) default NULL, sort_order int default NULL ) CREATE TABLE WEB_CUSTOMIZATIONS ( userid int NOT NULL default '0', sql_field_key varchar(255) default NULL, sql_field_value varchar(255) default NULL, sort_order int default NULL ) CREATE TABLE GROUPS ( groupname varchar(255) default NULL, userid int default NULL, server_group varchar(50) default NULL ) CREATE TABLE MODIFIED_TIMES ( server_group varchar(50) default NULL, prop_name varchar(255) default NULL, prop_value varchar(255) default NULL )
Add new attachment
Only authorized users are allowed to upload new attachments.
List of attachments
Kind | Attachment Name | Size | Version | Date Modified | Author | Change note |
---|---|---|---|---|---|---|
png |
driver_file.png | 21.2 kB | 2 | 05-Dec-2023 05:32 | Ben Spink | |
png |
url.png | 17.2 kB | 2 | 05-Dec-2023 05:32 | Ben Spink |
«
This particular version was published on 05-Dec-2023 05:32 by Ben Spink.
G’day (anonymous guest)
Log in
JSPWiki