aboutsummaryrefslogtreecommitdiffstats
path: root/install/dbscheme.txt
blob: 002059c4dd767d6f123177286b5c1d56a23ade87 (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
table:caddie
table:categories
table:comments
table:config
table:favorites
table:group_access
table:groups
table:history
table:image_category
table:images
table:rate
table:sessions
table:sites
table:user_access
table:user_forbidden
table:user_group
table:users
table:waiting

column:user_id                   table:caddie         type:smallint                 nullable:N length:5   signed:Y
column:element_id                table:caddie         type:mediumint                nullable:N length:8   signed:Y
column:id                        table:categories     type:smallint                 nullable:N length:5   signed:N
column:date_last                 table:categories     type:datetime                 nullable:Y
column:nb_images                 table:categories     type:mediumint                nullable:N length:8   signed:N
column:name                      table:categories     type:varchar                  nullable:N length:255 binary:N
column:id_uppercat               table:categories     type:smallint                 nullable:Y length:5   signed:N
column:comment                   table:categories     type:text                     nullable:Y
column:dir                       table:categories     type:varchar                  nullable:Y length:255 binary:N
column:rank                      table:categories     type:tinyint                  nullable:Y length:3   signed:N
column:status                    table:categories     type:enum('public','private') nullable:N
column:site_id                   table:categories     type:tinyint                  nullable:Y length:4   signed:N
column:visible                   table:categories     type:enum('true','false')     nullable:N
column:uploadable                table:categories     type:enum('true','false')     nullable:N
column:representative_picture_id table:categories     type:mediumint                nullable:Y length:8   signed:N
column:uppercats                 table:categories     type:varchar                  nullable:N length:255 binary:N
column:commentable               table:categories     type:enum('true','false')     nullable:N
column:global_rank               table:categories     type:varchar                  nullable:Y length:255 binary:N
column:id                        table:comments       type:int                      nullable:N length:11  signed:N
column:image_id                  table:comments       type:mediumint                nullable:N length:8   signed:N
column:date                      table:comments       type:datetime                 nullable:N
column:author                    table:comments       type:varchar                  nullable:Y length:255 binary:N
column:content                   table:comments       type:longtext                 nullable:Y
column:validated                 table:comments       type:enum('true','false')     nullable:N
column:validation_date           table:comments       type:datetime                 nullable:Y
column:param                     table:config         type:varchar                  nullable:N length:40  binary:N
column:value                     table:config         type:varchar                  nullable:Y length:255 binary:N
column:comment                   table:config         type:varchar                  nullable:Y length:255 binary:N
column:user_id                   table:favorites      type:smallint                 nullable:N length:5   signed:N
column:image_id                  table:favorites      type:mediumint                nullable:N length:8   signed:N
column:group_id                  table:group_access   type:smallint                 nullable:N length:5   signed:N
column:cat_id                    table:group_access   type:smallint                 nullable:N length:5   signed:N
column:id                        table:groups         type:smallint                 nullable:N length:5   signed:N
column:name                      table:groups         type:varchar                  nullable:N length:255 binary:N
column:date                      table:history        type:datetime                 nullable:N
column:login                     table:history        type:varchar                  nullable:Y length:15  binary:N
column:IP                        table:history        type:varchar                  nullable:N length:50  binary:N
column:category                  table:history        type:varchar                  nullable:Y length:150 binary:N
column:file                      table:history        type:varchar                  nullable:Y length:50  binary:N
column:picture                   table:history        type:varchar                  nullable:Y length:150 binary:N
column:image_id                  table:image_category type:mediumint                nullable:N length:8   signed:N
column:category_id               table:image_category type:smallint                 nullable:N length:5   signed:N
column:id                        table:images         type:mediumint                nullable:N length:8   signed:N
column:file                      table:images         type:varchar                  nullable:N length:255 binary:N
column:date_available            table:images         type:datetime                 nullable:N
column:date_creation             table:images         type:date                     nullable:Y
column:tn_ext                    table:images         type:varchar                  nullable:Y length:4   binary:N
column:name                      table:images         type:varchar                  nullable:Y length:255 binary:N
column:comment                   table:images         type:text                     nullable:Y
column:author                    table:images         type:varchar                  nullable:Y length:255 binary:N
column:hit                       table:images         type:int                      nullable:N length:10  signed:N
column:filesize                  table:images         type:mediumint                nullable:Y length:9   signed:N
column:width                     table:images         type:smallint                 nullable:Y length:9   signed:N
column:height                    table:images         type:smallint                 nullable:Y length:9   signed:N
column:keywords                  table:images         type:varchar                  nullable:Y length:255 binary:N
column:storage_category_id       table:images         type:smallint                 nullable:Y length:5   signed:N
column:representative_ext        table:images         type:varchar                  nullable:Y length:4   binary:N
column:date_metadata_update      table:images         type:date                     nullable:Y
column:average_rate              table:images         type:float                    nullable:Y length:5,2 signed:N
column:path                      table:images         type:varchar                  nullable:N length:255 binary:N
column:user_id                   table:rate           type:smallint                 nullable:N length:5   signed:N
column:element_id                table:rate           type:mediumint                nullable:N length:8   signed:N
column:rate                      table:rate           type:tinyint                  nullable:N length:2   signed:N
column:id                        table:sessions       type:varchar                  nullable:N length:255 binary:Y
column:user_id                   table:sessions       type:smallint                 nullable:N length:5   signed:N
column:expiration                table:sessions       type:datetime                 nullable:N
column:id                        table:sites          type:tinyint                  nullable:N length:4   signed:Y
column:galleries_url             table:sites          type:varchar                  nullable:N length:255 binary:N
column:user_id                   table:user_access    type:smallint                 nullable:N length:5   signed:N
column:cat_id                    table:user_access    type:smallint                 nullable:N length:5   signed:N
column:user_id                   table:user_forbidden type:smallint                 nullable:N length:5   signed:N
column:need_update               table:user_forbidden type:enum('true','false')     nullable:N
column:forbidden_categories      table:user_forbidden type:text                     nullable:Y
column:user_id                   table:user_group     type:smallint                 nullable:N length:5   signed:N
column:group_id                  table:user_group     type:smallint                 nullable:N length:5   signed:N
column:id                        table:users          type:smallint                 nullable:N length:5   signed:N
column:username                  table:users          type:varchar                  nullable:N length:20  binary:Y
column:password                  table:users          type:varchar                  nullable:Y length:32  binary:N
column:mail_address              table:users          type:varchar                  nullable:Y length:255 binary:N
column:nb_image_line             table:users          type:tinyint                  nullable:N length:1   signed:N
column:nb_line_page              table:users          type:tinyint                  nullable:N length:3   signed:N
column:status                    table:users          type:enum('admin','guest')    nullable:N
column:language                  table:users          type:varchar                  nullable:N length:50  binary:N
column:maxwidth                  table:users          type:smallint                 nullable:Y length:6   signed:Y
column:maxheight                 table:users          type:smallint                 nullable:Y length:6   signed:Y
column:expand                    table:users          type:enum('true','false')     nullable:N
column:show_nb_comments          table:users          type:enum('true','false')     nullable:N
column:recent_period             table:users          type:tinyint                  nullable:N length:3   signed:N
column:template                  table:users          type:varchar                  nullable:N length:255 binary:N
column:last_feed_check           table:users          type:datetime                 nullable:Y
column:feed_id                   table:users          type:varchar                  nullable:Y length:50  binary:Y
column:registration_date         table:users          type:datetime                 nullable:N
column:id                        table:waiting        type:int                      nullable:N length:10  signed:N
column:storage_category_id       table:waiting        type:smallint                 nullable:N length:5   signed:N
column:file                      table:waiting        type:varchar                  nullable:N length:255 binary:N
column:username                  table:waiting        type:varchar                  nullable:N length:255 binary:N
column:mail_address              table:waiting        type:varchar                  nullable:N length:255 binary:N
column:date                      table:waiting        type:int                      nullable:N length:10  signed:N
column:tn_ext                    table:waiting        type:char                     nullable:Y length:3   binary:N
column:validated                 table:waiting        type:enum('true','false')     nullable:N
column:infos                     table:waiting        type:text                     nullable:Y

PK:caddie_pk         table:caddie         column:user_id
PK:caddie_pk         table:caddie         column:element_id
PK:categories_pk     table:categories     column:id
PK:comments_pk       table:comments       column:id
PK:config_pk         table:config         column:param
PK:favorites_pk      table:favorites      column:user_id
PK:favorites_pk      table:favorites      column:image_id
PK:group_access_pk   table:group_access   column:group_id
PK:group_access_pk   table:group_access   column:cat_id
PK:groups_pk         table:groups         column:id
PK:image_category_pk table:image_category column:image_id
PK:image_category_pk table:image_category column:category_id
PK:images_pk         table:images         column:id
PK:rate_pk           table:rate           column:user_id
PK:rate_pk           table:rate           column:element_id
PK:sessions_pk       table:sessions       column:id
PK:sites_pk          table:sites          column:id
PK:user_access_pk    table:user_access    column:user_id
PK:user_access_pk    table:user_access    column:cat_id
PK:user_forbidden_pk table:user_forbidden column:user_id
PK:user_group_pk     table:user_group     column:group_id
PK:user_group_pk     table:user_group     column:user_id
PK:users_pk          table:users          column:id
PK:waiting_pk        table:waiting        column:id

index:categories_i2     table:categories     column:id_uppercat
index:comments_i2       table:comments       column:validation_date
index:comments_i1       table:comments       column:image_id
index:history_i1        table:history        column:date
index:image_category_i1 table:image_category column:image_id
index:image_category_i2 table:image_category column:category_id
index:images_i2         table:images         column:date_available
index:images_i1         table:images         column:storage_category_id
index:images_i3         table:images         column:average_rate
index:images_i4         table:images         column:hit
index:images_i5         table:images         column:date_creation
index:sites_ui1         table:sites          column:galleries_url
index:users_ui1         table:users          column:username