TA的每日心情 | 衰 2021-2-2 11:21 |
---|
签到天数: 36 天 [LV.5]常住居民I
|
DROP TABLE IF EXISTS uc_pms;# MySQL 返回的查询结果为空(即零行)。: f4 _7 ^4 J3 v+ H3 b
# MySQL 返回的查询结果为空(即零行)。
4 E+ k- c! {& aCREATE TABLE uc_pms(, p$ N9 R0 M7 X
pmid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
# P, {2 H( }. ]1 fmsgfrom VARCHAR( 15 ) NOT NULL DEFAULT '',
9 ^- i/ D( f9 bmsgfromid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',' Q- Y9 w* L- ?* o
msgtoid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',5 m9 x/ X& q5 ]. x( z0 x. w
folder ENUM( 'inbox', 'outbox' ) NOT NULL DEFAULT 'inbox',! p" l# V" N e' Q q3 K& D% `
new TINYINT( 1 ) NOT NULL DEFAULT '0', ]: z0 A" ]! G, u3 u1 A
subject VARCHAR( 75 ) NOT NULL DEFAULT '',
* z7 ]/ ]/ p/ \ edateline INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
E* C; J- s( U a/ xmessage TEXT NOT NULL ,
& P6 {1 q- k( s8 {" G% h/ pdelstatus TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',7 z6 }' p- u1 P5 u3 U
related INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
$ C% l" U, J; _PRIMARY KEY ( pmid ) ,: d Q; ~3 Z r
KEY msgtoid( msgtoid, folder, dateline ) ,5 ^+ B$ r9 x8 C8 J
KEY msgfromid( msgfromid, folder, dateline ) ,# w3 @1 v3 d8 s0 }, l8 b1 u I0 F
KEY RELATED( related ) ,
( }& l: N. E4 ?# O1 m+ G7 IKEY getnum( msgtoid, folder, delstatus )
) D+ J3 q" j! B& R" k6 [) TYPE = MYISAM ;# MySQL 返回的查询结果为空(即零行)。4 f" O1 E* \$ K. i1 {: A- k
" Y5 c7 s8 y! H% ~ |
|