Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- --------------------------------------------------
- -- Entity Designer DDL Script for SQL Server 2005, 2008, 2012 and Azure
- -- --------------------------------------------------
- -- Date Created: 01/27/2015 17:49:48
- -- Generated from EDMX file: C:\Users\Tobias\Documents\GitHub\MusicDolph\MusicDolphin\Model1.edmx
- -- --------------------------------------------------
- SET QUOTED_IDENTIFIER OFF;
- GO
- USE [MusicDolphinDB];
- 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_REV_ARTISTNR_FK]', 'F') IS NOT NULL
- ALTER TABLE [dbo].[Review] DROP CONSTRAINT [FK_REV_ARTISTNR_FK];
- GO
- IF OBJECT_ID(N'[dbo].[FK_REV_TRACKID_FK]', 'F') IS NOT NULL
- ALTER TABLE [dbo].[Review] DROP CONSTRAINT [FK_REV_TRACKID_FK];
- GO
- IF OBJECT_ID(N'[dbo].[FK_REV_USERNAME_FK]', 'F') IS NOT NULL
- ALTER TABLE [dbo].[Review] DROP CONSTRAINT [FK_REV_USERNAME_FK];
- GO
- -- --------------------------------------------------
- -- Dropping existing tables
- -- --------------------------------------------------
- IF OBJECT_ID(N'[dbo].[Artist]', 'U') IS NOT NULL
- DROP TABLE [dbo].[Artist];
- GO
- IF OBJECT_ID(N'[dbo].[Review]', 'U') IS NOT NULL
- DROP TABLE [dbo].[Review];
- GO
- IF OBJECT_ID(N'[dbo].[Track]', 'U') IS NOT NULL
- DROP TABLE [dbo].[Track];
- GO
- IF OBJECT_ID(N'[dbo].[User]', 'U') IS NOT NULL
- DROP TABLE [dbo].[User];
- GO
- -- --------------------------------------------------
- -- Creating all tables
- -- --------------------------------------------------
- -- Creating table 'Artist'
- CREATE TABLE [dbo].[Artist] (
- [artistNr] int IDENTITY(1,1) NOT NULL,
- [artistName] varchar(50) NULL
- );
- GO
- -- Creating table 'Review'
- CREATE TABLE [dbo].[Review] (
- [revNr] int IDENTITY(1,1) NOT NULL,
- [date] varchar(20) NULL,
- [rating] int NULL,
- [comments] varchar(300) NULL,
- [artistNr] int NULL,
- [trackID] int NULL,
- [username] varchar(50) NULL
- );
- GO
- -- Creating table 'Track'
- CREATE TABLE [dbo].[Track] (
- [trackID] int IDENTITY(1,1) NOT NULL,
- [title] varchar(50) NULL,
- [length] varchar(30) NULL,
- [year] varchar(30) NULL,
- [artistNr] nvarchar(max) NOT NULL,
- [Artist_artistNr] int NOT NULL
- );
- GO
- -- Creating table 'User'
- CREATE TABLE [dbo].[User] (
- [username] varchar(50) NOT NULL,
- [password] nvarchar(max) NOT NULL
- );
- GO
- -- --------------------------------------------------
- -- Creating all PRIMARY KEY constraints
- -- --------------------------------------------------
- -- Creating primary key on [artistNr] in table 'Artist'
- ALTER TABLE [dbo].[Artist]
- ADD CONSTRAINT [PK_Artist]
- PRIMARY KEY CLUSTERED ([artistNr] ASC);
- GO
- -- Creating primary key on [revNr] in table 'Review'
- ALTER TABLE [dbo].[Review]
- ADD CONSTRAINT [PK_Review]
- PRIMARY KEY CLUSTERED ([revNr] ASC);
- GO
- -- Creating primary key on [trackID] in table 'Track'
- ALTER TABLE [dbo].[Track]
- ADD CONSTRAINT [PK_Track]
- PRIMARY KEY CLUSTERED ([trackID] ASC);
- GO
- -- Creating primary key on [username] in table 'User'
- ALTER TABLE [dbo].[User]
- ADD CONSTRAINT [PK_User]
- PRIMARY KEY CLUSTERED ([username] ASC);
- GO
- -- --------------------------------------------------
- -- Creating all FOREIGN KEY constraints
- -- --------------------------------------------------
- -- Creating foreign key on [artistNr] in table 'Review'
- ALTER TABLE [dbo].[Review]
- ADD CONSTRAINT [FK_REV_ARTISTNR_FK]
- FOREIGN KEY ([artistNr])
- REFERENCES [dbo].[Artist]
- ([artistNr])
- ON DELETE NO ACTION ON UPDATE NO ACTION;
- GO
- -- Creating non-clustered index for FOREIGN KEY 'FK_REV_ARTISTNR_FK'
- CREATE INDEX [IX_FK_REV_ARTISTNR_FK]
- ON [dbo].[Review]
- ([artistNr]);
- GO
- -- Creating foreign key on [trackID] in table 'Review'
- ALTER TABLE [dbo].[Review]
- ADD CONSTRAINT [FK_REV_TRACKID_FK]
- FOREIGN KEY ([trackID])
- REFERENCES [dbo].[Track]
- ([trackID])
- ON DELETE NO ACTION ON UPDATE NO ACTION;
- GO
- -- Creating non-clustered index for FOREIGN KEY 'FK_REV_TRACKID_FK'
- CREATE INDEX [IX_FK_REV_TRACKID_FK]
- ON [dbo].[Review]
- ([trackID]);
- GO
- -- Creating foreign key on [username] in table 'Review'
- ALTER TABLE [dbo].[Review]
- ADD CONSTRAINT [FK_REV_USERNAME_FK]
- FOREIGN KEY ([username])
- REFERENCES [dbo].[User]
- ([username])
- ON DELETE NO ACTION ON UPDATE NO ACTION;
- GO
- -- Creating non-clustered index for FOREIGN KEY 'FK_REV_USERNAME_FK'
- CREATE INDEX [IX_FK_REV_USERNAME_FK]
- ON [dbo].[Review]
- ([username]);
- GO
- -- Creating foreign key on [Artist_artistNr] in table 'Track'
- ALTER TABLE [dbo].[Track]
- ADD CONSTRAINT [FK_ArtistTrack]
- FOREIGN KEY ([Artist_artistNr])
- REFERENCES [dbo].[Artist]
- ([artistNr])
- ON DELETE NO ACTION ON UPDATE NO ACTION;
- GO
- -- Creating non-clustered index for FOREIGN KEY 'FK_ArtistTrack'
- CREATE INDEX [IX_FK_ArtistTrack]
- ON [dbo].[Track]
- ([Artist_artistNr]);
- GO
- -- --------------------------------------------------
- -- Script has ended
- -- --------------------------------------------------
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement