1 | -- MySQL dump 8.21 |
---|
2 | -- |
---|
3 | -- Host: localhost Database: pwg-bsf |
---|
4 | --------------------------------------------------------- |
---|
5 | -- Server version 3.23.49-log |
---|
6 | |
---|
7 | -- |
---|
8 | -- Table structure for table 'phpwebgallery_categories' |
---|
9 | -- |
---|
10 | |
---|
11 | DROP TABLE IF EXISTS phpwebgallery_categories; |
---|
12 | CREATE TABLE phpwebgallery_categories ( |
---|
13 | id smallint(5) unsigned NOT NULL auto_increment, |
---|
14 | date_last date default NULL, |
---|
15 | nb_images mediumint(8) unsigned NOT NULL default '0', |
---|
16 | name varchar(255) NOT NULL default '', |
---|
17 | id_uppercat smallint(5) unsigned default NULL, |
---|
18 | comment text, |
---|
19 | dir varchar(255) default NULL, |
---|
20 | rank tinyint(3) unsigned default NULL, |
---|
21 | status enum('public','private') NOT NULL default 'public', |
---|
22 | site_id tinyint(4) unsigned default '1', |
---|
23 | visible enum('true','false') NOT NULL default 'true', |
---|
24 | uploadable enum('true','false') NOT NULL default 'false', |
---|
25 | representative_picture_id mediumint(8) unsigned default NULL, |
---|
26 | uppercats varchar(255) NOT NULL default '', |
---|
27 | commentable enum('true','false') NOT NULL default 'true', |
---|
28 | PRIMARY KEY (id), |
---|
29 | KEY categories_i2 (id_uppercat) |
---|
30 | ) TYPE=MyISAM; |
---|
31 | |
---|
32 | -- |
---|
33 | -- Table structure for table 'phpwebgallery_comments' |
---|
34 | -- |
---|
35 | |
---|
36 | DROP TABLE IF EXISTS phpwebgallery_comments; |
---|
37 | CREATE TABLE phpwebgallery_comments ( |
---|
38 | id int(11) unsigned NOT NULL auto_increment, |
---|
39 | image_id mediumint(8) unsigned NOT NULL default '0', |
---|
40 | date datetime NOT NULL default '0000-00-00 00:00:00', |
---|
41 | author varchar(255) default NULL, |
---|
42 | content longtext, |
---|
43 | validated enum('true','false') NOT NULL default 'false', |
---|
44 | PRIMARY KEY (id) |
---|
45 | ) TYPE=MyISAM; |
---|
46 | |
---|
47 | -- |
---|
48 | -- Table structure for table 'phpwebgallery_config' |
---|
49 | -- |
---|
50 | |
---|
51 | DROP TABLE IF EXISTS phpwebgallery_config; |
---|
52 | CREATE TABLE phpwebgallery_config ( |
---|
53 | param varchar(40) NOT NULL default '', |
---|
54 | value varchar(255) default NULL, |
---|
55 | comment varchar(255) default NULL, |
---|
56 | PRIMARY KEY (param) |
---|
57 | ) TYPE=MyISAM COMMENT='configuration table'; |
---|
58 | |
---|
59 | -- |
---|
60 | -- Table structure for table 'phpwebgallery_favorites' |
---|
61 | -- |
---|
62 | |
---|
63 | DROP TABLE IF EXISTS phpwebgallery_favorites; |
---|
64 | CREATE TABLE phpwebgallery_favorites ( |
---|
65 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
66 | image_id mediumint(8) unsigned NOT NULL default '0', |
---|
67 | PRIMARY KEY (user_id,image_id) |
---|
68 | ) TYPE=MyISAM; |
---|
69 | |
---|
70 | -- |
---|
71 | -- Table structure for table 'phpwebgallery_group_access' |
---|
72 | -- |
---|
73 | |
---|
74 | DROP TABLE IF EXISTS phpwebgallery_group_access; |
---|
75 | CREATE TABLE phpwebgallery_group_access ( |
---|
76 | group_id smallint(5) unsigned NOT NULL default '0', |
---|
77 | cat_id smallint(5) unsigned NOT NULL default '0', |
---|
78 | PRIMARY KEY (group_id,cat_id) |
---|
79 | ) TYPE=MyISAM; |
---|
80 | |
---|
81 | -- |
---|
82 | -- Table structure for table 'phpwebgallery_groups' |
---|
83 | -- |
---|
84 | |
---|
85 | DROP TABLE IF EXISTS phpwebgallery_groups; |
---|
86 | CREATE TABLE phpwebgallery_groups ( |
---|
87 | id smallint(5) unsigned NOT NULL auto_increment, |
---|
88 | name varchar(255) NOT NULL default '', |
---|
89 | PRIMARY KEY (id) |
---|
90 | ) TYPE=MyISAM; |
---|
91 | |
---|
92 | -- |
---|
93 | -- Table structure for table 'phpwebgallery_history' |
---|
94 | -- |
---|
95 | |
---|
96 | DROP TABLE IF EXISTS phpwebgallery_history; |
---|
97 | CREATE TABLE phpwebgallery_history ( |
---|
98 | date datetime NOT NULL default '0000-00-00 00:00:00', |
---|
99 | login varchar(15) default NULL, |
---|
100 | IP varchar(50) NOT NULL default '', |
---|
101 | category varchar(150) default NULL, |
---|
102 | file varchar(50) default NULL, |
---|
103 | picture varchar(150) default NULL, |
---|
104 | PRIMARY KEY (date) |
---|
105 | ) TYPE=MyISAM; |
---|
106 | |
---|
107 | -- |
---|
108 | -- Table structure for table 'phpwebgallery_image_category' |
---|
109 | -- |
---|
110 | |
---|
111 | DROP TABLE IF EXISTS phpwebgallery_image_category; |
---|
112 | CREATE TABLE phpwebgallery_image_category ( |
---|
113 | image_id mediumint(8) unsigned NOT NULL default '0', |
---|
114 | category_id smallint(5) unsigned NOT NULL default '0', |
---|
115 | PRIMARY KEY (image_id,category_id), |
---|
116 | KEY image_category_i1 (image_id), |
---|
117 | KEY image_category_i2 (category_id) |
---|
118 | ) TYPE=MyISAM; |
---|
119 | |
---|
120 | -- |
---|
121 | -- Table structure for table 'phpwebgallery_images' |
---|
122 | -- |
---|
123 | |
---|
124 | DROP TABLE IF EXISTS phpwebgallery_images; |
---|
125 | CREATE TABLE phpwebgallery_images ( |
---|
126 | id mediumint(8) unsigned NOT NULL auto_increment, |
---|
127 | file varchar(255) NOT NULL default '', |
---|
128 | date_available date NOT NULL default '0000-00-00', |
---|
129 | date_creation date default NULL, |
---|
130 | tn_ext varchar(4) default '', |
---|
131 | name varchar(255) default NULL, |
---|
132 | comment text, |
---|
133 | author varchar(255) default NULL, |
---|
134 | hit int(10) unsigned NOT NULL default '0', |
---|
135 | filesize mediumint(9) unsigned default NULL, |
---|
136 | width smallint(9) unsigned default NULL, |
---|
137 | height smallint(9) unsigned default NULL, |
---|
138 | keywords varchar(255) default NULL, |
---|
139 | storage_category_id smallint(5) unsigned default NULL, |
---|
140 | representative_ext varchar(4) default NULL, |
---|
141 | date_metadata_update date default NULL, |
---|
142 | average_rate float(5,2) unsigned default NULL, |
---|
143 | path varchar(255) NOT NULL default '', |
---|
144 | PRIMARY KEY (id), |
---|
145 | KEY images_i2 (date_available), |
---|
146 | KEY images_i1 (storage_category_id), |
---|
147 | KEY images_i3 (average_rate), |
---|
148 | KEY images_i4 (hit), |
---|
149 | KEY images_i5 (date_creation) |
---|
150 | ) TYPE=MyISAM; |
---|
151 | |
---|
152 | -- |
---|
153 | -- Table structure for table 'phpwebgallery_rate' |
---|
154 | -- |
---|
155 | |
---|
156 | DROP TABLE IF EXISTS phpwebgallery_rate; |
---|
157 | CREATE TABLE phpwebgallery_rate ( |
---|
158 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
159 | element_id mediumint(8) unsigned NOT NULL default '0', |
---|
160 | rate tinyint(2) unsigned NOT NULL default '0', |
---|
161 | PRIMARY KEY (user_id,element_id) |
---|
162 | ) TYPE=MyISAM; |
---|
163 | |
---|
164 | -- |
---|
165 | -- Table structure for table 'phpwebgallery_sessions' |
---|
166 | -- |
---|
167 | |
---|
168 | DROP TABLE IF EXISTS phpwebgallery_sessions; |
---|
169 | CREATE TABLE phpwebgallery_sessions ( |
---|
170 | id varchar(255) binary NOT NULL default '', |
---|
171 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
172 | expiration int(10) unsigned NOT NULL default '0', |
---|
173 | ip varchar(255) NOT NULL default '', |
---|
174 | PRIMARY KEY (id) |
---|
175 | ) TYPE=MyISAM; |
---|
176 | |
---|
177 | -- |
---|
178 | -- Table structure for table 'phpwebgallery_sites' |
---|
179 | -- |
---|
180 | |
---|
181 | DROP TABLE IF EXISTS phpwebgallery_sites; |
---|
182 | CREATE TABLE phpwebgallery_sites ( |
---|
183 | id tinyint(4) NOT NULL auto_increment, |
---|
184 | galleries_url varchar(255) NOT NULL default '', |
---|
185 | PRIMARY KEY (id), |
---|
186 | UNIQUE KEY sites_ui1 (galleries_url) |
---|
187 | ) TYPE=MyISAM; |
---|
188 | |
---|
189 | -- |
---|
190 | -- Table structure for table 'phpwebgallery_user_access' |
---|
191 | -- |
---|
192 | |
---|
193 | DROP TABLE IF EXISTS phpwebgallery_user_access; |
---|
194 | CREATE TABLE phpwebgallery_user_access ( |
---|
195 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
196 | cat_id smallint(5) unsigned NOT NULL default '0', |
---|
197 | PRIMARY KEY (user_id,cat_id) |
---|
198 | ) TYPE=MyISAM; |
---|
199 | |
---|
200 | -- |
---|
201 | -- Table structure for table 'phpwebgallery_user_group' |
---|
202 | -- |
---|
203 | |
---|
204 | DROP TABLE IF EXISTS phpwebgallery_user_group; |
---|
205 | CREATE TABLE phpwebgallery_user_group ( |
---|
206 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
207 | group_id smallint(5) unsigned NOT NULL default '0', |
---|
208 | PRIMARY KEY (group_id,user_id) |
---|
209 | ) TYPE=MyISAM; |
---|
210 | |
---|
211 | -- |
---|
212 | -- Table structure for table 'phpwebgallery_users' |
---|
213 | -- |
---|
214 | |
---|
215 | DROP TABLE IF EXISTS phpwebgallery_users; |
---|
216 | CREATE TABLE phpwebgallery_users ( |
---|
217 | id smallint(5) unsigned NOT NULL auto_increment, |
---|
218 | username varchar(20) binary NOT NULL default '', |
---|
219 | password varchar(255) NOT NULL default '', |
---|
220 | mail_address varchar(255) default NULL, |
---|
221 | nb_image_line tinyint(1) unsigned NOT NULL default '5', |
---|
222 | nb_line_page tinyint(3) unsigned NOT NULL default '3', |
---|
223 | status enum('admin','guest') NOT NULL default 'guest', |
---|
224 | language varchar(50) NOT NULL default 'english', |
---|
225 | maxwidth smallint(6) default NULL, |
---|
226 | maxheight smallint(6) default NULL, |
---|
227 | expand enum('true','false') NOT NULL default 'false', |
---|
228 | show_nb_comments enum('true','false') NOT NULL default 'false', |
---|
229 | recent_period tinyint(3) unsigned NOT NULL default '7', |
---|
230 | template varchar(255) NOT NULL default 'default', |
---|
231 | forbidden_categories text, |
---|
232 | PRIMARY KEY (id), |
---|
233 | UNIQUE KEY users_ui1 (username) |
---|
234 | ) TYPE=MyISAM; |
---|
235 | |
---|
236 | -- |
---|
237 | -- Table structure for table 'phpwebgallery_waiting' |
---|
238 | -- |
---|
239 | |
---|
240 | DROP TABLE IF EXISTS phpwebgallery_waiting; |
---|
241 | CREATE TABLE phpwebgallery_waiting ( |
---|
242 | id int(10) unsigned NOT NULL auto_increment, |
---|
243 | storage_category_id smallint(5) unsigned NOT NULL default '0', |
---|
244 | file varchar(255) NOT NULL default '', |
---|
245 | username varchar(255) NOT NULL default '', |
---|
246 | mail_address varchar(255) NOT NULL default '', |
---|
247 | date int(10) unsigned NOT NULL default '0', |
---|
248 | tn_ext char(3) default NULL, |
---|
249 | validated enum('true','false') NOT NULL default 'false', |
---|
250 | infos text, |
---|
251 | PRIMARY KEY (id) |
---|
252 | ) TYPE=MyISAM; |
---|
253 | |
---|