caEDRRLN

1internal static void InitDB()
2        {
3            //ellenőrzöm hogy léteznek-e a táblák
4            using (MySqlConnection connection = new MySqlConnection(ConnectionString))
5            using (MySqlCommand cmd = connection.CreateCommand())
6            {
7                connection.Open();
8                cmd.CommandText = "CREATE TABLE IF NOT EXISTS `dacstable`(`DacsID` VARCHAR(32) NOT NULL, `ReceivedUTCDate` DATETIME NOT NULL, `DacsContent` LONGTEXT NOT NULL, `ApiKey` TEXT NOT NULL, `DacsMeta` TEXT NOT NULL, `Status` INT NOT NULL, PRIMARY KEY (`DacsID`) ) CHARSET=utf8mb4;";
9                cmd.Prepare();
10                cmd.ExecuteNonQuery();
11
12                cmd.CommandText = "CREATE TABLE IF NOT EXISTS `foldertemplate`( `Instance` text NOT NULL, `Company` text NOT NULL, `Project` text, `Name` text NOT NULL, `ParentFID` text, `FolderID` text NOT NULL, `ParentGID` text, `GoogleID` text) CHARSET = utf8mb4;";
13                cmd.Prepare();
14                cmd.ExecuteNonQuery();
15
16                cmd.CommandText = "CREATE TABLE IF NOT EXISTS `files`(`Instance` TEXT NOT NULL, `Company` TEXT NOT NULL, `Project` TEXT NOT NULL, `Name` TEXT NOT NULL, `vFileGuid` TEXT NOT NULL, `fileID` TEXT NOT NULL, `ParentFID` TEXT NOT NULL, `ParentGID` TEXT NOT NULL, `GoogleID` TEXT NOT NULL) CHARSET = utf8mb4;";
17                cmd.Prepare();
18                cmd.ExecuteNonQuery();
19
20                cmd.CommandText = "CREATE TABLE IF NOT EXISTS `userfolders`(`username` TEXT NOT NULL, `Instance` TEXT NOT NULL, `Company` TEXT NOT NULL, `Project` TEXT, `FolderName` TEXT NOT NULL, `FolderID` TEXT NOT NULL, `GoogleID` TEXT NOT NULL, `ParentFID` TEXT , `ParentGID` TEXT NOT NULL) CHARSET = utf8mb4;";
21                cmd.Prepare();
22                cmd.ExecuteNonQuery();
23            }
24        }