[thesite] the evolt database

[rudy]

i'm getting ready to do a new data model diagram, and in preparation, i
have done a DESCRIBE on all the tables in the production database

aside: dan, i got in to the server using putty with no problem, but when i
entered

  sqlplus evolttest/evolttest

i got   ORA-01017: invalid username/password; logon denied

however, i got into the production database with no problem -- at least, i
*think* that's where i ended up


what i noticed that was different from the last time i described all the
tables (april) was:

the CONTACT table has 4 new columns --
ACKED                                              NUMBER(1)
USERAGENT                                          VARCHAR2(45)
IPADDRESS                                          VARCHAR2(15)
REFERER                                            VARCHAR2(50)

the CONTENT table has 1 new column --
KEYPHRASE                                          VARCHAR2(100)

the POSTS table is gone

the THELIST table (currently 44,453 rows, latest august 19) has been
completely redesigned --
LISTID                                             NUMBER
MESSAGEID                                 NOT NULL NUMBER
HDR_MESSAGEID                                      VARCHAR2(512)
HDR_FROMNAME                                       VARCHAR2(512)
HDR_FROMEMAIL                                      VARCHAR2(512)
HDR_TOEMAIL                                        VARCHAR2(1024)
HDR_SUBJECT                                        VARCHAR2(512)
HDR_DATE                                           DATE
HDR_INREPLYTO                                      VARCHAR2(512)
BDY_CONTENT                                        LONG

the THETIPS table (currently 3,446 rows, latest august 19) has been
completely redesigned --
TIP_ID                                    NOT NULL NUMBER(8)
MESSAGEID                                          NUMBER
TIP_DATE                                  NOT NULL DATE
TIP_TYPE_ID                                        NUMBER(8)
AUTHOR_ID                                          NUMBER(8)
ATTRIB_TYPE                                        VARCHAR2(200)
ATTRIB_AUTHOR                                      VARCHAR2(50)
TIP_BODY                                           LONG

new table TIP_TYPES added, 25 rows --
TIP_TYPE_ID                                        NUMBER(8)
TIP_TYPE_NAME                                      VARCHAR2(80)

the USERS table has 1 new column --
THEWIFE                                            NUMBER(1)



is this really the production database, or was i looking at the test
database?


rudy