TA的每日心情 | 衰 2021-2-2 11:21 |
---|
签到天数: 36 天 [LV.5]常住居民I
|
DROP TABLE IF EXISTS uc_pms;# MySQL 返回的查询结果为空(即零行)。
/ @) B. z( ^6 @9 m! Z. l# J# MySQL 返回的查询结果为空(即零行)。
0 s) ~ b# W& j* fCREATE TABLE uc_pms(1 d o$ r+ X6 M) N
pmid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,+ E8 ] a, c, Q2 l* H. q/ Z
msgfrom VARCHAR( 15 ) NOT NULL DEFAULT '',- A; v* Z3 W6 t: q
msgfromid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
) z8 s+ j2 P3 G# e& m/ d O1 g7 h+ Cmsgtoid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
/ w$ r" U0 `1 D) Yfolder ENUM( 'inbox', 'outbox' ) NOT NULL DEFAULT 'inbox',
- h: e- a- P7 F$ G* S7 k9 I9 Fnew TINYINT( 1 ) NOT NULL DEFAULT '0',& n3 d, G( \5 C- ~% F$ L
subject VARCHAR( 75 ) NOT NULL DEFAULT '',
6 R5 f" J% s% F. C4 h( ]1 Gdateline INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
% y) e1 r( [, R9 }message TEXT NOT NULL ,
, i2 `2 Z3 M+ ]& E. jdelstatus TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0', ` y3 p4 A, k6 G& t8 T* D
related INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
: u$ {/ @0 U/ d* K% {5 sPRIMARY KEY ( pmid ) ,8 u: k( U( M0 k( s( I9 O
KEY msgtoid( msgtoid, folder, dateline ) ,
) B3 F' |% Q/ }* t! o8 O uKEY msgfromid( msgfromid, folder, dateline ) ,
& L9 G+ z L! T4 K& ?3 W$ aKEY RELATED( related ) ,; U' _+ j! k+ s: u
KEY getnum( msgtoid, folder, delstatus )
& Y. ?- }/ g; R4 b1 J8 j9 q( \) TYPE = MYISAM ;# MySQL 返回的查询结果为空(即零行)。+ }: w5 M! J6 [) T; @3 ?
; T$ e% s2 R: k& k% P
|
|