--
-- $Id: myodbc_catastrophic_failure.sql 5230 2005-06-27 09:03:46Z wpc0756\Emmanuel $
--

DROP DATABASE IF EXISTS testmyodbc
;
CREATE DATABASE testmyodbc
;

DROP TABLE IF EXISTS testmyodbc.myodbc_catastrophic_failure
;
CREATE TABLE testmyodbc.myodbc_catastrophic_failure(
  id INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY,
  code VARCHAR(4) NOT NULL,
  label VARCHAR(255)
)
;

GRANT 
  ALL PRIVILEGES 
ON 
  testmyodbc.*
TO 
  'testmyodbc'@'localhost'
;

INSERT INTO testmyodbc.myodbc_catastrophic_failure(code, label)
VALUES
  ('A', 'Label A'),
  ('B', 'Label B'),
  ('C', 'Label C')
;

SELECT * FROM testmyodbc.myodbc_catastrophic_failure
;