<?php

function bwadminpages_dbcreate() {
	global $wpdb;
	
	$table_name = $wpdb->prefix . "bwadminpages"; 
	
	$charset_collate = $wpdb->get_charset_collate();
	
	$sql = "CREATE TABLE $table_name (
	  id mediumint(9) NOT NULL AUTO_INCREMENT,
	  timestamp varchar(30) NOT NULL,
	  page_title varchar(100) NOT NULL,
	  page_content varchar(10000) NOT NULL,
	  menu_position int(10) NOT NULL,
	  menu_icon varchar(100) NOT NULL,
	  menu_capability varchar(100) NOT NULL,
	  UNIQUE KEY id (id)
	) $charset_collate;";
	
	require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );
	dbDelta( $sql );
	
	$bwadminpages_page_title = 'Example page';
	$bwadminpages_page_content = 'This is an example page';
	$bwadminpages_timestamp = time();
	$bwadminpages_menu_position = '18';
	$bwadminpages_menu_icon = 'dashicons-media-code';
	$bwadminpages_menu_capability = 'activate_plugins';
	
	$table_name = $wpdb->prefix . 'bwadminpages';
	
	$wpdb->insert( 
		$table_name, 
		array( 
			'timestamp' => $bwadminpages_timestamp, 
			'page_title' => $bwadminpages_page_title, 
			'page_content' => $bwadminpages_page_content,
			'menu_position' => $bwadminpages_menu_position,
			'menu_icon' => $bwadminpages_menu_icon,
			'menu_capability' => $bwadminpages_menu_capability
		) 
	);
}
?>