-
Notifications
You must be signed in to change notification settings - Fork 0
/
schema-mysql.sql
executable file
·111 lines (86 loc) · 3.59 KB
/
schema-mysql.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
-- phpMyAdmin SQL Dump
-- version 3.2.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 23, 2010 at 12:49 PM
-- Server version: 5.1.45
-- PHP Version: 5.3.2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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 */;
--
-- Database: `videos5`
--
-- --------------------------------------------------------
--
-- Table structure for table `files`
--
CREATE TABLE `files` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`path` text COLLATE latin1_swedish_ci NOT NULL,
`video_codec` tinytext COLLATE latin1_swedish_ci,
`audio_codec` tinytext COLLATE latin1_swedish_ci,
`html5_ready` set('browser','mobile','ipad','android') COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`resolution` tinytext COLLATE latin1_swedish_ci,
`queued_for_encode` tinytext COLLATE latin1_swedish_ci NOT NULL,
`found` enum('yes','no') COLLATE latin1_swedish_ci NOT NULL DEFAULT 'yes',
`rating` enum('G','PG','PG-13','R','NC-17','TV-Y','TV-Y7','TV-G','TV-PG','TV-14','TV-MA') COLLATE latin1_swedish_ci DEFAULT NULL,
`last_scanned_size` bigint(12) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `files`
--
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE `settings` (
`name` tinytext COLLATE latin1_swedish_ci NOT NULL,
`value` text COLLATE latin1_swedish_ci NOT NULL,
PRIMARY KEY (`name`(255))
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`name`, `value`) VALUES
('paths', '/var/hda/files/movies/'),
('encode_command', 'nice HandBrakeCLI --preset="iPhone & iPod Touch" -i $input -o $output'),
('encode_extension', 'm4v'),
('video_extensions', 'm4v,mp4,ts,mov,divx,xvid,vob,m2v,avi,mpg,mpeg,mkv,mt2,m2ts');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`name` tinytext COLLATE latin1_swedish_ci NOT NULL,
`password` tinytext COLLATE latin1_swedish_ci,
`allowed_ratings` set('Unrated','G','PG','PG-13','R','NC-17','TV-Y','TV-Y7','TV-G','TV-PG','TV-14','TV-MA') COLLATE latin1_swedish_ci NOT NULL,
`is_admin` enum('yes','no') COLLATE latin1_swedish_ci NOT NULL DEFAULT 'no',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `name`, `password`, `allowed_ratings`, `is_admin`) VALUES
(1, 'Encoder', '1234', 'Unrated,G,PG,PG-13,R,NC-17,TV-Y,TV-Y7,TV-G,TV-PG,TV-14,TV-MA', 'yes'),
(2, 'Viewer', '1234', 'Unrated,G,PG,PG-13,R,NC-17,TV-Y,TV-Y7,TV-G,TV-PG,TV-14,TV-MA', 'no'),
(3, 'Young Viewer', NULL, 'G,PG,TV-Y,TV-Y7,TV-G,TV-PG', 'no'),
(4, 'Teenage Viewer', NULL, 'G,PG,PG-13,TV-Y,TV-Y7,TV-G,TV-PG,TV-14', 'no'),
(5, 'Rater', '1234', 'Unrated', 'yes');
-- --------------------------------------------------------
--
-- Table structure for table `dir_ratings`
--
CREATE TABLE `dir_ratings` (
`path` text COLLATE latin1_swedish_ci NOT NULL,
`rating` enum('G','PG','PG-13','R','NC-17','TV-Y','TV-Y7','TV-G','TV-PG','TV-14','TV-MA') COLLATE latin1_swedish_ci DEFAULT NULL,
PRIMARY KEY ( `path` ( 255 ) )
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
--
-- Dumping data for table `dir_ratings`
--