TA的每日心情 | 衰 2021-2-2 11:21 |
---|
签到天数: 36 天 [LV.5]常住居民I
|
DROP TABLE IF EXISTS uc_pms;# MySQL 返回的查询结果为空(即零行)。
! w( J, R# Q B9 }# MySQL 返回的查询结果为空(即零行)。
! O# i0 a% S3 t, t7 H" bCREATE TABLE uc_pms(
6 `. q8 b0 Y, G. G0 E1 E( ppmid INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
$ t- V$ R) X# _- b+ X: R- amsgfrom VARCHAR( 15 ) NOT NULL DEFAULT '',
- w! A: Q2 e' Pmsgfromid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
1 S9 s# }- n# f( B+ Fmsgtoid MEDIUMINT( 8 ) UNSIGNED NOT NULL DEFAULT '0',
+ R! w. [0 D, v: Kfolder ENUM( 'inbox', 'outbox' ) NOT NULL DEFAULT 'inbox',
- r4 r) f) w/ m9 L7 wnew TINYINT( 1 ) NOT NULL DEFAULT '0', ^+ X/ g; s7 w$ D+ P
subject VARCHAR( 75 ) NOT NULL DEFAULT '',8 L& g5 d) L" B. N3 A* j ]3 k8 @, g4 C
dateline INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
) |* h0 Z' `; v$ j9 ~0 _$ cmessage TEXT NOT NULL ,
; W8 p: f4 q( U" Z6 v- udelstatus TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0',
5 {9 t5 m8 `% ?% [4 Lrelated INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',6 L2 P; p: t8 }
PRIMARY KEY ( pmid ) ,
, B! u+ ] `7 ~/ VKEY msgtoid( msgtoid, folder, dateline ) , w& {; q. `. U& q( Z4 P' E6 d
KEY msgfromid( msgfromid, folder, dateline ) ,
: `7 x0 q g! X+ E8 NKEY RELATED( related ) ,( w3 L8 n& E* z! N( \
KEY getnum( msgtoid, folder, delstatus )
. C) M' \# t. S x0 F$ i8 g* Q) TYPE = MYISAM ;# MySQL 返回的查询结果为空(即零行)。3 n$ \- c5 T; w. H( q, |" \9 | S
/ c3 C9 _: Y: A- J) i( f6 Y6 u
|
|