Changeset 2566:9bf417837888 for inc/dbschema/db-schema.php
- Timestamp:
- 11/17/13 20:25:53 (12 years ago)
- Branch:
- 2.6
- Children:
- 2567:6c11245cbf04, 2568:61c67a7d17fa
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
inc/dbschema/db-schema.php
r1179 r2566 27 27 ->blog_desc ('text', 0, true) 28 28 ->blog_status ('smallint', 0, false, 1) 29 29 30 30 ->primary('pk_blog','blog_id') 31 31 ; … … 40 40 ->cat_lft ('integer', 0, true) 41 41 ->cat_rgt ('integer', 0, true) 42 42 43 43 ->primary('pk_category','cat_id') 44 44 45 45 ->unique('uk_cat_url','cat_url','blog_id') 46 46 ; … … 51 51 ->ses_start ('integer', 0, false, 0) 52 52 ->ses_value ('text', 0, false) 53 53 54 54 ->primary('pk_session','ses_id') 55 55 ; … … 62 62 ->setting_type ('varchar', 8, false, "'string'") 63 63 ->setting_label ('text', 0, true) 64 64 65 65 ->unique('uk_setting','setting_ns','setting_id','blog_id') 66 66 ; … … 86 86 ->user_creadt ('timestamp', 0, false, 'now()') 87 87 ->user_upddt ('timestamp', 0, false, 'now()') 88 88 89 89 ->primary('pk_user','user_id') 90 90 ; … … 94 94 ->blog_id ('varchar', 32, false) 95 95 ->permissions ('text', 0, true) 96 96 97 97 ->primary('pk_permissions','user_id','blog_id') 98 98 ; … … 127 127 ->nb_comment ('integer', 0, false, 0) 128 128 ->nb_trackback ('integer', 0, false, 0) 129 129 130 130 ->primary('pk_post','post_id') 131 131 132 132 ->unique('uk_post_url','post_url','post_type','blog_id') 133 133 ; … … 145 145 ->media_upddt ('timestamp', 0, false, 'now()') 146 146 ->media_private ('smallint', 0, false, 0) 147 147 148 148 ->primary('pk_media','media_id') 149 149 ; … … 153 153 ->post_id ('bigint', 0, false) 154 154 ->link_type ('varchar', 32, false, "'attachment'") 155 155 156 156 ->primary('pk_post_media','media_id','post_id','link_type') 157 157 ; … … 165 165 ->log_ip ('varchar', 39, false) 166 166 ->log_msg ('text', 0, true, null) 167 167 168 168 ->primary('pk_log','log_id') 169 169 ; … … 172 172 ->module ('varchar', 64, false) 173 173 ->version ('varchar', 32, false) 174 174 175 175 ->primary('pk_version','module') 176 176 ; … … 180 180 ->ping_url ('varchar', 255, false) 181 181 ->ping_dt ('timestamp', 0, false, 'now()') 182 182 183 183 ->primary('pk_ping','post_id','ping_url') 184 184 ; … … 200 200 ->comment_spam_filter ('varchar', 32, true, null) 201 201 ->comment_trackback ('smallint', 0, false, 0) 202 202 203 203 ->primary('pk_comment','comment_id') 204 204 ; … … 208 208 ->meta_type ('varchar', 64, false) 209 209 ->post_id ('bigint', 0, false) 210 210 211 211 ->primary('pk_meta','meta_id','meta_type','post_id') 212 212 ; … … 219 219 ->pref_type ('varchar', 8, false, "'string'") 220 220 ->pref_label ('text', 0, true) 221 221 222 222 ->unique('uk_pref','pref_ws','pref_id','user_id') 223 223 ; … … 280 280 $_s->pref->index ('idx_pref_user_id_null', 'btree', '(user_id IS NULL)'); 281 281 } 282 ?>
Note: See TracChangeset
for help on using the changeset viewer.