TA的每日心情 | 衰 2021-2-2 11:21 |
---|
签到天数: 36 天 [LV.5]常住居民I
|
DROP TABLE IF EXISTS uc_pms;# MySQL 返回的查询结果为空(即零行)。- S& T- i- Y2 F. O: N# i
# MySQL 返回的查询结果为空(即零行)。
, ?3 K9 k. y9 C/ k, x3 RCREATE TABLE uc_pms(& J! e. K2 e* U" L5 p# J2 _
pmid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
; W( c3 a6 ~/ Vmsgfrom VARCHAR( 15 ) NOT NULL DEFAULT '',4 O8 R& P3 D8 f* t! K& v m" K
msgfromid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
9 j' g6 e8 D6 H2 e6 zmsgtoid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',8 w; \8 x/ w. u# s/ K% O& m
folder ENUM( 'inbox', 'outbox' ) NOT NULL DEFAULT 'inbox',
& s& g9 a" h# R) l$ u/ `new TINYINT( 1 ) NOT NULL DEFAULT '0',1 w0 N: |" ^+ r& ^3 Y! H/ `
subject VARCHAR( 75 ) NOT NULL DEFAULT '',
6 m- s! l) e ~8 |( Zdateline INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
9 E2 T( b- ], n' u1 P6 w* |/ nmessage TEXT NOT NULL ,
* t+ I5 n. r+ A8 m+ u* Kdelstatus TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',. ^$ b& K; d$ S C7 T/ F) B
related INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
: g8 g4 b, X9 s) } Q) k, n- TPRIMARY KEY ( pmid ) ,
7 P \. C9 n5 Q2 Q; ]1 B! vKEY msgtoid( msgtoid, folder, dateline ) ,7 r( |( u1 L, D' O/ o$ t Q
KEY msgfromid( msgfromid, folder, dateline ) ," M \# ]! V; a- F% t
KEY RELATED( related ) ,
$ w7 @6 s0 {4 v5 k; UKEY getnum( msgtoid, folder, delstatus ), U: G# @8 P6 i; ?4 f
) TYPE = MYISAM ;# MySQL 返回的查询结果为空(即零行)。
% L) f/ B" M5 ]; ]( @7 S8 E; {9 z
|
|