Download the PHP package com.jukusoft/php-database-table-upgrader without Composer
On this page you can find all versions of the php package com.jukusoft/php-database-table-upgrader. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download com.jukusoft/php-database-table-upgrader
More information about com.jukusoft/php-database-table-upgrader
Files in com.jukusoft/php-database-table-upgrader
Package php-database-table-upgrader
Short Description php-database-table-upgrader, An database upgrader for upgrade mysql table structures automatically. You dont have to write CREATE TABLE, ALTER TABLE querys and so on anymore, just configure your table structure in PHP and the classes will upgrade your table structures automatically.
License LGPL 3.0
Homepage https://github.com/JuKu/php-database-table-upgrader
Informations about the package php-database-table-upgrader
php-database-table-upgrader
An database upgrader for upgrade mysql table structures automatically
Version: 0.0.1 alpha License: LGPL 3.0
Currently upgrade isnt fully integrated, but table creation should be work. Work in Progress!
Requirements
- PHP 7.0.8+
- MySQL 5.7+
Configuration
If you want to use the build-in MySQLDriver, you have to copy config/mysql.examplecfg.php to mysql.cfg.php and change values.
Supported Data Types
- INT
- VARCHAR
- TEXT
- CHAR
- TINYTEXT
- MEDIUMTEXT
- LONGTEXT (4294967295 characters)
- BIT
- BINARY
- TINYINT
- SMALLINT
- MEDIUMINT
- BIGINT
- DECIMAL
- NUMERIC
- DOUBLE
- FLOAT
- REAL
- BLOB
- TINYBLOB
- MEDIUMBLOB
- LONGBLOB
- ENUM
- SET
- DATE
- TIME
- YEAR
- TIMESTAMP
- DATETIME
- JSON
Supported Keys and Indexes
- PRIMARY KEY
- INDEX
- UNIQUE
- SPATIAL
- FULLTEXT
-
FOREIGN KEY
- more are Work in Progress
Example
Generate CREATE TABLE query:
prints following query:
How to add an PRIMARY KEY
PRIMARY with only 1 column:
PRIMARY KEY with more than 1 column:
Because PRIMARY KEYS are limited to specific length, you can also specifiy length of columns used in PRIMARY KEY: