

#
# Data for table 'SITE'
#
#---------
DELETE FROM SITE;
INSERT INTO SITE VALUES (1, '24', 7, 'http://www.ist.utl.pt','joao@ist.utl.pt',null,null,'gesdis-web.css');
INSERT INTO SITE VALUES (2, '25', null, null, null, null, null,'gesdis-web.css');
INSERT INTO SITE VALUES (3, '26', null, null, null, null, null,'gesdis-web.css');
INSERT INTO SITE VALUES (4, '27', null, null, null, null, null,'gesdis-web.css');
INSERT INTO SITE VALUES (5, '28', null, null, null, null, null,'gesdis-web.css');
INSERT INTO SITE VALUES (6, '29', null, null, null, null, null,'gesdis-web.css');
INSERT INTO SITE VALUES (7, '30', null, null, null, null, null,'gesdis-web.css');
INSERT INTO SITE VALUES (8, '31', null, null, null, null, null,'gesdis-web.css');
INSERT INTO SITE VALUES (9, '32', null, null, null, null, null,'gesdis-web.css');
INSERT INTO SITE VALUES (10,'33', null, null, null, null, null,'gesdis-web.css');




#
# Data for table 'SECTION'
#
#---------
DELETE FROM SECTION;

INSERT INTO SECTION VALUES (3, 'SubSeccao1dePO',0,4,6,'2003-01-23');
INSERT INTO SECTION VALUES (4, 'SubSeccao2dePO',1,4,6,'2003-01-25');
INSERT INTO SECTION VALUES (5, 'SubSubSeccao1dePO',0,4,3,'2003-01-26');
INSERT INTO SECTION VALUES (6, 'Seccao1dePO',0,4,null,'2003-01-21');
INSERT INTO SECTION VALUES (7, 'Seccao1deTFCI',0,1,null,'2003-01-22');

#
# Data for table 'ITEM'
#
#---------
DELETE FROM ITEM;
INSERT INTO ITEM VALUES (1,'Item1dePO',0,'item1 da seccao1dePO',1,6);
INSERT INTO ITEM VALUES (2,'Item1deTFCI',0,'item1 da seccao1deTFCI',1,7);
INSERT INTO ITEM VALUES (3,'Item2deTFCI',1,'item2 da seccao1deTFCI',0,7);
#
# Data for table 'CURRICULUM'
#
#---------
DELETE FROM CURRICULUM;
INSERT INTO CURRICULUM ( ID_INTERNAL,KEY_CURRICULAR_COURSE,GENERAL_OBJECTIVES,OPERACIONAL_OBJECTIVES,PROGRAM,GENERAL_OBJECTIVES_EN,OPERACIONAL_OBJECTIVES_EN,PROGRAM_EN) VALUES (2, '15', 'bla','bla','bla',null,null,null);
INSERT INTO CURRICULUM ( ID_INTERNAL,KEY_CURRICULAR_COURSE,GENERAL_OBJECTIVES,OPERACIONAL_OBJECTIVES,PROGRAM,GENERAL_OBJECTIVES_EN,OPERACIONAL_OBJECTIVES_EN,PROGRAM_EN) VALUES (1, '14','bla','bla','bla',null,null,null);

#
# Data for table 'TEACHER'
#
#---------
DELETE FROM TEACHER;
INSERT INTO TEACHER VALUES (1, 1,1, null);
INSERT INTO TEACHER VALUES (2, 2,2, null);
INSERT INTO TEACHER VALUES (3, 3,3, null);
INSERT INTO TEACHER VALUES (4, 4,4, null);
INSERT INTO TEACHER VALUES (5, 5,5, null);
INSERT INTO TEACHER VALUES (6, 6,6, null);
INSERT INTO TEACHER VALUES (7, 8,8, null);



#
# Data for table 'PROFESSORSHIPS'
#
#---------
DELETE FROM PROFESSORSHIPS;
INSERT INTO PROFESSORSHIPS VALUES (1,1, 24,0);
INSERT INTO PROFESSORSHIPS VALUES (2,1, 25,0);
INSERT INTO PROFESSORSHIPS VALUES (3,1, 26,0);
INSERT INTO PROFESSORSHIPS VALUES (4,2, 24,0);
#INSERT INTO PROFESSORSHIPS VALUES (5,3, 24,0);

#
# Data for table 'RESPONSIBLEFOR'
#
#---------
DELETE FROM RESPONSIBLEFOR;
INSERT INTO RESPONSIBLEFOR VALUES (1,1, 24);
INSERT INTO RESPONSIBLEFOR VALUES (2,1, 25);
INSERT INTO RESPONSIBLEFOR VALUES (3,1, 26);

#
# Data for table 'ANNOUNCEMENT'
#
#---------
DELETE FROM ANNOUNCEMENT;
INSERT INTO ANNOUNCEMENT VALUES (1, 'announcement1deTFCI', '2003-01-21 13:20:00', '2003-01-21 0:0:00', 'information1', 1);
INSERT INTO ANNOUNCEMENT VALUES (2, 'announcement2deTFCI', '2003-01-22 13:20:00', '2003-01-22 0:0:00', 'information2', 1);
INSERT INTO ANNOUNCEMENT VALUES (3, 'announcement1dePO', '2003-01-23 13:20:01', '2003-01-23 0:00:00', 'information3', 4);
INSERT INTO ANNOUNCEMENT VALUES (4, 'announcement2dePO', '2003-01-21 13:20:02', '2003-01-25 0:00:00', 'information4', 4);
INSERT INTO ANNOUNCEMENT VALUES (5, 'announcement3dePO', '2003-01-21 13:20:03', '2003-01-24 0:00:00', 'information5', 4);

#
# Data for table 'BIBLIOGRAPHIC_REFERENCE'
#
#---------
DELETE FROM BIBLIOGRAPHIC_REFERENCE;
INSERT  INTO  BIBLIOGRAPHIC_REFERENCE VALUES  (1, 'xpto', 'pedro', 'ref', '2002', 0, 24) ;
INSERT  INTO  BIBLIOGRAPHIC_REFERENCE VALUES  (2, 'so', 'am', 'ref2', '2004', 0, 25) ;
INSERT  INTO  BIBLIOGRAPHIC_REFERENCE VALUES  (3, 'as', 'rs', 'ref5', '2040', 0, 24) ;
INSERT  INTO  BIBLIOGRAPHIC_REFERENCE VALUES  (4, 'ep', 'rs', 'ref5', '2040', 1, 24) ;


#
# Data for table 'EVALUATION_METHOD'
#
#---------
DELETE FROM EVALUATION_METHOD;
INSERT INTO EVALUATION_METHOD VALUES (2, '15', 'bla',null);
INSERT INTO EVALUATION_METHOD VALUES (1, '14','bla',null);


#
#Data for the Summary table
#
#--------
DELETE FROM SUMMARY;
INSERT  INTO SUMMARY ( ID_INTERNAL,KEY_EXECUTION_COURSE,TITLE,SUMMARY_DATE,SUMMARY_HOUR,LAST_MODIFICATION_DATE,SUMMARY_TEXT,SUMMARY_TYPE) VALUES (261, 24, 0x61756c6131, '2003-03-12', '12:30:00', '20030722141709', 0x61756c6131, 1) ;
INSERT  INTO SUMMARY ( ID_INTERNAL,KEY_EXECUTION_COURSE,TITLE,SUMMARY_DATE,SUMMARY_HOUR,LAST_MODIFICATION_DATE,SUMMARY_TEXT,SUMMARY_TYPE) VALUES (281, 24, 0x61756c6132, '2003-03-13', '12:00:00', '20030722141715', 0x61756c61, 1) ;

#
# Data for table 'GROUP_PROPERTIES'
#
#---------
DELETE FROM GROUP_PROPERTIES;

INSERT INTO GROUP_PROPERTIES VALUES (2,4,2,4,2,6,"nameB",2,'2002-02-22','2003-10-02',"descricao do projecto nameB",27);
INSERT INTO GROUP_PROPERTIES VALUES (1,8,4,6,2,4,"nameA",3,'2001-01-11','2001-10-10',"descricao do projecto nameA",26);
INSERT INTO GROUP_PROPERTIES VALUES (3,4,3,4,1,2,"projecto A",2,'2003-03-23','2003-11-03',"descricao do projecto A",25);
INSERT INTO GROUP_PROPERTIES VALUES (4,2,1,2,2,20,"nameS",2,'1994-04-14','2003-12-04',"descricao do projecto nameS",27);
INSERT INTO GROUP_PROPERTIES VALUES (5,3,2,3,2,10,"projecto B",2,'2003-03-23','2003-10-04',"descricao do projectoB",25);
INSERT INTO GROUP_PROPERTIES VALUES (6,4,2,4,1,10,"projecto Arquitectura de Computadores",3,'2003-03-23','2003-11-03',"descricao do projecto de AC",30);


#
# Data for table 'STUDENT_GROUP'
#
#---------
DELETE FROM STUDENT_GROUP;

INSERT INTO STUDENT_GROUP VALUES (1,1,21,4);
INSERT INTO STUDENT_GROUP VALUES (2,1,22,2);
INSERT INTO STUDENT_GROUP VALUES (3,2,23,2);
INSERT INTO STUDENT_GROUP VALUES (4,3,22,2);
INSERT INTO STUDENT_GROUP VALUES (5,4,22,2);
INSERT INTO STUDENT_GROUP VALUES (6,1,9,3);
INSERT INTO STUDENT_GROUP VALUES (7,2,9,3);
INSERT INTO STUDENT_GROUP VALUES (8,3,34,3);
INSERT INTO STUDENT_GROUP VALUES (9,4,34,3);
INSERT INTO STUDENT_GROUP VALUES (10,1,30,6);
INSERT INTO STUDENT_GROUP VALUES (11,1,34,5);

#
# Data for table 'STUDENT_GROUP_ATTEND'
#
#---------
DELETE FROM STUDENT_GROUP_ATTEND;
INSERT INTO STUDENT_GROUP_ATTEND VALUES (1,1,6);
INSERT INTO STUDENT_GROUP_ATTEND VALUES (2,2,6);
INSERT INTO STUDENT_GROUP_ATTEND VALUES (3,7,6);
INSERT INTO STUDENT_GROUP_ATTEND VALUES (4,8,8);
INSERT INTO STUDENT_GROUP_ATTEND VALUES (5,1,11);
INSERT INTO STUDENT_GROUP_ATTEND VALUES (6,2,11);
INSERT INTO STUDENT_GROUP_ATTEND VALUES (7,7,11);

