Model1.edmx.sqlce

-- --------------------------------------------------
-- Entity Designer DDL Script for SQL Server Compact Edition
-- --------------------------------------------------
-- Date Created: 08/06/2010 11:25:06
-- Generated from EDMX file: C:\Users\Jaddie\Documents\Coding\WCell-Utility-Bot\Model1.edmx
-- --------------------------------------------------


-- --------------------------------------------------
-- Dropping existing FOREIGN KEY constraints
-- NOTE: if the constraint does not exist, an ignorable error will be reported.
-- --------------------------------------------------


-- --------------------------------------------------
-- Dropping existing tables
-- NOTE: if the table does not exist, an ignorable error will be reported.
-- --------------------------------------------------

    DROP TABLE [Accounts];
GO
    DROP TABLE [Messages];
GO

-- --------------------------------------------------
-- Creating all tables
-- --------------------------------------------------

-- Creating table 'Accounts'
CREATE TABLE [Accounts] (
    [Username] nvarchar(4000)  NOT NULL,
    [Password] nvarchar(4000)  NOT NULL,
    [UserLevel] nvarchar(4000)  NOT NULL
);
GO

-- Creating table 'Messages'
CREATE TABLE [Messages] (
    [DateLeft] nvarchar(4000)  NOT NULL,
    [IrcNick] nvarchar(4000)  NOT NULL,
    [MessageText] nvarchar(4000)  NOT NULL,
    [FromIrcNick] nvarchar(4000)  NOT NULL
);
GO

-- --------------------------------------------------
-- Creating all PRIMARY KEY constraints
-- --------------------------------------------------

-- Creating primary key on [Username] in table 'Accounts'
ALTER TABLE [Accounts]
ADD CONSTRAINT [PK_Accounts]
    PRIMARY KEY ([Username] );
GO

-- Creating primary key on [DateLeft] in table 'Messages'
ALTER TABLE [Messages]
ADD CONSTRAINT [PK_Messages]
    PRIMARY KEY ([DateLeft] );
GO

-- --------------------------------------------------
-- Creating all FOREIGN KEY constraints
-- --------------------------------------------------

-- --------------------------------------------------
-- Script has ended
-- --------------------------------------------------