/* 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 events
# ------------------------------------------------------------

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
) ENGINE=MyISAM DEFAULT CHARSET=latin1;