diff options
| -rw-r--r-- | video.module | 60 |
1 files changed, 0 insertions, 60 deletions
diff --git a/video.module b/video.module index c49ae98..29d0c86 100644 --- a/video.module +++ b/video.module @@ -9,66 +9,6 @@ * @author Fabio Varesano <fvaresano at yahoo dot it> * @author David Norman <deekayen at: deekayen (dot) net> * @author Luke Last <luke [at] lukelast dot com> - * - * Database definition: - * @code - -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; - - * @endcode - */ - -/* Database Update from v1.8 schema. - -ALTER TABLE `video` CHANGE `clicks` `download_counter` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'; -ALTER TABLE `video` CHANGE `audio_channels` `audio_channels` ENUM( '', '5.1', 'stereo', 'mono' ) NULL DEFAULT NULL; -ALTER TABLE video ADD play_counter int(10) unsigned NOT NULL default '0'; -ALTER TABLE video ADD download_folder varchar(255) NULL default NULL; -ALTER TABLE video ADD disable_multidownload tinyint(1) unsigned NOT NULL default '0'; -ALTER TABLE video ADD use_play_folder tinyint(1) unsigned NOT NULL default '0'; -ALTER TABLE video ADD custom_field_1 varchar(255) NULL default NULL; -ALTER TABLE video ADD custom_field_2 varchar(255) NULL default NULL; -ALTER TABLE video ADD custom_field_3 varchar(255) NULL default NULL; -ALTER TABLE video ADD custom_field_4 varchar(255) NULL default NULL; -ALTER TABLE video ADD custom_field_5 text NULL default NULL; -ALTER TABLE video ADD custom_field_6 text NULL default NULL; -ALTER TABLE video ADD vid int(10) unsigned NOT NULL default '0'; -ALTER TABLE `video` DROP PRIMARY KEY , ADD PRIMARY KEY ( `vid` ) -ALTER TABLE video ADD serialized_data text NULL default NULL; - -*/ - -/* Database Updates from 1.24 schema. - -ALTER TABLE video ADD vid int(10) unsigned NOT NULL default '0'; -ALTER TABLE `video` DROP PRIMARY KEY , ADD PRIMARY KEY ( `vid` ) -ALTER TABLE video ADD serialized_data text NULL default NULL; - */ /******************************************************************** |