--
-- Table structure for table `ip_customers`
--

DROP TABLE IF EXISTS `ip_customers`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `ip_customers` (
  `id` int(11) NOT NULL auto_increment,
  `remote_ip` varchar(15) NOT NULL default '',
  `is_node` enum('Y','N') NOT NULL default 'N',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `remote_ip` (`remote_ip`)
) ;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `username` varchar(30) NOT NULL default '',
  `md5secret` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `username` (`username`)
) ;

--
-- Table structure for table `vendors`
--

DROP TABLE IF EXISTS `vendors`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `vendors` (
  `id` int(11) NOT NULL auto_increment,
  `remote_ip` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `remote_ip` (`remote_ip`)
) ;

--
-- Table structure for table `triggers_log`
--

DROP TABLE IF EXISTS `triggers_log`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `triggers_log` (
  `id` int(11) NOT NULL auto_increment,
  `table_name` varchar(30) default NULL,
  `event` varchar(30) default NULL,
  `log_time` datetime default NULL,
  `comment` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ;

--
-- Table structure for table `realm`
--

DROP TABLE IF EXISTS `realm`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `realm` (
  `id` int(11) NOT NULL auto_increment,
  `val` varchar(80) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `val` (`val`)
) ;

