aboutsummaryrefslogtreecommitdiff
path: root/video.mysql
blob: 25d609f3c0821526942704c9501eec1d601ded5e (plain)
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
-- $Id$
CREATE TABLE video (
  vid int(10) unsigned NOT NULL default '0',
  nid int(10) unsigned NOT NULL default '0',
  vidfile text NOT NULL default '',
  videox smallint(4) unsigned NOT NULL default '0',
  videoy smallint(4) unsigned NOT NULL default '0',
  size bigint(13) unsigned default NULL,
  download_counter int(10) unsigned NOT NULL default '0',
  play_counter int(10) unsigned NOT NULL default '0',
  video_bitrate int(10) unsigned default NULL,
  audio_bitrate int(10) unsigned default NULL,
  audio_sampling_rate int(10) unsigned default NULL,
  audio_channels enum('','5.1','stereo','mono') default NULL,  
  playtime_seconds int(10) unsigned default NULL,
  download_folder varchar(255) NULL default NULL,
  disable_multidownload tinyint(1) unsigned NOT NULL default '0',
  use_play_folder tinyint(1) unsigned NOT NULL default '0',
  custom_field_1 varchar(255) NULL default NULL,
  custom_field_2 varchar(255) NULL default NULL,
  custom_field_3 varchar(255) NULL default NULL,
  custom_field_4 varchar(255) NULL default NULL,
  custom_field_5 text NULL default NULL,
  custom_field_6 text NULL default NULL,
  serialized_data text NULL default NULL,
  PRIMARY KEY  (vid)
) TYPE=MyISAM /*!40100 DEFAULT CHARACTER SET utf8 */;