# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : vsdadmsite

# --------------------------------------------------------
#
# Table structure for table 'siteusers'
#

CREATE TABLE siteusers (
   id varchar(255) NOT NULL,
   passwd varchar(255) NOT NULL,
   name varchar(255) NOT NULL,
   status varchar(50) DEFAULT 'LIVE' NOT NULL,
   PRIMARY KEY (id)
);


# --------------------------------------------------------
#
# Table structure for table 'user_vs'
#

CREATE TABLE user_vs (
   uid varchar(255) NOT NULL,
   vid bigint(20) unsigned DEFAULT '0' NOT NULL
);


# --------------------------------------------------------
#
# Table structure for table 'vs'
#

CREATE TABLE vs (
   id bigint(20) unsigned NOT NULL auto_increment,
   vs varchar(255) NOT NULL,
   fqdn varchar(255) NOT NULL,
   host varchar(255) NOT NULL,
   ip varchar(255) NOT NULL,
   vstype varchar(255) NOT NULL,
   date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
   status varchar(255) NOT NULL,
   PRIMARY KEY (id)
);

