TA的每日心情 | 衰 2021-2-2 11:21 |
---|
签到天数: 36 天 [LV.5]常住居民I
|
DROP TABLE IF EXISTS uc_pms;# MySQL 返回的查询结果为空(即零行)。
7 b9 M O- g' H$ \# ^% z# MySQL 返回的查询结果为空(即零行)。& K* o1 r4 G9 S% r
CREATE TABLE uc_pms(0 }% o0 `4 ^+ F+ t) T
pmid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
2 ]- S0 H3 q8 n* x& A0 ^msgfrom VARCHAR( 15 ) NOT NULL DEFAULT '',
: Z, [7 x$ x; N4 ] Y" ]4 Bmsgfromid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
5 a4 s+ _6 I* r( |: q! }! h- mmsgtoid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
& c& }1 a4 W I- P0 t/ J6 vfolder ENUM( 'inbox', 'outbox' ) NOT NULL DEFAULT 'inbox',( p' [" Y: Q; r
new TINYINT( 1 ) NOT NULL DEFAULT '0',
( T1 z$ V3 e3 i; Z. H" U" Usubject VARCHAR( 75 ) NOT NULL DEFAULT '',& H/ Q/ p! _5 S& e U& y
dateline INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
7 W" C- g" r' l6 jmessage TEXT NOT NULL ,+ P+ j/ g! G! Q* |$ M w" t/ `" S
delstatus TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',7 H* S2 | b- d' f0 U. i0 E! ^
related INT( 10 ) UNSIGNED NOT NULL DEFAULT '0', k% N- t$ F0 [6 E9 |* F. c$ J- _
PRIMARY KEY ( pmid ) ,
2 X. J! N" P: K7 ~$ L: i8 DKEY msgtoid( msgtoid, folder, dateline ) ,
/ K0 U7 [3 N4 K# aKEY msgfromid( msgfromid, folder, dateline ) ,
* C5 d( A: S+ U: D$ U* wKEY RELATED( related ) ,& h: a. j; v2 Q+ N; L! G2 v
KEY getnum( msgtoid, folder, delstatus )" w9 i1 P J! S; ?: j4 y3 a" o
) TYPE = MYISAM ;# MySQL 返回的查询结果为空(即零行)。; g8 [+ d6 n+ G# H! ?
4 I, s: J+ w; R$ ~
|
|