Go to most recent revision | Blame | Last modification | View Log | Download
table:categoriestable:commentstable:configtable:favoritestable:group_accesstable:groupstable:historytable:image_categorytable:imagestable:ratetable:sessionstable:sitestable:user_accesstable:user_forbiddentable:user_grouptable:userstable:waitingcolumn:id table:categories type:smallint nullable:N length:5 signed:Ncolumn:date_last table:categories type:date nullable:Ycolumn:nb_images table:categories type:mediumint nullable:N length:8 signed:Ncolumn:name table:categories type:varchar nullable:N length:255 binary:Ncolumn:id_uppercat table:categories type:smallint nullable:Y length:5 signed:Ncolumn:comment table:categories type:text nullable:Ycolumn:dir table:categories type:varchar nullable:Y length:255 binary:Ncolumn:rank table:categories type:tinyint nullable:Y length:3 signed:Ncolumn:status table:categories type:enum('public','private') nullable:Ncolumn:site_id table:categories type:tinyint nullable:Y length:4 signed:Ncolumn:visible table:categories type:enum('true','false') nullable:Ncolumn:uploadable table:categories type:enum('true','false') nullable:Ncolumn:representative_picture_id table:categories type:mediumint nullable:Y length:8 signed:Ncolumn:uppercats table:categories type:varchar nullable:N length:255 binary:Ncolumn:commentable table:categories type:enum('true','false') nullable:Ncolumn:global_rank table:categories type:varchar nullable:Y length:255 binary:Ncolumn:id table:comments type:int nullable:N length:11 signed:Ncolumn:image_id table:comments type:mediumint nullable:N length:8 signed:Ncolumn:date table:comments type:datetime nullable:Ncolumn:author table:comments type:varchar nullable:Y length:255 binary:Ncolumn:content table:comments type:longtext nullable:Ycolumn:validated table:comments type:enum('true','false') nullable:Ncolumn:param table:config type:varchar nullable:N length:40 binary:Ncolumn:value table:config type:varchar nullable:Y length:255 binary:Ncolumn:comment table:config type:varchar nullable:Y length:255 binary:Ncolumn:user_id table:favorites type:smallint nullable:N length:5 signed:Ncolumn:image_id table:favorites type:mediumint nullable:N length:8 signed:Ncolumn:group_id table:group_access type:smallint nullable:N length:5 signed:Ncolumn:cat_id table:group_access type:smallint nullable:N length:5 signed:Ncolumn:id table:groups type:smallint nullable:N length:5 signed:Ncolumn:name table:groups type:varchar nullable:N length:255 binary:Ncolumn:date table:history type:datetime nullable:Ncolumn:login table:history type:varchar nullable:Y length:15 binary:Ncolumn:IP table:history type:varchar nullable:N length:50 binary:Ncolumn:category table:history type:varchar nullable:Y length:150 binary:Ncolumn:file table:history type:varchar nullable:Y length:50 binary:Ncolumn:picture table:history type:varchar nullable:Y length:150 binary:Ncolumn:image_id table:image_category type:mediumint nullable:N length:8 signed:Ncolumn:category_id table:image_category type:smallint nullable:N length:5 signed:Ncolumn:id table:images type:mediumint nullable:N length:8 signed:Ncolumn:file table:images type:varchar nullable:N length:255 binary:Ncolumn:date_available table:images type:date nullable:Ncolumn:date_creation table:images type:date nullable:Ycolumn:tn_ext table:images type:varchar nullable:Y length:4 binary:Ncolumn:name table:images type:varchar nullable:Y length:255 binary:Ncolumn:comment table:images type:text nullable:Ycolumn:author table:images type:varchar nullable:Y length:255 binary:Ncolumn:hit table:images type:int nullable:N length:10 signed:Ncolumn:filesize table:images type:mediumint nullable:Y length:9 signed:Ncolumn:width table:images type:smallint nullable:Y length:9 signed:Ncolumn:height table:images type:smallint nullable:Y length:9 signed:Ncolumn:keywords table:images type:varchar nullable:Y length:255 binary:Ncolumn:storage_category_id table:images type:smallint nullable:Y length:5 signed:Ncolumn:representative_ext table:images type:varchar nullable:Y length:4 binary:Ncolumn:date_metadata_update table:images type:date nullable:Ycolumn:average_rate table:images type:float nullable:Y length:5,2 signed:Ncolumn:path table:images type:varchar nullable:N length:255 binary:Ncolumn:user_id table:rate type:smallint nullable:N length:5 signed:Ncolumn:element_id table:rate type:mediumint nullable:N length:8 signed:Ncolumn:rate table:rate type:tinyint nullable:N length:2 signed:Ncolumn:id table:sessions type:varchar nullable:N length:255 binary:Ycolumn:user_id table:sessions type:smallint nullable:N length:5 signed:Ncolumn:expiration table:sessions type:datetime nullable:Ncolumn:id table:sites type:tinyint nullable:N length:4 signed:Ycolumn:galleries_url table:sites type:varchar nullable:N length:255 binary:Ncolumn:user_id table:user_access type:smallint nullable:N length:5 signed:Ncolumn:cat_id table:user_access type:smallint nullable:N length:5 signed:Ncolumn:user_id table:user_forbidden type:smallint nullable:N length:5 signed:Ncolumn:need_update table:user_forbidden type:enum('true','false') nullable:Ncolumn:forbidden_categories table:user_forbidden type:text nullable:Ycolumn:user_id table:user_group type:smallint nullable:N length:5 signed:Ncolumn:group_id table:user_group type:smallint nullable:N length:5 signed:Ncolumn:id table:users type:smallint nullable:N length:5 signed:Ncolumn:username table:users type:varchar nullable:N length:20 binary:Ycolumn:password table:users type:varchar nullable:N length:255 binary:Ncolumn:mail_address table:users type:varchar nullable:Y length:255 binary:Ncolumn:nb_image_line table:users type:tinyint nullable:N length:1 signed:Ncolumn:nb_line_page table:users type:tinyint nullable:N length:3 signed:Ncolumn:status table:users type:enum('admin','guest') nullable:Ncolumn:language table:users type:varchar nullable:N length:50 binary:Ncolumn:maxwidth table:users type:smallint nullable:Y length:6 signed:Ycolumn:maxheight table:users type:smallint nullable:Y length:6 signed:Ycolumn:expand table:users type:enum('true','false') nullable:Ncolumn:show_nb_comments table:users type:enum('true','false') nullable:Ncolumn:recent_period table:users type:tinyint nullable:N length:3 signed:Ncolumn:template table:users type:varchar nullable:N length:255 binary:Ncolumn:id table:waiting type:int nullable:N length:10 signed:Ncolumn:storage_category_id table:waiting type:smallint nullable:N length:5 signed:Ncolumn:file table:waiting type:varchar nullable:N length:255 binary:Ncolumn:username table:waiting type:varchar nullable:N length:255 binary:Ncolumn:mail_address table:waiting type:varchar nullable:N length:255 binary:Ncolumn:date table:waiting type:int nullable:N length:10 signed:Ncolumn:tn_ext table:waiting type:char nullable:Y length:3 binary:Ncolumn:validated table:waiting type:enum('true','false') nullable:Ncolumn:infos table:waiting type:text nullable:YPK:categories_pk table:categories column:idPK:comments_pk table:comments column:idPK:config_pk table:config column:paramPK:favorites_pk table:favorites column:user_idPK:favorites_pk table:favorites column:image_idPK:group_access_pk table:group_access column:group_idPK:group_access_pk table:group_access column:cat_idPK:groups_pk table:groups column:idPK:image_category_pk table:image_category column:image_idPK:image_category_pk table:image_category column:category_idPK:images_pk table:images column:idPK:rate_pk table:rate column:user_idPK:rate_pk table:rate column:element_idPK:sessions_pk table:sessions column:idPK:sites_pk table:sites column:idPK:user_access_pk table:user_access column:user_idPK:user_access_pk table:user_access column:cat_idPK:user_forbidden_pk table:user_forbidden column:user_idPK:user_group_pk table:user_group column:group_idPK:user_group_pk table:user_group column:user_idPK:users_pk table:users column:idPK:waiting_pk table:waiting column:idindex:categories_i2 table:categories column:id_uppercatindex:history_i1 table:history column:dateindex:image_category_i1 table:image_category column:image_idindex:image_category_i2 table:image_category column:category_idindex:images_i2 table:images column:date_availableindex:images_i1 table:images column:storage_category_idindex:images_i3 table:images column:average_rateindex:images_i4 table:images column:hitindex:images_i5 table:images column:date_creationindex:sites_ui1 table:sites column:galleries_urlindex:users_ui1 table:users column:username