| 6 |
kaklik |
1 |
#*************************
|
|
|
2 |
# Coppermine Photo Gallery
|
|
|
3 |
# ************************
|
|
|
4 |
# Copyright (c) 2003-2005 Coppermine Dev Team
|
|
|
5 |
# v1.1 originaly written by Gregory DEMAR
|
|
|
6 |
#
|
|
|
7 |
# This program is free software; you can redistribute it and/or modify
|
|
|
8 |
# it under the terms of the GNU General Public License as published by
|
|
|
9 |
# the Free Software Foundation; either version 2 of the License, or
|
|
|
10 |
# (at your option) any later version.
|
|
|
11 |
# ********************************************
|
|
|
12 |
# Coppermine version: 1.3.3
|
|
|
13 |
# $Source: /cvsroot/coppermine/stable/sql/basic.sql,v $
|
|
|
14 |
# $Revision: 1.8 $
|
|
|
15 |
# $Author: gaugau $
|
|
|
16 |
# $Date: 2005/04/19 03:17:11 $
|
|
|
17 |
#**********************************************
|
|
|
18 |
|
|
|
19 |
#
|
|
|
20 |
# Dumping data for table `CPG_config`
|
|
|
21 |
#
|
|
|
22 |
|
|
|
23 |
INSERT INTO CPG_config VALUES ('albums_per_page', '12');
|
|
|
24 |
INSERT INTO CPG_config VALUES ('album_list_cols', '2');
|
|
|
25 |
INSERT INTO CPG_config VALUES ('display_pic_info', '0');
|
|
|
26 |
INSERT INTO CPG_config VALUES ('alb_list_thumb_size', '50');
|
|
|
27 |
|
|
|
28 |
#INSERT INTO CPG_config VALUES ('allowed_file_extensions', 'GIF/PNG/JPG/JPEG/TIF/TIFF');
|
|
|
29 |
|
|
|
30 |
|
|
|
31 |
# FOR USE WITH VIDEO MOD
|
|
|
32 |
INSERT INTO CPG_config VALUES ('allowed_mov_types', 'ALL');
|
|
|
33 |
INSERT INTO CPG_config VALUES ('allowed_doc_types', 'ALL');
|
|
|
34 |
INSERT INTO CPG_config VALUES ('allowed_snd_types', 'ALL');
|
|
|
35 |
INSERT INTO CPG_config VALUES ('allowed_img_types', 'ALL');
|
|
|
36 |
|
|
|
37 |
|
|
|
38 |
INSERT INTO CPG_config VALUES ('allow_private_albums', '1');
|
|
|
39 |
INSERT INTO CPG_config VALUES ('allow_user_registration', '0');
|
|
|
40 |
INSERT INTO CPG_config VALUES ('allow_duplicate_emails_addr', '0');
|
|
|
41 |
INSERT INTO CPG_config VALUES ('caption_in_thumbview', '1');
|
|
|
42 |
INSERT INTO CPG_config VALUES ('views_in_thumbview', '1');
|
|
|
43 |
INSERT INTO CPG_config VALUES ('charset', 'language file');
|
|
|
44 |
INSERT INTO CPG_config VALUES ('cookie_name', 'cpg133');
|
|
|
45 |
INSERT INTO CPG_config VALUES ('cookie_path', '/');
|
|
|
46 |
INSERT INTO CPG_config VALUES ('debug_mode', '0');
|
|
|
47 |
INSERT INTO CPG_config VALUES ('debug_notice', '0');
|
|
|
48 |
INSERT INTO CPG_config VALUES ('default_dir_mode', '0755');
|
|
|
49 |
INSERT INTO CPG_config VALUES ('default_file_mode', '0644');
|
|
|
50 |
INSERT INTO CPG_config VALUES ('default_sort_order', 'na');
|
|
|
51 |
INSERT INTO CPG_config VALUES ('ecards_more_pic_target', 'http://coppermine.sourceforge.net/');
|
|
|
52 |
INSERT INTO CPG_config VALUES ('enable_smilies', '1');
|
|
|
53 |
INSERT INTO CPG_config VALUES ('filter_bad_words', '0');
|
|
|
54 |
INSERT INTO CPG_config VALUES ('forbiden_fname_char', '$/\\\\:*?"\'<>|`');
|
|
|
55 |
INSERT INTO CPG_config VALUES ('fullpath', 'albums/');
|
|
|
56 |
INSERT INTO CPG_config VALUES ('gallery_admin_email', 'you@somewhere.com');
|
|
|
57 |
INSERT INTO CPG_config VALUES ('gallery_description', 'Your online photo album');
|
|
|
58 |
INSERT INTO CPG_config VALUES ('gallery_name', 'Coppermine Photo Gallery');
|
|
|
59 |
INSERT INTO CPG_config VALUES ('im_options', '-antialias');
|
|
|
60 |
INSERT INTO CPG_config VALUES ('impath', '');
|
|
|
61 |
INSERT INTO CPG_config VALUES ('jpeg_qual', '80');
|
|
|
62 |
INSERT INTO CPG_config VALUES ('keep_votes_time', '30');
|
|
|
63 |
INSERT INTO CPG_config VALUES ('lang', 'english');
|
|
|
64 |
INSERT INTO CPG_config VALUES ('main_page_layout', 'breadcrumb/catlist/alblist/random,2/lastup,2');
|
|
|
65 |
INSERT INTO CPG_config VALUES ('main_table_width', '100%');
|
|
|
66 |
INSERT INTO CPG_config VALUES ('make_intermediate', '1');
|
|
|
67 |
INSERT INTO CPG_config VALUES ('max_com_lines', '10');
|
|
|
68 |
INSERT INTO CPG_config VALUES ('max_com_size', '512');
|
|
|
69 |
INSERT INTO CPG_config VALUES ('max_com_wlength', '38');
|
|
|
70 |
INSERT INTO CPG_config VALUES ('max_img_desc_length', '512');
|
|
|
71 |
INSERT INTO CPG_config VALUES ('max_tabs', '12');
|
|
|
72 |
INSERT INTO CPG_config VALUES ('max_upl_size', '1024');
|
|
|
73 |
INSERT INTO CPG_config VALUES ('max_upl_width_height', '2048');
|
|
|
74 |
INSERT INTO CPG_config VALUES ('min_votes_for_rating', '1');
|
|
|
75 |
INSERT INTO CPG_config VALUES ('normal_pfx', 'normal_');
|
|
|
76 |
INSERT INTO CPG_config VALUES ('offline', '0');
|
|
|
77 |
INSERT INTO CPG_config VALUES ('picture_table_width', '600');
|
|
|
78 |
INSERT INTO CPG_config VALUES ('picture_width', '400');
|
|
|
79 |
INSERT INTO CPG_config VALUES ('randpos_interval', '1063623637');
|
|
|
80 |
INSERT INTO CPG_config VALUES ('read_exif_data', '0');
|
|
|
81 |
INSERT INTO CPG_config VALUES ('reg_requires_valid_email', '1');
|
|
|
82 |
INSERT INTO CPG_config VALUES ('subcat_level', '2');
|
|
|
83 |
INSERT INTO CPG_config VALUES ('theme', 'classic');
|
|
|
84 |
INSERT INTO CPG_config VALUES ('thumbcols', '4');
|
|
|
85 |
INSERT INTO CPG_config VALUES ('thumbrows', '3');
|
|
|
86 |
INSERT INTO CPG_config VALUES ('thumb_method', 'im');
|
|
|
87 |
INSERT INTO CPG_config VALUES ('thumb_pfx', 'thumb_');
|
|
|
88 |
INSERT INTO CPG_config VALUES ('thumb_width', '100');
|
|
|
89 |
INSERT INTO CPG_config VALUES ('userpics', 'userpics/');
|
|
|
90 |
INSERT INTO CPG_config VALUES ('user_field1_name', '');
|
|
|
91 |
INSERT INTO CPG_config VALUES ('user_field2_name', '');
|
|
|
92 |
INSERT INTO CPG_config VALUES ('user_field3_name', '');
|
|
|
93 |
INSERT INTO CPG_config VALUES ('user_field4_name', '');
|
|
|
94 |
INSERT INTO CPG_config VALUES ('display_comment_count', '0');
|
|
|
95 |
INSERT INTO CPG_config VALUES ('show_private', '0');
|
|
|
96 |
INSERT INTO CPG_config VALUES ('first_level', '1');
|
|
|
97 |
INSERT INTO CPG_config VALUES ('display_film_strip', '1');
|
|
|
98 |
INSERT INTO CPG_config VALUES ('max_film_strip_items', '5');
|
|
|
99 |
INSERT INTO CPG_config VALUES ('thumb_use', 'any');
|
|
|
100 |
INSERT INTO CPG_config VALUES ('comment_email_notification', '0');
|
|
|
101 |
#INSERT INTO CPG_config VALUES ('disable_popup_rightclick', '0');
|
|
|
102 |
#INSERT INTO CPG_config VALUES ('disable_gallery_rightclick', '0');
|
|
|
103 |
INSERT INTO CPG_config VALUES ('read_iptc_data', '0');
|
|
|
104 |
INSERT INTO CPG_config VALUES ('reg_notify_admin_email', '0');
|
|
|
105 |
INSERT INTO CPG_config VALUES ('disable_comment_flood_protect', '0');
|
|
|
106 |
INSERT INTO CPG_config VALUES ('upl_notify_admin_email', '0');
|
|
|
107 |
INSERT INTO CPG_config VALUES ('display_uploader', '0');
|
|
|
108 |
|
|
|
109 |
INSERT INTO CPG_config VALUES ('language_list', '0');
|
|
|
110 |
INSERT INTO CPG_config VALUES ('language_flags', '0');
|
|
|
111 |
INSERT INTO CPG_config VALUES ('theme_list', '0');
|
|
|
112 |
INSERT INTO CPG_config VALUES ('language_reset', '1');
|
|
|
113 |
INSERT INTO CPG_config VALUES ('theme_reset', '1');
|
|
|
114 |
|
|
|
115 |
INSERT INTO CPG_config VALUES ('allow_memberlist', '0');
|
|
|
116 |
INSERT INTO CPG_config VALUES ('display_faq', '0');
|
|
|
117 |
INSERT INTO CPG_config VALUES ('show_bbcode_help', '1');
|
|
|
118 |
INSERT INTO CPG_config VALUES ('log_ecards', '0');
|
|
|
119 |
INSERT INTO CPG_config VALUES ('email_comment_notification', '0');
|
|
|
120 |
INSERT INTO CPG_config VALUES ('enable_zipdownload', '1');
|
|
|
121 |
INSERT INTO CPG_config VALUES ('slideshow_interval', '5000');
|
|
|
122 |
|
|
|
123 |
|
|
|
124 |
#
|
|
|
125 |
# Dumping data for table `CPG_filetypes`
|
|
|
126 |
#
|
|
|
127 |
|
|
|
128 |
INSERT INTO CPG_filetypes VALUES ('jpg', 'image/jpg', 'image');
|
|
|
129 |
INSERT INTO CPG_filetypes VALUES ('jpeg', 'image/jpeg', 'image');
|
|
|
130 |
INSERT INTO CPG_filetypes VALUES ('jpe', 'image/jpe', 'image');
|
|
|
131 |
INSERT INTO CPG_filetypes VALUES ('gif', 'image/gif', 'image');
|
|
|
132 |
INSERT INTO CPG_filetypes VALUES ('png', 'image/png', 'image');
|
|
|
133 |
INSERT INTO CPG_filetypes VALUES ('bmp', 'image/bmp', 'image');
|
|
|
134 |
INSERT INTO CPG_filetypes VALUES ('jpc', 'image/jpc', 'image');
|
|
|
135 |
INSERT INTO CPG_filetypes VALUES ('jp2', 'image/jp2', 'image');
|
|
|
136 |
INSERT INTO CPG_filetypes VALUES ('jpx', 'image/jpx', 'image');
|
|
|
137 |
INSERT INTO CPG_filetypes VALUES ('jb2', 'image/jb2', 'image');
|
|
|
138 |
INSERT INTO CPG_filetypes VALUES ('swc', 'image/swc', 'image');
|
|
|
139 |
INSERT INTO CPG_filetypes VALUES ('iff', 'image/iff', 'image');
|
|
|
140 |
|
|
|
141 |
INSERT INTO CPG_filetypes VALUES ('asf', 'video/x-ms-asf', 'movie');
|
|
|
142 |
INSERT INTO CPG_filetypes VALUES ('asx', 'video/x-ms-asx', 'movie');
|
|
|
143 |
INSERT INTO CPG_filetypes VALUES ('mpg', 'video/mpeg', 'movie');
|
|
|
144 |
INSERT INTO CPG_filetypes VALUES ('mpeg', 'video/mpeg', 'movie');
|
|
|
145 |
INSERT INTO CPG_filetypes VALUES ('wmv', 'video/x-ms-wmv', 'movie');
|
|
|
146 |
INSERT INTO CPG_filetypes VALUES ('swf', 'application/x-shockwave-flash', 'movie');
|
|
|
147 |
INSERT INTO CPG_filetypes VALUES ('avi', 'video/avi', 'movie');
|
|
|
148 |
INSERT INTO CPG_filetypes VALUES ('mov', 'video/quicktime', 'movie');
|
|
|
149 |
|
|
|
150 |
INSERT INTO CPG_filetypes VALUES ('mp3', 'audio/mpeg3', 'audio');
|
|
|
151 |
INSERT INTO CPG_filetypes VALUES ('midi', 'audio/midi', 'audio');
|
|
|
152 |
INSERT INTO CPG_filetypes VALUES ('mid', 'audio/midi', 'audio');
|
|
|
153 |
INSERT INTO CPG_filetypes VALUES ('wma', 'audio/x-ms-wma', 'audio');
|
|
|
154 |
INSERT INTO CPG_filetypes VALUES ('wav', 'audio/wav', 'audio');
|
|
|
155 |
INSERT INTO CPG_filetypes VALUES ('ogg', 'audio/ogg', 'audio');
|
|
|
156 |
|
|
|
157 |
INSERT INTO CPG_filetypes VALUES ('psd', 'image/psd', 'image');
|
|
|
158 |
INSERT INTO CPG_filetypes VALUES ('ram', 'audio/x-pn-realaudio', 'document');
|
|
|
159 |
INSERT INTO CPG_filetypes VALUES ('ra', 'audio/x-realaudio', 'document');
|
|
|
160 |
INSERT INTO CPG_filetypes VALUES ('rm', 'audio/x-realmedia', 'document');
|
|
|
161 |
INSERT INTO CPG_filetypes VALUES ('tiff', 'image/tiff', 'document');
|
|
|
162 |
INSERT INTO CPG_filetypes VALUES ('tif', 'image/tif', 'document');
|
|
|
163 |
INSERT INTO CPG_filetypes VALUES ('doc', 'application/msword', 'document');
|
|
|
164 |
INSERT INTO CPG_filetypes VALUES ('txt', 'text/plain', 'document');
|
|
|
165 |
INSERT INTO CPG_filetypes VALUES ('rtf', 'text/richtext', 'document');
|
|
|
166 |
INSERT INTO CPG_filetypes VALUES ('pdf', 'application/pdf', 'document');
|
|
|
167 |
INSERT INTO CPG_filetypes VALUES ('xls', 'application/excel', 'document');
|
|
|
168 |
INSERT INTO CPG_filetypes VALUES ('pps', 'application/powerpoint', 'document');
|
|
|
169 |
INSERT INTO CPG_filetypes VALUES ('ppt', 'application/powerpoint', 'document');
|
|
|
170 |
INSERT INTO CPG_filetypes VALUES ('zip', 'application/zip', 'document');
|
|
|
171 |
INSERT INTO CPG_filetypes VALUES ('rar', 'application/rar', 'document');
|
|
|
172 |
INSERT INTO CPG_filetypes VALUES ('gz', 'application/gz', 'document');
|
|
|
173 |
INSERT INTO CPG_filetypes VALUES ('mdb', 'application/msaccess', 'document');
|
|
|
174 |
|
|
|
175 |
|
|
|
176 |
#
|
|
|
177 |
# Dumping data for table `CPG_usergroups`
|
|
|
178 |
#
|
|
|
179 |
|
|
|
180 |
INSERT INTO CPG_usergroups VALUES (1, 'Administrators', 0, 1, 1, 1, 1, 1, 1, 0, 0, 3, 0, 5, 3);
|
|
|
181 |
INSERT INTO CPG_usergroups VALUES (2, 'Registered', 1024, 0, 1, 1, 1, 1, 1, 1, 0, 3, 0, 5, 3);
|
|
|
182 |
INSERT INTO CPG_usergroups VALUES (3, 'Anonymous', 0, 0, 1, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3);
|
|
|
183 |
INSERT INTO CPG_usergroups VALUES (4, 'Banned', 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 5, 3);
|
|
|
184 |
|
|
|
185 |
#
|
|
|
186 |
# Dumping data for table `CPG_categories`
|
|
|
187 |
#
|
|
|
188 |
|
|
|
189 |
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');
|