--	Execute on Windows
--		c:\> db2 connect to cake
--		c:\> db2 -tf "C:\Documents and Settings\Administrator\My Documents\CakePHP\db_test\db_test_db2.sql"

-- Dump of table categories
-- ------------------------------------------------------------

DROP TABLE categories;
CREATE TABLE categories (
  id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
  name VARCHAR(255)
);


-- Dump of table categories_products
-- ------------------------------------------------------------

DROP TABLE categories_products;
CREATE TABLE categories_products (
  id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
  category_id INTEGER,
  product_id INTEGER
);


-- Dump of table order_items
-- ------------------------------------------------------------

DROP TABLE order_items;
CREATE TABLE order_items (
  id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
  order_id INTEGER,
  product_id INTEGER,
  created TIMESTAMP,
  updated TIMESTAMP
);


-- Dump of table orders
-- ------------------------------------------------------------

DROP TABLE orders;
CREATE TABLE orders (
  id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
  customer_name VARCHAR(255),
  created TIMESTAMP,
  updated TIMESTAMP
);


-- Dump of table payments
-- ------------------------------------------------------------

DROP TABLE payments;
CREATE TABLE payments (
  id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
  order_id INTEGER,
  total DOUBLE,
  created TIMESTAMP,
  updated TIMESTAMP
);


-- Dump of table products
-- ------------------------------------------------------------

DROP TABLE products;
CREATE TABLE products (
  id INTEGER GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
  name VARCHAR(255),
  description CLOB	
);