chapter1_mysql_createdb.sql

来自「SQL Server入门经典源码」· SQL 代码 · 共 51 行

CREATE TABLE MemberDetails
(
    MemberId integer,
    FirstName nvarchar(50),
    LastName nvarchar(50),
    DateOfBirth date,
    Street varchar(100),
    City varchar(75),
    State varchar(75),
    ZipCode varchar(12),
    Email varchar(200),
    DateOfJoining date

);

CREATE TABLE Attendance
(
    MeetingDate date,
    Location varchar(200),
    MemberAttended char(1),
    MemberId integer
);

CREATE TABLE Films
(
    FilmId integer,
    FilmName varchar(100),
    YearReleased integer,
    PlotSummary text,
    AvailableOnDVD char(1),
    Rating integer,
    CategoryId integer
);

CREATE TABLE Category
(
    CategoryId integer,
    Category varchar(100)
);

CREATE TABLE FavCategory
(
    CategoryId integer,
    MemberId integer
);