Revised Scope

1.	Script will once a day go to http://www.clublandlv.com/forum.php
2.	Script will access the database named “clublandlv”
3.	From here the script will create the “genres_main” table (If it does not exist.)

		“genres_main” table
		id: integer (auto increment)
		genre_name: string
		genreforum_id: integer

4.	The script will insert the “genre_name” as well as the unique ”genreforum_id”, and check for any added forums.
	If there have been forums added, the script will write a new row for that forum.

5.	Create a “subgenres_main” table.

		“subgenres_main” table
		id: integer (auto increment)
		genreforum_name : string
		subgenre_name: string
		subgenreforum_id: integer
		start_run : integer
		end_run : integer

6.	Create a table for each separate subgenre, based on the “genreforum_id” (If it does not exist.)

		“subSUBGENRENAME” table
		id : integer (auto increment)
		subgenre_name : string
		subgenre_id: integer
		genrefoum_id: integer (foreign key)
		post_id	:integer
		post_title : string
		zippy_url : string
		healthy : Boolean
		dl_timestamp : integer
		post_timestamp : integer?