CREATE TABLE [dbo].[VideoCourse] |
( |
[VideoCourseID] int NOT NULL |
,[VideoCourse_CourseTypeID_FK] int NOT NULL |
,[VideoCourse_Title] varchar(100) NOT NULL |
,[VideoCourse_Desc] varchar(500) NOT NULL |
,[VideoCourse_ImagePath] varchar(255) NULL |
,[VideoCourse_Hyperlink] varchar(255) NOT NULL |
,[VideoCourse_Time] decimal(4,2) NOT NULL |
,[VideoCourse_Transcript] text(2147483647) NOT NULL |
,[VideoCourse_MetaTags] varchar(160) NOT NULL |
,[VideoCourse_ProductVersions] varchar(255) NOT NULL |
,[VideoCourse_Users] varchar(255) NOT NULL |
,[VideoCourse_Featured] bit NULL |
,[VideoCourse_Popular] bit NULL |
,[VideoCourse_Recent] bit NULL |
,[VideoCourse_SortOrder] int NOT NULL |
PRIMARY KEY [PK_VideoCourse] (VideoCourseID) |
) |
CREATE TABLE [dbo].[VideoCourse] |
( |
[VideoCourseID] int NOT NULL |
,[VideoCourse_CourseTypeID_FK] int NOT NULL |
,[VideoCourse_Title] varchar(100) NOT NULL |
,[VideoCourse_Desc] varchar(500) NOT NULL |
,[VideoCourse_Hyperlink] varchar(255) NOT NULL |
,[VideoCourse_Time] decimal(4,2) NOT NULL |
,[VideoCourse_Transcript] text(2147483647) NOT NULL |
,[VideoCourse_MetaTags] varchar(255) NOT NULL |
,[VideoCourse_ProductVersions] varchar(255) NOT NULL |
,[VideoCourse_Users] varchar(255) NOT NULL |
,[VideoCourse_Featured] bit NULL |
,[VideoCourse_Popular] bit NULL |
,[VideoCourse_Recent] bit NULL |
,[VideoCourse_SortOrder] int NOT NULL |
,[VideoCourse_ImagePath] varchar(255) NULL |
PRIMARY KEY [PK_VideoCourse] (VideoCourseID) |
) |