The file is formatted into sections, which are delimited with ini file style tags. You should name your file using the following format, dbs_FILENAME.asp, where FILENAME is your setup filename.
The allowed Tags are
[CREATE] - for creating new tables
[ALTER] - for Adding/deleting/changing columns in an existing table
[DELETE] - Deleting records from a Table
[INSERT] - Inserting records into a table
[UPDATE] - Updating specific values
[DROP] - Deleting Tables
Section Formatting.
Code:
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]
