version  INTEGER NOT NULL     
);
Create table SHKProcessStates
(
KeyValue  VARCHAR (30)  NOT NULL     ,

CREATE view cities_states_countries
as
select     cities.cityid, cities.cityname, cities.stateid, states.statename, states.countryid, countries.countryname

drop table states
create table states (                    \
     state          varchar(50),               \

CREATE TABLE STATES NOT NULL PRIMARY KEY(
     STATE_ID VARCHAR(3) NOT NULL,
     STATE_NAME VARCHAR(24) NOT NULL,

-- Server version     3.23.54
--
-- Table structure for table 'bzl_states'
--
DROP TABLE IF EXISTS bzl_states;

create table dbo.QX_STATES (
    pkey              int             not null,
    name              varchar(255)    not null,

INSERT INTO phpgw_us_states values (1,'','Not Applicable');
INSERT INTO phpgw_us_states values (2,'AL','Alabama');
INSERT INTO phpgw_us_states values (3,'AK','Alaska');

  UNIQUE KEY wid (wid)
);
INSERT INTO nuke_listweather VALUES (NULL,'USA','Arkadelphia','United States','Arkansas','ARAR');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Arkansas City','United States','Arkansas','ARAK');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Ash Flat','United States','Arkansas','ARAS');

-- =====================================================
-- Name: InsertStates.sql
-- Author: Minerva Development Team
-- Copyright: ESBS Inc

  UNIQUE KEY wid (wid)
);
INSERT INTO nuke_listweather VALUES (NULL,'USA','Abilene','United States','Kansas','KS01');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Anthony','United States','Kansas','KS02');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Ashland','United States','Kansas','KS03');

# Compiled by Dave Nuttall, San Antonio, TX  9/15/2001.
#
INSERT INTO nuke_listweather VALUES (NULL,'USA','Abilene','United States','Texas','ABI');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Addison','United States','Texas','95TX');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Albany','United States','Texas','TX01');

  UNIQUE KEY wid (wid)
);
INSERT INTO nuke_listweather VALUES (NULL,'USA','Abbeville','United States','Alabama','ALBB');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Alexander City','United States','Alabama','ALLE');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Andalusia','United States','Alabama','ALAN');

  UNIQUE KEY wid (wid)
);
INSERT INTO nuke_listweather VALUES (NULL,'USA','Alpine','United States','Arizona','ALPX');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Apache Junction','United States','Arizona','AZAJ');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Avondale','United States','Arizona','AZ00');

create table states (
  code     varchar(2) primary key,
  name     varchar(30)

  UNIQUE KEY wid (wid)
);
INSERT INTO nuke_listweather VALUES (NULL,'USA','Agawam','United States','Massachusetts','MA10');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Amherst','United States','Massachusetts','AMHX');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Arlington','United States','Massachusetts','ARLY');

  UNIQUE KEY wid (wid)
);
INSERT INTO nuke_listweather VALUES (NULL,'USA','Adrian','United States','Michigan','MIAD');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Allen Park','United States','Michigan','ALNP');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Allendale','United States','Michigan','ALDX');

INSERT INTO gl_weather VALUES (1, 'KRUE', 'Russellville, AR', 'United States', '72801', 1, 0);
INSERT INTO gl_weather VALUES (148, 'KSAC', 'Sacramento, CA', 'United States', '94203', 1, 0);
INSERT INTO gl_weather VALUES (5, 'KBOS', 'Boston, MA', 'United States', '02109', 1, 0);

  UNIQUE KEY wid (wid)
);
INSERT INTO nuke_listweather VALUES (NULL,'USA','Aberdeen','United States','North Carolina','NCAB');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Albemarle','United States','North Carolina','NC01');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Alma','United States','North Carolina','NCAL');

  UNIQUE KEY wid (wid)
);
INSERT INTO nuke_listweather VALUES (NULL,'USA','Affton','United States','Missouri','03MO');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Albany','United States','Missouri','MO01');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Alton','United States','Missouri','MO02');

  UNIQUE KEY wid (wid)
);
INSERT INTO nuke_listweather VALUES (NULL,'USA','Air Force Academy','United States','Colorado','AFF');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Akron','United States','Colorado','AKO');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Alamosa','United States','Colorado','ALS');

  UNIQUE KEY wid (wid)
);
INSERT INTO nuke_listweather VALUES (NULL,'USA','Adelanto','United States','California','2L9');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Agoura Hills','United States','California','CAAH');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Alameda','United States','California','NGZ');

CREATE DATABASE sample_db2;
USE sample_db2;
CREATE TABLE US_states (
   state_name varchar(100),
   state_capital varchar(100),

  UNIQUE KEY wid (wid)
);
INSERT INTO nuke_listweather VALUES (NULL,'USA','Anchorage','United States','Alaska','ANC');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Arctic Village','United States','Alaska','AKAV');
INSERT INTO nuke_listweather VALUES (NULL,'USA','Barrow','United States','Alaska','BRW');

DROP TABLE IF EXISTS states;
CREATE TABLE `states` (
  `id` int(11) NOT NULL auto_increment,

DROP TABLE IF EXISTS states;
CREATE TABLE `states` (
  `id` int(11) NOT NULL auto_increment,