PDA

View Full Version : Need a bit of help on the database layout...


Darth Cow
07-26-2002, 11:44 PM
I'm working on creating a hack to allow reporting of PMs. Unfortunately, we don't have phpMyAdmin installed, so I was wondering what the name of the table where PMs are stored in and what the last field in that table is. I probably *could* do a query to figure all that out, but it would be a pain :D.

In other words, what do $pmtablename and $thelastthing equal? :)

ALTER TABLE $pmtablename ADD reported tinyint(1) DEFAULT '0' not null AFTER $thelastthing

Thanks!

Xenon
07-27-2002, 12:27 AM
table name is privatemessage

and AFTER $thelastthing you could cut off, it'll work also ;)

Darth Cow
07-27-2002, 12:31 AM
Ok, thanks :).

I'll let you all know when I finish my hack.