/* Script for MYSQL to make the DB tables needed for CrushFTP. */

# Dump of table DOMAIN_ROOT_LIST
# ------------------------------------------------------------

CREATE TABLE `DOMAIN_ROOT_LIST` (
  `userid` int(11) NOT NULL default '0',
  `domain` varchar(255) default NULL,
  `path` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table EVENTS5
# ------------------------------------------------------------

CREATE TABLE `EVENTS5` (
  `userid` int(11) NOT NULL default '0',
  `event_name` varchar(255) NOT NULL default '',
  `prop_name` varchar(255) NOT NULL default '',
  `prop_value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table INHERITANCE
# ------------------------------------------------------------

CREATE TABLE `INHERITANCE` (
  `userid` int(11) default NULL,
  `inherit_username` varchar(255) default NULL,
  `sort_order` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table IP_RESTRICTIONS
# ------------------------------------------------------------

CREATE TABLE `IP_RESTRICTIONS` (
  `userid` int(11) NOT NULL default '0',
  `start_ip` varchar(255) default NULL,
  `type` varchar(1) default NULL,
  `stop_ip` varchar(255) default NULL,
  `sort_order` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table USER_PROPERTIES
# ------------------------------------------------------------

CREATE TABLE `USER_PROPERTIES` (
  `userid` int(11) default NULL,
  `prop_name` varchar(255) default NULL,
  `prop_value` varchar(2000) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table USERS
# ------------------------------------------------------------

CREATE TABLE `USERS` (
  `userid` int(11) NOT NULL auto_increment,
  `username` varchar(255) default NULL,
  `password` varchar(255) default NULL,
  `server_group` varchar(50) default NULL,
  PRIMARY KEY  (`userid`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;



# Dump of table VFS
# ------------------------------------------------------------

CREATE TABLE `VFS` (
  `userid` int(11) default NULL,
  `url` varchar(255) default NULL,
  `type` varchar(50) default NULL,
  `path` varchar(255) default NULL,
  `sort_order` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table VFS_PERMISSIONS
# ------------------------------------------------------------

CREATE TABLE `VFS_PERMISSIONS` (
  `userid` int(11) default NULL,
  `path` varchar(255) default NULL,
  `privs` varchar(255) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table WEB_BUTTONS
# ------------------------------------------------------------

CREATE TABLE `WEB_BUTTONS` (
  `userid` int(11) NOT NULL default '0',
  `sql_field_key` varchar(255) default NULL,
  `sql_field_value` varchar(255) default NULL,
  `sort_order` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table WEB_CUSTOMIZATIONS
# ------------------------------------------------------------

CREATE TABLE `WEB_CUSTOMIZATIONS` (
  `userid` int(11) NOT NULL default '0',
  `sql_field_key` varchar(255) default NULL,
  `sql_field_value` varchar(255) default NULL,
  `sort_order` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table GROUPS
# ------------------------------------------------------------

CREATE TABLE `GROUPS` (
  `groupname` varchar(255) default NULL,
  `userid` int(11) default NULL,
  `server_group` varchar(50) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



# Dump of table MODIFIED_TIMES
# ------------------------------------------------------------
CREATE TABLE `MODIFIED_TIMES` (
  `SERVER_GROUP` varchar(50) default NULL,
  `PROP_NAME` varchar(255) default NULL,
  `PROP_VALUE` varchar(255) default NULL
  PRIMARY KEY (`SERVER_GROUP`,`PROP_NAME`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;