This is version . It is not the current version, and thus it cannot be edited.
[Back to current version]   [Restore this version]

/* 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 events ( userid int NOT NULL default '0', 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 )

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(255) 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 )

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 25-Oct-2018 04:31 Ben Spink
png
url.png 17.2 kB 2 25-Oct-2018 04:31 Ben Spink
« This particular version was published on 25-Oct-2018 04:31 by Ben Spink.
G’day (anonymous guest)
CrushFTP9 | What's New

Referenced by
LeftMenu

JSPWiki