MyTest Mod		The fist line of the file is the name of the Mod the Db setup is for.

[CREATE]			Create table sections
TEST_TABLE		Name of the Table to create
TABLE_ID			Name of the ID Field, leave a blank line if no ID field is required
field1#int#NULL#0		The rest of the lines in this section are for the field definitions
field2#varchar(20)##		They should all follow the same Format: FIELDNAME#FIELDTYPE#NULL#DEFAULT
			FIELDNAME# Name of column to add
			FIELDTYPE# Valid field Types are smallint,int,varchar,text. 
			NULL#	   Column allows NULL leave blank for Not allow
			DEFAULT	   default value for new field
				Any missing items should be left blank, the '#' delimeters should all appear.
				i.e.
			field1#int#NULL#0 will create an integer field with a default value of 1 that allows NULL
			field2#varchar(20)## will create a varchar field with no default that does not allow NULLs
[END]			End of create table tag.


[ALTER]			Alter table start tag
TEST_TABLE		Name of table to be altered
ADD#field3#int#NULL#		Field Definitions - Format: As above
ALTER#field2#varchar(255)##	Change column Properties
DROP#field4###		Delete  a column from the Table
[END]			End Alter table tag


[INSERT]			Insert Values start Tag
TEST_TABLE		Name of table you whish to insert values into
(field1,field2)#(12,'test')	Field Defs - This uses the same basic definition as an insert
				statement. The first parameter being a comma delimeted list of fields
				and the second the corresponding values.Each parameter enclosed by ()
					i.e. (field1,....)#(value1,....)
[END]			End of Table insert Tag


[UPDATE]			Table Update start Tag
TEST_TABLE2		Name of Table to update
field22#'B'#TABLE_ID2 = 1	Field definitions - Format: FIELDNAME#VALUE#WHERE CLAUSE
				FIELDNAME# - Name of field to be updated
				VALUE#	  - New value for field
				WHERE CLAUSE - Criteria to specify records to be updated, blank if All records
[END]				End of update tag


[DROP]
TEST_TABLE
[END]

[CREATE]
USERGROUPS
USERGROUP_ID
USERGROUP_NAME#varchar(100)##
USERGROUP_DESC#memo#NULL#
USERGROUP_TYPE#int##0
AUTOJOIN#int##0
MEM_HIDE#int##0
MOD_HIDE#int##0
[END]

[CREATE]
USERGROUP_MEMBERS
USERGROUP_ID#int##
MEMBER_ID#int##
MEMBER_TYPE#int##1
[END]

[CREATE]
ALLOWED_USERGROUPS
USERGROUP_ID#int##
FORUM_ID#int##
PERMS#int##0
[END]

[INSERT]
CONFIG_NEW
(C_VARIABLE,C_VALUE)#('STRUGVIEW','0')
(C_VARIABLE,C_VALUE)#('STRUGMEMVIEW','0')
(C_VARIABLE,C_VALUE)#('STRUGMODFORUMS','0')
[END]