Writing an Install Script for my new plugin

[kathyfrombauline]

Hi

I have created a plugin (my first attempt).
Now I am trying to create an install script for this plugin where I create a database.
How do I install sample data with this

<?php
/*
Plugin Name: 	XXXX
Description:	XXXX
Version: 		1.0
Author: 		XXXXXX
*/

function ss_options_install() 
{
    global $wpdb;

    $table_name 	= $wpdb->prefix . "tenders";
    $charset_collate 	= $wpdb->get_charset_collate();

    $sql = "CREATE TABLE $table_name 
	(
           	 `id` 	varchar(30) CHARACTER SET utf8 NOT NULL,
	 `name` 	varchar(60) CHARACTER SET utf8 NOT NULL,
           	 `type`   	varchar(30) CHARACTER SET utf8 NOT NULL,
           	 `issued`   varchar(10) CHARACTER SET utf8 NOT NULL,
           	 `closed` 	varchar(10) CHARACTER SET utf8 NOT NULL,
           	 `status`   varchar(30) CHARACTER SET utf8 NOT NULL,
           	 `awarded`   varchar(60) CHARACTER SET utf8 NOT NULL,
           	 `desc`      varchar(250) CHARACTER SET utf8 NOT NULL,
           	 PRIMARY KEY (`id`)
          	) $charset_collate; ";

    require_once( ABSPATH . 'wp-admin/includes/upgrade.php' );

    dbDelta($sql);
}

register_activation_hook(__FILE__, 'ss_options_install');

add_action('admin_menu','Katie_tenders_modifymenu');

function Katie_tenders_modifymenu() 
{
	add_menu_page('Katie Tenders', 
	'Katie Tenders', 
	'manage_options', 
	'Katie_tenders_list', 
	'Katie_tenders_list' 
	);
	
	add_submenu_page('Katie_tenders_list', 
	'Add New Tender', 
	'Add New Tender', 
	'manage_options', 
	'Katie_tenders_create', 
	'Katie_tenders_create'); 
	
	add_submenu_page(null, 
	'Update Tender', 
	'Update Tender', 
	'manage_options', 
	'Katie_tenders_update', 
	'Katie_tenders_update'); 
}

define('ROOTDIR', plugin_dir_path(__FILE__));
require_once(ROOTDIR . 'tenders-list.php');
require_once(ROOTDIR . 'tenders-create.php');
require_once(ROOTDIR . 'tenders-update.php');