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