| 6 |
kaklik |
1 |
|
|
|
2 |
table:categories
|
|
|
3 |
table:comments
|
|
|
4 |
table:config
|
|
|
5 |
table:favorites
|
|
|
6 |
table:group_access
|
|
|
7 |
table:groups
|
|
|
8 |
table:history
|
|
|
9 |
table:image_category
|
|
|
10 |
table:images
|
|
|
11 |
table:rate
|
|
|
12 |
table:sessions
|
|
|
13 |
table:sites
|
|
|
14 |
table:user_access
|
|
|
15 |
table:user_forbidden
|
|
|
16 |
table:user_group
|
|
|
17 |
table:users
|
|
|
18 |
table:waiting
|
|
|
19 |
|
|
|
20 |
column:id table:categories type:smallint nullable:N length:5 signed:N
|
|
|
21 |
column:date_last table:categories type:date nullable:Y
|
|
|
22 |
column:nb_images table:categories type:mediumint nullable:N length:8 signed:N
|
|
|
23 |
column:name table:categories type:varchar nullable:N length:255 binary:N
|
|
|
24 |
column:id_uppercat table:categories type:smallint nullable:Y length:5 signed:N
|
|
|
25 |
column:comment table:categories type:text nullable:Y
|
|
|
26 |
column:dir table:categories type:varchar nullable:Y length:255 binary:N
|
|
|
27 |
column:rank table:categories type:tinyint nullable:Y length:3 signed:N
|
|
|
28 |
column:status table:categories type:enum('public','private') nullable:N
|
|
|
29 |
column:site_id table:categories type:tinyint nullable:Y length:4 signed:N
|
|
|
30 |
column:visible table:categories type:enum('true','false') nullable:N
|
|
|
31 |
column:uploadable table:categories type:enum('true','false') nullable:N
|
|
|
32 |
column:representative_picture_id table:categories type:mediumint nullable:Y length:8 signed:N
|
|
|
33 |
column:uppercats table:categories type:varchar nullable:N length:255 binary:N
|
|
|
34 |
column:commentable table:categories type:enum('true','false') nullable:N
|
|
|
35 |
column:global_rank table:categories type:varchar nullable:Y length:255 binary:N
|
|
|
36 |
column:id table:comments type:int nullable:N length:11 signed:N
|
|
|
37 |
column:image_id table:comments type:mediumint nullable:N length:8 signed:N
|
|
|
38 |
column:date table:comments type:datetime nullable:N
|
|
|
39 |
column:author table:comments type:varchar nullable:Y length:255 binary:N
|
|
|
40 |
column:content table:comments type:longtext nullable:Y
|
|
|
41 |
column:validated table:comments type:enum('true','false') nullable:N
|
|
|
42 |
column:param table:config type:varchar nullable:N length:40 binary:N
|
|
|
43 |
column:value table:config type:varchar nullable:Y length:255 binary:N
|
|
|
44 |
column:comment table:config type:varchar nullable:Y length:255 binary:N
|
|
|
45 |
column:user_id table:favorites type:smallint nullable:N length:5 signed:N
|
|
|
46 |
column:image_id table:favorites type:mediumint nullable:N length:8 signed:N
|
|
|
47 |
column:group_id table:group_access type:smallint nullable:N length:5 signed:N
|
|
|
48 |
column:cat_id table:group_access type:smallint nullable:N length:5 signed:N
|
|
|
49 |
column:id table:groups type:smallint nullable:N length:5 signed:N
|
|
|
50 |
column:name table:groups type:varchar nullable:N length:255 binary:N
|
|
|
51 |
column:date table:history type:datetime nullable:N
|
|
|
52 |
column:login table:history type:varchar nullable:Y length:15 binary:N
|
|
|
53 |
column:IP table:history type:varchar nullable:N length:50 binary:N
|
|
|
54 |
column:category table:history type:varchar nullable:Y length:150 binary:N
|
|
|
55 |
column:file table:history type:varchar nullable:Y length:50 binary:N
|
|
|
56 |
column:picture table:history type:varchar nullable:Y length:150 binary:N
|
|
|
57 |
column:image_id table:image_category type:mediumint nullable:N length:8 signed:N
|
|
|
58 |
column:category_id table:image_category type:smallint nullable:N length:5 signed:N
|
|
|
59 |
column:id table:images type:mediumint nullable:N length:8 signed:N
|
|
|
60 |
column:file table:images type:varchar nullable:N length:255 binary:N
|
|
|
61 |
column:date_available table:images type:date nullable:N
|
|
|
62 |
column:date_creation table:images type:date nullable:Y
|
|
|
63 |
column:tn_ext table:images type:varchar nullable:Y length:4 binary:N
|
|
|
64 |
column:name table:images type:varchar nullable:Y length:255 binary:N
|
|
|
65 |
column:comment table:images type:text nullable:Y
|
|
|
66 |
column:author table:images type:varchar nullable:Y length:255 binary:N
|
|
|
67 |
column:hit table:images type:int nullable:N length:10 signed:N
|
|
|
68 |
column:filesize table:images type:mediumint nullable:Y length:9 signed:N
|
|
|
69 |
column:width table:images type:smallint nullable:Y length:9 signed:N
|
|
|
70 |
column:height table:images type:smallint nullable:Y length:9 signed:N
|
|
|
71 |
column:keywords table:images type:varchar nullable:Y length:255 binary:N
|
|
|
72 |
column:storage_category_id table:images type:smallint nullable:Y length:5 signed:N
|
|
|
73 |
column:representative_ext table:images type:varchar nullable:Y length:4 binary:N
|
|
|
74 |
column:date_metadata_update table:images type:date nullable:Y
|
|
|
75 |
column:average_rate table:images type:float nullable:Y length:5,2 signed:N
|
|
|
76 |
column:path table:images type:varchar nullable:N length:255 binary:N
|
|
|
77 |
column:user_id table:rate type:smallint nullable:N length:5 signed:N
|
|
|
78 |
column:element_id table:rate type:mediumint nullable:N length:8 signed:N
|
|
|
79 |
column:rate table:rate type:tinyint nullable:N length:2 signed:N
|
|
|
80 |
column:id table:sessions type:varchar nullable:N length:255 binary:Y
|
|
|
81 |
column:user_id table:sessions type:smallint nullable:N length:5 signed:N
|
|
|
82 |
column:expiration table:sessions type:datetime nullable:N
|
|
|
83 |
column:id table:sites type:tinyint nullable:N length:4 signed:Y
|
|
|
84 |
column:galleries_url table:sites type:varchar nullable:N length:255 binary:N
|
|
|
85 |
column:user_id table:user_access type:smallint nullable:N length:5 signed:N
|
|
|
86 |
column:cat_id table:user_access type:smallint nullable:N length:5 signed:N
|
|
|
87 |
column:user_id table:user_forbidden type:smallint nullable:N length:5 signed:N
|
|
|
88 |
column:need_update table:user_forbidden type:enum('true','false') nullable:N
|
|
|
89 |
column:forbidden_categories table:user_forbidden type:text nullable:Y
|
|
|
90 |
column:user_id table:user_group type:smallint nullable:N length:5 signed:N
|
|
|
91 |
column:group_id table:user_group type:smallint nullable:N length:5 signed:N
|
|
|
92 |
column:id table:users type:smallint nullable:N length:5 signed:N
|
|
|
93 |
column:username table:users type:varchar nullable:N length:20 binary:Y
|
|
|
94 |
column:password table:users type:varchar nullable:N length:255 binary:N
|
|
|
95 |
column:mail_address table:users type:varchar nullable:Y length:255 binary:N
|
|
|
96 |
column:nb_image_line table:users type:tinyint nullable:N length:1 signed:N
|
|
|
97 |
column:nb_line_page table:users type:tinyint nullable:N length:3 signed:N
|
|
|
98 |
column:status table:users type:enum('admin','guest') nullable:N
|
|
|
99 |
column:language table:users type:varchar nullable:N length:50 binary:N
|
|
|
100 |
column:maxwidth table:users type:smallint nullable:Y length:6 signed:Y
|
|
|
101 |
column:maxheight table:users type:smallint nullable:Y length:6 signed:Y
|
|
|
102 |
column:expand table:users type:enum('true','false') nullable:N
|
|
|
103 |
column:show_nb_comments table:users type:enum('true','false') nullable:N
|
|
|
104 |
column:recent_period table:users type:tinyint nullable:N length:3 signed:N
|
|
|
105 |
column:template table:users type:varchar nullable:N length:255 binary:N
|
|
|
106 |
column:id table:waiting type:int nullable:N length:10 signed:N
|
|
|
107 |
column:storage_category_id table:waiting type:smallint nullable:N length:5 signed:N
|
|
|
108 |
column:file table:waiting type:varchar nullable:N length:255 binary:N
|
|
|
109 |
column:username table:waiting type:varchar nullable:N length:255 binary:N
|
|
|
110 |
column:mail_address table:waiting type:varchar nullable:N length:255 binary:N
|
|
|
111 |
column:date table:waiting type:int nullable:N length:10 signed:N
|
|
|
112 |
column:tn_ext table:waiting type:char nullable:Y length:3 binary:N
|
|
|
113 |
column:validated table:waiting type:enum('true','false') nullable:N
|
|
|
114 |
column:infos table:waiting type:text nullable:Y
|
|
|
115 |
|
|
|
116 |
PK:categories_pk table:categories column:id
|
|
|
117 |
PK:comments_pk table:comments column:id
|
|
|
118 |
PK:config_pk table:config column:param
|
|
|
119 |
PK:favorites_pk table:favorites column:user_id
|
|
|
120 |
PK:favorites_pk table:favorites column:image_id
|
|
|
121 |
PK:group_access_pk table:group_access column:group_id
|
|
|
122 |
PK:group_access_pk table:group_access column:cat_id
|
|
|
123 |
PK:groups_pk table:groups column:id
|
|
|
124 |
PK:image_category_pk table:image_category column:image_id
|
|
|
125 |
PK:image_category_pk table:image_category column:category_id
|
|
|
126 |
PK:images_pk table:images column:id
|
|
|
127 |
PK:rate_pk table:rate column:user_id
|
|
|
128 |
PK:rate_pk table:rate column:element_id
|
|
|
129 |
PK:sessions_pk table:sessions column:id
|
|
|
130 |
PK:sites_pk table:sites column:id
|
|
|
131 |
PK:user_access_pk table:user_access column:user_id
|
|
|
132 |
PK:user_access_pk table:user_access column:cat_id
|
|
|
133 |
PK:user_forbidden_pk table:user_forbidden column:user_id
|
|
|
134 |
PK:user_group_pk table:user_group column:group_id
|
|
|
135 |
PK:user_group_pk table:user_group column:user_id
|
|
|
136 |
PK:users_pk table:users column:id
|
|
|
137 |
PK:waiting_pk table:waiting column:id
|
|
|
138 |
|
|
|
139 |
index:categories_i2 table:categories column:id_uppercat
|
|
|
140 |
index:history_i1 table:history column:date
|
|
|
141 |
index:image_category_i1 table:image_category column:image_id
|
|
|
142 |
index:image_category_i2 table:image_category column:category_id
|
|
|
143 |
index:images_i2 table:images column:date_available
|
|
|
144 |
index:images_i1 table:images column:storage_category_id
|
|
|
145 |
index:images_i3 table:images column:average_rate
|
|
|
146 |
index:images_i4 table:images column:hit
|
|
|
147 |
index:images_i5 table:images column:date_creation
|
|
|
148 |
index:sites_ui1 table:sites column:galleries_url
|
|
|
149 |
index:users_ui1 table:users column:username
|