портал - схема базы данных

-- --------------------------------------------------
-- Entity Designer DDL Script for SQL Server 2005, 2008, and Azure
-- --------------------------------------------------
-- Date Created: 10/08/2010 14:36:14
-- Generated from EDMX file: C:\Users\HIMen\Documents\Visual Studio 2010\Projects\MvcApplication2\Models\Model1.edmx
-- --------------------------------------------------
 
SET QUOTED_IDENTIFIER OFF;
GO
USE [Database1];
GO
IF SCHEMA_ID(N'dbo') IS NULL EXECUTE(N'CREATE SCHEMA [dbo]');
GO
 
-- --------------------------------------------------
-- Dropping existing FOREIGN KEY constraints
-- --------------------------------------------------
 
IF OBJECT_ID(N'[dbo].[FK_Comments_Softs]', 'F') IS NOT NULL
    ALTER TABLE [dbo].[Comments] DROP CONSTRAINT [FK_Comments_Softs];
GO
IF OBJECT_ID(N'[dbo].[FK_Comments_Users]', 'F') IS NOT NULL
    ALTER TABLE [dbo].[Comments] DROP CONSTRAINT [FK_Comments_Users];
GO
 
-- --------------------------------------------------
-- Dropping existing tables
-- --------------------------------------------------
 
IF OBJECT_ID(N'[dbo].[Comments]', 'U') IS NOT NULL
    DROP TABLE [dbo].[Comments];
GO
IF OBJECT_ID(N'[dbo].[Softs]', 'U') IS NOT NULL
    DROP TABLE [dbo].[Softs];
GO
IF OBJECT_ID(N'[dbo].[Users]', 'U') IS NOT NULL
    DROP TABLE [dbo].[Users];
GO
 
-- --------------------------------------------------
-- Creating all tables
-- --------------------------------------------------
 
-- Creating table 'Comments'
CREATE TABLE [dbo].[Comments] (
    [ID] INT IDENTITY(1,1) NOT NULL,
    [UserID] INT  NOT NULL,
    [SoftID] INT  NOT NULL,
    [DATE] datetime  NOT NULL,
    [Text] NCHAR(10)  NOT NULL
);
GO
 
-- Creating table 'Softs'
CREATE TABLE [dbo].[Softs] (
    [ID] INT IDENTITY(1,1) NOT NULL,
    [Title] NCHAR(10)  NOT NULL,
    [Description] NCHAR(10)  NOT NULL,
    [DATE] datetime  NOT NULL
);
GO
 
-- Creating table 'Users'
CREATE TABLE [dbo].[Users] (
    [ID] INT IDENTITY(1,1) NOT NULL,
    [Name] NCHAR(10)  NOT NULL,
    [Password] NCHAR(10)  NOT NULL,
    [Email] NCHAR(10)  NOT NULL
);
GO
 
-- --------------------------------------------------
-- Creating all PRIMARY KEY constraints
-- --------------------------------------------------
 
-- Creating primary key on [ID] in table 'Comments'
ALTER TABLE [dbo].[Comments]
ADD CONSTRAINT [PK_Comments]
    PRIMARY KEY CLUSTERED ([ID] ASC);
GO
 
-- Creating primary key on [ID] in table 'Softs'
ALTER TABLE [dbo].[Softs]
ADD CONSTRAINT [PK_Softs]
    PRIMARY KEY CLUSTERED ([ID] ASC);
GO
 
-- Creating primary key on [ID] in table 'Users'
ALTER TABLE [dbo].[Users]
ADD CONSTRAINT [PK_Users]
    PRIMARY KEY CLUSTERED ([ID] ASC);
GO
 
-- --------------------------------------------------
-- Creating all FOREIGN KEY constraints
-- --------------------------------------------------
 
-- Creating foreign key on [SoftID] in table 'Comments'
ALTER TABLE [dbo].[Comments]
ADD CONSTRAINT [FK_Comments_Softs]
    FOREIGN KEY ([SoftID])
    REFERENCES [dbo].[Softs]
        ([ID])
    ON DELETE NO ACTION ON UPDATE NO ACTION;
 
-- Creating non-clustered index for FOREIGN KEY 'FK_Comments_Softs'
CREATE INDEX [IX_FK_Comments_Softs]
ON [dbo].[Comments]
    ([SoftID]);
GO
 
-- Creating foreign key on [UserID] in table 'Comments'
ALTER TABLE [dbo].[Comments]
ADD CONSTRAINT [FK_Comments_Users]
    FOREIGN KEY ([UserID])
    REFERENCES [dbo].[Users]
        ([ID])
    ON DELETE NO ACTION ON UPDATE NO ACTION;
 
-- Creating non-clustered index for FOREIGN KEY 'FK_Comments_Users'
CREATE INDEX [IX_FK_Comments_Users]
ON [dbo].[Comments]
    ([UserID]);
GO
 
-- --------------------------------------------------
-- Script has ended
-- --------------------------------------------------