PHP code example of sheltie / simp-ddl-db

1. Go to this page and download the library: Download sheltie/simp-ddl-db library. Choose the download type require.

2. Extract the ZIP file and open the index.php.

3. Add this code to the index.php. 
    
        
<?php
require_once('vendor/autoload.php');

/* Start to develop here. Best regards https://php-download.com/ */

sheltie / simp-ddl-db example snippets



e = $argv[1]??'';
$specifyDir= $argv[2]??'';
$force = $argv[3]??'false';

const PDO_DSN = "mysql:host=127.0.0.1;dbname=YOURNAME;charset=utf8";
const PDO_USER = "root";
const PDO_PASS = "123456";

use sheltie\SimpleManageDb\SimpleManageDb;
$SimpleDDL= SimpleManageDb::getInstance(new PDO(PDO_DSN, PDO_USER, PDO_PASS));
$SimpleDDL->run($mode,$specifyDir);



return [
  'engine' => 'InnoDB',
  'charset' => 'utf8mb4',
  'collation' => 'utf8mb4_unicode_ci',
  'comment' => '',
  'column' => 
  [
    [
      'field' => 'id',
      'type' => 'int(4) unsigned',
      'null' => 'NO',
      'key' => 'PRI',
      'default' => NULL,
      'extra' => 'auto_increment',
      'comment' => '',
    ],
    [
      'field' => 'uid',
      'type' => 'int(4) unsigned',
      'null' => 'NO',
      'default' => '0',
      'comment' => '',
    ],



return [
  'engine' => 'InnoDB',
  'charset' => 'utf8mb4',
  'collation' => 'utf8mb4_unicode_ci',
  'comment' => '',
  'column' => 
  [
    [
      'field' => 'id',
      'type' => 'int(4) unsigned',
      'null' => 'NO',
      'key' => 'PRI',
      'default' => NULL,
      'extra' => 'auto_increment',
      'comment' => '',
    ],
    [
      'field' => 'uid',
      'type' => 'varchar(255)', // 修改
      'null' => 'NO',
      'default' => '',          // 修改
      'comment' => '字符串',          // 修改
    ],

bash
php ddl.php update tie/user

bash
php demo.php generate

bash
php ddl.php update df/user

bash
php ddl.php update

bash
Execute an SQl :ALTER TABLE `df_user_sales` ADD COLUMN open_switch int(8)  DEFAULT 0 COMMENT '开关' AFTER `page_value`;
Execute complete