{"repo":"aimeos/upscheme","free":true,"listed":false,"github":"https://github.com/aimeos/upscheme","clone":"git clone https://github.com/aimeos/upscheme.git","description":"Database migrations and schema updates made easy","language":"PHP","stars":2723,"topics":["database","database-migrations","database-schema","migrations","php","sqlite","mysql","postgresql","sql-server","sqlsrv"],"license":"LGPL-3.0","category":"databases-storage","readme_excerpt":"Upscheme: Database schema updates made easy Easy to use PHP package for updating the database schema of your application and migrate data between versions. Table of contents Why Upscheme Database support Integrating Upscheme Writing migrations Naming Dependencies Messages Schemas Generate from database Database Accessing objects Checking existence Renaming objects Removing objects Query/modify table rows Executing custom SQL Database methods Tables Creating tables Setting table options Checking table existence Changing tables Renaming tables Dropping tables Table methods Columns Adding columns Available column types Column modifiers Checking column existence Changing columns Renaming columns Dropping columns Column methods Foreign keys Creating foreign keys Checking foreign key existence Dropping foreign keys Foreign key methods Sequences Adding sequences Checking sequence existence Dropping sequences Sequence methods Indexes Adding indexes Checking index existence Renaming indexes Dropping indexes Custom index naming Customizing Upscheme Adding custom methods Implementing custom columns Upgrade Upscheme Why Upscheme Migrations are like version control for your database. They allow you to get the exact same state in every installation. Using Upscheme, you get: one place for defining tables, columns, indexes, etc. easily upgrades from any state in between to the expected schema consistent, reliable and hassle-free schema upgrades minimal code required for writing migrations pe","default_branch":null,"files":null,"tree":[],"storefront":"/r/aimeos","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/aimeos/upscheme/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}