TA的每日心情 | 衰 2021-2-2 11:21 |
---|
签到天数: 36 天 [LV.5]常住居民I
|
DROP TABLE IF EXISTS uc_pms;# MySQL 返回的查询结果为空(即零行)。& |, u4 c' q/ M7 F3 q$ K
# MySQL 返回的查询结果为空(即零行)。
( B, z" ]* R7 m" aCREATE TABLE uc_pms(
, a( J! v5 }$ @% Dpmid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,/ ?! F ?% _8 D6 l. G
msgfrom VARCHAR( 15 ) NOT NULL DEFAULT '',
' E3 L. }6 C, c3 o. s- emsgfromid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
& G0 P2 u7 w. ]$ f6 E) g* [ Pmsgtoid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
/ T2 t+ z3 w6 q& t* n( v6 g8 ]; gfolder ENUM( 'inbox', 'outbox' ) NOT NULL DEFAULT 'inbox',
' o8 x" O. B( h: v5 j8 H7 [new TINYINT( 1 ) NOT NULL DEFAULT '0',
% q; ]- A. p e) l* U4 Usubject VARCHAR( 75 ) NOT NULL DEFAULT '',, t3 `# o: z) K. a ]1 H
dateline INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'," _2 D2 l" B( |3 a$ G T$ D$ O: w
message TEXT NOT NULL ,, v( N$ I& y& o3 h2 }
delstatus TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',- s8 Y6 i/ d9 ]$ Y4 R" _) h# L& U
related INT( 10 ) UNSIGNED NOT NULL DEFAULT '0', l8 n5 } v9 @/ k& Z' ?9 m1 s! [
PRIMARY KEY ( pmid ) ,
/ N2 K/ ~, k0 M/ F, ^4 cKEY msgtoid( msgtoid, folder, dateline ) ,
+ f8 k* l, z& H# \: GKEY msgfromid( msgfromid, folder, dateline ) ,
9 z" R( T6 p0 u) e/ Z. A8 y* \KEY RELATED( related ) ,- I) f4 x" C. V3 e
KEY getnum( msgtoid, folder, delstatus )% v& q6 O6 u8 H ~. d# A
) TYPE = MYISAM ;# MySQL 返回的查询结果为空(即零行)。
9 m- P1 ^: k! L
; o: |6 K# X% d: C" J) E6 o1 z |
|