My table scripts are in:
Setup
applications
myapplication
SchemaInstallScripts
mssql
0.0.0.1.config
Here's a snippet of my table Create
SET NOCOUNT ON
GO
-- Definition for table DOC_BUSINESS_PROCESS :
--
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DOC_BUSINESS_PROCESS] (
[BPGuid] uniqueidentifier DEFAULT newid() NOT NULL,
[SiteGuid] uniqueidentifier NOT NULL,
[ModuleGuid] uniqueidentifier NOT NULL,
[BPName] varchar(100) COLLATE Latin1_General_CI_AS NOT NULL,
[DeptGuid] uniqueidentifier NOT NULL,
[HlinkProcess] uniqueidentifier NULL,
[HlinkProcessMap] uniqueidentifier NULL,
[Created] datetime DEFAULT getutcdate() NOT NULL,
[CreatedBy] uniqueidentifier NOT NULL,
[LastModified] datetime NULL,
[LastModifedBy] uniqueidentifier NULL
)
ON [PRIMARY]
GO
--
-- Definition for table DOC_BUSINESS_PROCESS_RULE :
--
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DOC_BUSINESS_PROCESS_RULE] (
[BPRGuid] uniqueidentifier DEFAULT newid() NOT NULL,
[SiteGuid] uniqueidentifier NOT NULL,
[ModuleGuid] uniqueidentifier NOT NULL,
[BPGuid] uniqueidentifier NOT NULL,
[BRGuid] uniqueidentifier NOT NULL,
[Created] datetime DEFAULT getutcdate() NOT NULL,
[CreatedBy] uniqueidentifier NOT NULL,
[LastModified] datetime NULL,
[LastModifedBy] uniqueidentifier NULL
)
ON [PRIMARY]
GO
Then I add my stored procedures and functions in SchemaUpgradelScripts\mssql\ starting with 0.0.0.2.config, then 0.0.0.3.config, then 0.0.0.4.config
I use several files to separate things. Makes for easier debugging.
Hope this helps
Arvixe.com