# MySQL-Front 3.2  (Build 7.16)

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES 'latin1' */;
CREATE TABLE `attachments` (
  `id` int(11) NOT NULL auto_increment,
  `original_path` varchar(255) default NULL,
  `processed_path` varchar(255) default NULL,
  `original_name` varchar(255) default NULL,
  `extension` varchar(10) default NULL,
  `source_id` int(11) default NULL,
  `type` varchar(15) default NULL,
  `view_count` int(11) default NULL,
  `is_disabled` tinyint(1) default '0',
  `url_slug` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `blogs` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `blogs` VALUES (1,1);

CREATE TABLE `comments` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  `post_id` int(11) default NULL,
  `body` text,
  `created_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `faqs` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `bio` text,
  `skillz` text,
  `schools` text,
  `companies` text,
  `music` text,
  `movies` text,
  `television` text,
  `magazines` text,
  `books` text,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `faqs` VALUES (1,1,'','','','','','','','','');

CREATE TABLE `friendships` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) default NULL,
  `friend_id` int(11) default NULL,
  `status` varchar(255) default NULL,
  `created_at` datetime default NULL,
  `accepted_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `news` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `description` text,
  `news_type` varchar(255) default NULL,
  `user_id` int(11) default NULL,
  `status` varchar(10) default NULL,
  `view_count` int(11) default '0',
  `comment_count` int(11) default '0',
  `rating_count` int(11) default '0',
  `rating_average` float default '0',
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `newscomments` (
  `id` int(11) NOT NULL auto_increment,
  `news_id` int(11) default NULL,
  `user_id` int(11) default NULL,
  `comment` text,
  `reply_id` int(11) default NULL,
  `is_deleted` tinyint(1) default '0',
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `newstypes` (
  `id` int(11) NOT NULL auto_increment,
  `news_type` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `newstypes` VALUES (1,'Politics');
INSERT INTO `newstypes` VALUES (2,'World Affairs');
INSERT INTO `newstypes` VALUES (3,'Sports');
INSERT INTO `newstypes` VALUES (4,'Entertainment');
INSERT INTO `newstypes` VALUES (5,'Science, Technology & Health');
INSERT INTO `newstypes` VALUES (6,'Travel');
INSERT INTO `newstypes` VALUES (7,'General Interest');
INSERT INTO `newstypes` VALUES (8,'Business');

CREATE TABLE `posts` (
  `id` int(11) NOT NULL auto_increment,
  `blog_id` int(11) default NULL,
  `title` varchar(255) default NULL,
  `body` text,
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `ratings` (
  `id` int(11) NOT NULL auto_increment,
  `news_id` int(11) default NULL,
  `user_id` int(11) default NULL,
  `rating` float default '0',
  `is_texture` tinyint(1) default '0',
  `timeline` float default '0',
  `accuracy` float default '0',
  `interesting` float default '0',
  `quality` float default '0',
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `schema_info` (
  `version` int(11) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `schema_info` VALUES (13);

CREATE TABLE `sessions` (
  `id` int(11) NOT NULL auto_increment,
  `session_id` varchar(255) default NULL,
  `data` text,
  `updated_at` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `index_sessions_on_session_id` (`session_id`),
  KEY `index_sessions_on_updated_at` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `sessions` VALUES (1,'7f6def8651331526c0443a24d129b460','BAh7BzoMdXNlcl9pZGkGIgpmbGFzaElDOidBY3Rpb25Db250cm9sbGVyOjpG\nbGFzaDo6Rmxhc2hIYXNoewAGOgpAdXNlZHsA\n','2008-06-25 23:37:58');

CREATE TABLE `specs` (
  `id` int(11) NOT NULL auto_increment,
  `user_id` int(11) NOT NULL,
  `first_name` varchar(255) default '',
  `last_name` varchar(255) default '',
  `gender` varchar(255) default NULL,
  `birthdate` date default NULL,
  `occupation` varchar(255) default '',
  `city` varchar(255) default '',
  `state` varchar(255) default '',
  `zip_code` varchar(255) default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `specs` VALUES (1,1,'','',NULL,NULL,'','','','');

CREATE TABLE `taggings` (
  `id` int(11) NOT NULL auto_increment,
  `tag_id` int(11) default NULL,
  `taggable_type` varchar(255) default NULL,
  `taggable_id` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `tags` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `taggings_count` int(11) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


CREATE TABLE `users` (
  `id` int(11) NOT NULL auto_increment,
  `screen_name` varchar(255) default NULL,
  `email` varchar(255) default NULL,
  `password` varchar(255) default NULL,
  `user_type` varchar(20) default 'normal',
  `points` int(11) default '0',
  `created_at` datetime default NULL,
  `updated_at` datetime default NULL,
  `authorization_token` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO `users` VALUES (1,'amir','amaris4you@gmail.com','amir123','normal',0,'2008-06-25 23:37:42','2008-06-25 23:37:42',NULL);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;