Re: BASE / SQL Server 2008 and 'create_base_tbls_mssql_extra.sql' ????

[Nigel Houghton <nhoughton () sourcefire com>]

On Aug 14, 2011, at 6:36 PM, Michael Steele wrote:

> I'm working SQL Server 2008. I know I have to add the main database schema
> file (create_base_tbls_mssql.sql) for BASE. However there is another file
> called 'create_base_tbls_mssql_extra.sql'.
>
> Does anyone know what this is for, a purpose?

Since it adds foreign keys to a few tables, I'm guessing it's something to do with adding referential integrity to the 
DB schema.

> I'm thinking that it wasn't included in the main
> 'create_base_tbls_mssql.sql' because it's optional?

After reading the comments in the script, it adds referential integrity to the original DB schema and was written by 
Kevin Johnson (who used to run the BASE project) and instead of altering the original work, he added the second script 
to provide that option.

-- Author: Kevin Johnson <kjohnson () secureideas net
-- Based upon work by Roman Danyliw <roman () danyliw com>

-- - Purpose:
--   Add referential integrity to the database schema

Maybe.

--
Nigel Houghton
Head Mentalist
SF VRT Department of Intelligence Excellence
http://vrt-blog.snort.org/ && http://labs.snort.org/


------------------------------------------------------------------------------
uberSVN's rich system and user administration capabilities and model 
configuration take the hassle out of deploying and managing Subversion and 
the tools developers use with it. Learn more about uberSVN and get a free 
download at:  http://p.sf.net/sfu/wandisco-dev2dev
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users

Please see http://www.snort.org/docs for documentation