/****** This script was created using the Data Springs Dynamic Forms Create Table SQL Routine ******/ /****** - This SQL Script should be executed under Host, SQL within your DNN Installation ******/ /****** - You should only execute this script one time, and it should be executed after your have setup all of your form fields. ******/ /****** - Your table will be created based on your form fields short field names ******/ /****** - You should always review your SQL query created, to determine approx column names, column sizes, and overall query. ******/ /****** - Note: Creating your own table and using SQL events is not required to capture data, your form data is alreay stored in standard related tables. ******/ /****** Creating your own table and inserting data into the table should only be used for advanced data manipulations or custom application requirements. ******/ /****** - Example implementations might include insert/update/delete custom workflow implementation requirements, backup log of data, or other related implementations. ******/ CREATE TABLE {databaseOwner}[{objectQualifier}DynamicForms_CustomTable_1197]( [DynamicForms_ResultsID] [int] IDENTITY(1,1) NOT NULL, [UniqueCompletionID] [UniqueIdentifier] NULL, [ResponseDateTime] [DateTime] NULL, [UserID] [int] NULL, [IPAddress] [nvarchar(100)] NULL, [DSParam1] [nvarchar](500) null, [DSParam2a] [nvarchar](500) null, [GenHTML] [nvarchar](500) null, [FirstNameonkeyup] [nvarchar](500) null, [LastNameonkeyup] [nvarchar](500) null, [Phone] [nvarchar](500) null, [FavoriteProduct] [nvarchar](500) null, [New Field] [nvarchar](500) null, [SQLType] [nvarchar](500) null )