Setting Up A SnipEx Server

To setup a SnipEx server, the first step is to download the SnipEx server software.

This is currently available from RIAForge at snipex.riaforge.org

Requirements

• ColdFusion 7.02
• CFEclipse 1.3.1.5

Contents of readme.txt

SnipEx Release 1.0

This package contains the server components for SnipEx. Its made up of two CFC's: Application.cfc and SnipEx.cfc.

You can define the settings you require in Application.cfc and change the behaviour of your SnipEx server in the SnipEx.cfc

Once you have installed the database using the snipex.sql file (this is for mySQL but you can easily modify it to support any database) you need to create an entry in the lib table for your initial library.

This library will contain the name of your SnipEx server and is used as the 'root' node.

A Microsoft SQL Server 2005 version of the snipex.sql file

CREATE TABLE lib (
	libid INT IDENTITY(1,1) PRIMARY KEY ,
	name VARCHAR(64) NOT NULL , 
	description VARCHAR(MAX) NOT NULL ,
	parent int FOREIGN KEY REFERENCES lib(libid),
	created DATETIME NOT NULL DEFAULT GETDATE() ,
	updated DATETIME NOT NULL DEFAULT GETDATE() 
)

CREATE TABLE snip (
	snipid INT IDENTITY(1,1) PRIMARY KEY NOT NULL ,
	name VARCHAR(64) NOT NULL,
	useremail VARCHAR(MAX),
	parent INT NOT NULL DEFAULT 0 FOREIGN KEY REFERENCES snip(snipid),
	help VARCHAR(MAX) NOT NULL,
	description VARCHAR(MAX) NOT NULL,
	starttext VARCHAR(MAX) NOT NULL ,
	endtext VARCHAR(MAX) NOT NULL ,
	author VARCHAR(64) NOT NULL,
	platforms VARCHAR(64) NOT NULL,
	template VARCHAR(6) NOT NULL,
	created DATETIME NOT NULL DEFAULT GETDATE() ,
	updated DATETIME NOT NULL DEFAULT GETDATE() ,
	published BIT NOT NULL DEFAULT 0
)