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 09-Oct-2016 18:14 Ben Spink
png
url.png 17.2 kB 2 09-Oct-2016 18:14 Ben Spink

This page (revision-13) was last changed on 16-Aug-2018 16:32 by Ada Csaba

This page was created on 09-Oct-2016 18:14 by Ben Spink

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Difference between version and

At line 1 changed one line
/* Script for MS SQL to make the DB tables needed for CrushFTP. */
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\\
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
)
\\
Some documentation from MS on the driver usage: [http://msdn.microsoft.com/en-us/library/ms378428]\\
\\
{{{
At line 14 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 25 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 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 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 109 added 4 lines
}}}
Version Date Modified Size Author Changes ... Change note
13 16-Aug-2018 16:32 3.073 kB Ada Csaba to previous
12 16-Aug-2018 14:34 3.077 kB Ada Csaba to previous | to last
11 09-Oct-2016 18:14 3.101 kB Ben Spink to previous | to last
10 09-Oct-2016 18:14 3.027 kB Ben Spink to previous | to last
9 09-Oct-2016 18:14 2.844 kB Ben Spink to previous | to last
8 09-Oct-2016 18:14 2.762 kB Ben Spink to previous | to last
7 09-Oct-2016 18:14 2.603 kB Ben Spink to previous | to last
6 09-Oct-2016 18:14 2.794 kB Ben Spink to previous | to last
5 09-Oct-2016 18:14 3.455 kB Ben Spink to previous | to last
4 09-Oct-2016 18:14 2.956 kB Ben Spink to previous | to last
3 09-Oct-2016 18:14 2.868 kB Ben Spink to previous | to last
2 09-Oct-2016 18:14 2.867 kB Ben Spink to previous | to last
1 09-Oct-2016 18:14 2.849 kB Ben Spink to last
« This page (revision-13) was last changed on 16-Aug-2018 16:32 by Ada Csaba
G’day (anonymous guest)

OLD WIKI!!!#

New: CrushFTPv9#

OLD WIKI!!!#


CrushFTP8 | What's New

Referenced by
LeftMenu

JSPWiki v2.8.2