Subversion Repositories svnkaklik

#*************************

#  Coppermine Photo Gallery

#  ************************

#  Copyright (c) 2003-2005 Coppermine Dev Team

#  v1.1 originaly written by Gregory DEMAR

#

#  This program is free software; you can redistribute it and/or modify

#  it under the terms of the GNU General Public License as published by

#  the Free Software Foundation; either version 2 of the License, or

#  (at your option) any later version.

#  ********************************************

#  Coppermine version: 1.3.3

#  $Source: /cvsroot/coppermine/stable/sql/update.sql,v $

#  $Revision: 1.14 $

#  $Author: gaugau $

#  $Date: 2005/04/19 03:17:12 $

#**********************************************

#

# Table structure for table `CPG_filetypes`

#

CREATE TABLE IF NOT EXISTS CPG_filetypes (

  extension char(7) NOT NULL default '',

  mime char(30) default NULL,

  content char(15) default NULL,

  KEY extension (extension)

) TYPE=MyISAM COMMENT='Used to store the file extensions';

ALTER TABLE `CPG_filetypes` DROP INDEX `EXTENSION`, ADD PRIMARY KEY ( `extension` );

INSERT INTO CPG_filetypes VALUES ('jpg', 'image/jpg', 'image');

INSERT INTO CPG_filetypes VALUES ('jpeg', 'image/jpeg', 'image');

INSERT INTO CPG_filetypes VALUES ('jpe', 'image/jpe', 'image');

INSERT INTO CPG_filetypes VALUES ('gif', 'image/gif', 'image');

INSERT INTO CPG_filetypes VALUES ('png', 'image/png', 'image');

INSERT INTO CPG_filetypes VALUES ('psd', 'image/psd', 'image');

INSERT INTO CPG_filetypes VALUES ('bmp', 'image/bmp', 'image');

INSERT INTO CPG_filetypes VALUES ('jpc', 'image/jpc', 'image');

INSERT INTO CPG_filetypes VALUES ('jp2', 'image/jp2', 'image');

INSERT INTO CPG_filetypes VALUES ('jpx', 'image/jpx', 'image');

INSERT INTO CPG_filetypes VALUES ('jb2', 'image/jb2', 'image');

INSERT INTO CPG_filetypes VALUES ('swc', 'image/swc', 'image');

INSERT INTO CPG_filetypes VALUES ('iff', 'image/iff', 'image');

UPDATE CPG_config SET value='ALL' WHERE name='allowed_img_types';

INSERT INTO CPG_filetypes VALUES ('asf', 'video/x-ms-asf', 'movie');

INSERT INTO CPG_filetypes VALUES ('asx', 'video/x-ms-asx', 'movie');

INSERT INTO CPG_filetypes VALUES ('mpg', 'video/mpeg', 'movie');

INSERT INTO CPG_filetypes VALUES ('mpeg', 'video/mpeg', 'movie');

INSERT INTO CPG_filetypes VALUES ('wmv', 'video/x-ms-wmv', 'movie');

INSERT INTO CPG_filetypes VALUES ('swf', 'application/x-shockwave-flash', 'movie');

INSERT INTO CPG_filetypes VALUES ('avi', 'video/avi', 'movie');

INSERT INTO CPG_filetypes VALUES ('mov', 'video/quicktime', 'movie');

INSERT INTO CPG_config VALUES ('allowed_mov_types', 'ALL');

INSERT INTO CPG_filetypes VALUES ('mp3', 'audio/mpeg3', 'audio');

INSERT INTO CPG_filetypes VALUES ('midi', 'audio/midi', 'audio');

INSERT INTO CPG_filetypes VALUES ('mid', 'audio/midi', 'audio');

INSERT INTO CPG_filetypes VALUES ('wma', 'audio/x-ms-wma', 'audio');

INSERT INTO CPG_filetypes VALUES ('wav', 'audio/wav', 'audio');

INSERT INTO CPG_filetypes VALUES ('ogg', 'audio/ogg', 'audio');

INSERT INTO CPG_config VALUES ('allowed_snd_types', 'ALL');

INSERT INTO CPG_filetypes VALUES ('ram', 'audio/x-pn-realaudio', 'document');

INSERT INTO CPG_filetypes VALUES ('ra', 'audio/x-realaudio', 'document');

INSERT INTO CPG_filetypes VALUES ('rm', 'audio/x-realmedia', 'document');

INSERT INTO CPG_filetypes VALUES ('tiff', 'image/tiff', 'document');

INSERT INTO CPG_filetypes VALUES ('tif', 'image/tif', 'document');

INSERT INTO CPG_filetypes VALUES ('doc', 'application/msword', 'document');

INSERT INTO CPG_filetypes VALUES ('txt', 'text/plain', 'document');

INSERT INTO CPG_filetypes VALUES ('rtf', 'text/richtext', 'document');

INSERT INTO CPG_filetypes VALUES ('pdf', 'application/pdf', 'document');

INSERT INTO CPG_filetypes VALUES ('xls', 'application/excel', 'document');

INSERT INTO CPG_filetypes VALUES ('pps', 'application/powerpoint', 'document');

INSERT INTO CPG_filetypes VALUES ('ppt', 'application/powerpoint', 'document');

INSERT INTO CPG_filetypes VALUES ('zip', 'application/zip', 'document');

INSERT INTO CPG_filetypes VALUES ('rar', 'application/rar', 'document');

INSERT INTO CPG_filetypes VALUES ('gz', 'application/gz', 'document');

INSERT INTO CPG_filetypes VALUES ('mdb', 'application/msaccess', 'document');

INSERT INTO CPG_config VALUES ('allowed_doc_types', 'ALL');

#

# Modify structure for table `CPG_comments`

#

ALTER TABLE CPG_comments add msg_raw_ip tinytext;

ALTER TABLE CPG_comments add msg_hdr_ip tinytext;

ALTER TABLE CPG_pictures add pic_raw_ip tinytext;

ALTER TABLE CPG_pictures add pic_hdr_ip tinytext;

INSERT INTO CPG_config VALUES ('thumb_use', 'any');

INSERT INTO CPG_config VALUES ('show_private', '0');

INSERT INTO CPG_config VALUES ('first_level', '1');

INSERT INTO CPG_config VALUES ('display_film_strip', '1');

INSERT INTO CPG_config VALUES ('max_film_strip_items', '5');

INSERT INTO CPG_config VALUES ('comment_email_notification', '0');

INSERT INTO CPG_config VALUES ('read_iptc_data', '0');

INSERT INTO CPG_config VALUES ('display_uploader', '0');

#gtroll wil implement

#INSERT INTO CPG_config VALUES ('picinfo_display_filename', '1');

#INSERT INTO CPG_config VALUES ('picinfo_display_album_name', '1');

#INSERT INTO CPG_config VALUES ('picinfo_display_file_size', '1');

#INSERT INTO CPG_config VALUES ('picinfo_display_dimensions', '1');

#INSERT INTO CPG_config VALUES ('picinfo_display_count_displayed', '1');

#INSERT INTO CPG_config VALUES ('picinfo_display_URL', '1');

#INSERT INTO CPG_config VALUES ('picinfo_display_URL_bookmark', '1');

#INSERT INTO CPG_config VALUES ('picinfo_display_favorites', 1');

INSERT INTO CPG_config VALUES ('reg_notify_admin_email', '0');

INSERT INTO CPG_config VALUES ('disable_comment_flood_protect', '0');

INSERT INTO CPG_config VALUES ('upl_notify_admin_email', '0');

INSERT INTO CPG_config VALUES ('language_list', '0');

INSERT INTO CPG_config VALUES ('language_flags', '0');

INSERT INTO CPG_config VALUES ('theme_list', '0');

INSERT INTO CPG_config VALUES ('language_reset', '1');

INSERT INTO CPG_config VALUES ('theme_reset', '1');

INSERT INTO CPG_config VALUES ('offline', '0');

INSERT INTO CPG_config VALUES ('allow_memberlist', '0');

INSERT INTO CPG_config VALUES ('display_faq', '0');

INSERT INTO CPG_config VALUES ('views_in_thumbview', '1');

INSERT INTO CPG_config VALUES ('show_bbcode_help', '1');

INSERT INTO CPG_config VALUES ('log_ecards', '0');

INSERT INTO CPG_config VALUES ('email_comment_notification', '0');

INSERT INTO CPG_config VALUES ('enable_zipdownload', '1');

INSERT INTO CPG_config VALUES ('debug_notice', '0');

INSERT INTO CPG_config VALUES ('slideshow_interval', '5000');

# Modify structure for category thumb

ALTER TABLE `CPG_categories` ADD `thumb` INT NOT NULL AFTER `parent` ;

# Modify structure for multi album pictures

ALTER TABLE `CPG_albums` ADD `keyword` VARCHAR( 50 ) NOT NULL ;

#

# Table structure for table `CPG_banned`

#

CREATE TABLE CPG_banned (

        ban_id int(11) NOT NULL auto_increment,

        user_id int(11) DEFAULT NULL,

        ip_addr tinytext DEFAULT NULL,

        expiry datetime DEFAULT NULL,

        PRIMARY KEY  (ban_id)

) TYPE=MyISAM;

#

# Table structure for table `CPG_exif`

#

CREATE TABLE CPG_exif (

  `filename` varchar(255) NOT NULL default '',

  `exifData` text NOT NULL,

  UNIQUE KEY `filename` (`filename`)

) TYPE=MyISAM;

#

# Table structure for table `CPG_ecards`

#

CREATE TABLE CPG_ecards (

  eid int(11) NOT NULL auto_increment,

  sender_name varchar(50) NOT NULL default '',

  sender_email text NOT NULL,

  recipient_name varchar(50) NOT NULL default '',

  recipient_email text NOT NULL,

  link text NOT NULL,

  date tinytext NOT NULL,

  sender_ip tinytext NOT NULL,

  PRIMARY KEY  (eid)

) TYPE=MyISAM COMMENT='Used to log ecards';

#

# Modify structure for table 'CPG_usergroups' - Upload form control - Hyperion

#

ALTER TABLE `CPG_usergroups` ADD `upload_form_config` TINYINT(4) DEFAULT '3' NOT NULL;

ALTER TABLE `CPG_usergroups` ADD `custom_user_upload` TINYINT(4) DEFAULT '0' NOT NULL;

ALTER TABLE `CPG_usergroups` ADD `num_file_upload` TINYINT(4) DEFAULT '5' NOT NULL;

ALTER TABLE `CPG_usergroups` ADD `num_URI_upload` TINYINT(4) DEFAULT '3' NOT NULL;

#

# Table structure for table `CPG_temp_data` - Temporary data for file uploads - Hyperion

#

CREATE TABLE IF NOT EXISTS `CPG_temp_data` (

`unique_ID` CHAR( 8 ) NOT NULL ,

`encoded_string` BLOB NOT NULL ,

`timestamp` INT( 11 ) UNSIGNED NOT NULL ,

PRIMARY KEY ( `unique_ID` )

) TYPE = MYISAM COMMENT = 'Holds temporary file data for multiple file uploads';

#

# Close security hole and re-point default theme in 1.3 - Jack

#

UPDATE `CPG_config` SET value='classic' WHERE (name='theme' AND value='default');

DELETE FROM `CPG_filetypes` WHERE mime='text/html';

#

# Finally remove all user_lang references - Jack

#

ALTER TABLE `CPG_users` CHANGE user_lang user_group_list varchar(255) NOT NULL default '';

#

# Fix usermgr timing out with 1k+ users -Omni

#

ALTER TABLE CPG_pictures DROP INDEX `owner_id`;

ALTER TABLE CPG_pictures DROP INDEX `owner_id_2`;

ALTER TABLE CPG_pictures DROP INDEX `owner_id_3`;

ALTER TABLE CPG_pictures DROP INDEX `owner_id_4`;

ALTER TABLE CPG_pictures ADD INDEX owner_id( `owner_id` );

#

# Record the last hit IP

#

ALTER TABLE `CPG_pictures` ADD `lasthit_ip` TINYTEXT ;