-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------





--
-- Create schema todojsc
--

CREATE DATABASE IF NOT EXISTS todojsc;
USE todojsc;

--
-- Definition of table `todojsc`.`todojsc_attachments`
--

CREATE TABLE  `todojsc`.`todojsc_attachments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` varchar(255) COLLATE utf8_bin NOT NULL,
  `path` varchar(255) COLLATE utf8_bin NOT NULL,
  `mime` varchar(255) COLLATE utf8_bin NOT NULL,
  `ancestor` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `todojsc`.`todojsc_attachments`
--

INSERT INTO `todojsc`.`todojsc_attachments` VALUES  (6,0x736173,0x2F746D702F61646D696E2F37365F313238343133333136305F6177642D686F7720746F207570646174652E747874,0x6E6F6E65,76),
 (7,0x676767,0x2F746D702F61646D696E2F37365F313238343133333937305F37356B61767131322E7A6970,0x6E6F6E65,76),
 (8,0x70686F746F,0x2F746D702F61646D696E2F37365F313238343133353434395F6C30315F362E6A7067,0x6E6F6E65,76),
 (9,0x6767,0x2F746D702F61646D696E2F37365F313238343133353436355F6C31345F32362E6A7067,0x6E6F6E65,76),
 (10,0x456E64206F662079656172,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F61646D696E2F37365F313238343430303530315F434F50454E484147454E5F44494330395F47494F54544F203030352E6A7067,0x6E6F6E65,76),
 (11,0x5469766F6C69,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F61646D696E2F37365F313238343430303633325F434F50454E484147454E5F44494330395F47494F54544F203030352E6A7067,0x6E6F6E65,76),
 (12,0x5469766F6C6932,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F61646D696E2F37375F313238343430303833395F434F50454E484147454E5F44494330395F47494F54544F203030362E6A7067,0x6E6F6E65,77),
 (13,0x4368696E61,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F61646D696E2F37375F313238343430303934365F434F50454E484147454E5F44494330395F47494F54544F203030382E6A7067,0x6E6F6E65,77),
 (14,0x7469766F6C6933,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F61646D696E2F37375F313238343430353730345F434F50454E484147454E5F44494330395F47494F54544F203031372E6A7067,0x6E6F6E65,77),
 (15,0x6D65,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F61646D696E2F39335F313238343438313732325F434F50454E484147454E5F44494330395F47494F54544F203035302E6A7067,0x6E6F6E65,93),
 (16,0x47617465203130,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F61646D696E2F3130365F313238343439343133315F4453434E373936352E4A5047,0x6E6F6E65,106),
 (17,0x4120646F6720616E64206120636869636B656E,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F6761622F3130395F313238343736363735325F303030303030303033392E6A7067,0x6E6F6E65,109),
 (20,0x536F6C766179,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F61646D696E2F3131305F313238343831363631355F38303070782D313931315F536F6C7661795F636F6E666572656E63652E6A7067,0x6E6F6E65,110),
 (21,0x466978,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F61646D696E2F3131305F313238343831363633395F6669782E6A7067,0x6E6F6E65,110),
 (22,0x46656172,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F61646D696E2F3131305F313238343831363636385F706972616D69646564697061757261,0x6E6F6E65,110),
 (23,0x7570,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F61646D696E2F39375F313238353234303738365F7375702E6A7067,0x6E6F6E65,97),
 (24,0x612066696C65,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F61646D696E2F3131325F313238353334333933365F303030303030303033392E6A7067,0x6E6F6E65,112),
 (25,0x72656D6F7665206D65,0x2F686F6D652F6761622F70726F6A656374732F746F646F6A73632F6174746163686D656E74732F61646D696E2F3131325F313238353334333934385F63617072657261332E6A7067,0x6E6F6E65,112);


--
-- Definition of table `todojsc`.`todojsc_benefits`
--

CREATE TABLE  `todojsc`.`todojsc_benefits` (
  `uid` varchar(255) NOT NULL,
  `name` varchar(32) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY (`uid`,`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `todojsc`.`todojsc_benefits`
--



--
-- Definition of table `todojsc`.`todojsc_event_types`
--

CREATE TABLE  `todojsc`.`todojsc_event_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `style` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `todojsc`.`todojsc_event_types`
--

INSERT INTO `todojsc`.`todojsc_event_types` VALUES  (1,'Travel','I will beout of office','purple'),
 (2,'Appointment','There will be a visit at my office','generic'),
 (3,'Office Meeting','Meeting for breafing in office','green');


--
-- Definition of table `todojsc`.`todojsc_events`
--

CREATE TABLE  `todojsc`.`todojsc_events` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ancestor` int(11) NOT NULL,
  `starttime` int(11) NOT NULL,
  `endtime` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `todojsc`.`todojsc_events`
--

INSERT INTO `todojsc`.`todojsc_events` VALUES  (4,44,1278540000,1280354400),
 (5,45,1278540000,1279836000),
 (6,47,1279144800,1279144800),
 (7,48,1279317600,1279317600),
 (8,50,1280181600,1280527200),
 (9,51,1280181600,1282082400),
 (10,52,1280440800,1279404000),
 (11,53,1279836000,1281391200),
 (12,54,1279058400,1282946400),
 (13,55,1279058400,1282946400),
 (14,56,1280181600,1280959200),
 (15,57,1280786400,1281564000),
 (16,58,1281391200,1282946400),
 (17,59,1282773600,1282946400),
 (18,60,1280613600,1283205600),
 (19,61,1280613600,1282946400),
 (20,62,1280613600,1282341600),
 (21,63,1281477600,1282341600),
 (22,64,1280872800,1282946400),
 (23,65,1281650400,1282860000),
 (24,66,1280613600,1283205600),
 (33,94,1282082400,1282860000),
 (32,79,1280786400,1282773600),
 (27,71,1281477600,1282341600),
 (28,72,1280872800,1282860000),
 (34,102,943916400,944002799),
 (31,75,1280613600,1282946400),
 (35,104,1284501600,1284847199),
 (36,105,1284933600,1285279199),
 (37,107,1284933600,1285883999);


--
-- Definition of table `todojsc`.`todojsc_expenses`
--

CREATE TABLE  `todojsc`.`todojsc_expenses` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ancestor` int(11) NOT NULL,
  `cost` varchar(32) NOT NULL,
  `notes` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `todojsc`.`todojsc_expenses`
--

INSERT INTO `todojsc`.`todojsc_expenses` VALUES  (37,91,'1100','accepted, very cheap'),
 (35,49,'130.00',''),
 (38,92,'100000','No, the company will not pay for your ferrari');


--
-- Definition of table `todojsc`.`todojsc_holidays`
--

CREATE TABLE  `todojsc`.`todojsc_holidays` (
  `hid` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `yearly` tinyint(1) NOT NULL,
  PRIMARY KEY (`hid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `todojsc`.`todojsc_holidays`
--

INSERT INTO `todojsc`.`todojsc_holidays` VALUES  (1,1279749600,1);


--
-- Definition of table `todojsc`.`todojsc_justification_types`
--

CREATE TABLE  `todojsc`.`todojsc_justification_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8_bin NOT NULL,
  `name` varchar(255) COLLATE utf8_bin NOT NULL,
  `mediumname` varchar(255) COLLATE utf8_bin NOT NULL,
  `shortname` varchar(255) COLLATE utf8_bin NOT NULL,
  `description` text COLLATE utf8_bin NOT NULL,
  `style` varchar(255) COLLATE utf8_bin NOT NULL,
  `internalonly` int(11) NOT NULL,
  PRIMARY KEY (`id`,`type`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `todojsc`.`todojsc_justification_types`
--

INSERT INTO `todojsc`.`todojsc_justification_types` VALUES  (1,0x626C6F6F64,0x426C6F6F6420446F6E6174696F6E,0x426C6F,0x44,0x426C6F6F6420446F6E6174696F6E,0x67656E6572616C,0),
 (2,0x686F6C6964617973,0x486F6C6964617973,0x486F6C,0x46,0x486F6C7964617973,0x67656E6572616C,0),
 (3,0x6F6C642D686F6C6964617973,0x41626F6C697368656420486F6C6964617973,0x41626F,0x4641,0x41626F6C697368656420686F6C7964617973,0x67656E6572616C,0),
 (4,0x6D61727269616765,0x4D61727269616765205065726D6974,0x4D6172,0x4C,0x4D61727269616765207065726D6974,0x67656E6572616C,0),
 (5,0x6D6F75726E696E67,0x4D6F75726E696E67,0x4D6F75,0x4C75,0x4D6F75726E696E67,0x67656E6572616C,0),
 (6,0x7369636B6E657373,0x5369636B6E657373,0x536963,0x4D,0x5369636B6E657373,0x67656E6572616C,0),
 (7,0x6D617465726E697479,0x4D617465726E697479,0x4D6174,0x4D61,0x4D617465726E697479,0x67656E6572616C,0),
 (8,0x666573746976697479,0x46657374697669747920436C6F73757265,0x466573,0x4E,0x46657374697669747920636C6F73757265,0x67656E6572616C,0),
 (9,0x70726573656E74,0x50726573656E74,0x507265,0x50,0x50726573656E74,0x67656E6572616C,1),
 (10,0x7065726D6974,0x50616964205065726D6974,0x506572,0x524F4C,0x5065726D6974,0x67656E6572616C,0),
 (11,0x6D65646963616C2D7669736974,0x446F63746F72205669736974,0x446F63,0x56,0x446F63746F72207669736974,0x67656E6572616C,0),
 (12,0x73747564792D7065726D6974,0x5374756479205065726D6974,0x537475,0x53,0x5374756479207065726D6974,0x67656E6572616C,0),
 (13,0x616273656E74,0x556E6A757374696669656420416273656E6365,0x556E6A,0x21,0x556E6A757374696669656420416273656E6365,0x67656E6572616C,1);


--
-- Definition of table `todojsc`.`todojsc_justifications`
--

CREATE TABLE  `todojsc`.`todojsc_justifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ancestor` int(11) NOT NULL,
  `starttime` int(11) NOT NULL,
  `endtime` int(11) NOT NULL,
  `notes` text NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `todojsc`.`todojsc_justifications`
--

INSERT INTO `todojsc`.`todojsc_justifications` VALUES  (1,81,1281391200,1282600800,'Edited too many times'),
 (2,82,1280613600,1283205600,''),
 (3,83,1280872800,1282773600,''),
 (4,84,1282255200,1282514400,'You took too many holidays already'),
 (5,85,1280613600,1282946400,'You are evil'),
 (6,86,1280872800,1282860000,'I really want to reject you'),
 (7,87,1281391200,1282773600,''),
 (10,95,1280613600,1281218400,'you deserve some summer vacations'),
 (11,96,1283378400,1283378400,'Okey, just for one day'),
 (12,97,1283724000,1283724000,'Another day'),
 (13,98,1284328800,1284415199,'Ok, just for one day'),
 (14,99,1284501600,1284674399,'We will pay you'),
 (15,100,1285797600,1285883999,'You are right. Bless you!'),
 (16,101,1284847200,1285451999,'Looks like you survived!'),
 (17,109,1285452000,1285883999,''),
 (18,114,1286056800,1286661599,'Show me on calendar');


--
-- Definition of table `todojsc`.`todojsc_message_targets`
--

CREATE TABLE  `todojsc`.`todojsc_message_targets` (
  `message` int(11) NOT NULL,
  `target` varchar(255) NOT NULL,
  `visible` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`message`,`target`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `todojsc`.`todojsc_message_targets`
--

INSERT INTO `todojsc`.`todojsc_message_targets` VALUES  (50,'admin',0),
 (51,'admin',0),
 (52,'admin',0),
 (53,'admin',0),
 (54,'admin',0),
 (55,'admin',0),
 (56,'admin',0),
 (57,'admin',0),
 (58,'admin',0),
 (59,'admin',0),
 (60,'admin',0),
 (61,'admin',0),
 (62,'admin',0),
 (63,'admin',0),
 (64,'admin',0),
 (65,'admin',0),
 (66,'admin',0),
 (85,'admin',0),
 (68,'admin',0),
 (79,'admin',1),
 (70,'admin',0),
 (71,'admin',0),
 (72,'admin',0),
 (86,'admin',1),
 (75,'admin',0),
 (84,'admin',1),
 (81,'admin',1),
 (82,'admin',1),
 (77,'admin',1),
 (77,'lauwenmark',1),
 (77,'gab',1),
 (77,'giulio',1),
 (77,'secretary',1),
 (77,'manager',1),
 (76,'admin',1),
 (76,'gab',1),
 (87,'admin',1),
 (91,'admin',1),
 (92,'admin',1),
 (94,'admin',1),
 (95,'admin',1),
 (96,'admin',1),
 (97,'admin',1),
 (98,'admin',1),
 (99,'admin',1),
 (100,'admin',1),
 (101,'admin',1),
 (102,'admin',1),
 (49,'admin',1),
 (103,'admin',1),
 (103,'lauwenmark',1),
 (103,'gab',1),
 (103,'giulio',1),
 (103,'secretary',1),
 (103,'manager',1),
 (104,'admin',1),
 (105,'admin',1),
 (106,'admin',1),
 (106,'lauwenmark',1),
 (106,'gab',1),
 (106,'giulio',1),
 (106,'secretary',1),
 (106,'manager',1),
 (107,'admin',1),
 (108,'gab',1),
 (109,'admin',1),
 (110,'admin',1),
 (110,'lauwenmark',1),
 (110,'gab',1),
 (110,'giulio',1),
 (110,'secretary',1),
 (110,'manager',1),
 (111,'admin',1),
 (111,'lauwenmark',1),
 (111,'gab',1),
 (111,'giulio',1),
 (111,'secretary',1),
 (111,'manager',1),
 (112,'gab',1),
 (112,'giulio',1),
 (114,'admin',1);


--
-- Definition of table `todojsc`.`todojsc_messages`
--

CREATE TABLE  `todojsc`.`todojsc_messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `timestamp` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `publisher` varchar(255) NOT NULL,
  `type` int(11) NOT NULL,
  `subtype` int(11) NOT NULL,
  `content` text NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=115 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `todojsc`.`todojsc_messages`
--

INSERT INTO `todojsc`.`todojsc_messages` VALUES  (97,1283377210,'For the 6th','admin',7,2,'Mmmm',3),
 (96,1283376935,'One day','admin',7,2,'Does this exists?',3),
 (82,1282150224,'An edited justification with id','admin',7,2,'id instead of jid, edited',1),
 (81,1282241174,'First Justification Edited2','admin',7,10,'First Justification text Edited2',4),
 (49,1279118745,'New York','admin',4,0,'Restaurant 50.00\nTaxi 30.00\nHotel 50.00',1),
 (95,1283250284,'Summer Holidays','admin',7,2,'Please confirm this',3),
 (94,1282679186,'Should be appointment','admin',2,1,'Ahhh works?',2),
 (93,1282679718,'Assumption','admin',3,1,'We got a new employer',0),
 (92,1282395494,'Expense to reject','admin',4,0,'Will the company pay that much?',4),
 (91,1282395346,'shoudl work','admin',4,0,'any descrition',3),
 (83,1282150732,'another justifcation','admin',7,6,'I was sick! For real!',0),
 (86,1282287467,'A justification to reject','admin',7,8,'Reject me in the view',4),
 (85,1282285480,'Trash me','admin',7,6,'Trash me please and everything will be fine',4),
 (68,1281631002,'auto accepted','admin',1,0,'Event auto-accepted',1),
 (77,1281806262,'A new with multiple targets','admin',3,1,'multiple targets',2),
 (76,1281810028,'a news - edited','admin',3,2,'a news - this news has been edited again and again',2),
 (75,1281712566,'An event to trash','admin',2,1,'An event for the calendar',2),
 (87,1282318234,'Delete me','admin',7,1,'delete me',1),
 (79,1281900745,'','admin',2,2,'For the calendar',2),
 (84,1282241040,'Ferie estive','gab',7,2,'Holidays for the week end',3),
 (70,1281695330,'type 2 subtype ?','admin',1,0,'Event auto-accepted',1),
 (71,1281704856,'auto accepted','admin',2,1,'no message sent for acceptance',2),
 (72,1281705219,'no acceptance message','admin',2,1,'no acceoptance message',2),
 (98,1283424848,'Th 13th','admin',7,2,'Will work',3),
 (99,1283442855,'paid permit','admin',7,10,'pay me',3),
 (100,1283442872,'was holy!','admin',7,3,'Hey! It was a holiday',3),
 (101,1283442898,'Was sick!','admin',7,6,'Bad flu',3),
 (102,1283790970,'','admin',2,1,'',2),
 (103,1284405939,'Empty news','admin',3,3,'Pub strike',2),
 (104,1284484980,'Not accepted','admin',2,1,'Not accepted but status = 2',2),
 (105,1284485095,'fast tab','admin',2,3,'Meeting',2),
 (106,1284494208,'Intrusion Control','admin',3,2,'Test will be performed on server. Expect downtime',2),
 (107,1284559056,'Works like a charm!','admin',2,3,'The new pane set works great',2),
 (108,1284647401,'Post multiple test','admin',3,1,'Text',2),
 (109,1284766862,'\'nother test','gab',7,6,'Should not see \"accept\" and \"reject\" on my own justification',1),
 (110,1284817893,'I have attachments','admin',3,2,'I have three attachments',2),
 (111,1284843806,'News without attachment','admin',3,1,'I do not have any attachment',2),
 (112,1285344017,'a news','admin',3,2,'For gab, my darling',2),
 (113,1285525641,'Still working','admin',3,2,'Still working news',0),
 (114,1285585992,'Secretary see me','gab',7,2,'This justification, after acceptance should display in secretary calendar',3);


--
-- Definition of table `todojsc`.`todojsc_news`
--

CREATE TABLE  `todojsc`.`todojsc_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ancestor` int(11) NOT NULL,
  `starttime` int(11) NOT NULL,
  `endtime` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `todojsc`.`todojsc_news`
--

INSERT INTO `todojsc`.`todojsc_news` VALUES  (1,76,1280786400,1282082400),
 (2,77,1280872800,1282860000),
 (4,93,1281996000,1282687200),
 (5,103,1283292000,1285883999),
 (6,106,1283896800,1284501600),
 (7,108,1285884000,1286661599),
 (8,110,1285279200,1285365599),
 (9,111,1285279200,1285365599),
 (10,112,1285192800,1285279199),
 (11,113,1283292000,1285970399);


--
-- Definition of table `todojsc`.`todojsc_news_types`
--

CREATE TABLE  `todojsc`.`todojsc_news_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `style` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `todojsc`.`todojsc_news_types`
--

INSERT INTO `todojsc`.`todojsc_news_types` VALUES  (1,'New building','A new building has been acquired','generic'),
 (2,'Intrusion control','Intrusion control will be performed on our systems','blue'),
 (3,'Strike','Atm strike, take the car','yellow');


--
-- Definition of table `todojsc`.`todojsc_paypacket_directories`
--

CREATE TABLE  `todojsc`.`todojsc_paypacket_directories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) NOT NULL,
  `path` text NOT NULL,
  `default` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `todojsc`.`todojsc_paypacket_directories`
--

INSERT INTO `todojsc`.`todojsc_paypacket_directories` VALUES  (1,'admin','admin',1),
 (2,'gab','gab',1),
 (4,'giulio','giulio',1);


--
-- Definition of table `todojsc`.`todojsc_paypacket_files`
--

CREATE TABLE  `todojsc`.`todojsc_paypacket_files` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `filename` text NOT NULL,
  `read` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `todojsc`.`todojsc_paypacket_files`
--

INSERT INTO `todojsc`.`todojsc_paypacket_files` VALUES  (1,'admin',1283872698,'presence-3.pdf',1),
 (2,'gab',1283872698,'presence-3.pdf',1),
 (4,'gab',1285857024,'0000000039.jpg',0),
 (5,'admin',1285857102,'aerodinamica2_teorie_alari.pdf',1),
 (6,'giulio',1285911328,'apxG.pdf',0);


--
-- Definition of table `todojsc`.`todojsc_stamps`
--

CREATE TABLE  `todojsc`.`todojsc_stamps` (
  `uid` varchar(255) NOT NULL,
  `timestamp` int(11) NOT NULL,
  `type` varchar(16) NOT NULL,
  PRIMARY KEY (`uid`,`timestamp`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `todojsc`.`todojsc_stamps`
--

INSERT INTO `todojsc`.`todojsc_stamps` VALUES  ('admin',1278687813,'start'),
 ('admin',1278708936,'end'),
 ('admin',1279115385,'start'),
 ('admin',1279130292,'end'),
 ('admin',1279570089,'start'),
 ('admin',1279616902,'start'),
 ('admin',1279620546,'end'),
 ('admin',1279732658,'start'),
 ('admin',1279753114,'end'),
 ('admin',1279833215,'start'),
 ('admin',1279838841,'end'),
 ('admin',1279901639,'start'),
 ('admin',1279966819,'start'),
 ('admin',1280103710,'start'),
 ('admin',1280158222,'end'),
 ('admin',1280397348,'start'),
 ('admin',1280416066,'end'),
 ('admin',1280487650,'start'),
 ('admin',1281900689,'start'),
 ('admin',1281900693,'end'),
 ('admin',1282287482,'start'),
 ('admin',1282318477,'end'),
 ('admin',1282639093,'start'),
 ('admin',1282660292,'end'),
 ('admin',1282721875,'start'),
 ('admin',1282905559,'start'),
 ('admin',1282942360,'end'),
 ('admin',1283252023,'start'),
 ('admin',1283364128,'start'),
 ('admin',1283372908,'end'),
 ('admin',1283425081,'start'),
 ('admin',1283529670,'start'),
 ('admin',1283602250,'start'),
 ('admin',1283784021,'start'),
 ('admin',1283855730,'start'),
 ('admin',1283898235,'end'),
 ('admin',1283968837,'start'),
 ('admin',1283983751,'end'),
 ('admin',1284029193,'start'),
 ('admin',1284123813,'start'),
 ('admin',1284191751,'start'),
 ('admin',1284381512,'start'),
 ('admin',1284404456,'end'),
 ('admin',1284484122,'start'),
 ('admin',1284484482,'end'),
 ('admin',1284557097,'start'),
 ('admin',1284592682,'end'),
 ('admin',1284634583,'start'),
 ('admin',1284724478,'start'),
 ('admin',1284815204,'start'),
 ('admin',1284815209,'end'),
 ('admin',1285004249,'start'),
 ('admin',1285239976,'start'),
 ('admin',1285343866,'start'),
 ('admin',1285512111,'start'),
 ('admin',1285579804,'start'),
 ('admin',1285603790,'end'),
 ('admin',1285692906,'start'),
 ('admin',1285760089,'start'),
 ('admin',1285856128,'start'),
 ('admin',1285877321,'end'),
 ('admin',1285911368,'start'),
 ('admin',1286030570,'start'),
 ('admin',1286030575,'end'),
 ('admin',1286273707,'start'),
 ('admin',1286273709,'end'),
 ('gab',1283983495,'start'),
 ('gab',1284560528,'start'),
 ('gab',1284560582,'end'),
 ('gab',1284766596,'start'),
 ('gab',1285004816,'start'),
 ('gab',1285083213,'start'),
 ('gab',1285083226,'end'),
 ('gab',1285152442,'start'),
 ('gab',1285344958,'start'),
 ('gab',1285344960,'end'),
 ('gab',1285511429,'start'),
 ('gab',1285511430,'end'),
 ('gab',1285585811,'start'),
 ('gab',1286032585,'start'),
 ('gab',1286032586,'end'),
 ('gab',1286283497,'start'),
 ('gab',1286283499,'end'),
 ('giulio',1285242010,'start');


--
-- Definition of table `todojsc`.`todojsc_work`
--

CREATE TABLE  `todojsc`.`todojsc_work` (
  `uid` varchar(255) NOT NULL,
  `manager` varchar(255) NOT NULL,
  `company` varchar(255) NOT NULL,
  `legal_entity` varchar(255) NOT NULL,
  `contract_type` varchar(255) NOT NULL,
  `contract_duration` varchar(255) NOT NULL,
  `contract_level` varchar(255) NOT NULL,
  `contract_field` varchar(255) NOT NULL,
  `contract_date` int(11) NOT NULL,
  `contract_expiration_date` int(11) NOT NULL,
  `internship_end_date` int(11) NOT NULL,
  `severance_pay` varchar(255) NOT NULL,
  `gross_salary` int(11) NOT NULL,
  `salary_bonus` int(11) NOT NULL,
  `medical_checkup_date` int(11) NOT NULL,
  `work_role` varchar(255) NOT NULL,
  `work_position` varchar(255) NOT NULL,
  `ccnl` varchar(255) NOT NULL,
  `employment_date` int(11) NOT NULL,
  `city_saint_date` int(11) NOT NULL,
  UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `todojsc`.`todojsc_work`
--

INSERT INTO `todojsc`.`todojsc_work` VALUES  ('disabled','admin','fare-spa','','full-time','fixed','director','administration',-3600,1293836400,1304200800,'company',0,0,1306879200,'','','',-3600,-3600),
 ('admin','admin','fare-spa','Phisical person','full-time','unfixed','director','administration',946681200,978303600,949186800,'fund50',100000,10000,961020000,'Analyst','Slave','123456789101112',946681200,976230000),
 ('manager','admin','fai-srl','Persona fisica','horizontal-part-time-morning','unfixed','framework','analysis',1285884000,1286661600,1286402400,'fund100',40000,2300,1230764400,'','','',-3600,1291676400),
 ('stage','admin','fare-spa','','stage','unfixed','level6','secretariat',1230764400,-3600,-3600,'fund50',30000,1250,1262300400,'','','',-3600,-3600);




