1 | -- MySQL dump 8.21 |
---|
2 | -- |
---|
3 | -- Host: localhost Database: devel |
---|
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 NOT NULL 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 | PRIMARY KEY (id) |
---|
27 | ) TYPE=MyISAM; |
---|
28 | |
---|
29 | -- |
---|
30 | -- Table structure for table 'phpwebgallery_comments' |
---|
31 | -- |
---|
32 | |
---|
33 | DROP TABLE IF EXISTS phpwebgallery_comments; |
---|
34 | CREATE TABLE phpwebgallery_comments ( |
---|
35 | id int(11) unsigned NOT NULL auto_increment, |
---|
36 | image_id mediumint(8) unsigned NOT NULL default '0', |
---|
37 | date int(11) unsigned NOT NULL default '0', |
---|
38 | author varchar(255) default NULL, |
---|
39 | content longtext, |
---|
40 | validated enum('true','false') NOT NULL default 'false', |
---|
41 | PRIMARY KEY (id) |
---|
42 | ) TYPE=MyISAM; |
---|
43 | |
---|
44 | -- |
---|
45 | -- Table structure for table 'phpwebgallery_config' |
---|
46 | -- |
---|
47 | |
---|
48 | DROP TABLE IF EXISTS phpwebgallery_config; |
---|
49 | CREATE TABLE phpwebgallery_config ( |
---|
50 | prefix_thumbnail varchar(10) default 'TN-', |
---|
51 | webmaster varchar(255) NOT NULL default '', |
---|
52 | mail_webmaster varchar(255) NOT NULL default '', |
---|
53 | access enum('free','restricted') default 'free', |
---|
54 | session_id_size tinyint(3) unsigned NOT NULL default '4', |
---|
55 | session_keyword varchar(255) default NULL, |
---|
56 | session_time tinyint(3) unsigned NOT NULL default '30', |
---|
57 | max_user_listbox tinyint(3) unsigned NOT NULL default '10', |
---|
58 | show_comments enum('true','false') NOT NULL default 'true', |
---|
59 | nb_comment_page tinyint(4) NOT NULL default '10', |
---|
60 | upload_available enum('true','false') NOT NULL default 'false', |
---|
61 | upload_maxfilesize smallint(5) unsigned NOT NULL default '150', |
---|
62 | upload_maxwidth smallint(5) unsigned NOT NULL default '800', |
---|
63 | upload_maxheight smallint(5) unsigned NOT NULL default '600', |
---|
64 | upload_maxwidth_thumbnail smallint(5) unsigned NOT NULL default '150', |
---|
65 | upload_maxheight_thumbnail smallint(5) unsigned NOT NULL default '100', |
---|
66 | log enum('true','false') NOT NULL default 'false', |
---|
67 | comments_validation enum('true','false') NOT NULL default 'false', |
---|
68 | comments_forall enum('true','false') NOT NULL default 'false', |
---|
69 | authorize_cookies enum('true','false') NOT NULL default 'false', |
---|
70 | mail_notification enum('true','false') NOT NULL default 'false' |
---|
71 | ) TYPE=MyISAM; |
---|
72 | |
---|
73 | -- |
---|
74 | -- Table structure for table 'phpwebgallery_favorites' |
---|
75 | -- |
---|
76 | |
---|
77 | DROP TABLE IF EXISTS phpwebgallery_favorites; |
---|
78 | CREATE TABLE phpwebgallery_favorites ( |
---|
79 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
80 | image_id mediumint(8) unsigned NOT NULL default '0', |
---|
81 | KEY user_id (user_id,image_id) |
---|
82 | ) TYPE=MyISAM; |
---|
83 | |
---|
84 | -- |
---|
85 | -- Table structure for table 'phpwebgallery_group_access' |
---|
86 | -- |
---|
87 | |
---|
88 | DROP TABLE IF EXISTS phpwebgallery_group_access; |
---|
89 | CREATE TABLE phpwebgallery_group_access ( |
---|
90 | group_id smallint(5) unsigned NOT NULL default '0', |
---|
91 | cat_id smallint(5) unsigned NOT NULL default '0', |
---|
92 | PRIMARY KEY (group_id,cat_id) |
---|
93 | ) TYPE=MyISAM; |
---|
94 | |
---|
95 | -- |
---|
96 | -- Table structure for table 'phpwebgallery_groups' |
---|
97 | -- |
---|
98 | |
---|
99 | DROP TABLE IF EXISTS phpwebgallery_groups; |
---|
100 | CREATE TABLE phpwebgallery_groups ( |
---|
101 | id smallint(5) unsigned NOT NULL auto_increment, |
---|
102 | name varchar(255) NOT NULL default '', |
---|
103 | PRIMARY KEY (id) |
---|
104 | ) TYPE=MyISAM; |
---|
105 | |
---|
106 | -- |
---|
107 | -- Table structure for table 'phpwebgallery_history' |
---|
108 | -- |
---|
109 | |
---|
110 | DROP TABLE IF EXISTS phpwebgallery_history; |
---|
111 | CREATE TABLE phpwebgallery_history ( |
---|
112 | date int(11) NOT NULL default '0', |
---|
113 | login varchar(15) default NULL, |
---|
114 | IP varchar(50) NOT NULL default '', |
---|
115 | category varchar(150) default NULL, |
---|
116 | file varchar(50) default NULL, |
---|
117 | picture varchar(150) default NULL |
---|
118 | ) TYPE=MyISAM; |
---|
119 | |
---|
120 | -- |
---|
121 | -- Table structure for table 'phpwebgallery_image_category' |
---|
122 | -- |
---|
123 | |
---|
124 | DROP TABLE IF EXISTS phpwebgallery_image_category; |
---|
125 | CREATE TABLE phpwebgallery_image_category ( |
---|
126 | image_id mediumint(8) unsigned NOT NULL default '0', |
---|
127 | category_id smallint(5) unsigned NOT NULL default '0', |
---|
128 | PRIMARY KEY (image_id,category_id) |
---|
129 | ) TYPE=MyISAM; |
---|
130 | |
---|
131 | -- |
---|
132 | -- Table structure for table 'phpwebgallery_images' |
---|
133 | -- |
---|
134 | |
---|
135 | DROP TABLE IF EXISTS phpwebgallery_images; |
---|
136 | CREATE TABLE phpwebgallery_images ( |
---|
137 | id mediumint(8) unsigned NOT NULL auto_increment, |
---|
138 | file varchar(255) NOT NULL default '', |
---|
139 | date_available date NOT NULL default '0000-00-00', |
---|
140 | date_creation date default NULL, |
---|
141 | tn_ext char(3) NOT NULL default 'jpg', |
---|
142 | name varchar(255) default NULL, |
---|
143 | comment text, |
---|
144 | author varchar(255) default NULL, |
---|
145 | hit int(10) unsigned NOT NULL default '0', |
---|
146 | filesize mediumint(9) unsigned default NULL, |
---|
147 | width smallint(9) unsigned default NULL, |
---|
148 | height smallint(9) unsigned default NULL, |
---|
149 | keywords varchar(255) default NULL, |
---|
150 | storage_category_id smallint(5) unsigned default NULL, |
---|
151 | PRIMARY KEY (id), |
---|
152 | KEY storage_category_id (storage_category_id) |
---|
153 | ) TYPE=MyISAM; |
---|
154 | |
---|
155 | -- |
---|
156 | -- Table structure for table 'phpwebgallery_sessions' |
---|
157 | -- |
---|
158 | |
---|
159 | DROP TABLE IF EXISTS phpwebgallery_sessions; |
---|
160 | CREATE TABLE phpwebgallery_sessions ( |
---|
161 | id varchar(255) binary NOT NULL default '', |
---|
162 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
163 | expiration int(10) unsigned NOT NULL default '0', |
---|
164 | ip varchar(255) NOT NULL default '', |
---|
165 | PRIMARY KEY (id) |
---|
166 | ) TYPE=MyISAM; |
---|
167 | |
---|
168 | -- |
---|
169 | -- Table structure for table 'phpwebgallery_sites' |
---|
170 | -- |
---|
171 | |
---|
172 | DROP TABLE IF EXISTS phpwebgallery_sites; |
---|
173 | CREATE TABLE phpwebgallery_sites ( |
---|
174 | id tinyint(4) NOT NULL auto_increment, |
---|
175 | galleries_url varchar(255) NOT NULL default '', |
---|
176 | PRIMARY KEY (id), |
---|
177 | UNIQUE KEY galleries_url (galleries_url) |
---|
178 | ) TYPE=MyISAM; |
---|
179 | |
---|
180 | -- |
---|
181 | -- Table structure for table 'phpwebgallery_user_access' |
---|
182 | -- |
---|
183 | |
---|
184 | DROP TABLE IF EXISTS phpwebgallery_user_access; |
---|
185 | CREATE TABLE phpwebgallery_user_access ( |
---|
186 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
187 | cat_id smallint(5) unsigned NOT NULL default '0', |
---|
188 | PRIMARY KEY (user_id,cat_id) |
---|
189 | ) TYPE=MyISAM; |
---|
190 | |
---|
191 | -- |
---|
192 | -- Table structure for table 'phpwebgallery_user_group' |
---|
193 | -- |
---|
194 | |
---|
195 | DROP TABLE IF EXISTS phpwebgallery_user_group; |
---|
196 | CREATE TABLE phpwebgallery_user_group ( |
---|
197 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
198 | group_id smallint(5) unsigned NOT NULL default '0', |
---|
199 | PRIMARY KEY (group_id,user_id) |
---|
200 | ) TYPE=MyISAM; |
---|
201 | |
---|
202 | -- |
---|
203 | -- Table structure for table 'phpwebgallery_users' |
---|
204 | -- |
---|
205 | |
---|
206 | DROP TABLE IF EXISTS phpwebgallery_users; |
---|
207 | CREATE TABLE phpwebgallery_users ( |
---|
208 | id smallint(5) unsigned NOT NULL auto_increment, |
---|
209 | username varchar(20) binary NOT NULL default '', |
---|
210 | password varchar(255) NOT NULL default '', |
---|
211 | mail_address varchar(255) default NULL, |
---|
212 | nb_image_line tinyint(1) unsigned NOT NULL default '5', |
---|
213 | nb_line_page tinyint(3) unsigned NOT NULL default '3', |
---|
214 | status enum('admin','guest') NOT NULL default 'guest', |
---|
215 | language varchar(50) NOT NULL default 'english', |
---|
216 | maxwidth smallint(6) default NULL, |
---|
217 | maxheight smallint(6) default NULL, |
---|
218 | expand enum('true','false') NOT NULL default 'false', |
---|
219 | show_nb_comments enum('true','false') NOT NULL default 'false', |
---|
220 | short_period tinyint(3) unsigned NOT NULL default '7', |
---|
221 | long_period tinyint(3) unsigned NOT NULL default '14', |
---|
222 | template varchar(255) NOT NULL default 'default', |
---|
223 | PRIMARY KEY (id), |
---|
224 | UNIQUE KEY username (username) |
---|
225 | ) TYPE=MyISAM; |
---|
226 | |
---|
227 | -- |
---|
228 | -- Table structure for table 'phpwebgallery_waiting' |
---|
229 | -- |
---|
230 | |
---|
231 | DROP TABLE IF EXISTS phpwebgallery_waiting; |
---|
232 | CREATE TABLE phpwebgallery_waiting ( |
---|
233 | id int(10) unsigned NOT NULL auto_increment, |
---|
234 | storage_category_id smallint(5) unsigned NOT NULL default '0', |
---|
235 | file varchar(255) NOT NULL default '', |
---|
236 | username varchar(255) NOT NULL default '', |
---|
237 | mail_address varchar(255) NOT NULL default '', |
---|
238 | date int(10) unsigned NOT NULL default '0', |
---|
239 | tn_ext char(3) default NULL, |
---|
240 | validated enum('true','false') NOT NULL default 'false', |
---|
241 | infos text, |
---|
242 | PRIMARY KEY (id) |
---|
243 | ) TYPE=MyISAM; |
---|
244 | |
---|