// 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));
}
