From 5f6a5223f4c2de9cc26a02279fda13fdda249d7b Mon Sep 17 00:00:00 2001 From: David Norman Date: Thu, 11 May 2006 22:34:11 +0000 Subject: DB stuff is in .install file now --- video.module | 60 ------------------------------------------------------------ 1 file changed, 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 * @author David Norman * @author Luke Last - * - * 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; - */ /******************************************************************** -- cgit v1.2.3