At line 1 added 11 lines |
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. |
\\ |
Driver download link: [http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774]\\ |
\\ |
|db_driver_file|sqljdbc.jar\\ |
|db_driver|com.microsoft.sqlserver.jdbc.SQLServerDriver\\ |
|db_url|jdbc:sqlserver://192.168.0.100:1433;databaseName=crushftp\\ |
|
\\ |
Some documentation from MS on the driver usage: [http://msdn.microsoft.com/en-us/library/ms378428]\\ |
\\ |
At line 6 changed one line |
CREATE TABLE domain_root_list ( |
|
CREATE TABLE DOMAIN_ROOT_LIST ( |
At line 8 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 12 changed 4 lines |
|
|
|
CREATE TABLE events ( |
CREATE TABLE EVENTS5 ( |
At line 17 changed 19 lines |
SQL_FIELD_name varchar(255) NOT NULL default '', |
command varchar(255) NOT NULL default '', |
event_dir_data varchar(255) NOT NULL default '', |
event_if_list varchar(255) NOT NULL default '', |
event_action_list varchar(255) NOT NULL default '', |
event_user_action_list varchar(255) NOT NULL default '', |
event_after_list varchar(255) NOT NULL default '', |
event_plugin_list varchar(255) NOT NULL default '', |
SQL_FIELD_from varchar(255) NOT NULL default '', |
SQL_FIELD_to varchar(255) NOT NULL default '', |
cc varchar(255) NOT NULL default '', |
bcc varchar(255) NOT NULL default '', |
subject varchar(255) NOT NULL default '', |
body varchar(255) NOT NULL default '', |
event_always_cb varchar(10) NOT NULL default 'false', |
event_after_cb varchar(10) NOT NULL default 'false', |
event_now_cb varchar(10) NOT NULL default 'false', |
event_if_cb varchar(10) NOT NULL default 'false', |
sort_order int default NULL |
event_name varchar(8000) NOT NULL default '', |
prop_name varchar(8000) NOT NULL default '', |
prop_value text NOT NULL |
At line 38 changed 3 lines |
|
|
CREATE TABLE inheritance ( |
CREATE TABLE INHERITANCE ( |
At line 42 changed one line |
inherit_username varchar(255) default NULL, |
inherit_username varchar(8000) default NULL, |
server_group varchar(8000) default NULL, |
At line 46 changed 3 lines |
|
|
CREATE TABLE ip_restrictions ( |
CREATE TABLE IP_RESTRICTIONS ( |
At line 50 changed one line |
start_ip varchar(255) default NULL, |
start_ip varchar(8000) default NULL, |
At line 52 changed one line |
stop_ip varchar(255) default NULL, |
stop_ip varchar(8000) default NULL, |
At line 56 changed 4 lines |
|
|
|
CREATE TABLE user_properties ( |
CREATE TABLE USER_PROPERTIES ( |
At line 61 changed 2 lines |
prop_name varchar(255) default NULL, |
prop_value varchar(255) default NULL |
prop_name varchar(8000) default NULL, |
prop_value varchar(MAX) default NULL |
At line 65 changed 4 lines |
|
|
|
CREATE TABLE users ( |
CREATE TABLE USERS ( |
At line 70 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 74 changed one line |
) |
) |
At line 76 changed 3 lines |
|
|
CREATE TABLE vfs ( |
CREATE TABLE VFS ( |
At line 80 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 86 changed 3 lines |
|
|
CREATE TABLE vfs_permissions ( |
CREATE TABLE VFS_PERMISSIONS ( |
At line 90 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 94 changed 4 lines |
|
|
|
CREATE TABLE web_buttons ( |
CREATE TABLE WEB_BUTTONS ( |
At line 99 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(8000) default NULL, |
for_menu varchar(8000) default NULL, |
for_context_menu varchar(8000) default NULL, |
At line 104 changed 3 lines |
|
|
CREATE TABLE web_customizations ( |
CREATE TABLE WEB_CUSTOMIZATIONS ( |
At line 108 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 91 added 5 lines |
CREATE TABLE GROUPS ( |
groupname varchar(8000) default NULL, |
userid int default NULL, |
server_group varchar(8000) default NULL |
) |
At line 97 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 115 changed 3 lines |
|
CREATE TABLE groups ( |
groupname varchar(255) default NULL, |
CREATE TABLE VFS_PROPERTIES ( |
At line 119 changed one line |
server_group varchar(50) default NULL |
path varchar(8000) default NULL, |
prop_name varchar(8000) default NULL, |
prop_value varchar(8000) default NULL |
At line 111 added one line |
|