/*
SQLyog - Free MySQL GUI v5.01
Host - 4.1.16-log : Database - uger_production
*********************************************************************
Server version : 4.1.16-log
*/


create database if not exists `uger_production`;

USE `uger_production`;

/*Table structure for table `accounts` */

DROP TABLE IF EXISTS `accounts`;

CREATE TABLE `accounts` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `created_on` timestamp NOT NULL default '0000-00-00 00:00:00',
  `updated_on` timestamp NULL default '0000-00-00 00:00:00',
  `login` varchar(45) NOT NULL default '',
  `password` varchar(45) default NULL,
  `name` varchar(45) default NULL,
  `company_id` int(11) default NULL,
  `admin` tinyint(1) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `login` (`login`),
  KEY `company_id` (`company_id`),
  KEY `admin` (`admin`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `companies` */

DROP TABLE IF EXISTS `companies`;

CREATE TABLE `companies` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `url` varchar(255) NOT NULL default '',
  `account_id` int(11) NOT NULL default '0',
  `description` text,
  `developer_count` int(11) default NULL,
  `technologies` varchar(255) default NULL,
  `phone` varchar(18) default NULL,
  `email` varchar(50) default NULL,
  `address` varchar(255) default NULL,
  `city` varchar(40) default NULL,
  `state` varchar(20) default NULL,
  `country` varchar(40) default 'United States',
  `postal_code` varchar(20) default NULL,
  `created_on` timestamp NULL default NULL,
  `updated_on` timestamp NULL default NULL,
  PRIMARY KEY  (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `events` */

DROP TABLE IF EXISTS `events`;

CREATE TABLE `events` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `description` text,
  `time` timestamp NULL default NULL,
  `location` text,
  `note` text,
  `special_request_choices` text,
  `created_on` timestamp NULL default NULL,
  `updated_on` timestamp NULL default NULL,
  PRIMARY KEY  (`id`),
  KEY `time` (`time`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `payments` */

DROP TABLE IF EXISTS `payments`;

CREATE TABLE `payments` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `created_on` timestamp NOT NULL default '0000-00-00 00:00:00',
  `updated_on` timestamp NOT NULL default '0000-00-00 00:00:00',
  `amount` double NOT NULL default '40',
  `medium` varchar(15) NOT NULL default '',
  `notation` varchar(45) NOT NULL default '',
  `account_id` int(10) unsigned NOT NULL default '0',
  `company_id` int(10) default '0',
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`),
  KEY `created_on` (`created_on`),
  KEY `updated_on` (`updated_on`),
  KEY `amount` (`amount`),
  KEY `medium` (`medium`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Table structure for table `rsvps` */

DROP TABLE IF EXISTS `rsvps`;

CREATE TABLE `rsvps` (
  `id` int(11) NOT NULL auto_increment,
  `created_on` timestamp NULL default NULL,
  `updated_on` timestamp NULL default NULL,
  `account_id` int(11) NOT NULL default '0',
  `event_id` int(11) NOT NULL default '0',
  `guest_count` int(11) NOT NULL default '0',
  `comment` varchar(255) default NULL,
  `status` varchar(10) default 'Yes',
  `special_request` text,
  PRIMARY KEY  (`id`),
  KEY `account_id` (`account_id`),
  KEY `event_id` (`event_id`),
  KEY `status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;