- Timestamp:
- Oct 23, 2004, 11:02:11 AM (20 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/install/dbscheme.txt
r507 r573 17 17 table:waiting 18 18 19 column:id table:categories type:smallint nullable: Ylength:5 signed:N20 column:date_last table:categories type:date nullable: N21 column:nb_images table:categories type:mediumint nullable: Ylength:8 signed:N22 column:name table:categories type:varchar nullable: Ylength:255 binary:N23 column:id_uppercat table:categories type:smallint nullable: Nlength:5 signed:N24 column:comment table:categories type:text nullable: N25 column:dir table:categories type:varchar nullable: Nlength:255 binary:N26 column:rank table:categories type:tinyint nullable: Nlength:3 signed:N27 column:status table:categories type:enum('public','private') nullable: Y28 column:site_id table:categories type:tinyint nullable: Ylength:4 signed:N29 column:visible table:categories type:enum('true','false') nullable: Y30 column:uploadable table:categories type:enum('true','false') nullable: Y31 column:representative_picture_id table:categories type:mediumint nullable: Nlength:8 signed:N32 column:uppercats table:categories type:varchar nullable: Ylength:255 binary:N33 column:id table:comments type:int nullable: Ylength:11 signed:N34 column:image_id table:comments type:mediumint nullable: Ylength:8 signed:N35 column:date table:comments type:datetime nullable: Y36 column:author table:comments type:varchar nullable: Nlength:255 binary:N37 column:content table:comments type:longtext nullable: N38 column:validated table:comments type:enum('true','false') nullable: Y39 column:param table:config type:varchar nullable: Ylength:40 binary:N40 column:value table:config type:varchar nullable: Nlength:255 binary:N41 column:comment table:config type:varchar nullable: Nlength:255 binary:N42 column:user_id table:favorites type:smallint nullable: Ylength:5 signed:N43 column:image_id table:favorites type:mediumint nullable: Ylength:8 signed:N44 column:group_id table:group_access type:smallint nullable: Ylength:5 signed:N45 column:cat_id table:group_access type:smallint nullable: Ylength:5 signed:N46 column:id table:groups type:smallint nullable: Ylength:5 signed:N47 column:name table:groups type:varchar nullable: Ylength:255 binary:N48 column:date table:history type:int nullable: Ylength:11 signed:Y49 column:login table:history type:varchar nullable: Nlength:15 binary:N50 column:IP table:history type:varchar nullable: Ylength:50 binary:N51 column:category table:history type:varchar nullable: Nlength:150 binary:N52 column:file table:history type:varchar nullable: Nlength:50 binary:N53 column:picture table:history type:varchar nullable: Nlength:150 binary:N54 column:image_id table:image_category type:mediumint nullable: Ylength:8 signed:N55 column:category_id table:image_category type:smallint nullable: Ylength:5 signed:N56 column:id table:images type:mediumint nullable: Ylength:8 signed:N57 column:file table:images type:varchar nullable: Ylength:255 binary:N58 column:date_available table:images type:date nullable: Y59 column:date_creation table:images type:date nullable: N60 column:tn_ext table:images type:varchar nullable: Nlength:4 binary:N61 column:name table:images type:varchar nullable: Nlength:255 binary:N62 column:comment table:images type:text nullable: N63 column:author table:images type:varchar nullable: Nlength:255 binary:N64 column:hit table:images type:int nullable: Ylength:10 signed:N65 column:filesize table:images type:mediumint nullable: Nlength:9 signed:N66 column:width table:images type:smallint nullable: Nlength:9 signed:N67 column:height table:images type:smallint nullable: Nlength:9 signed:N68 column:keywords table:images type:varchar nullable: Nlength:255 binary:N69 column:storage_category_id table:images type:smallint nullable: Nlength:5 signed:N70 column:representative_ext table:images type:varchar nullable: Nlength:4 binary:N71 column:date_metadata_update table:images type:date nullable: N72 column:average_rate table:images type:float nullable: Nlength:5,2 signed:N73 column:user_id table:rate type:smallint nullable: Ylength:5 signed:N74 column:element_id table:rate type:mediumint nullable: Ylength:8 signed:N75 column:rate table:rate type:tinyint nullable: Ylength:2 signed:N76 column:id table:sessions type:varchar nullable: Ylength:255 binary:Y77 column:user_id table:sessions type:smallint nullable: Ylength:5 signed:N78 column:expiration table:sessions type:int nullable: Ylength:10 signed:N79 column:ip table:sessions type:varchar nullable: Ylength:255 binary:N80 column:id table:sites type:tinyint nullable: Ylength:4 signed:Y81 column:galleries_url table:sites type:varchar nullable: Ylength:255 binary:N82 column:user_id table:user_access type:smallint nullable: Ylength:5 signed:N83 column:cat_id table:user_access type:smallint nullable: Ylength:5 signed:N84 column:user_id table:user_group type:smallint nullable: Ylength:5 signed:N85 column:group_id table:user_group type:smallint nullable: Ylength:5 signed:N86 column:id table:users type:smallint nullable: Ylength:5 signed:N87 column:username table:users type:varchar nullable: Ylength:20 binary:Y88 column:password table:users type:varchar nullable: Ylength:255 binary:N89 column:mail_address table:users type:varchar nullable: Nlength:255 binary:N90 column:nb_image_line table:users type:tinyint nullable: Ylength:1 signed:N91 column:nb_line_page table:users type:tinyint nullable: Ylength:3 signed:N92 column:status table:users type:enum('admin','guest') nullable: Y93 column:language table:users type:varchar nullable: Ylength:50 binary:N94 column:maxwidth table:users type:smallint nullable: Nlength:6 signed:Y95 column:maxheight table:users type:smallint nullable: Nlength:6 signed:Y96 column:expand table:users type:enum('true','false') nullable: Y97 column:show_nb_comments table:users type:enum('true','false') nullable: Y98 column:recent_period table:users type:tinyint nullable: Ylength:3 signed:N99 column:template table:users type:varchar nullable: Ylength:255 binary:N100 column:forbidden_categories table:users type:text nullable: N101 column:id table:waiting type:int nullable: Ylength:10 signed:N102 column:storage_category_id table:waiting type:smallint nullable: Ylength:5 signed:N103 column:file table:waiting type:varchar nullable: Ylength:255 binary:N104 column:username table:waiting type:varchar nullable: Ylength:255 binary:N105 column:mail_address table:waiting type:varchar nullable: Ylength:255 binary:N106 column:date table:waiting type:int nullable: Ylength:10 signed:N107 column:tn_ext table:waiting type:char nullable: Nlength:3 binary:N108 column:validated table:waiting type:enum('true','false') nullable: Y109 column:infos table:waiting type:text nullable: N19 column:id table:categories type:smallint nullable:N length:5 signed:N 20 column:date_last table:categories type:date nullable:Y 21 column:nb_images table:categories type:mediumint nullable:N length:8 signed:N 22 column:name table:categories type:varchar nullable:N length:255 binary:N 23 column:id_uppercat table:categories type:smallint nullable:Y length:5 signed:N 24 column:comment table:categories type:text nullable:Y 25 column:dir table:categories type:varchar nullable:Y length:255 binary:N 26 column:rank table:categories type:tinyint nullable:Y length:3 signed:N 27 column:status table:categories type:enum('public','private') nullable:N 28 column:site_id table:categories type:tinyint nullable:N length:4 signed:N 29 column:visible table:categories type:enum('true','false') nullable:N 30 column:uploadable table:categories type:enum('true','false') nullable:N 31 column:representative_picture_id table:categories type:mediumint nullable:Y length:8 signed:N 32 column:uppercats table:categories type:varchar nullable:N length:255 binary:N 33 column:id table:comments type:int nullable:N length:11 signed:N 34 column:image_id table:comments type:mediumint nullable:N length:8 signed:N 35 column:date table:comments type:datetime nullable:N 36 column:author table:comments type:varchar nullable:Y length:255 binary:N 37 column:content table:comments type:longtext nullable:Y 38 column:validated table:comments type:enum('true','false') nullable:N 39 column:param table:config type:varchar nullable:N length:40 binary:N 40 column:value table:config type:varchar nullable:Y length:255 binary:N 41 column:comment table:config type:varchar nullable:Y length:255 binary:N 42 column:user_id table:favorites type:smallint nullable:N length:5 signed:N 43 column:image_id table:favorites type:mediumint nullable:N length:8 signed:N 44 column:group_id table:group_access type:smallint nullable:N length:5 signed:N 45 column:cat_id table:group_access type:smallint nullable:N length:5 signed:N 46 column:id table:groups type:smallint nullable:N length:5 signed:N 47 column:name table:groups type:varchar nullable:N length:255 binary:N 48 column:date table:history type:int nullable:N length:11 signed:Y 49 column:login table:history type:varchar nullable:Y length:15 binary:N 50 column:IP table:history type:varchar nullable:N length:50 binary:N 51 column:category table:history type:varchar nullable:Y length:150 binary:N 52 column:file table:history type:varchar nullable:Y length:50 binary:N 53 column:picture table:history type:varchar nullable:Y length:150 binary:N 54 column:image_id table:image_category type:mediumint nullable:N length:8 signed:N 55 column:category_id table:image_category type:smallint nullable:N length:5 signed:N 56 column:id table:images type:mediumint nullable:N length:8 signed:N 57 column:file table:images type:varchar nullable:N length:255 binary:N 58 column:date_available table:images type:date nullable:N 59 column:date_creation table:images type:date nullable:Y 60 column:tn_ext table:images type:varchar nullable:Y length:4 binary:N 61 column:name table:images type:varchar nullable:Y length:255 binary:N 62 column:comment table:images type:text nullable:Y 63 column:author table:images type:varchar nullable:Y length:255 binary:N 64 column:hit table:images type:int nullable:N length:10 signed:N 65 column:filesize table:images type:mediumint nullable:Y length:9 signed:N 66 column:width table:images type:smallint nullable:Y length:9 signed:N 67 column:height table:images type:smallint nullable:Y length:9 signed:N 68 column:keywords table:images type:varchar nullable:Y length:255 binary:N 69 column:storage_category_id table:images type:smallint nullable:Y length:5 signed:N 70 column:representative_ext table:images type:varchar nullable:Y length:4 binary:N 71 column:date_metadata_update table:images type:date nullable:Y 72 column:average_rate table:images type:float nullable:Y length:5,2 signed:N 73 column:user_id table:rate type:smallint nullable:N length:5 signed:N 74 column:element_id table:rate type:mediumint nullable:N length:8 signed:N 75 column:rate table:rate type:tinyint nullable:N length:2 signed:N 76 column:id table:sessions type:varchar nullable:N length:255 binary:Y 77 column:user_id table:sessions type:smallint nullable:N length:5 signed:N 78 column:expiration table:sessions type:int nullable:N length:10 signed:N 79 column:ip table:sessions type:varchar nullable:N length:255 binary:N 80 column:id table:sites type:tinyint nullable:N length:4 signed:Y 81 column:galleries_url table:sites type:varchar nullable:N length:255 binary:N 82 column:user_id table:user_access type:smallint nullable:N length:5 signed:N 83 column:cat_id table:user_access type:smallint nullable:N length:5 signed:N 84 column:user_id table:user_group type:smallint nullable:N length:5 signed:N 85 column:group_id table:user_group type:smallint nullable:N length:5 signed:N 86 column:id table:users type:smallint nullable:N length:5 signed:N 87 column:username table:users type:varchar nullable:N length:20 binary:Y 88 column:password table:users type:varchar nullable:N length:255 binary:N 89 column:mail_address table:users type:varchar nullable:Y length:255 binary:N 90 column:nb_image_line table:users type:tinyint nullable:N length:1 signed:N 91 column:nb_line_page table:users type:tinyint nullable:N length:3 signed:N 92 column:status table:users type:enum('admin','guest') nullable:N 93 column:language table:users type:varchar nullable:N length:50 binary:N 94 column:maxwidth table:users type:smallint nullable:Y length:6 signed:Y 95 column:maxheight table:users type:smallint nullable:Y length:6 signed:Y 96 column:expand table:users type:enum('true','false') nullable:N 97 column:show_nb_comments table:users type:enum('true','false') nullable:N 98 column:recent_period table:users type:tinyint nullable:N length:3 signed:N 99 column:template table:users type:varchar nullable:N length:255 binary:N 100 column:forbidden_categories table:users type:text nullable:Y 101 column:id table:waiting type:int nullable:N length:10 signed:N 102 column:storage_category_id table:waiting type:smallint nullable:N length:5 signed:N 103 column:file table:waiting type:varchar nullable:N length:255 binary:N 104 column:username table:waiting type:varchar nullable:N length:255 binary:N 105 column:mail_address table:waiting type:varchar nullable:N length:255 binary:N 106 column:date table:waiting type:int nullable:N length:10 signed:N 107 column:tn_ext table:waiting type:char nullable:Y length:3 binary:N 108 column:validated table:waiting type:enum('true','false') nullable:N 109 column:infos table:waiting type:text nullable:Y 110 110 111 111 PK:categories_pk table:categories column:id
Note: See TracChangeset
for help on using the changeset viewer.