The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
Forgive the Snitz newbie here... but a friend showed me the site yesterday. I downloaded a copy of it and really liked the mod_dbsetup.asp system (among many other things) based on .dbs script files. Anyway, I saw lots of discussion on documents, but forgive me for not being able to find one specifically for the .dbs files. So, I created my own short text file document to help in my own Snitz project which I would like to give back to the community if it can be of any use which you can download from here:
http://www.honorandfaith.org/SnitzDBModOrig.txt
<
http://www.honorandfaith.org/SnitzDBModOrig.txt
<
Posted
Sorry, but your Doc is not correct, it does not support all those types. it only supports int varchar and memo field types.
These are the original specs
Script file Instructions.
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.
<
These are the original specs
Script file Instructions.
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.
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]
<
Posted
Thanks so much for the review and additional information :) I will update my document accordingly and repost a link to it. I had to make a lot of assumptions by reverse engineering a document from just the asp file, so this will help clear things up!
<
<
Posted
Along these lines... I have a question...
Using the following script for setting up the User Groups MOD, the first table created uses the strTablePrefix variable for the prefix, and the second one uses the strMemberTablePrefix then the third table goes back and uses the first prefixing variable...
is there a way to tell it which variable to use for the prefix?<
Using the following script for setting up the User Groups MOD, the first table created uses the strTablePrefix variable for the prefix, and the second one uses the strMemberTablePrefix then the third table goes back and uses the first prefixing variable...
Code:
[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]is there a way to tell it which variable to use for the prefix?<
Posted
this is how it was designed, the use of the word MEMBER in the table name causes it to use the membertable prefix<
Posted
Huw, in the document you posted above, could you add the description for the [DELETE] tag?<
