aboutsummaryrefslogtreecommitdiffstats
path: root/admin/phpwebgallery_structure.sql
blob: cdd6f22b3b70bf2437b3906cb390e8d3ddaad058 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
-- MySQL dump 8.21
--
-- Host: localhost    Database: devel
---------------------------------------------------------
-- Server version	3.23.49-log

--
-- Table structure for table 'phpwebgallery_categories'
--

DROP TABLE IF EXISTS phpwebgallery_categories;
CREATE TABLE phpwebgallery_categories (
  id smallint(5) unsigned NOT NULL auto_increment,
  date_last date default NULL,
  nb_images mediumint(8) unsigned NOT NULL default '0',
  name varchar(255) NOT NULL default '',
  id_uppercat smallint(5) unsigned default NULL,
  comment text,
  dir varchar(255) default NULL,
  rank tinyint(3) unsigned default NULL,
  status enum('public','private') NOT NULL default 'public',
  site_id tinyint(4) unsigned NOT NULL default '1',
  visible enum('true','false') NOT NULL default 'true',
  uploadable enum('true','false') NOT NULL default 'false',
  representative_picture_id mediumint(8) unsigned default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_comments'
--

DROP TABLE IF EXISTS phpwebgallery_comments;
CREATE TABLE phpwebgallery_comments (
  id int(11) unsigned NOT NULL auto_increment,
  image_id mediumint(8) unsigned NOT NULL default '0',
  date int(11) unsigned NOT NULL default '0',
  author varchar(255) default NULL,
  content longtext,
  validated enum('true','false') NOT NULL default 'false',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_config'
--

DROP TABLE IF EXISTS phpwebgallery_config;
CREATE TABLE phpwebgallery_config (
  prefix_thumbnail varchar(10) default 'TN-',
  webmaster varchar(255) NOT NULL default '',
  mail_webmaster varchar(255) NOT NULL default '',
  access enum('free','restricted') default 'free',
  session_id_size tinyint(3) unsigned NOT NULL default '4',
  session_keyword varchar(255) default NULL,
  session_time tinyint(3) unsigned NOT NULL default '30',
  max_user_listbox tinyint(3) unsigned NOT NULL default '10',
  show_comments enum('true','false') NOT NULL default 'true',
  nb_comment_page tinyint(4) NOT NULL default '10',
  upload_available enum('true','false') NOT NULL default 'false',
  upload_maxfilesize smallint(5) unsigned NOT NULL default '150',
  upload_maxwidth smallint(5) unsigned NOT NULL default '800',
  upload_maxheight smallint(5) unsigned NOT NULL default '600',
  upload_maxwidth_thumbnail smallint(5) unsigned NOT NULL default '150',
  upload_maxheight_thumbnail smallint(5) unsigned NOT NULL default '100',
  log enum('true','false') NOT NULL default 'false',
  comments_validation enum('true','false') NOT NULL default 'false',
  comments_forall enum('true','false') NOT NULL default 'false',
  authorize_cookies enum('true','false') NOT NULL default 'false',
  mail_notification enum('true','false') NOT NULL default 'false'
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_favorites'
--

DROP TABLE IF EXISTS phpwebgallery_favorites;
CREATE TABLE phpwebgallery_favorites (
  user_id smallint(5) unsigned NOT NULL default '0',
  image_id mediumint(8) unsigned NOT NULL default '0',
  KEY user_id (user_id,image_id)
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_group_access'
--

DROP TABLE IF EXISTS phpwebgallery_group_access;
CREATE TABLE phpwebgallery_group_access (
  group_id smallint(5) unsigned NOT NULL default '0',
  cat_id smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (group_id,cat_id)
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_groups'
--

DROP TABLE IF EXISTS phpwebgallery_groups;
CREATE TABLE phpwebgallery_groups (
  id smallint(5) unsigned NOT NULL auto_increment,
  name varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_history'
--

DROP TABLE IF EXISTS phpwebgallery_history;
CREATE TABLE phpwebgallery_history (
  date int(11) NOT NULL default '0',
  login varchar(15) default NULL,
  IP varchar(50) NOT NULL default '',
  category varchar(150) default NULL,
  file varchar(50) default NULL,
  picture varchar(150) default NULL
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_image_category'
--

DROP TABLE IF EXISTS phpwebgallery_image_category;
CREATE TABLE phpwebgallery_image_category (
  image_id mediumint(8) unsigned NOT NULL default '0',
  category_id smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (image_id,category_id)
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_images'
--

DROP TABLE IF EXISTS phpwebgallery_images;
CREATE TABLE phpwebgallery_images (
  id mediumint(8) unsigned NOT NULL auto_increment,
  file varchar(255) NOT NULL default '',
  date_available date NOT NULL default '0000-00-00',
  date_creation date default NULL,
  tn_ext char(3) NOT NULL default 'jpg',
  name varchar(255) default NULL,
  comment text,
  author varchar(255) default NULL,
  hit int(10) unsigned NOT NULL default '0',
  filesize mediumint(9) unsigned default NULL,
  width smallint(9) unsigned default NULL,
  height smallint(9) unsigned default NULL,
  keywords varchar(255) default NULL,
  storage_category_id smallint(5) unsigned default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_sessions'
--

DROP TABLE IF EXISTS phpwebgallery_sessions;
CREATE TABLE phpwebgallery_sessions (
  id varchar(255) binary NOT NULL default '',
  user_id smallint(5) unsigned NOT NULL default '0',
  expiration int(10) unsigned NOT NULL default '0',
  ip varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_sites'
--

DROP TABLE IF EXISTS phpwebgallery_sites;
CREATE TABLE phpwebgallery_sites (
  id tinyint(4) NOT NULL auto_increment,
  galleries_url varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY galleries_url (galleries_url)
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_user_access'
--

DROP TABLE IF EXISTS phpwebgallery_user_access;
CREATE TABLE phpwebgallery_user_access (
  user_id smallint(5) unsigned NOT NULL default '0',
  cat_id smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (user_id,cat_id)
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_user_group'
--

DROP TABLE IF EXISTS phpwebgallery_user_group;
CREATE TABLE phpwebgallery_user_group (
  user_id smallint(5) unsigned NOT NULL default '0',
  group_id smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (group_id,user_id)
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_users'
--

DROP TABLE IF EXISTS phpwebgallery_users;
CREATE TABLE phpwebgallery_users (
  id smallint(5) unsigned NOT NULL auto_increment,
  username varchar(20) binary NOT NULL default '',
  password varchar(255) NOT NULL default '',
  mail_address varchar(255) default NULL,
  nb_image_line tinyint(1) unsigned NOT NULL default '5',
  nb_line_page tinyint(3) unsigned NOT NULL default '3',
  status enum('admin','guest') NOT NULL default 'guest',
  language varchar(50) NOT NULL default 'english',
  maxwidth smallint(6) default NULL,
  maxheight smallint(6) default NULL,
  expand enum('true','false') NOT NULL default 'false',
  show_nb_comments enum('true','false') NOT NULL default 'false',
  short_period tinyint(3) unsigned NOT NULL default '7',
  long_period tinyint(3) unsigned NOT NULL default '14',
  template varchar(255) NOT NULL default 'default',
  PRIMARY KEY  (id),
  UNIQUE KEY pseudo (username)
) TYPE=MyISAM;

--
-- Table structure for table 'phpwebgallery_waiting'
--

DROP TABLE IF EXISTS phpwebgallery_waiting;
CREATE TABLE phpwebgallery_waiting (
  id int(10) unsigned NOT NULL auto_increment,
  storage_category_id smallint(5) unsigned NOT NULL default '0',
  file varchar(255) NOT NULL default '',
  username varchar(255) NOT NULL default '',
  mail_address varchar(255) NOT NULL default '',
  date int(10) unsigned NOT NULL default '0',
  tn_ext char(3) default NULL,
  validated enum('true','false') NOT NULL default 'false',
  infos text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;