/web/test/gallery/cpg133/sql/_vti_cnf/basic.sql |
---|
0,0 → 1,6 |
vti_encoding:SR|utf8-nl |
vti_timelastmodified:TR|19 Apr 2005 03:17:12 -0000 |
vti_extenderversion:SR|6.0.2.5516 |
vti_cacheddtm:TX|19 Apr 2005 03:17:12 -0000 |
vti_filesize:IR|10008 |
vti_backlinkinfo:VX| |
/web/test/gallery/cpg133/sql/_vti_cnf/schema.sql |
---|
0,0 → 1,6 |
vti_encoding:SR|utf8-nl |
vti_timelastmodified:TR|19 Apr 2005 03:17:12 -0000 |
vti_extenderversion:SR|6.0.2.5516 |
vti_cacheddtm:TX|19 Apr 2005 03:17:12 -0000 |
vti_filesize:IR|8525 |
vti_backlinkinfo:VX| |
/web/test/gallery/cpg133/sql/_vti_cnf/update.sql |
---|
0,0 → 1,6 |
vti_encoding:SR|utf8-nl |
vti_timelastmodified:TR|19 Apr 2005 03:17:12 -0000 |
vti_extenderversion:SR|6.0.2.5516 |
vti_cacheddtm:TX|19 Apr 2005 03:17:12 -0000 |
vti_filesize:IR|9438 |
vti_backlinkinfo:VX| |
/web/test/gallery/cpg133/sql/basic.sql |
---|
0,0 → 1,189 |
#************************* |
# 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/basic.sql,v $ |
# $Revision: 1.8 $ |
# $Author: gaugau $ |
# $Date: 2005/04/19 03:17:11 $ |
#********************************************** |
# |
# Dumping data for table `CPG_config` |
# |
INSERT INTO CPG_config VALUES ('albums_per_page', '12'); |
INSERT INTO CPG_config VALUES ('album_list_cols', '2'); |
INSERT INTO CPG_config VALUES ('display_pic_info', '0'); |
INSERT INTO CPG_config VALUES ('alb_list_thumb_size', '50'); |
#INSERT INTO CPG_config VALUES ('allowed_file_extensions', 'GIF/PNG/JPG/JPEG/TIF/TIFF'); |
# FOR USE WITH VIDEO MOD |
INSERT INTO CPG_config VALUES ('allowed_mov_types', 'ALL'); |
INSERT INTO CPG_config VALUES ('allowed_doc_types', 'ALL'); |
INSERT INTO CPG_config VALUES ('allowed_snd_types', 'ALL'); |
INSERT INTO CPG_config VALUES ('allowed_img_types', 'ALL'); |
INSERT INTO CPG_config VALUES ('allow_private_albums', '1'); |
INSERT INTO CPG_config VALUES ('allow_user_registration', '0'); |
INSERT INTO CPG_config VALUES ('allow_duplicate_emails_addr', '0'); |
INSERT INTO CPG_config VALUES ('caption_in_thumbview', '1'); |
INSERT INTO CPG_config VALUES ('views_in_thumbview', '1'); |
INSERT INTO CPG_config VALUES ('charset', 'language file'); |
INSERT INTO CPG_config VALUES ('cookie_name', 'cpg133'); |
INSERT INTO CPG_config VALUES ('cookie_path', '/'); |
INSERT INTO CPG_config VALUES ('debug_mode', '0'); |
INSERT INTO CPG_config VALUES ('debug_notice', '0'); |
INSERT INTO CPG_config VALUES ('default_dir_mode', '0755'); |
INSERT INTO CPG_config VALUES ('default_file_mode', '0644'); |
INSERT INTO CPG_config VALUES ('default_sort_order', 'na'); |
INSERT INTO CPG_config VALUES ('ecards_more_pic_target', 'http://coppermine.sourceforge.net/'); |
INSERT INTO CPG_config VALUES ('enable_smilies', '1'); |
INSERT INTO CPG_config VALUES ('filter_bad_words', '0'); |
INSERT INTO CPG_config VALUES ('forbiden_fname_char', '$/\\\\:*?"\'<>|`'); |
INSERT INTO CPG_config VALUES ('fullpath', 'albums/'); |
INSERT INTO CPG_config VALUES ('gallery_admin_email', 'you@somewhere.com'); |
INSERT INTO CPG_config VALUES ('gallery_description', 'Your online photo album'); |
INSERT INTO CPG_config VALUES ('gallery_name', 'Coppermine Photo Gallery'); |
INSERT INTO CPG_config VALUES ('im_options', '-antialias'); |
INSERT INTO CPG_config VALUES ('impath', ''); |
INSERT INTO CPG_config VALUES ('jpeg_qual', '80'); |
INSERT INTO CPG_config VALUES ('keep_votes_time', '30'); |
INSERT INTO CPG_config VALUES ('lang', 'english'); |
INSERT INTO CPG_config VALUES ('main_page_layout', 'breadcrumb/catlist/alblist/random,2/lastup,2'); |
INSERT INTO CPG_config VALUES ('main_table_width', '100%'); |
INSERT INTO CPG_config VALUES ('make_intermediate', '1'); |
INSERT INTO CPG_config VALUES ('max_com_lines', '10'); |
INSERT INTO CPG_config VALUES ('max_com_size', '512'); |
INSERT INTO CPG_config VALUES ('max_com_wlength', '38'); |
INSERT INTO CPG_config VALUES ('max_img_desc_length', '512'); |
INSERT INTO CPG_config VALUES ('max_tabs', '12'); |
INSERT INTO CPG_config VALUES ('max_upl_size', '1024'); |
INSERT INTO CPG_config VALUES ('max_upl_width_height', '2048'); |
INSERT INTO CPG_config VALUES ('min_votes_for_rating', '1'); |
INSERT INTO CPG_config VALUES ('normal_pfx', 'normal_'); |
INSERT INTO CPG_config VALUES ('offline', '0'); |
INSERT INTO CPG_config VALUES ('picture_table_width', '600'); |
INSERT INTO CPG_config VALUES ('picture_width', '400'); |
INSERT INTO CPG_config VALUES ('randpos_interval', '1063623637'); |
INSERT INTO CPG_config VALUES ('read_exif_data', '0'); |
INSERT INTO CPG_config VALUES ('reg_requires_valid_email', '1'); |
INSERT INTO CPG_config VALUES ('subcat_level', '2'); |
INSERT INTO CPG_config VALUES ('theme', 'classic'); |
INSERT INTO CPG_config VALUES ('thumbcols', '4'); |
INSERT INTO CPG_config VALUES ('thumbrows', '3'); |
INSERT INTO CPG_config VALUES ('thumb_method', 'im'); |
INSERT INTO CPG_config VALUES ('thumb_pfx', 'thumb_'); |
INSERT INTO CPG_config VALUES ('thumb_width', '100'); |
INSERT INTO CPG_config VALUES ('userpics', 'userpics/'); |
INSERT INTO CPG_config VALUES ('user_field1_name', ''); |
INSERT INTO CPG_config VALUES ('user_field2_name', ''); |
INSERT INTO CPG_config VALUES ('user_field3_name', ''); |
INSERT INTO CPG_config VALUES ('user_field4_name', ''); |
INSERT INTO CPG_config VALUES ('display_comment_count', '0'); |
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 ('thumb_use', 'any'); |
INSERT INTO CPG_config VALUES ('comment_email_notification', '0'); |
#INSERT INTO CPG_config VALUES ('disable_popup_rightclick', '0'); |
#INSERT INTO CPG_config VALUES ('disable_gallery_rightclick', '0'); |
INSERT INTO CPG_config VALUES ('read_iptc_data', '0'); |
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 ('display_uploader', '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 ('allow_memberlist', '0'); |
INSERT INTO CPG_config VALUES ('display_faq', '0'); |
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 ('slideshow_interval', '5000'); |
# |
# Dumping data for table `CPG_filetypes` |
# |
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 ('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'); |
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_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_filetypes VALUES ('psd', 'image/psd', 'image'); |
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'); |
# |
# Dumping data for table `CPG_usergroups` |
# |
INSERT INTO CPG_usergroups VALUES (1, 'Administrators', 0, 1, 1, 1, 1, 1, 1, 0, 0, 3, 0, 5, 3); |
INSERT INTO CPG_usergroups VALUES (2, 'Registered', 1024, 0, 1, 1, 1, 1, 1, 1, 0, 3, 0, 5, 3); |
INSERT INTO CPG_usergroups VALUES (3, 'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3); |
INSERT INTO CPG_usergroups VALUES (4, 'Banned', 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3); |
# |
# Dumping data for table `CPG_categories` |
# |
INSERT INTO CPG_categories VALUES (1, 0, 'User galleries', 'This category contains albums that belong to Coppermine users.', 0, 0, 0, 0, 0, 0, 'NO'); |
/web/test/gallery/cpg133/sql/schema.sql |
---|
0,0 → 1,262 |
#************************* |
# 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/schema.sql,v $ |
# $Revision: 1.4 $ |
# $Author: gaugau $ |
# $Date: 2005/04/19 03:17:12 $ |
#********************************************** |
# |
# Table structure for table `CPG_albums` |
# |
CREATE TABLE CPG_albums ( |
aid int(11) NOT NULL auto_increment, |
title varchar(255) NOT NULL default '', |
description text NOT NULL, |
visibility int(11) NOT NULL default '0', |
uploads enum('YES','NO') NOT NULL default 'NO', |
comments enum('YES','NO') NOT NULL default 'YES', |
votes enum('YES','NO') NOT NULL default 'YES', |
pos int(11) NOT NULL default '0', |
category int(11) NOT NULL default '0', |
pic_count int(11) NOT NULL default '0', |
thumb int(11) NOT NULL default '0', |
last_addition datetime NOT NULL default '0000-00-00 00:00:00', |
stat_uptodate enum('YES','NO') NOT NULL default 'NO', |
keyword VARCHAR( 50 ), |
PRIMARY KEY (aid), |
KEY alb_category (category) |
) TYPE=MyISAM; |
# -------------------------------------------------------- |
# |
# Table structure for table `CPG_categories` |
# |
CREATE TABLE CPG_categories ( |
cid int(11) NOT NULL auto_increment, |
owner_id int(11) NOT NULL default '0', |
name varchar(255) NOT NULL default '', |
description text NOT NULL, |
pos int(11) NOT NULL default '0', |
parent int(11) NOT NULL default '0', |
thumb int(11) NOT NULL default '0', |
subcat_count int(11) NOT NULL default '0', |
alb_count int(11) NOT NULL default '0', |
pic_count int(11) NOT NULL default '0', |
stat_uptodate enum('YES','NO') NOT NULL default 'NO', |
PRIMARY KEY (cid), |
KEY cat_parent (parent), |
KEY cat_pos (pos), |
KEY cat_owner_id (owner_id) |
) TYPE=MyISAM; |
# -------------------------------------------------------- |
# |
# Table structure for table `CPG_comments` |
# |
CREATE TABLE CPG_comments ( |
pid mediumint(10) NOT NULL default '0', |
msg_id mediumint(10) NOT NULL auto_increment, |
msg_author varchar(25) NOT NULL default '', |
msg_body text NOT NULL, |
msg_date datetime NOT NULL default '0000-00-00 00:00:00', |
msg_raw_ip tinytext, |
msg_hdr_ip tinytext, |
author_md5_id varchar(32) NOT NULL default '', |
author_id int(11) NOT NULL default '0', |
PRIMARY KEY (msg_id), |
KEY com_pic_id (pid) |
) TYPE=MyISAM; |
# -------------------------------------------------------- |
# |
# Table structure for table `CPG_config` |
# |
CREATE TABLE CPG_config ( |
name varchar(40) NOT NULL default '', |
value varchar(255) NOT NULL default '', |
PRIMARY KEY (name) |
) TYPE=MyISAM; |
# -------------------------------------------------------- |
# |
# Table structure for table `CPG_pictures` |
# |
CREATE TABLE CPG_pictures ( |
pid int(11) NOT NULL auto_increment, |
aid int(11) NOT NULL default '0', |
filepath varchar(255) NOT NULL default '', |
filename varchar(255) NOT NULL default '', |
filesize int(11) NOT NULL default '0', |
total_filesize int(11) NOT NULL default '0', |
pwidth smallint(6) NOT NULL default '0', |
pheight smallint(6) NOT NULL default '0', |
hits int(10) NOT NULL default '0', |
mtime timestamp(14) NOT NULL, |
ctime int(11) NOT NULL default '0', |
owner_id int(11) NOT NULL default '0', |
owner_name varchar(40) NOT NULL default '', |
pic_rating int(11) NOT NULL default '0', |
votes int(11) NOT NULL default '0', |
title varchar(255) NOT NULL default '', |
caption text NOT NULL, |
keywords varchar(255) NOT NULL default '', |
approved enum('YES','NO') NOT NULL default 'NO', |
user1 varchar(255) NOT NULL default '', |
user2 varchar(255) NOT NULL default '', |
user3 varchar(255) NOT NULL default '', |
user4 varchar(255) NOT NULL default '', |
url_prefix tinyint(4) NOT NULL default '0', |
randpos int(11) NOT NULL default '0', |
pic_raw_ip tinytext, |
pic_hdr_ip tinytext, |
PRIMARY KEY (pid), |
KEY owner_id (owner_id), |
KEY pic_hits (hits), |
KEY pic_rate (pic_rating), |
KEY aid_approved (aid,approved), |
KEY randpos (randpos), |
KEY pic_aid (aid), |
FULLTEXT KEY search (title,caption,keywords,filename) |
) TYPE=MyISAM; |
# -------------------------------------------------------- |
# |
# Table structure for table `CPG_usergroups` |
# |
CREATE TABLE CPG_usergroups ( |
group_id int(11) NOT NULL auto_increment, |
group_name varchar(255) NOT NULL default '', |
group_quota int(11) NOT NULL default '0', |
has_admin_access tinyint(4) NOT NULL default '0', |
can_rate_pictures tinyint(4) NOT NULL default '0', |
can_send_ecards tinyint(4) NOT NULL default '0', |
can_post_comments tinyint(4) NOT NULL default '0', |
can_upload_pictures tinyint(4) NOT NULL default '0', |
can_create_albums tinyint(4) NOT NULL default '0', |
pub_upl_need_approval tinyint(4) NOT NULL default '1', |
priv_upl_need_approval tinyint(4) NOT NULL default '1', |
upload_form_config tinyint(4) NOT NULL default '3', |
custom_user_upload tinyint(4) NOT NULL default '0', |
num_file_upload tinyint(4) NOT NULL default '5', |
num_URI_upload tinyint(4) NOT NULL default '3', |
PRIMARY KEY (group_id) |
) TYPE=MyISAM; |
# -------------------------------------------------------- |
# |
# Table structure for table `CPG_users` |
# |
CREATE TABLE CPG_users ( |
user_id int(11) NOT NULL auto_increment, |
user_group int(11) NOT NULL default '2', |
user_active enum('YES','NO') NOT NULL default 'NO', |
user_name varchar(25) NOT NULL default '', |
user_password varchar(25) NOT NULL default '', |
user_lastvisit datetime NOT NULL default '0000-00-00 00:00:00', |
user_regdate datetime NOT NULL default '0000-00-00 00:00:00', |
user_group_list varchar(255) NOT NULL default '', |
user_email varchar(255) NOT NULL default '', |
user_website varchar(255) NOT NULL default '', |
user_location varchar(255) NOT NULL default '', |
user_interests varchar(255) NOT NULL default '', |
user_occupation varchar(255) NOT NULL default '', |
user_actkey varchar(32) NOT NULL default '', |
PRIMARY KEY (user_id), |
UNIQUE KEY user_name (user_name) |
) TYPE=MyISAM; |
# -------------------------------------------------------- |
# |
# Table structure for table `CPG_votes` |
# |
CREATE TABLE CPG_votes ( |
pic_id mediumint(9) NOT NULL default '0', |
user_md5_id varchar(32) NOT NULL default '', |
vote_time int(11) NOT NULL default '0', |
PRIMARY KEY (pic_id,user_md5_id) |
) TYPE=MyISAM; |
#--------------------------------------------------------- |
# |
# 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_filetypes` |
# |
CREATE TABLE IF NOT EXISTS CPG_filetypes ( |
extension char(7) NOT NULL default '', |
mime char(30) default NULL, |
content char(15) default NULL, |
PRIMARY KEY (extension) |
) TYPE=MyISAM COMMENT='Used to store the file extensions'; |
# |
# 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'; |
# |
# Table structure for table `CPG_temp_data` |
# |
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'; |
/web/test/gallery/cpg133/sql/update.sql |
---|
0,0 → 1,228 |
#************************* |
# 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 ; |