# CREATE DATABASE voip;
# USE voip;

#
# TABLE structure FOR TABLE 'allocation'
#

# DROP TABLE IF EXISTS allocation;
CREATE TABLE `allocation` (
`allocation_id` int(11) NOT NULL AUTO_INCREMENT,
`asset_id` int(11) NOT NULL DEFAULT '0',
`site_id` int(11) NOT NULL DEFAULT '0',
`extension` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY  (`allocation_id`)
) ENGINE=MyISAM AUTO_INCREMENT=58 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# TABLE structure FOR TABLE 'asset'
#

# DROP TABLE IF EXISTS asset;
CREATE TABLE `asset` (
`asset_id` int(11) NOT NULL AUTO_INCREMENT,
`manufacturer` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
`model` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
`serial` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
`mac` varchar(12) collate latin1_general_ci NOT NULL DEFAULT '000000000000',
`phone_ip` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
`purchase_price` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
`purchase_date` date NOT NULL DEFAULT '0000-00-00',
`purchase_from` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
`invoice_number` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
PRIMARY KEY  (`asset_id`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# TABLE structure FOR TABLE 'phoneline'
#

# DROP TABLE IF EXISTS phoneline;
CREATE TABLE `phoneline` (
`line_id` int(11) NOT NULL AUTO_INCREMENT,
`phone_number` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
PRIMARY KEY  (`line_id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# TABLE structure FOR TABLE 'server'
#

# DROP TABLE IF EXISTS server;
CREATE TABLE `server` (
`server_id` int(11) NOT NULL AUTO_INCREMENT,
`site_id` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
`server_ip` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
`server_hostname` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
PRIMARY KEY  (`server_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# TABLE structure FOR TABLE 'site'
#

# DROP TABLE IF EXISTS site;
CREATE TABLE `site` (
`site_id` int(11) NOT NULL AUTO_INCREMENT,
`site_name` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
`street_number` int(11) NOT NULL DEFAULT '0',
`street_name` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
`city` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
`state` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
`country` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
PRIMARY KEY  (`site_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

#
# TABLE structure FOR TABLE 'user'
#

# DROP TABLE IF EXISTS user;
CREATE TABLE `user` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`samaccountname` varchar(100) collate latin1_general_ci NOT NULL DEFAULT '',
PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;