// Generate SQL Table public bool PrnChill_CreateSQLTable() { SqlConnection Conn = PrnChill_Conn(); string CreateTableLine = "CREATE TABLE [PrnChill]("; CreateTableLine = CreateTableLine + "[PostName] [int] IDENTITY(1,1) NOT NULL,"; CreateTableLine = CreateTableLine + "[PostURL] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[Links] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[DateAdded] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[LinkCheckDate] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[InCollection] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[ImageDir] [varchar](max) NOT NULL"; CreateTableLine = CreateTableLine + ") ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]"; _Database.SQL sql = new _Database.SQL(); return(sql.WriteDataRecord(Conn, CreateTableLine)); }
// Generate SQL Table public bool ReleaseBBMovies_CreateSQLTable() { SqlConnection Conn = ReleaseBBMovies_Conn(); string CreateTableLine = "CREATE TABLE [ReleaseBBMovies]("; CreateTableLine = CreateTableLine + "[MovieName] [int] IDENTITY(1,1) NOT NULL,"; CreateTableLine = CreateTableLine + "[IMDbID] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[Year] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[PostTitle] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[PostURL] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[ImageURL] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[RapidGator] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[LinksChecked] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[InCollection] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[DateAdded] [varchar](max) NOT NULL,"; CreateTableLine = CreateTableLine + "[Cateogry] [varchar](max) NOT NULL"; CreateTableLine = CreateTableLine + ") ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]"; _Database.SQL sql = new _Database.SQL(); return(sql.WriteDataRecord(Conn, CreateTableLine)); }