 
 CREATE TABLE customers (
   customer_id BPCHAR NOT NULL PRIMARY KEY,
-  company_name CHARACTER VARYING(40) NOT NULL,
-  contact_name CHARACTER VARYING(30),
-  contact_title CHARACTER VARYING(30),
-  address CHARACTER VARYING(60),
-  city CHARACTER VARYING(15),
-  region CHARACTER VARYING(15),
-  postal_code CHARACTER VARYING(10),
-  country CHARACTER VARYING(15),
-  phone CHARACTER VARYING(24),
-  fax CHARACTER VARYING(24)
+  company_name VARCHAR(40) NOT NULL,
+  contact_name VARCHAR(30),
+  contact_title VARCHAR(30),
+  address VARCHAR(60),
+  city VARCHAR(15),
+  region VARCHAR(15),
+  postal_code VARCHAR(10),
+  country VARCHAR(15),
+  phone VARCHAR(24),
+  fax VARCHAR(24)
 );
 
 CREATE TABLE customer_customer_demo (


CREATE TABLE us_states (
  state_id SMALLINT NOT NULL PRIMARY KEY,
  state_name CHARACTER VARYING(100),
  state_abbr CHARACTER VARYING(2),
  state_region CHARACTER VARYING(50)
);


CREATE TABLE categories (
  category_id SMALLINT NOT NULL PRIMARY KEY,
  category_name VARCHAR(15) NOT NULL,
  description TEXT,
  picture BYTEA
);
