magento2-modules/app/code/Wowow/Devis/Setup/InstallSchema.php

<?php namespace Wowow\Devis\Setup;

use Magento\Framework\Setup\InstallSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;
use Magento\Framework\DB\Ddl\Table;

class InstallSchema implements InstallSchemaInterface
{
    /**
     * Installs DB schema for a module
     *
     * @param SchemaSetupInterface $setup
     * @param ModuleContextInterface $context
     * @return void
     */
    public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)
    {
        $installer = $setup;
        $installer->startSetup();

        /**
         * Create table 'edeclic_news'
         */

        //$tableName = $installer->getTable('wowow_devis');
        
        $tableDevis = $setup->getConnection()->newTable($setup->getTable('wowow_devis'));
        
        $tableDevis->addColumn(
            'entity_id',
            Table::TYPE_INTEGER,
            null,
            array('identity' => true,'nullable' => false,'primary' => true,'unsigned' => true,),
            'Entity ID'
        );
        
        $tableDevis->addColumn(
            'customer_id',
            Table::TYPE_INTEGER,
            null,
            [],
            'Customer ID'
        );
        
        $tableDevis->addColumn(
            'created_at',
            Table::TYPE_DATETIME,
            null,
            [],
            'Created At'
        );
        
        $tableDevis->addColumn(
            'traite',
            Table::TYPE_BOOLEAN,
            null,
            [],
            'Traite'
        );
        
        $setup->getConnection()->createTable($tableDevis);

        /**
         * Create table 'edeclic_devis_item'
         */

        
        $tableDevisItem = $setup->getConnection()->newTable($setup->getTable('wowow_devis_item'));

        
        $tableDevisItem->addColumn(
            'entity_id',
            Table::TYPE_INTEGER,
            null,
            array('identity' => true,'nullable' => false,'primary' => true,'unsigned' => true,),
            'Entity ID'
        );
        
        $tableDevisItem->addColumn(
            'devis_id',
            Table::TYPE_INTEGER,
            null,
            [],
            'Devis ID'
        );
        
        $tableDevisItem->addColumn(
            'sku',
            Table::TYPE_TEXT,
            null,
            [],
            'sku'
        );
        
        $tableDevisItem->addColumn(
            'qty',
            Table::TYPE_INTEGER,
            null,
            [],
            'qty'
        );
        
        $tableDevisItem->addColumn(
            'prix_unit',
            Table::TYPE_FLOAT,
            null,
            [],
            'prix unitaire'
        );
        
        $setup->getConnection()->createTable($tableDevisItem);

        
        // End Setup
        $installer->endSetup();
    }

}