CREATE TABLE pklasku_base (
  id int(11) NOT NULL auto_increment,
  name varchar(100) NOT NULL,
  contact_person varchar(50) NOT NULL,
  street_address varchar(100) NOT NULL,
  zip_code varchar(10) NOT NULL,
  city varchar(50) NOT NULL,
  phone varchar(50) NOT NULL,
  bank_name varchar(50) NOT NULL,
  bank_account varchar(30) NOT NULL,
  www varchar(255) default NULL,
  email varchar(100) default NULL,
  company_id varchar(15) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE pklasku_company (
  id int(11) NOT NULL auto_increment,
  inside_info text,
  type_id int(11) default NULL,
  company_name varchar(100) NOT NULL,
  contact_person varchar(100) default NULL,
  street_address varchar(100) default NULL,
  zip_code varchar(10) default NULL,
  city varchar(100) default NULL,
  phone varchar(30) default NULL,
  fax varchar(30) default NULL,
  email varchar(50) default NULL,
  gsm varchar(30) default NULL,
  billing_address text,
  www varchar(100) default NULL,
  info text,
  company_id varchar(15) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE pklasku_company_contact (
  id int(11) NOT NULL auto_increment,
  company_id int(11) NOT NULL default '0',
  contact_person varchar(100) default NULL,
  person_title varchar(100) default NULL,
  email varchar(50) default NULL,
  phone varchar(30) default NULL,
  gsm varchar(30) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

CREATE TABLE pklasku_company_type (
  id int(11) NOT NULL auto_increment,
  name varchar(255) default NULL,
  order_no int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=23 ;

CREATE TABLE pklasku_invoice (
  id int(11) NOT NULL auto_increment,
  name varchar(50) default NULL,
  company_id int(11) default NULL,
  invoice_no varchar(100) default NULL,
  real_invoice_no int(11) default NULL,
  invoice_date int(11) default NULL,
  due_date int(11) default NULL,
  payment_date int(11) default NULL,
  ref_number varchar(100) default NULL,
  state_id int(11) default NULL,
  reference varchar(50) default NULL,
  base_id int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE pklasku_invoice_row (
  id int(11) NOT NULL auto_increment,
  invoice_id int(11) default NULL,
  description varchar(255) default NULL,
  type_id int(11) default NULL,
  pcs decimal(9,2) default NULL,
  price decimal(9,2) default NULL,
  row_date int(11) default NULL,
  vat int(11) NOT NULL default '0',
  order_no int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=1;

CREATE TABLE pklasku_invoice_state (
  id int(11) NOT NULL auto_increment,
  name varchar(15) default NULL,
  order_no int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=4 ;

CREATE TABLE pklasku_row_type (
  id int(11) NOT NULL auto_increment,
  name varchar(15) default NULL,
  order_no int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

CREATE TABLE pklasku_session (
  id varchar(100) NOT NULL,
  ip varchar(30) NOT NULL,
  timestamp int(11) default NULL,
  timeout int(11) default NULL,
  type_id int(11) default NULL,
  user_id int(11) default NULL,
  access_level int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

CREATE TABLE pklasku_session_type (
  id int(11) NOT NULL auto_increment,
  name varchar(15) default NULL,
  order_no int(11) default NULL,
  time_out int(11) default NULL,
  access_level int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=3;

CREATE TABLE pklasku_users (
  id int(11) NOT NULL auto_increment,
  name varchar(50) default NULL,
  email varchar(255) default NULL,
  login varchar(15) default NULL,
  passwd varchar(255) default NULL,
  type_id int(11) default NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM AUTO_INCREMENT=2;

CREATE TABLE pklasku_quicksearch (
  id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL default '0',
  name varchar(15) default NULL,
  form varchar(100) default NULL,
  whereclause text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

INSERT INTO pklasku_base (id, name, contact_person, street_address, zip_code, city, phone, bank_name, bank_account, www, email, company_id) VALUES (1, 'Samu Reinikainen Ltd', 'Samu Reinikainen', 'Pihkatie', '00410', 'HELSINKI', '+358 46 8104040', 'Pankki', '123456-654321', 'http://ajassa.fi/', 'samu@ajassa.fi', '123456-7');

INSERT INTO pklasku_company (id, inside_info, type_id, company_name, contact_person, street_address, zip_code, city, phone, fax, email, gsm, billing_address, www, info, company_id) VALUES (1, NULL, NULL, 'Samu Reinikainen Ltd', NULL, 'Pihkatie', '00410', 'HELSINKI', '046 - 810 4040', '-', 'samu@ajassa.fi', '046 - 810 4040', 'Samu Reinikainen Ltd\r\nPihkatie\r\n00410 HELSINKI', 'www.ajassa.fi', '', 'FI-123456-x');

INSERT INTO pklasku_company_contact (id, company_id, contact_person, person_title, email, phone, gsm) VALUES (1, 1, 'Samu Reinikainen', 'Johtaja, duunari, juoksupoika', 'samu@ajassa.fi', '046 - 810 4040', '046 - 810 4040');

INSERT INTO pklasku_company_type (id, name, order_no) VALUES (1, 'Autoilu', 5);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (2, 'Elintarviketeollisuus', 10);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (3, 'Graafinen ala', 15);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (4, 'Henkilsthallinto', 20);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (5, 'Julkinen sektori', 25);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (6, 'Kemian teollisuus', 30);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (7, 'Kiinteist', 35);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (8, 'Kuljetus ja logistiikka', 40);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (9, 'Kumi- ja muoviteollisuus', 45);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (10, 'Maa- ja metstalous', 50);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (11, 'Markkinointi ja mainonta', 55);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (12, 'Matkailu, majoitus ja virkistystoiminta', 60);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (13, 'Metalli', 65);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (14, 'Rakentaminen', 70);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (15, 'Taideteollisuus', 75);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (16, 'Taloushallinto', 80);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (17, 'Tekstiili- ja vaatetusteollisuus', 85);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (18, 'Terveydenhuolto ja hyvinvointi', 90);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (19, 'Tietotekniikka', 95);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (20, 'Vapaa-aika ja harrastustoiminta', 100);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (21, 'Ymprist', 105);
INSERT INTO pklasku_company_type (id, name, order_no) VALUES (22, 'Elektroniikka', 110);

INSERT INTO pklasku_invoice (id, name, company_id, invoice_no, real_invoice_no, invoice_date, due_date, payment_date, ref_number, state_id, reference, base_id) VALUES (1, 'Testi', 1, '100', 100, 20060530, 20060613, NULL, '', 1, '', 1);

INSERT INTO pklasku_invoice_row (id, invoice_id, description, type_id, pcs, price, row_date, vat, order_no) VALUES (1, 1, 'Testirivi 1', 3, 12.00, 150.00, 20060515, 22, 5);

INSERT INTO pklasku_invoice_state (id, name, order_no) VALUES (1, 'AVOIN', 5);
INSERT INTO pklasku_invoice_state (id, name, order_no) VALUES (2, 'LHETETTY', 10);
INSERT INTO pklasku_invoice_state (id, name, order_no) VALUES (3, 'MAKSETTU', 15);

INSERT INTO pklasku_row_type (id, name, order_no) VALUES (1, 'h', 5);
INSERT INTO pklasku_row_type (id, name, order_no) VALUES (2, 'pv', 10);
INSERT INTO pklasku_row_type (id, name, order_no) VALUES (3, 'kk', 15);
INSERT INTO pklasku_row_type (id, name, order_no) VALUES (4, 'kpl', 20);
INSERT INTO pklasku_row_type (id, name, order_no) VALUES (5, 'vuosi', 25);
INSERT INTO pklasku_row_type (id, name, order_no) VALUES (6, 'er', 30);
INSERT INTO pklasku_row_type (id, name, order_no) VALUES (8, 'km', 35);

INSERT INTO pklasku_session_type (id, name, order_no, time_out, access_level) VALUES (1, 'Kyttj', 1, 3600, 1);
INSERT INTO pklasku_session_type (id, name, order_no, time_out, access_level) VALUES (2, 'Admin', 2, 3600, 99);

INSERT INTO pklasku_users (id, name, email, login, passwd, type_id) VALUES (1, 'Administrator', 'foo@bar.fi.not', 'admin', md5('admin'), 2);