diff --git a/web/application/migrations/1.php b/web/application/migrations/1.php index 04f1777..8a31f6c 100644 --- a/web/application/migrations/1.php +++ b/web/application/migrations/1.php @@ -4,7 +4,7 @@ use \vendor\DB\DB; echo "Creating session table..." . PHP_EOL; DB::query("CREATE TABLE sessions ( - id INTEGER PRIMARY KEY AUTOINCREMENT, + id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, sessionid VARCHAR(255), ip VARCHAR(255), userAgent VARCHAR(255), @@ -13,7 +13,7 @@ DB::query("CREATE TABLE sessions ( echo "Creating users table..." . PHP_EOL; DB::query("CREATE TABLE users ( - id INTEGER PRIMARY KEY AUTOINCREMENT, + id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, email VARCHAR(255) )"); diff --git a/web/application/migrations/2.php b/web/application/migrations/2.php index 2ce2939..f420cd2 100644 --- a/web/application/migrations/2.php +++ b/web/application/migrations/2.php @@ -4,7 +4,7 @@ use \vendor\DB\DB; echo "Creating job table..." . PHP_EOL; DB::query("CREATE TABLE jobs ( - id INTEGER PRIMARY KEY AUTOINCREMENT, + id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, jobName VARCHAR(255), runType VARCHAR(255), runScript TEXT, diff --git a/web/application/migrations/3.php b/web/application/migrations/3.php index 09e7aca..b38dd33 100644 --- a/web/application/migrations/3.php +++ b/web/application/migrations/3.php @@ -4,7 +4,7 @@ use \vendor\DB\DB; echo "Creating history table..."; DB::query("CREATE TABLE histories ( - id INTEGER PRIMARY KEY AUTOINCREMENT, + id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT, output TEXT, jobs_id INTEGER, run_date DATETIME,