diff options
| author | Fabio Varesano <fax8@13637.no-reply.drupal.org> | 2005-10-28 18:52:18 +0000 |
|---|---|---|
| committer | Fabio Varesano <fax8@13637.no-reply.drupal.org> | 2005-10-28 18:52:18 +0000 |
| commit | 9657ef1ad24aebc808fa86ebe9b6a48ec44af0ed (patch) | |
| tree | 4c96344e91301e273cd5fce12406aff176ed24df | |
| parent | efad769aead9d04d0b7a3c8f99e708129f8f1f89 (diff) | |
| download | video-9657ef1ad24aebc808fa86ebe9b6a48ec44af0ed.tar.gz video-9657ef1ad24aebc808fa86ebe9b6a48ec44af0ed.tar.bz2 | |
Changed Database code to define every int filed as unsigned.
| -rw-r--r-- | video.module | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/video.module b/video.module index afd7ad2..c2e44b6 100644 --- a/video.module +++ b/video.module @@ -15,20 +15,20 @@ CREATE TABLE video ( nid int(10) unsigned NOT NULL default '0', - vidfile text NOT NULL, - videox smallint(4) NOT NULL default '0', - videoy smallint(4) NOT NULL default '0', - size bigint(13) default NULL, + 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(11) default NULL, - audio_bitrate int(11) default NULL, - audio_sampling_rate int(11) default NULL, + video_bitrate int(11) unsigned default NULL, + audio_bitrate int(11) unsigned default NULL, + audio_sampling_rate int(11) unsigned default NULL, audio_channels enum('','5.1','stereo','mono') default NULL, - playtime_seconds int(11) default NULL, + playtime_seconds int(11) unsigned default NULL, download_folder varchar(255) NULL default NULL, - disable_multidownload tinyint(1) NOT NULL default '0', - use_play_folder tinyint(1) NOT NULL default '0', + 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, @@ -47,8 +47,8 @@ ALTER TABLE `video` CHANGE `clicks` `download_counter` INT( 10 ) UNSIGNED NOT NU 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) NOT NULL default '0'; -ALTER TABLE video ADD use_play_folder tinyint(1) NOT NULL default '0'; +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; |