Person.sql

If Exists (Select * From sysobjects Where name = N'Person' And user_name(uid) = N'dbo')
    Drop Table dbo.Person
Go

Create Table dbo.Person
    (
    PersonId int Not Null Identity (1, 1),
    StudentId nvarchar(12) Null,
    FirstName nvarchar(50) Not Null,
    LastName nvarchar(50) Not Null,
    Email nvarchar(128) Null,
    Street nvarchar(64) Null,
    City nvarchar(32) Null,
    Region nvarchar(32) Null,
    PostalCode nvarchar(20) Null,
    Country nvarchar(32) Null,
    Phone nvarchar(24) Null,
    Contact nvarchar(50) Null,
    ContactPhone nvarchar(24) Null,
    ContactRelationship nvarchar(24) Null,
    ReleaseInfo nvarchar(16) Not Null Constraint DF_Person_ReleaseInfo Default (1101000000000)
    )
Go
Alter Table dbo.Person Add Constraint
    PK_Person Primary Key Nonclustered
    (
    PersonId
    )
Go