-- $Platon: $

--
-- Table structure for table `actions`
--

DROP TABLE IF EXISTS actions;
CREATE TABLE actions (
  aid int(11) NOT NULL auto_increment,
  name enum('list','add','change','delete','view') default NULL,
  relation enum('actions','customers','users','calls','orders','products') default NULL,
  notes blob,
  PRIMARY KEY  (aid)
) TYPE=MyISAM;

--
-- Table structure for table `calls`
--

DROP TABLE IF EXISTS calls;
CREATE TABLE calls (
  call_id int(11) NOT NULL auto_increment,
  cid int(11) default NULL,
  uid int(11) default NULL,
  call_date datetime default NULL,
  type enum('phone','fax','mail','e-mail','icq','visit') default NULL,
  subject varchar(255) default NULL,
  notes blob,
  created_by int(11) default NULL,
  created_date datetime default NULL,
  changed_by int(11) default NULL,
  changed_date datetime default NULL,
  PRIMARY KEY  (call_id),
  KEY calls_cid (cid),
  KEY calls_uid (uid)
) TYPE=MyISAM;

--
-- Table structure for table `customers`
--

DROP TABLE IF EXISTS customers;
CREATE TABLE customers (
  cid int(11) NOT NULL auto_increment,
  ico varchar(60) default NULL,
  name varchar(255) default NULL,
  website varchar(60) default NULL,
  phone varchar(60) default NULL,
  person varchar(60) default NULL,
  notes blob,
  created_by int(11) default NULL,
  created_date datetime default NULL,
  changed_by int(11) default NULL,
  changed_date datetime default NULL,
  PRIMARY KEY  (cid),
  KEY customers_ico (ico)
) TYPE=MyISAM;

--
-- Table structure for table `order_products`
--

DROP TABLE IF EXISTS order_products;
CREATE TABLE order_products (
  prod_id int(11) default NULL,
  order_id int(11) default NULL,
  KEY order_products_prod_id (prod_id),
  KEY order_products_order_id (order_id)
) TYPE=MyISAM;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS orders;
CREATE TABLE orders (
  order_id int(11) NOT NULL auto_increment,
  cid int(11) default NULL,
  uid int(11) default NULL,
  order_date datetime default NULL,
  status enum('new','negotiated','confirmed','payed','closed') default NULL,
  notes blob,
  created_by int(11) default NULL,
  created_date datetime default NULL,
  changed_by int(11) default NULL,
  changed_date datetime default NULL,
  PRIMARY KEY  (order_id)
) TYPE=MyISAM;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS products;
CREATE TABLE products (
  prod_id int(11) NOT NULL auto_increment,
  name varchar(32) default NULL,
  description varchar(255) default NULL,
  otc_price decimal(9,2) default NULL,
  frc_price decimal(9,2) default NULL,
  notes blob,
  created_by int(11) default NULL,
  created_date datetime default NULL,
  changed_by int(11) default NULL,
  changed_date datetime default NULL,
  PRIMARY KEY  (prod_id),
  KEY products_name (name)
) TYPE=MyISAM;

--
-- Table structure for table `user_actions`
--

DROP TABLE IF EXISTS user_actions;
CREATE TABLE user_actions (
  aid int(11) default NULL,
  uid int(11) default NULL,
  KEY user_actions_aid (aid),
  KEY user_actions_uid (uid)
) TYPE=MyISAM;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS users;
CREATE TABLE users (
  uid int(11) NOT NULL auto_increment,
  login varchar(60) default NULL,
  password varchar(32) default NULL,
  firstname varchar(60) default NULL,
  middlename varchar(60) default NULL,
  lastname varchar(60) default NULL,
  parent_uid int(11) default NULL,
  login_count bigint(20) default NULL,
  last_login datetime default NULL,
  last_logout datetime default NULL,
  last_access datetime default NULL,
  notes blob,
  created_by int(11) default NULL,
  created_date datetime default NULL,
  changed_by int(11) default NULL,
  changed_date datetime default NULL,
  session_id varchar(32) default NULL,
  PRIMARY KEY  (uid),
  UNIQUE KEY users_login (login),
  KEY users_parent_uid (parent_uid)
) TYPE=MyISAM;