|
My First Forum - a bulletin board application
You are here: irt.org | Articles | Database | My First Forum - a bulletin board application Published on: Thursday 8th April 1999 By: Andrew Shatwell |
| tblArticles | ||
|---|---|---|
| Field Name | Type | Size |
| GroupID | Number (integer) | - |
| ThreadID | Number (long) | - |
| ThreadName | Text | 30 |
| Link | Text | 255 |
| Posted | Date/Time | - |
| UserName | Text | 25 |
| UserEmail | Text | 50 |
| Message | Memo | - |
| ArticleID | AutoNumber (aka counter) - no duplicate values | - |
| tblGroups | ||
|---|---|---|
| Field Name | Type | Size |
| GroupID | Number (integer) | - |
| GroupName | Text | 50 |
| ReadAccess | Text | 50 |
| WriteAccess | Text | 50 |
| Description | Text | 255 |
| tblThreads | ||
|---|---|---|
| Field Name | Type | Size |
| GroupID | Number (integer) | - |
| ThreadID | Number (long) | - |
| ThreadName | Text | 30 |
| UserName | Text | 25 |
| Distribution | Text | 255 |
| Users | ||
|---|---|---|
| Field Name | Type | Size |
| UserName | Text | 10 |
| FirstName | Text | 20 |
| Surname | Text | 20 |
| Text | 50 | |
| Access | Text | 255 |
| Lastlogin | Date/Time | - |
Creating a forum
To add forums, it is simply a case of entering a record in the tblGroups table. For this example create one record in the tblGroups table as follows:
GroupID: 1
GroupName: My First Forum
ReadAccess: public
WriteAccess: public
Description: This is the first forum in the bulletin board.
It is up to you whether you allow the general public to become registered users of the system. The final document provides a web frontend for an administrator to register users. This could easily be adapted so that users can register themselves.
In the mean time we will create a record in the User table so that you can test some of the functions of the application. Enter the following in the Users table:
Username: [think of a user name for yourself]
FirstName: [your first name]
Surname: [your surname]
Email: [your email]
Access: public
Lastlogin: 1/1/74
Publishing the database
In order for Cold Fusion to be able to access your database you need to publish it on the server. This task is normally done by the server administrator. For this application, it does not matter what name you publish the database under as long as you record this name in the application.cfm file.
Back to the Introduction, or forward to Displaying the forums
Feedback on 'My First Forum - a bulletin board application'
- My First Forum - a bulletin board application - carlos 06:21:28 5/17/01
- My First Forum - a bulletin board application - CB Butler 09:53:04 8/30/00
- My First Forum - a bulletin board application - Jetaime 08:42:01 8/18/00
- My First Forum - a bulletin board application - Robert P. 12:50:10 7/20/00
- My First Forum - a bulletin board application - R�mi van der Deure 17:14:28 6/18/00
- My First Forum - a bulletin board application - Margaret Le 15:02:51 6/08/00
- My First Forum - a bulletin board application - Michael Appenzellar 16:11:40 3/29/00
- My First Forum - a bulletin board application - Vanya Loroch 10:49:50 3/09/00
- My First Forum - a bulletin board application - Emilio 14:37:51 11/02/99
- My First Forum - a bulletin board application - Novianingrum 23:35:22 9/22/99
- My First Forum - a bulletin board application - Daniel Iversen 04:53:34 8/19/99
- My First Forum - a bulletin board application - C Gardner 08:43:58 4/12/99
View the author profiles.
irt.org liability, trademark, document use, privacy statement and software licensing rules apply.