Juris Malinens [wap4 video converter DB schema]

-- phpMyAdmin SQL Dump
-- version 3.3.7
-- http://www.phpmyadmin.net
--
-- Hosts: localhost
-- Izveidošanas laiks: 31.12.2011 20:59
-- Servera versija: 5.5.18
-- PHP Versija: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Datubāze: `wap4`
--

-- --------------------------------------------------------

--
-- Tabulas struktūra tabulai `groups`
--

CREATE TABLE IF NOT EXISTS `groups` (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(20) NOT NULL,
  `description` VARCHAR(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

-- --------------------------------------------------------

--
-- Tabulas struktūra tabulai `meta`
--

CREATE TABLE IF NOT EXISTS `meta` (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) UNSIGNED DEFAULT NULL,
  `birthday` DATE DEFAULT NULL,
  `gender` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=954 ;

-- --------------------------------------------------------

--
-- Tabulas struktūra tabulai `news`
--

CREATE TABLE IF NOT EXISTS `news` (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` VARCHAR(30) NOT NULL,
  `news` text NOT NULL,
  `date` datetime DEFAULT NULL,
  `lang` VARCHAR(2) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;

-- --------------------------------------------------------

--
-- Tabulas struktūra tabulai `site`
--

CREATE TABLE IF NOT EXISTS `site` (
  `setting_name` VARCHAR(100) NOT NULL,
  `setting_value` VARCHAR(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Tabulas struktūra tabulai `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `group_id` mediumint(8) UNSIGNED NOT NULL,
  `ip_address` CHAR(16) NOT NULL,
  `username` VARCHAR(15) NOT NULL,
  `password` VARCHAR(40) NOT NULL,
  `salt` VARCHAR(40) DEFAULT NULL,
  `email` VARCHAR(100) NOT NULL,
  `activation_code` VARCHAR(40) DEFAULT NULL,
  `forgotten_password_code` VARCHAR(40) DEFAULT NULL,
  `remember_code` VARCHAR(40) DEFAULT NULL,
  `created_on` INT(11) UNSIGNED NOT NULL,
  `last_login` INT(11) UNSIGNED DEFAULT NULL,
  `active` tinyint(1) UNSIGNED DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=954 ;

-- --------------------------------------------------------

--
-- Tabulas struktūra tabulai `videos`
--

CREATE TABLE IF NOT EXISTS `videos` (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `users_id` mediumint(8) NOT NULL,
  `file_name` VARCHAR(100) NOT NULL,
  `description` text NOT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20729 ;

-- --------------------------------------------------------

--
-- Tabulas struktūra tabulai `videos2`
--

CREATE TABLE IF NOT EXISTS `videos2` (
  `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `uniqid` VARCHAR(13) NOT NULL,
  `users_id` mediumint(8) NOT NULL,
  `file_body` VARCHAR(100) NOT NULL DEFAULT 'file',
  `file_size` INT(12) NOT NULL COMMENT 'in bytes',
  `original_extension` VARCHAR(6) NOT NULL DEFAULT 'flv',
  `converted_extension` VARCHAR(6) NOT NULL DEFAULT 'mp3',
  `is_uploaded` tinyint(1) NOT NULL DEFAULT '0',
  `is_converted` tinyint(1) NOT NULL DEFAULT '0',
  `source_type` enum('upload','youtube','vimeo','direct') NOT NULL,
  `description` text NOT NULL,
  `date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Tabulas struktūra tabulai `video_details`
--

CREATE TABLE IF NOT EXISTS `video_details` (
  `uniqid` VARCHAR(20) NOT NULL,
  `video_title` VARCHAR(164) NOT NULL,
  `video_description` text NOT NULL,
  `video_size` INT(10) UNSIGNED NOT NULL,
  `uploaded_video_body` VARCHAR(164) NOT NULL,
  `converted_video_body` VARCHAR(164) NOT NULL,
  `uploaded_video_extension` VARCHAR(5) NOT NULL,
  `converted_video_extension` VARCHAR(5) NOT NULL,
  `percents_uploaded` INT(3) UNSIGNED NOT NULL,
  `percents_converted` INT(3) UNSIGNED NOT NULL,
  `source_type` enum('upload','known','direct') NOT NULL,
  `requested_link` VARCHAR(200) NOT NULL,
  `modified_link` VARCHAR(200) NOT NULL,
  `converter_option` VARCHAR(45) NOT NULL,
  `convert_quality` enum('low','normal','high') NOT NULL,
  `ffmpeg_command` VARCHAR(625) NOT NULL,
  `ffmpeg_output` text NOT NULL,
  `wget_output` text NOT NULL,
  `download_count` INT(10) UNSIGNED NOT NULL,
  `is_uploaded` tinyint(1) NOT NULL,
  `is_converted` tinyint(1) NOT NULL,
  `is_failed` tinyint(1) NOT NULL,
  `fail_log` text NOT NULL,
  `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`uniqid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



--
-- Dati tabulai `site`
--

INSERT INTO `site` (`setting_name`, `setting_value`) VALUES
('status', 'online'),
('file_size_unregistered', '100'),
('file_size_registered', '300');