TA的每日心情 | 衰 2021-2-2 11:21 |
---|
签到天数: 36 天 [LV.5]常住居民I
|
DROP TABLE IF EXISTS uc_pms;# MySQL 返回的查询结果为空(即零行)。
- ^% k, I& b% v3 N( z+ y# MySQL 返回的查询结果为空(即零行)。
" I- W0 S) N* H2 i; C* I9 j: n' oCREATE TABLE uc_pms(2 L5 s8 L/ _7 g5 H) S$ \: m
pmid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
& Y3 Q8 i* H4 a) gmsgfrom VARCHAR( 15 ) NOT NULL DEFAULT '',+ ]+ _1 R! ~* N6 l0 K% o; X, T
msgfromid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0'," U, I, B+ G& v0 p% b
msgtoid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
% c/ t% P- g; P e# {' w: @2 Ifolder ENUM( 'inbox', 'outbox' ) NOT NULL DEFAULT 'inbox',
: `- g( z7 I& y8 T: i) e! c* gnew TINYINT( 1 ) NOT NULL DEFAULT '0',
$ U! y, V0 E/ J0 t! F/ n- Rsubject VARCHAR( 75 ) NOT NULL DEFAULT '',
6 R2 d5 E; h6 D! N. s; P2 pdateline INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
( ]' I: a5 N, H+ f4 i3 B0 zmessage TEXT NOT NULL ,9 `( ~* m" i" r& `
delstatus TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',- l7 ` j* I" |0 s5 k* g
related INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',, D3 T5 j, E2 P
PRIMARY KEY ( pmid ) ,
! ~& y' ]9 j" k; H" o" ?KEY msgtoid( msgtoid, folder, dateline ) ,* ?' P8 _# h- @6 i
KEY msgfromid( msgfromid, folder, dateline ) ,2 c2 n i* h. v/ M
KEY RELATED( related ) ,8 q1 m$ p# m: A& b( c B2 ]
KEY getnum( msgtoid, folder, delstatus )
3 v& s# J- v! I) TYPE = MYISAM ;# MySQL 返回的查询结果为空(即零行)。& O+ g' T: r/ ]/ B; |
8 S& q5 }0 I6 x( H1 _* o/ I0 V |
|