At line 1 changed one line |
These screenshots should help as an example of what to enter. In this example, I put the driver file into my CrushFTP program folder. You could also use absolute paths. |
__IMPORTANT: due to the security updates since CrushFTP version 10.5.2+ any JDBC driver jar file needs to be placed into the CrushFTP10/plugins/lib/ directory, or it won't load.__ |
|
\\These screenshots should help as an example of what to enter. In this example, I put the driver file into my CrushFTP program folder. You could also use absolute paths. |
At line 3 changed one line |
Driver download link: [http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774]\\ |
Driver download link: [https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16]\\ |
At line 5 changed one line |
|db_driver_file|sqljdbc.jar\\ |
|db_driver_file|mssql-jdbc-12.4.0.jre11.jar\\ |
At line 18 added 2 lines |
|
|
At line 18 changed 2 lines |
domain varchar(255) default NULL, |
path varchar(255) default NULL |
domain varchar(8000) default NULL, |
path varchar(8000) default NULL, |
sort_order int default NULL |
At line 22 removed 3 lines |
|
|
|
At line 27 changed 2 lines |
event_name varchar(255) NOT NULL default '', |
prop_name varchar(255) NOT NULL default '', |
event_name varchar(8000) NOT NULL default '', |
prop_name varchar(8000) NOT NULL default '', |
At line 32 removed 2 lines |
|
|
At line 36 changed one line |
inherit_username varchar(255) default NULL, |
inherit_username varchar(8000) default NULL, |
server_group varchar(8000) default NULL, |
At line 40 removed 2 lines |
|
|
At line 44 changed one line |
start_ip varchar(255) default NULL, |
start_ip varchar(8000) default NULL, |
At line 46 changed one line |
stop_ip varchar(255) default NULL, |
stop_ip varchar(8000) default NULL, |
At line 50 removed 3 lines |
|
|
|
At line 55 changed 2 lines |
prop_name varchar(255) default NULL, |
prop_value varchar(2000) default NULL |
prop_name varchar(8000) default NULL, |
prop_value varchar(MAX) default NULL |
At line 59 removed 3 lines |
|
|
|
At line 64 changed 3 lines |
username varchar(255) default NULL, |
password varchar(255) default NULL, |
server_group varchar(50) default NULL, |
username varchar(8000) default NULL, |
password varchar(8000) default NULL, |
server_group varchar(8000) default NULL, |
At line 68 changed one line |
) |
) |
At line 70 removed 2 lines |
|
|
At line 74 changed 3 lines |
url varchar(255) default NULL, |
type varchar(50) default NULL, |
path varchar(255) default NULL, |
url varchar(8000) default NULL, |
type varchar(8000) default NULL, |
path varchar(8000) default NULL, |
At line 80 removed 2 lines |
|
|
At line 84 changed 2 lines |
path varchar(255) default NULL, |
privs varchar(255) default NULL |
path varchar(8000) default NULL, |
privs varchar(8000) default NULL |
At line 88 removed 2 lines |
|
|
At line 92 changed 4 lines |
sql_field_key varchar(255) default NULL, |
sql_field_value varchar(255) default NULL, |
for_menu varchar(10) default NULL, |
for_context_menu varchar(10) default NULL, |
sql_field_key varchar(8000) default NULL, |
sql_field_value varchar(8000) default NULL, |
for_menu varchar(8000) default NULL, |
for_context_menu varchar(8000) default NULL, |
At line 99 removed 2 lines |
|
|
At line 103 changed 2 lines |
sql_field_key varchar(255) default NULL, |
sql_field_value varchar(255) default NULL, |
sql_field_key varchar(8000) default NULL, |
sql_field_value varchar(MAX), |
At line 108 removed 3 lines |
|
|
|
At line 112 changed one line |
groupname varchar(255) default NULL, |
groupname varchar(8000) default NULL, |
At line 114 changed one line |
server_group varchar(50) default NULL |
server_group varchar(8000) default NULL |
At line 99 added 5 lines |
CREATE TABLE MODIFIED_TIMES ( |
server_group varchar(8000) default NULL, |
prop_name varchar(8000) default NULL, |
prop_value varchar(8000) default NULL |
) |
At line 105 added 6 lines |
CREATE TABLE VFS_PROPERTIES ( |
userid int default NULL, |
path varchar(8000) default NULL, |
prop_name varchar(8000) default NULL, |
prop_value varchar(8000) default NULL |
) |
At line 120 removed 5 lines |
CREATE TABLE MODIFIED_TIMES ( |
server_group varchar(50) default NULL, |
prop_name varchar(255) default NULL, |
prop_value varchar(255) default NULL |
) |