CREATE TABLE IF NOT EXISTS medij_operacija (
  medij_operacija_ID  integer NOT NULL AUTO_INCREMENT,
  film_ID integer,
  film_medij_ID integer,
  stranka_ID integer,
  vrsta_medija_ID integer,
  zac_operacije date default '0000-00-00',
  zac_operacije_t time,
  plan_kon_operacije date default '0000-00-00',
  kon_operacije   date,
  oper integer NOT NULL,
  racun_ID integer,
  i_operator  varchar(30) default '',
  i_date  date default '0000-00-00',
  u_operator  varchar(30) default '',
  u_date  date default '0000-00-00',
  is_deleted integer,
  INDEX (film_medij_ID),
  INDEX (racun_ID),
  INDEX (stranka_ID),
  INDEX(oper),
  INDEX (is_deleted),
  PRIMARY KEY (medij_operacija_ID)
) TYPE=InnoDB COMMENT='POD. TABELA OPERACIJ NAD MEDIJI';



INSERT INTO medij_operacija VALUES
(1, NULL, 398, 37, NULL, '2004-09-02', '01:55:35', '2004-09-04', '2004-09-02', 2, 1, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(2, NULL, 398, 37, NULL, '2004-09-02', '01:56:29', '2004-09-04', '2004-09-02', 2, 1, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(3, NULL, 400, 37, NULL, '2004-09-02', '02:02:02', '2004-09-04', '2004-09-02', 2, 2, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(4, NULL, 402, 37, NULL, '2004-09-02', '02:03:26', '2004-09-04', '2004-09-02', 2, 3, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(5, NULL, 403, 37, NULL, '2004-09-02', '02:03:40', '2004-09-04', '2004-09-02', 2, 3, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(6, NULL, 406, 37, NULL, '2004-09-01', '02:04:58', '2004-09-03', '2004-09-02', 2, 4, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(7, NULL, 408, 37, NULL, '2004-09-02', '02:05:27', '2004-09-04', '2004-09-02', 2, 4, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(8, NULL, 357, 37, NULL, '2004-08-31', '02:38:56', '2004-09-02', '2004-09-02', 2, 5, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(9, NULL, 408, 37, NULL, '2004-08-25', '02:45:58', '2004-08-27', '2004-09-02', 2, 5, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(10, NULL, 366, 37, NULL, '2004-09-02', '09:12:22', '2004-09-04', '2004-09-02', 2, 6, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(11, NULL, 259, 37, NULL, '2004-09-02', '09:25:45', '2004-09-04', '2004-09-02', 2, 7, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(12, NULL, 368, 37, NULL, '2004-09-02', '09:33:23', '2004-09-04', '2004-09-02', 2, 8, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(13, NULL, 484, 37, NULL, '2004-09-02', '09:37:06', '2004-09-04', '2004-09-02', 2, 9, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(14, NULL, 581, 37, NULL, '2004-09-02', '09:38:46', '2004-09-04', '2004-09-02', 2, 10, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(15, NULL, 292, 37, NULL, '2004-09-02', '10:01:10', '2004-09-04', '2004-09-02', 2, 10, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(16, NULL, 411, 37, NULL, '2004-09-02', '10:06:16', '2004-09-04', '2004-09-02', 2, 12, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(17, NULL, 581, 37, NULL, '2004-09-02', '10:09:32', '2004-09-04', '2004-09-02', 2, 13, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(18, NULL, 25, 37, NULL, '2004-09-02', '10:18:52', '2004-09-04', '2004-09-02', 2, 14, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(19, NULL, 256, 37, NULL, '2004-09-02', '10:29:51', '2004-09-04', '2004-09-02', 2, 15, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(20, NULL, 257, 37, NULL, '2004-09-02', '10:30:33', '2004-08-23', '2004-09-02', 2, 16, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(21, NULL, 260, 37, NULL, '2004-09-02', '10:31:29', '2004-09-05', '2004-09-02', 2, 17, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(22, NULL, 260, 37, NULL, '2004-09-02', '10:32:53', '2004-09-08', '2004-09-02', 2, 18, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(23, NULL, 366, 37, NULL, '2004-09-02', '10:35:57', '2004-09-17', '2004-09-02', 2, 19, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(24, NULL, 260, 37, NULL, '2004-09-02', '10:36:58', '2004-08-13', '2004-09-02', 2, 19, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(25, NULL, 260, 37, NULL, '2004-09-02', '10:43:40', '2004-09-04', '2004-09-02', 2, 20, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(26, NULL, 260, 37, NULL, '2004-09-02', '10:47:36', '2004-08-18', '2004-09-02', 2, 20, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(27, NULL, 260, 37, NULL, '2004-09-02', '10:48:47', '2004-08-18', '2004-09-02', 2, 21, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(28, NULL, 260, 37, NULL, '2004-09-02', '10:56:32', '2004-08-18', '2004-09-02', 2, 22, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(29, NULL, 366, 37, NULL, '2004-09-02', '11:02:24', '2004-10-22', '2004-09-02', 2, 23, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(30, NULL, 483, 37, NULL, '2004-09-02', '11:06:28', '2004-09-04', '2004-09-02', 2, 23, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(31, NULL, 483, 37, NULL, '2004-09-02', '11:08:07', '2004-10-12', '2004-09-02', 2, 24, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(32, NULL, 483, 37, NULL, '2004-09-02', '11:13:31', '2004-09-14', '2004-09-02', 2, 25, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(33, NULL, 483, 37, NULL, '2004-09-02', '11:15:55', '2004-09-14', '2004-09-02', 2, 26, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(34, NULL, 483, 37, NULL, '2004-09-02', '11:17:19', '2004-09-14', '2004-09-02', 2, 27, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(35, NULL, 483, 37, NULL, '2004-09-02', '11:24:35', '2004-09-14', '2004-09-02', 2, 28, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(36, NULL, 483, 37, NULL, '2004-09-02', '11:56:03', '2004-09-14', '2004-09-02', 2, 29, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(37, NULL, 483, 37, NULL, '2004-09-02', '12:58:04', '2004-09-04', '2004-09-02', 2, 30, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(38, NULL, 483, 37, NULL, '2004-09-02', '12:59:36', '2004-09-04', '2004-09-02', 2, 31, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(39, NULL, 483, 37, NULL, '2004-09-02', '13:00:07', '2004-09-05', NULL, 1, 32, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(40, NULL, 482, 37, NULL, '2004-09-02', '13:13:40', '2004-09-04', '2004-09-02', 2, 33, 'borisb', '2004-09-02', 'borisb', '2004-09-02', NULL),

(41, NULL, 406, 37, NULL, '2004-09-03', '21:29:05', '2004-09-05', NULL, 1, NULL, 'borisb', '2004-09-03', 'borisb', '2004-09-03', NULL);