3v4l.org

run code in 300+ PHP versions simultaneously

@ 2014-03-12T12:15:38Z

<?php
function floormap_schema(){
    $schema['floormap_images'] = array (
            'description'   => 'Floor map images.',
            'fields'        => array (
                'image'     => array('type'     => 'blob',      'not null'  => TRUE,),
                'name'      => array( 'type'        => 'varchar',       'length'        => 30,      'not null'  => TRUE,),
                'active'    => array('type'     => 'int',           'unsigned'  => TRUE,    'not null'  => TRUE,),
            ),
            'unique keys'   => array('name' => array('name'),
            ),
        );  
    $schema['floormap_coords'] = array (
        'description'   => 'Floor map images.',
        'fields'        => array (
            'uid'       => array( 'type'    => 'serial',    'unsigned'  => TRUE,    'not null'  => TRUE,),
            'floormap'  => array( 'type'    => 'text',  'not null'  => TRUE,),
            'item_type' => array( 'type'    => 'text',  'not null'  => TRUE,),
            'pos_a_x'   => array( 'type'    => 'int',       'unsigned'  => TRUE,    'not null'  => TRUE,),
            'pos_a_y'   => array( 'type'    => 'int',       'unsiged'   => TRUE,    'not null'  => TRUE,),
            'pos_b_x'   => array( 'type'    => 'int',       'unsigned'  => TRUE,    'not null'  => TRUE,),
            'pos_b_y'   => array( 'type'    => 'int',       'unsiged'   => TRUE,    'not null'  => TRUE,),
            'pos_c_x'   => array( 'type'    => 'int',       'unsigned'  => TRUE,    'not null'  => TRUE,),
            'pos_c_y'   => array( 'type'    => 'int',       'unsiged'   => TRUE,'   not null'   => TRUE,),
            'pos_d_x'   => array('type' => 'int',       'unsigned'  => TRUE,    'not null'  => TRUE,),
            'pos_d_y'   => array('type' => 'int',       'unsiged'   => TRUE,    'not null'  => TRUE,),
        ),
        'unique keys'   => array('uid' => array('uid'),),
    );  
    return $schema;
}

print_r(floormap_schema());

Output for 4.3.0 - 4.3.11, 4.4.0 - 4.4.9, 5.0.0 - 5.0.5, 5.1.0 - 5.1.6, 5.2.0 - 5.2.17, 5.3.0 - 5.3.29, 5.4.0 - 5.4.45, 5.5.0 - 5.5.38, 5.6.0 - 5.6.28, 7.0.0 - 7.0.20, 7.1.0 - 7.1.20, 7.2.0 - 7.2.33, 7.3.12 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.6: Array ( [floormap_images] => Array ( [description] => Floor map images. [fields] => Array ( [image] => Array ( [type] => blob [not null] => 1 ) [name] => Array ( [type] => varchar [length] => 30 [not null] => 1 ) [active] => Array ( [type] => int [unsigned] => 1 [not null] => 1 ) ) [unique keys] => Array ( [name] => Array ( [0] => name ) ) ) [floormap_coords] => Array ( [description] => Floor map images. [fields] => Array ( [uid] => Array ( [type] => serial [unsigned] => 1 [not null] => 1 ) [floormap] => Array ( [type] => text [not null] => 1 ) [item_type] => Array ( [type] => text [not null] => 1 ) [pos_a_x] => Array ( [type] => int [unsigned] => 1 [not null] => 1 ) [pos_a_y] => Array ( [type] => int [unsiged] => 1 [not null] => 1 ) [pos_b_x] => Array ( [type] => int [unsigned] => 1 [not null] => 1 ) [pos_b_y] => Array ( [type] => int [unsiged] => 1 [not null] => 1 ) [pos_c_x] => Array ( [type] => int [unsigned] => 1 [not null] => 1 ) [pos_c_y] => Array ( [type] => int [unsiged] => 1 [ not null] => 1 ) [pos_d_x] => Array ( [type] => int [unsigned] => 1 [not null] => 1 ) [pos_d_y] => Array ( [type] => int [unsiged] => 1 [not null] => 1 ) ) [unique keys] => Array ( [uid] => Array ( [0] => uid ) ) ) )

preferences:dark modelive preview

249.78 ms | 414 KiB | 356 Q