Subversion Repositories svnkaklik

Rev

Details | Last modification | View Log

Rev Author Line No. Line
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