SQL create tables reference

gistfile1.sql

CREATE TABLE sometable
(
    	[id] [uniqueidentifier] NOT NULL
	CONSTRAINT [DF_sometable_id] DEFAULT (newid()), /* This isn't required for DEFAULT */
	[userid] [uniqueidentifier] NOT NULL,
	[accountid] [uniqueidentifier] NOT NULL,
	[activated] [bit] NOT NULL,
	[activatedon] [datetime] NULL,
	[email] [nvarchar](128)  NOT NULL,
	[key] [varchar](32)  NOT NULL,
	PRIMARY KEY NONCLUSTERED (id), /* DONT USE CLUSTERED FOR uniqueidentifier */
	CONSTRAINT FK_sometable_userid FOREIGN KEY(userid) REFERENCES users (id),
	CONSTRAINT FK_sometable_accountid FOREIGN KEY(accountid) REFERENCES accounts (id),
)
CREATE NONCLUSTERED INDEX [idx_anothertable] ON [dbo].[anothertable]
(
	[sometypeid] ASC,
	[fileid] ASC,
	[layoutid] ASC
)