Sqlite

[WiLDTuRTLE]

How do i add this to a table?

            CREATE TABLE IF NOT EXISTS `bounty_hunters` (
             `id` int(11) NOT NULL auto_increment,
              `fp_id` int(11) NOT NULL,
              `sp_id` int(11) NOT NULL,
              `k_id` int(11) NOT NULL,
              `added` int(15) NOT NULL,
              `prize` bigint(20) NOT NULL,
              `killed` int(11) NOT NULL,
              `kill_time` int(15) NOT NULL,
              PRIMARY KEY  (`id`)
            ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

 

[Ninja]

CREATE TABLE IF NOT EXISTS `bounty_hunters` (
    `id` INTEGER(11) NOT NULL,
    `fp_id` INTEGER(11) NOT NULL,
    `sp_id` INTEGER(11) NOT NULL,
    `k_id` INTEGER(11) NOT NULL,
    `added` INTEGER(15) NOT NULL,
    `prize` BIGINT(20) NOT NULL,
    `killed` INTEGER(11) NOT NULL,
    `kill_time` INTEGER(15) NOT NULL,
    PRIMARY KEY  (`id`)
)

 

[Zeuch]

I think he is after the alter statement, since he said "add this to a table"

ALTER TABLE bounty_hunters ADD COLUMN
    `id` INTEGER(11) NOT NULL,
    `fp_id` INTEGER(11) NOT NULL,
    `sp_id` INTEGER(11) NOT NULL,
    `k_id` INTEGER(11) NOT NULL,
    `added` INTEGER(15) NOT NULL,
    `prize` BIGINT(20) NOT NULL,
    `killed` INTEGER(11) NOT NULL,
    `kill_time` INTEGER(15) NOT NULL,
    PRIMARY KEY (`id`)