There are MANY database changes made to version 3.0.  Here are a few of them.  It is recommended that you use the database that is distributed with the program and import your old data where possible.


Edit the following tables:

Table Name - Conferences

Field Name - IsEmoticonActive
Data Type - Yes/No
Required - No
Indexed - No

Field Name - IsMsgCensored
Data Type - Yes/No
Required - Yes
Indexed - No

Field Name - LeftColumn
Data Type - Memo
Required - No
Allow Zero Length - Yes

Field Name - OpenTag
Data Type - Text
Field Size = 50
Required - No
Allow Zero Length - Yes

Field Name - CloseTag
Data Type - Text
Field Size = 50
Required - No
Allow Zero Length - Yes

Field Name - FramedSite
Data Type - Yes/No
Required - Yes
Indexed - No


Table Name - Forums

Field Name - Fid
Data Type - AutoNumber - (Primary Key)
Remove the other Primary Key settings from the other fields


Table Name - Messages
Add the following fields

Field Name - DateEdited
Data Type - Date/Time
Required - No

Field Name - Pvt
Data Type - Number
Required - No


Table Name - Messages_Archived
Add the following fields

Field Name - DateEdited
Data Type - Date/Time
Required - No

Field Name - Pvt
Data Type - Number
Required - No


Table Name - Users
Add the following fields

FieldName - Role
Data Type - Text
Field Size - 50
Required - No
Allow Zero Length - Yes
Indexed - No

Field Name - Profile
Data Type - Memo
Required - No
Allow Zero Length - Yes
Indexed - No

Field Name - Url
Data Type - Text
Field Size - 75
Required - No
Allow Zero Length - Yes
Indexed - No

Field Name - SiteName
Data Type - Text
Field Size - 75
Required - No
Allow Zero Length - Yes
Indexed - No

Field Name - Admin
Data Type - Yes/No
Required - Yes
Indexed - No

Field Name - Comment
Data Type - Text
Field Size - 255
Required - No
Allow Zero Length - Yes
Indexed - No

Field Name - Cnt
Data Type - Number
Required - No
Indexed - No

Field Name - LastLogin
Data Type - Date/Time
Required - No
Indexed - No




Add the following tables and fields

Table Name - Censored

Field Name - Cid - (Primary Key)
Data Type - Number

Field Name - Nasty
Data Type - Text
Field Size - 35
Allow Zero Length - No
Indexed - No


Table Name - PvtClass

Field Name - PvtClass_id - (Primary Key)
Data Type - Number

Field Name - PvtClass
Data Type - Text
Field Size - 15
Allow Zero Length - No
Indexed - No


Table Name - PvtPriority

Field Name - PvtPriority_id - (Primary Key)
Data Type - Number

Field Name - PvtPriority
Data Type - Text
Field Size - 15
Allow Zero Length - No
Indexed - No


Table Name - PvtMessage

Field Name - PvtMsg_Id
Data Type - AutoNumber (Primary Key)
Indexed - Yes (No Duplicates)

Field Name - DateCreated
Data Type - Date/Time
Required - No
Indexed - No

Field Name - DateRead
Data Type - Date/Time
Required - No
Indexed - No

Field Name - FromUser
Data Type - Number
Required - No
Indexed - No

Field Name - ToUser
Data Type - Number
Required - No
Indexed - Yes (Duplicates ok)

Field Name - ToUser2
Data Type - Number
Required - No
Indexed - No

Field Name - Message
Data Type - Memo
Required - No
Allow Zero Length - No

Field Name - Subject
Data Type - Text
Field Size - 50
Required - No
Allow Zero Length - Yes
Indexed - No

Field Name - PvtClass
Data Type - Text
Field Size - 12
Required - No
Allow Zero Length - Yes
Indexed - No

Field Name - PvtPriority
Data Type - Text
Field Size - 12
Required - No
Allow Zero Length - Yes
Indexed - No

Field Name - Message_Id
Data Type - Number
Required - No
Indexed - No

Field Name - ReadReceipt
Data Type - Yes/No
Required - No
Indexed - No