aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFabio Varesano <fax8@13637.no-reply.drupal.org>2005-10-28 18:52:18 +0000
committerFabio Varesano <fax8@13637.no-reply.drupal.org>2005-10-28 18:52:18 +0000
commit9657ef1ad24aebc808fa86ebe9b6a48ec44af0ed (patch)
tree4c96344e91301e273cd5fce12406aff176ed24df
parentefad769aead9d04d0b7a3c8f99e708129f8f1f89 (diff)
downloadvideo-9657ef1ad24aebc808fa86ebe9b6a48ec44af0ed.tar.gz
video-9657ef1ad24aebc808fa86ebe9b6a48ec44af0ed.tar.bz2
Changed Database code to define every int filed as unsigned.
-rw-r--r--video.module24
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;