-- Convert schema '/home/hmai/Projekte/Tapper/src/Tapper-Schema/lib/auto/Tapper/Schema/Tapper-Schema-ReportsDB-3.000007-SQLite.sql' to '/home/hmai/Projekte/Tapper/src/Tapper-Schema/lib/auto/Tapper/Schema/Tapper-Schema-ReportsDB-4.001001-SQLite.sql':;

BEGIN;

CREATE TABLE owner (
  id INTEGER PRIMARY KEY NOT NULL,
  name VARCHAR(255) NOT NULL,
  login VARCHAR(255) NOT NULL,
  password VARCHAR(255)
);

CREATE UNIQUE INDEX unique_login ON owner (login);

CREATE TEMPORARY TABLE contact_temp_alter (
  id INTEGER PRIMARY KEY NOT NULL,
  owner_id INT(11) NOT NULL,
  address VARCHAR(255) NOT NULL,
  protocol VARCHAR(255) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME,
  FOREIGN KEY (owner_id) REFERENCES owner(id) ON DELETE CASCADE ON UPDATE CASCADE
);

INSERT INTO contact_temp_alter( id, address, protocol, created_at, updated_at) SELECT id, address, protocol, created_at, updated_at FROM contact;

DROP TABLE contact;

CREATE TABLE contact (
  id INTEGER PRIMARY KEY NOT NULL,
  owner_id INT(11) NOT NULL,
  address VARCHAR(255) NOT NULL,
  protocol VARCHAR(255) NOT NULL,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME,
  FOREIGN KEY (owner_id) REFERENCES owner(id) ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE INDEX contact_idx_owner_id03 ON contact (owner_id);

INSERT INTO contact SELECT id, owner_id, address, protocol, created_at, updated_at FROM contact_temp_alter;

DROP TABLE contact_temp_alter;

CREATE TEMPORARY TABLE notification_temp_alter (
  id INTEGER PRIMARY KEY NOT NULL,
  owner_id INT(11),
  persist INT(1),
  event VARCHAR(255) NOT NULL,
  filter TEXT NOT NULL,
  comment VARCHAR(255),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME,
  FOREIGN KEY (owner_id) REFERENCES owner(id) ON DELETE CASCADE ON UPDATE CASCADE
);

INSERT INTO notification_temp_alter( id, persist, event, filter, comment, created_at, updated_at) SELECT id, persist, event, filter, comment, created_at, updated_at FROM notification;

DROP TABLE notification;

CREATE TABLE notification (
  id INTEGER PRIMARY KEY NOT NULL,
  owner_id INT(11),
  persist INT(1),
  event VARCHAR(255) NOT NULL,
  filter TEXT NOT NULL,
  comment VARCHAR(255),
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  updated_at DATETIME,
  FOREIGN KEY (owner_id) REFERENCES owner(id) ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE INDEX notification_idx_owner_id03 ON notification (owner_id);

INSERT INTO notification SELECT id, owner_id, persist, event, filter, comment, created_at, updated_at FROM notification_temp_alter;

DROP TABLE notification_temp_alter;

DROP INDEX ;

CREATE TEMPORARY TABLE reportcomment_temp_alter (
  id INTEGER PRIMARY KEY NOT NULL,
  report_id INT(11) NOT NULL,
  owner_id INT(11),
  succession INT(10),
  comment TEXT NOT NULL DEFAULT '',
  created_at DATETIME NOT NULL,
  updated_at DATETIME NOT NULL,
  FOREIGN KEY (owner_id) REFERENCES owner(id),
  FOREIGN KEY (report_id) REFERENCES report(id) ON DELETE CASCADE ON UPDATE CASCADE
);

INSERT INTO reportcomment_temp_alter( id, report_id, succession, comment, created_at, updated_at) SELECT id, report_id, succession, comment, created_at, updated_at FROM reportcomment;

DROP TABLE reportcomment;

CREATE TABLE reportcomment (
  id INTEGER PRIMARY KEY NOT NULL,
  report_id INT(11) NOT NULL,
  owner_id INT(11),
  succession INT(10),
  comment TEXT NOT NULL DEFAULT '',
  created_at DATETIME NOT NULL,
  updated_at DATETIME NOT NULL,
  FOREIGN KEY (owner_id) REFERENCES owner(id),
  FOREIGN KEY (report_id) REFERENCES report(id) ON DELETE CASCADE ON UPDATE CASCADE
);

CREATE INDEX reportcomment_idx_owner_id03 ON reportcomment (owner_id);

CREATE INDEX reportcomment_idx_report_id03 ON reportcomment (report_id);

INSERT INTO reportcomment SELECT id, report_id, owner_id, succession, comment, created_at, updated_at FROM reportcomment_temp_alter;

DROP TABLE reportcomment_temp_alter;

DROP INDEX ;

DROP INDEX ;

DROP INDEX ;

DROP INDEX ;

DROP INDEX ;

DROP TABLE user;


COMMIT;