forked from lochmueller/html5videoplayer
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathext_tables.sql
70 lines (59 loc) · 1.81 KB
/
ext_tables.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
#
# Table structure for table 'tx_html5videoplayer_domain_model_video'
#
CREATE TABLE tx_html5videoplayer_domain_model_video (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
starttime int(11) unsigned DEFAULT '0' NOT NULL,
endtime int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(10) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumblob,
fe_group tinytext,
title tinytext,
description text,
posterimage tinytext,
mp4source tinytext,
webmsource tinytext,
oggsource tinytext,
youtube tinytext,
vimeo tinytext,
height tinytext,
width tinytext,
downloadlinks tinyint(3) DEFAULT '0' NOT NULL,
supportvideojs tinyint(3) DEFAULT '0' NOT NULL,
preloadvideo tinytext,
autoplayvideo tinyint(3) DEFAULT '0' NOT NULL,
mutevideo tinyint(3) DEFAULT '0' NOT NULL,
loopvideo tinyint(3) DEFAULT '0' NOT NULL,
controlsvideo tinyint(3) DEFAULT '0' NOT NULL,
video_starttime int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tt_content'
#
CREATE TABLE tt_content (
tx_html5videoplayer_videos text
);
#
# Table structure for table 'tx_html5videoplayer_video_content'
#
CREATE TABLE tx_html5videoplayer_video_content (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
sorting int(11) DEFAULT '0' NOT NULL,
content_uid int(11) DEFAULT '0' NOT NULL,
video_uid int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);