diff options
Diffstat (limited to 'app/Schema')
-rw-r--r-- | app/Schema/Mysql.php | 6 | ||||
-rw-r--r-- | app/Schema/Postgres.php | 6 | ||||
-rw-r--r-- | app/Schema/Sqlite.php | 6 |
3 files changed, 9 insertions, 9 deletions
diff --git a/app/Schema/Mysql.php b/app/Schema/Mysql.php index 626f7b84..91e744a4 100644 --- a/app/Schema/Mysql.php +++ b/app/Schema/Mysql.php @@ -10,9 +10,9 @@ const VERSION = 62; function version_62($pdo) { - $pdo->exec('ALTER TABLE files ADD COLUMN date VARCHAR(10) NOT NULL DEFAULT 0'); - $pdo->exec('ALTER TABLE files ADD COLUMN user_id INT NOT NULL DEFAULT 0'); - $pdo->exec('ALTER TABLE files ADD COLUMN size FLOAT NOT NULL DEFAULT 0'); + $pdo->exec('ALTER TABLE files ADD COLUMN `date` INT NOT NULL DEFAULT 0'); + $pdo->exec('ALTER TABLE files ADD COLUMN `user_id` INT NOT NULL DEFAULT 0'); + $pdo->exec('ALTER TABLE files ADD COLUMN `size` INT NOT NULL DEFAULT 0'); } function version_61($pdo) diff --git a/app/Schema/Postgres.php b/app/Schema/Postgres.php index 4b9752eb..0c4c4829 100644 --- a/app/Schema/Postgres.php +++ b/app/Schema/Postgres.php @@ -10,9 +10,9 @@ const VERSION = 43; function version_43($pdo) { - $pdo->exec('ALTER TABLE files ADD COLUMN date VARCHAR(10) NOT NULL DEFAULT 0'); - $pdo->exec('ALTER TABLE files ADD COLUMN user_id INT NOT NULL DEFAULT 0'); - $pdo->exec('ALTER TABLE files ADD COLUMN size FLOAT NOT NULL DEFAULT 0'); + $pdo->exec('ALTER TABLE files ADD COLUMN "date" INTEGER NOT NULL DEFAULT 0'); + $pdo->exec('ALTER TABLE files ADD COLUMN "user_id" INTEGER NOT NULL DEFAULT 0'); + $pdo->exec('ALTER TABLE files ADD COLUMN "size" INTEGER NOT NULL DEFAULT 0'); } function version_42($pdo) diff --git a/app/Schema/Sqlite.php b/app/Schema/Sqlite.php index 52a37d25..4ea1f875 100644 --- a/app/Schema/Sqlite.php +++ b/app/Schema/Sqlite.php @@ -10,9 +10,9 @@ const VERSION = 61; function version_61($pdo) { - $pdo->exec('ALTER TABLE files ADD COLUMN date VARCHAR(10) NOT NULL DEFAULT 0'); - $pdo->exec('ALTER TABLE files ADD COLUMN user_id INT NOT NULL DEFAULT 0'); - $pdo->exec('ALTER TABLE files ADD COLUMN size FLOAT NOT NULL DEFAULT 0'); + $pdo->exec('ALTER TABLE files ADD COLUMN "date" INTEGER NOT NULL DEFAULT 0'); + $pdo->exec('ALTER TABLE files ADD COLUMN "user_id" INTEGER NOT NULL DEFAULT 0'); + $pdo->exec('ALTER TABLE files ADD COLUMN "size" INTEGER NOT NULL DEFAULT 0'); } function version_60($pdo) |