| At line 1 changed one line |
| /* Script for MS SQL to make the DB tables needed for CrushFTP. */ |
| __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.__ |
| At line 3 changed 5 lines |
| CREATE TABLE domain_root_list ( |
| userid int NOT NULL default '0', |
| domain varchar(255) default NULL, |
| path varchar(255) default NULL |
| ) |
| \\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: [https://learn.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view=sql-server-ver16]\\ |
| \\ |
| |db_driver_file|mssql-jdbc-12.4.0.jre11.jar\\ |
| |db_driver|com.microsoft.sqlserver.jdbc.SQLServerDriver\\ |
| |db_url|jdbc:sqlserver://192.168.0.100:1433;databaseName=crushftp\\ |
| At line 11 added 4 lines |
| \\ |
| Some documentation from MS on the driver usage: [http://msdn.microsoft.com/en-us/library/ms378428]\\ |
| \\ |
| {{{ |
| At line 16 added one line |
| /* Script for MS SQL to make the DB tables needed for CrushFTP. */ |
| At line 12 changed one line |
| CREATE TABLE events ( |
|
| CREATE TABLE DOMAIN_ROOT_LIST ( |
| At line 14 changed 18 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', |
| domain varchar(8000) default NULL, |
| path varchar(8000) default NULL, |
| At line 27 added 6 lines |
| CREATE TABLE EVENTS5 ( |
| userid int NOT NULL default '0', |
| event_name varchar(8000) NOT NULL default '', |
| prop_name varchar(8000) NOT NULL default '', |
| prop_value text NOT NULL |
| ) |
| At line 36 changed 2 lines |
|
| CREATE TABLE inheritance ( |
| CREATE TABLE INHERITANCE ( |
| At line 39 changed one line |
| inherit_username varchar(255) default NULL, |
| inherit_username varchar(8000) default NULL, |
| server_group varchar(8000) default NULL, |
| At line 43 changed 3 lines |
|
|
| CREATE TABLE ip_restrictions ( |
| CREATE TABLE IP_RESTRICTIONS ( |
| At line 47 changed one line |
| start_ip varchar(255) default NULL, |
| start_ip varchar(8000) default NULL, |
| At line 49 changed one line |
| stop_ip varchar(255) default NULL, |
| stop_ip varchar(8000) default NULL, |
| At line 53 changed 4 lines |
|
|
|
| CREATE TABLE user_properties ( |
| CREATE TABLE USER_PROPERTIES ( |
| At line 58 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 62 changed 4 lines |
|
|
|
| CREATE TABLE users ( |
| CREATE TABLE USERS ( |
| At line 67 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 71 changed one line |
| ) |
| ) |
| At line 73 changed 3 lines |
|
|
| CREATE TABLE vfs ( |
| CREATE TABLE VFS ( |
| At line 77 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 83 changed 3 lines |
|
|
| CREATE TABLE vfs_permissions ( |
| CREATE TABLE VFS_PERMISSIONS ( |
| At line 87 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 91 changed 4 lines |
|
|
|
| CREATE TABLE web_buttons ( |
| CREATE TABLE WEB_BUTTONS ( |
| At line 96 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 101 changed 3 lines |
|
|
| CREATE TABLE web_customizations ( |
| CREATE TABLE WEB_CUSTOMIZATIONS ( |
| At line 105 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 93 added 5 lines |
| CREATE TABLE GROUPS ( |
| groupname varchar(8000) default NULL, |
| userid int 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 112 changed 3 lines |
|
| CREATE TABLE groups ( |
| groupname varchar(255) default NULL, |
| CREATE TABLE VFS_PROPERTIES ( |
| At line 116 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 4 lines |
|
|
|
| }}} |
