/*
SQLyog Enterprise - MySQL GUI v7.14 
MySQL - 5.1.36-community-log : Database - scooptvdb
*********************************************************************
*/


/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

CREATE DATABASE /*!32312 IF NOT EXISTS*/`scooptvdb` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `scooptvdb`;

/*Table structure for table `scaccounts` */

DROP TABLE IF EXISTS `scaccounts`;

CREATE TABLE `scaccounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `buser_email` varchar(50) DEFAULT NULL,
  `card_type` varchar(50) DEFAULT NULL,
  `expiry_month` varchar(20) DEFAULT NULL,
  `expiry_year` varchar(10) DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  `admin_perm` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Table structure for table `scadmin_msgs` */

DROP TABLE IF EXISTS `scadmin_msgs`;

CREATE TABLE `scadmin_msgs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `report_email` varchar(50) DEFAULT NULL,
  `remarks` varchar(50) DEFAULT NULL,
  `submit_email` varchar(50) DEFAULT NULL,
  `submit_date` datetime DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  `admin_perm` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Table structure for table `scalbums` */

DROP TABLE IF EXISTS `scalbums`;

CREATE TABLE `scalbums` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `album_name` varchar(50) DEFAULT NULL,
  `user_email` varchar(50) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `date_pub` datetime DEFAULT NULL,
  `privacy` int(11) DEFAULT NULL,
  `remarks` varchar(200) DEFAULT NULL,
  `albumimg_id` int(11) DEFAULT NULL,
  `view_count` int(11) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  `admin_perm` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;

/*Table structure for table `scarticles` */

DROP TABLE IF EXISTS `scarticles`;

CREATE TABLE `scarticles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_email` varchar(50) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `sub_title` varchar(200) DEFAULT NULL,
  `body` text,
  `remarks` varchar(500) DEFAULT NULL,
  `date_pub` datetime DEFAULT NULL,
  `rating` int(11) NOT NULL,
  `view_count` int(11) NOT NULL,
  `art_typ` int(11) DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `privacy` int(11) DEFAULT NULL,
  `meta_tags` varchar(200) DEFAULT NULL,
  `ratehits` int(11) NOT NULL,
  `url` varchar(250) DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  `admin_perm` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `url_index` (`url`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Table structure for table `scaudios` */

DROP TABLE IF EXISTS `scaudios`;

CREATE TABLE `scaudios` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_email` varchar(50) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `genre` varchar(30) DEFAULT NULL,
  `artist` varchar(200) DEFAULT NULL,
  `additional` varchar(200) DEFAULT NULL,
  `date_pub` datetime DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `audio` longblob,
  `filetype` varchar(30) DEFAULT NULL,
  `dl_count` int(11) DEFAULT NULL,
  `admin_perm` int(11) DEFAULT NULL,
  `privacy` int(11) DEFAULT NULL,
  `filename` varchar(100) DEFAULT NULL,
  `filesize` int(11) DEFAULT NULL,
  `play_count` int(11) DEFAULT NULL,
  `meta_tags` varchar(200) DEFAULT NULL,
  `ratehits` int(11) NOT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

/*Table structure for table `scbusers` */

DROP TABLE IF EXISTS `scbusers`;

CREATE TABLE `scbusers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(50) NOT NULL,
  `pass` varchar(20) DEFAULT NULL,
  `f_name` varchar(50) DEFAULT NULL,
  `l_name` varchar(50) DEFAULT NULL,
  `reg_date` datetime DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL,
  `city` varchar(50) DEFAULT NULL,
  `time_zone` varchar(50) DEFAULT NULL,
  `package_id` int(11) DEFAULT NULL,
  `utype` int(11) DEFAULT NULL,
  `ustatus` int(11) DEFAULT NULL,
  `validator` varchar(42) DEFAULT NULL,
  `last_login_date` datetime DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email_index` (`email`),
  UNIQUE KEY `em_bindex` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Table structure for table `sccategories` */

DROP TABLE IF EXISTS `sccategories`;

CREATE TABLE `sccategories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(50) DEFAULT NULL,
  `cdate` datetime DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  `admin_perm` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

/*Table structure for table `scchannels` */

DROP TABLE IF EXISTS `scchannels`;

CREATE TABLE `scchannels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(50) DEFAULT NULL,
  `cdate` datetime DEFAULT NULL,
  `type` int(11) NOT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  `admin_perm` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

/*Table structure for table `scforums` */

DROP TABLE IF EXISTS `scforums`;

CREATE TABLE `scforums` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `description` varchar(1000) DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `cdate` datetime DEFAULT NULL,
  `club_img_id` int(11) DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  `privacy` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `user_email` varchar(50) DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  `admin_perm` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=95 DEFAULT CHARSET=latin1;

/*Table structure for table `scfposts` */

DROP TABLE IF EXISTS `scfposts`;

CREATE TABLE `scfposts` (
  `id` int(11) DEFAULT NULL,
  `user_email` varchar(50) DEFAULT NULL,
  `club_id` int(11) DEFAULT NULL,
  `media_id` int(11) DEFAULT NULL,
  `media_type` varchar(20) DEFAULT NULL,
  `cdate` datetime DEFAULT NULL,
  `permission` int(11) DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  `admin_perm` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

/*Table structure for table `scfriends` */

DROP TABLE IF EXISTS `scfriends`;

CREATE TABLE `scfriends` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `req_to` varchar(50) DEFAULT NULL,
  `req_from` varchar(50) DEFAULT NULL,
  `date_added` datetime DEFAULT NULL,
  `date_accept` datetime DEFAULT NULL,
  `req_pending` int(11) DEFAULT NULL,
  `blocked` int(11) DEFAULT NULL,
  `admin_perm` int(11) DEFAULT NULL,
  `req_msg` varchar(100) DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_friends` (`req_to`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Table structure for table `scmessages` */

DROP TABLE IF EXISTS `scmessages`;

CREATE TABLE `scmessages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `subj` varchar(80) DEFAULT NULL,
  `sndr_email` varchar(50) DEFAULT NULL,
  `user_email` varchar(50) DEFAULT NULL,
  `to` varchar(2500) DEFAULT NULL,
  `rcvr_email` varchar(50) DEFAULT NULL,
  `box_type` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `content` varchar(3000) DEFAULT NULL,
  `read_stat` int(11) DEFAULT NULL,
  `privacy_type` int(11) DEFAULT NULL,
  `sender_type` int(11) DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  `admin_perm` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Table structure for table `scpackages` */

DROP TABLE IF EXISTS `scpackages`;

CREATE TABLE `scpackages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(50) DEFAULT NULL,
  `desc` varchar(250) DEFAULT NULL,
  `price` double(10,5) NOT NULL,
  `admin_perm` int(11) NOT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

/*Table structure for table `scprofiles_a` */

DROP TABLE IF EXISTS `scprofiles_a`;

CREATE TABLE `scprofiles_a` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_email` varchar(50) DEFAULT NULL,
  `home_town` varchar(30) DEFAULT NULL,
  `addr` varchar(200) DEFAULT NULL,
  `city` varchar(20) DEFAULT NULL,
  `country` varchar(40) DEFAULT NULL,
  `zipcode` varchar(50) DEFAULT NULL,
  `last_updt` datetime DEFAULT NULL,
  `user_imgs_id` int(11) DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  `admin_perm` int(11) DEFAULT NULL,
  `view_count` int(10) unsigned NOT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_profiles` (`user_email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Table structure for table `scprofiles_c` */

DROP TABLE IF EXISTS `scprofiles_c`;

CREATE TABLE `scprofiles_c` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_email` varchar(50) DEFAULT NULL,
  `work_info` varchar(200) DEFAULT NULL,
  `phone` varchar(80) DEFAULT NULL,
  `web_url` varchar(80) DEFAULT NULL,
  `last_updt` datetime DEFAULT NULL,
  `user_imgs_id` int(11) DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  `admin_perm` int(11) DEFAULT NULL,
  `view_count` int(10) unsigned NOT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_profiles` (`user_email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Table structure for table `scprofiles_p` */

DROP TABLE IF EXISTS `scprofiles_p`;

CREATE TABLE `scprofiles_p` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_email` varchar(50) DEFAULT NULL,
  `about_me` varchar(500) DEFAULT NULL,
  `lang` varchar(30) DEFAULT NULL,
  `rel_status` varchar(30) DEFAULT NULL,
  `interests` varchar(100) DEFAULT NULL,
  `favourites` varchar(500) DEFAULT NULL,
  `religion` varchar(20) DEFAULT NULL,
  `occupation` varchar(50) DEFAULT NULL,
  `edu_info` varchar(200) DEFAULT NULL,
  `work_info` varchar(200) DEFAULT NULL,
  `last_updt` datetime DEFAULT NULL,
  `user_imgs_id` int(11) DEFAULT NULL,
  `active` int(11) DEFAULT NULL,
  `admin_perm` int(11) DEFAULT NULL,
  `view_count` int(10) unsigned NOT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_profiles` (`user_email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

/*Table structure for table `scsitestats` */

DROP TABLE IF EXISTS `scsitestats`;

CREATE TABLE `scsitestats` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ip_add` varchar(20) DEFAULT NULL,
  `pg_name` varchar(20) DEFAULT NULL,
  `cdate` datetime DEFAULT NULL,
  `user_email` varchar(50) DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  `admin_perm` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_sitestat` (`user_email`)
) ENGINE=InnoDB AUTO_INCREMENT=20294 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Table structure for table `sctransactions` */

DROP TABLE IF EXISTS `sctransactions`;

CREATE TABLE `sctransactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `account_id` int(11) DEFAULT NULL,
  `buser_id` int(11) DEFAULT NULL,
  `amount` varchar(50) DEFAULT NULL,
  `auth_code` varchar(100) DEFAULT NULL,
  `ref_code` varchar(100) DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  `admin_perm` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

/*Table structure for table `scuploaded_videos` */

DROP TABLE IF EXISTS `scuploaded_videos`;

CREATE TABLE `scuploaded_videos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_email` varchar(50) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `artist` varchar(200) DEFAULT NULL,
  `additional` varchar(200) DEFAULT NULL,
  `date_pub` datetime DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `file_path` varchar(250) DEFAULT NULL,
  `filetype` varchar(50) DEFAULT NULL,
  `dl_count` int(11) DEFAULT NULL,
  `admin_perm` int(11) DEFAULT NULL COMMENT '0=uploaded, 1=published, 2=encoded',
  `privacy` int(11) DEFAULT NULL,
  `filename` varchar(100) DEFAULT NULL,
  `filesize` int(11) DEFAULT NULL,
  `play_count` int(11) DEFAULT NULL,
  `scrnshot_img_id` int(11) DEFAULT NULL,
  `meta_tags` varchar(200) DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

/*Table structure for table `scuser_imgs` */

DROP TABLE IF EXISTS `scuser_imgs`;

CREATE TABLE `scuser_imgs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_email` varchar(50) DEFAULT NULL,
  `l_file_path` varchar(250) DEFAULT NULL,
  `s_file_path` varchar(250) DEFAULT NULL,
  `file_type` varchar(20) DEFAULT NULL,
  `stat` int(11) DEFAULT NULL,
  `file_name` varchar(80) DEFAULT NULL,
  `file_size` int(11) DEFAULT NULL,
  `album_id` int(11) DEFAULT NULL,
  `admin_perm` int(11) DEFAULT NULL,
  `view_count` int(11) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `date_pub` datetime DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=136 DEFAULT CHARSET=latin1;

/*Table structure for table `scusers` */

DROP TABLE IF EXISTS `scusers`;

CREATE TABLE `scusers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(50) NOT NULL,
  `pass` varchar(20) DEFAULT NULL,
  `f_name` varchar(50) DEFAULT NULL,
  `l_name` varchar(50) DEFAULT NULL,
  `reg_date` datetime DEFAULT NULL,
  `utype` int(11) DEFAULT NULL,
  `ustatus` int(11) DEFAULT NULL,
  `validator` varchar(42) DEFAULT NULL,
  `last_login_date` datetime DEFAULT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  `admin_perm` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email_index` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC;

/*Table structure for table `scvideos` */

DROP TABLE IF EXISTS `scvideos`;

CREATE TABLE `scvideos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_email` varchar(50) DEFAULT NULL,
  `title` varchar(100) DEFAULT NULL,
  `channel_id` int(11) DEFAULT NULL,
  `artist` varchar(200) DEFAULT NULL,
  `additional` varchar(200) DEFAULT NULL,
  `date_pub` datetime DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  `file_path` varchar(250) DEFAULT NULL,
  `filetype` varchar(10) DEFAULT NULL,
  `dl_count` int(11) DEFAULT NULL,
  `admin_perm` int(11) DEFAULT NULL,
  `privacy` int(11) DEFAULT NULL,
  `filename` varchar(100) DEFAULT NULL,
  `filesize` int(11) DEFAULT NULL,
  `play_count` int(11) DEFAULT NULL,
  `scrnshot_img_id` int(11) DEFAULT NULL,
  `meta_tags` varchar(200) DEFAULT NULL,
  `ratehits` int(11) NOT NULL,
  `ins_date` datetime NOT NULL,
  `upd_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;