INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (1, 'fdupont@ibm.com', 'M.', 'DUPONT', 'François', 'IBM')
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (2, 'e.duval@edf.fr', 'M.', 'DUVAL', 'Éric', NULL)
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (3, 'aurelia.ente@aol.com', 'Mlle.', 'ENTE', 'Aurélia', 'AOL'); 
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (4, 'marcel.muller@bell.ca', 'M.', 'MÜLLER', 'Marcel', 'Bell Telephone Cie.')
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (6, 'fred.martin@ibm.com', 'M.', 'Martin', NULL, 'IBM')
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (7, 'o.leroy@free.fr', 'M.', 'LEROY', 'Olivier', NULL)
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (9, 'John.Coward@oaci.org', 'M.', 'COWARD', 'John Leslie', 'O_A_C_I')
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (10, 'etienne.prudhomme@airfrance.fr', 'M.', 'PRUD''HOMME', 'Étienne', 'Air France')
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (11, 'catherine.maillant@freesurf.com', 'Mlle.', 'MAILLANT', 'Catherine', 'FreeSurf International')
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (14, 'ocesar@wanadoo.fr', 'Mlle.', 'CÉSARI', NULL, NULL)
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (15, 'francois.clerc12@aol.com', 'M.', 'CLERC', 'François', 'SNCF')
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (16, 'charles.dupont@aol.fr', 'M.', 'DUPONT', 'Charles', 'AOL france')
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (18, 'emilie.leroy@galfa.fr', 'Mme.', 'LEROY', 'Émilie', 'AOL')
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (20, 'antoine.valladon@free.fr', 'M.', 'VALLADON', 'Antoine', 'FREE')
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (21, 'a.bidault@chez.com', 'Mme.', 'BIDAULT', NULL, NULL)
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (22, 'Henry.Hermex@cegetel.com', 'M.', 'HERMEX', NULL, 'CEGETEL USA')
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (25, 'cdupont@wanadoo.com', 'M.', 'DUPONT', 'Charles', 'Wanadoo')
INSERT INTO T_UTILISATEUR_USR (USR_ID, USR_MAIL, USR_TITRE, USR_NOM, USR_PRENOM, USR_ORGANISATION)
       VALUES (27, 'maillant223@free.fr', 'M.', 'MAILLANT', NULL, 'France Free')



INSERT INTO T_FORUM_FRM (FRM_ID, FRM_NOM, FRM_SUJET, FRM_DATE_CREATION) 
       VALUES (1, 'fr.comp.applications.sgbd', 'Bases de données','18/11/1996 15:34:00')
INSERT INTO T_FORUM_FRM (FRM_ID, FRM_NOM, FRM_SUJET, FRM_DATE_CREATION) 
       VALUES (2, 'comp.databases.ibm-db2', 'RDBMS IBM DB2', '19/02/1997 16:22:41')
INSERT INTO T_FORUM_FRM (FRM_ID, FRM_NOM, FRM_SUJET, FRM_DATE_CREATION) 
       VALUES (3, 'comp.databases.informix', 'RDBMS IBM INFORMIX', '21/03/2001 05:02:11')
INSERT INTO T_FORUM_FRM (FRM_ID, FRM_NOM, FRM_SUJET, FRM_DATE_CREATION) 
       VALUES (4, 'comp.databases.ms-access', 'RDBMS Microsoft Access', '11/06/1998 23:17:16')
INSERT INTO T_FORUM_FRM (FRM_ID, FRM_NOM, FRM_SUJET, FRM_DATE_CREATION) 
       VALUES (5, 'comp.databases.ms-sqlserver', 'RDBMS Microsoft SQL Server', '20/07/1997 11:47:59')
INSERT INTO T_FORUM_FRM (FRM_ID, FRM_NOM, FRM_SUJET, FRM_DATE_CREATION) 
       VALUES (6, 'comp.databases.olap', 'OLAP', '12/11/1998 17:16:15')
INSERT INTO T_FORUM_FRM (FRM_ID, FRM_NOM, FRM_SUJET, FRM_DATE_CREATION) 
       VALUES (7, 'comp.databases.oracle', 'RDBMS ORACLE', '01/03/1997 10:10:09')



INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (1, 1, '21/11/2002 17:18:30')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (2, 2, '16/03/2004 11:22:37')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (2, 3, '16/03/2004 11:22:37')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (2, 7, '16/03/2004 11:22:37')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (4, 1, '17/11/2001 22:11:47')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (4, 2, '16/12/2002 07:11:37')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (4, 3, '21/04/2003 08:12:38')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (4, 4, '01/06/2000 17:12:17')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (4, 5, '30/11/2001 19:29:38')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (4, 6, '21/11/2002 02:18:19')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (4, 7, '11/08/2001 06:01:02')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (6, 1, '03/01/2004 17:58:16')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (7, 1, '22/12/2002 14:55:00')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (7, 2, '16/12/2002 13:27:17')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (7, 3, '16/12/2002 13:27:17')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (7, 4, '21/11/2002 14:27:32')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (7, 5, '21/11/2002 14:27:32')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (7, 6, '21/11/2002 14:27:32')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (7, 7, '21/11/2002 14:27:32')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (10, 4, '16/02/1999 16:40:13')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (10, 5, '18/10/2000 09:58:13')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (11, 6, '01/09/2003 13:27:14')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (14, 1, '10/11/2002 17:37:52')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (14, 2, '03/02/2001 04:05:06')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (14, 3, '11/10/2002 17:37:53')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (16, 1, '11/09/2000 11:11:10')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (16, 5, '19/11/2002 21:53:17')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (16, 7, '25/12/2002 16:15:14')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (18, 1, '12/09/2003 22:33:44')
INSERT INTO TJ_INSCRIT_ISC (USR_ID, FRM_ID, ISC_MOMENT)
       VALUES (22, 7, '11/12/2004 13:14:15')



INSERT INTO T_FOURNINET_FAI (FAI_ID, FAI_NOM) VALUES (1, 'Wanadoo')
INSERT INTO T_FOURNINET_FAI (FAI_ID, FAI_NOM) VALUES (2, 'AOL')
INSERT INTO T_FOURNINET_FAI (FAI_ID, FAI_NOM) VALUES (3, 'Club-Internet')
INSERT INTO T_FOURNINET_FAI (FAI_ID, FAI_NOM) VALUES (4, 'Free')
INSERT INTO T_FOURNINET_FAI (FAI_ID, FAI_NOM) VALUES (5, 'Tiscali')
INSERT INTO T_FOURNINET_FAI (FAI_ID, FAI_NOM) VALUES (6, 'Cegetel')



INSERT INTO T_SERVEUR_SRV (SRV_ID, FAI_ID, SRV_ADR_IP, SRV_NOM) 
       VALUES (1, 1, '80.10.246.2', 'DNS primaire Wanadoo')
INSERT INTO T_SERVEUR_SRV (SRV_ID, FAI_ID, SRV_ADR_IP, SRV_NOM) 
       VALUES (2, 1, '80.10.246.129', 'DNS secondaire Wanadoo')
INSERT INTO T_SERVEUR_SRV (SRV_ID, FAI_ID, SRV_ADR_IP, SRV_NOM) 
       VALUES (3, 4, '212.27.42.77', 'Serveur de news free')
INSERT INTO T_SERVEUR_SRV (SRV_ID, FAI_ID, SRV_ADR_IP, SRV_NOM) 
       VALUES (4, 5, '213.36.80.2', 'DNS primaire tiscali (libertysurf.net)')
INSERT INTO T_SERVEUR_SRV (SRV_ID, FAI_ID, SRV_ADR_IP, SRV_NOM) 
       VALUES (5, 6, '193.54.227.1', 'Serveur de news Cegetel')
INSERT INTO T_SERVEUR_SRV (SRV_ID, FAI_ID, SRV_ADR_IP, SRV_NOM) 
       VALUES (6, 4, '213.228.0.82', 'DNS primaire free')
INSERT INTO T_SERVEUR_SRV (SRV_ID, FAI_ID, SRV_ADR_IP, SRV_NOM) 
       VALUES (7, 4, '213.228.0.198', 'DNS secondaire free')
INSERT INTO T_SERVEUR_SRV (SRV_ID, FAI_ID, SRV_ADR_IP, SRV_NOM) 
       VALUES (8, 2, '152.163.159.232', 'DNS primaire AOL')
INSERT INTO T_SERVEUR_SRV (SRV_ID, FAI_ID, SRV_ADR_IP, SRV_NOM) 
       VALUES (9, 2, '205.188.157.232', 'DNS secondaire AOL')
INSERT INTO T_SERVEUR_SRV (SRV_ID, FAI_ID, SRV_ADR_IP, SRV_NOM) 
       VALUES (10, 2, '64.12.51.132', 'DNS quaternaire AOL')
INSERT INTO T_SERVEUR_SRV (SRV_ID, FAI_ID, SRV_ADR_IP, SRV_NOM) 
       VALUES (11, 2, '149.174.211.8', 'DNS tertiaire AOL')
INSERT INTO T_SERVEUR_SRV (SRV_ID, FAI_ID, SRV_ADR_IP, SRV_NOM) 
       VALUES (12, 3, '194.158.102.10', 'DNS primaire club-internet')
INSERT INTO T_SERVEUR_SRV (SRV_ID, FAI_ID, SRV_ADR_IP, SRV_NOM) 
       VALUES (13, 3, '194.158.102.11', 'DNS secondaire club-internet')




INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (1,1)     
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (1,2)     
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (2,3)     
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (4,3)     
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (4,5)     
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (6,1)   
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (6,6)   
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (7,5)   
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (9,4)   
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (10,4)   
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (11,4)   
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (14,6)   
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (15,2)   
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (15,5)   
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (16,3)   
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (18,2)   
INSERT INTO TJ_ABONNE_ABN (USR_ID,FAI_ID) 
	VALUES (22,3)   



INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (1,1) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (1,2) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (1,3) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (1,4)
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (1,5)
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (1,6)  
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (1,7)      
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (2,1)     
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (2,5)     
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (2,6)     
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (2,7)     
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (3,1)     
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (3,2)     
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (3,3)     
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (3,4)     
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (3,5)     
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (4,1)     
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (5,1)         
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (5,2)         
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (5,5)     
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (5,6) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (6,1) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (6,2) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (6,3) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (6,4)
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (6,5)
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (6,6)  
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (6,7)   
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (7,1) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (7,2) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (7,3) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (8,1) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (8,7)     
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (10,4)
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (10,5)
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (10,6)  
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (11,1) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (11,2) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (11,3) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (11,4)
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (11,5)
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (11,6)  
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (11,7) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (12,1) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (12,2) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (13,1) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (13,2) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (13,3) 
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (13,4)
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (13,5)
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (13,6)  
INSERT INTO TJ_RECENSE_RCS (SRV_ID,FRM_ID)    
	VALUES (13,7)      

    


INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (1, NULL, 2, 1, '30/01/2005 20:53:53', '51271217-1346-46DA-866B-512D00E5C129', 'Quid des marqueurs NULL ?', 'Sont-ils indispensable ?')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (2, 1, 2, 1, '31/01/2005 20:59:46', '660731A0-2C26-43F6-BA4E-A219B51920B5', 'mon expérience des marqueurs NULL', 'Indispensable, parce que sémantiquement important')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (3, NULL, 1, 7, '01/02/2005 16:23:21', '90475A12-7357-4AF5-BF37-3C17B332129E', 'L''objet dans le serveur', 'Ca sert à quoi ?')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (4, 3, 4, 7, '02/02/2005 14:56:16', 'D8D3E3A1-C00A-4542-B909-625E2B101A86', 'Rien de bon!', 'C''est anti relationnel')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (5, 4, 6, 7, '02/02/2005 15:09:11', '12AF4602-DB3E-4CF3-B89D-1A5A21215C99', 'Mais si au contraire!', 'C''est fait pour travailler avec des langages objet comme C++ ou Java')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (6, NULL, 15, 1, '02/02/2005 18:17:12', '87084D0A-C202-454B-AB94-088E2E651EF9', 'Jointure ou sous requête ?', 'Quelle est la meilleure technique ?')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (7, 1, 11, 1, '02/02/2005 19:18:17', 'E30933F5-1EFF-4C09-835F-4AF9449B4333', 'Quid des marqueurs NULL ?', 'Moi je met toujours NOT NULL comme ça j''ai pas d''ennuis.')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (8, 1, 7, 1, '30/01/2005 11:16:22', '6B7DB439-ACDF-4B42-9D4C-BCC86D365FF7', 'Quid des marqueurs NULL ?', 'Pourquoi pas des marqueurs pour INFINI ?')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (9, 8, 11, 1, '03/02/2005 17:21:42', 'DEEC380E-5E9E-4260-87F4-3DC748060B76', 'Quid des marqueurs NULL ?', 'Le docteur CODD et Chris DATE y ont déjà pensé et D. McGoveran à proposé mieux.')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (10, NULL, 6, 2, '04/02/2005 11:17:39', 'B6E8D09D-A1BC-440E-A3E3-C50EDA48A0CE', 'Le SQL de DB2', 'Le SQL d''IBM DB2 est-il très normatif ?')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (11, 10, 22, 2, '04/02/2005 21:41:53', '1353E2DB-9510-44D8-A763-10F5CB59445D', 'Le SQL de DB2', 'Assurément, mais il manque quelques éléments')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (12, 10, 14, 2, '04/02/2005 22:00:09', 'ACEF8DFD-1DD7-499F-83BD-BB9C74BDA64E', 'Le SQL de DB2', 'A mon avis c''est le plus proche de la norme')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (13, NULL, 10, 6, '05/02/2005 09:17:08', '66848669-62D0-45FE-8214-2047487EF123', 'GROUPING', 'A quoi sert GROUPIN ? GROUP BY ne suffit-il pas ??')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (15, NULL, 16, 5, '09/02/2005 07:59:58', '33FA97E5-C0D9-4C2D-BFD8-C5976D1DE5BC', 'Procédure stockée', 'A quoi sert le niveau d''isolation READ UNCOMMITED ?')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (16, 15, 18, 5, '09/02/2005 20:19:28', 'EB328538-321E-4DDC-9FFB-FA934E3A2C9E', 'Procédure stockée', 'C''est de la lecture sale !')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (17, 15, 4, 5, '12/02/2005 13:47:52', '5358EC89-776C-4104-AE49-781791EF3044', 'Procédure stockée', 'On peut lire des données non encore validées. C''est dangereux sauf pour une base de données documentaire')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (19, 16, 2, 5, '13/02/2005 17:47:55', '5EFA0332-443F-4E6D-9F14-8F93C098C9BA', 'Procédure stockée', 'Le terme technique est : "lecture impropre".')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (20, NULL, 6, 3, '14/02/2005 15:52:28', '8C6D1DC3-80D8-4C3E-843E-2BE01F357A44', 'Remplacer INFORMIX', 'Quelle est le meilleur SGBD pour remplacer INFORMIX ?')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (21, NULL, 2, 4, '17/02/2005 10:47:52', '1ED2486A-09DC-432F-B81F-D5906B4CD754', 'Doublons', 'A quoi sert DISTINCTROW ?')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (22, 21, 14, 4, '17/02/2005 18:11:44', '5F3FB845-0947-43E5-89B6-006FBB74189D', 'Doublons', 'C''est particulier à Access : dédoublonnement de ligne de table, mais pas du résultat !')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (23, 22, 2, 4, '17/02/2005 19:44:22', '5410F92E-B996-4372-8064-C9E5726B7C6B', 'Doublons', 'D''accord, merci.')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (24, NULL, 7, 4, '19/02/2005 08:59:00', 'A1DB8A83-8903-49CE-9AE6-4AFDE4213567', 'Doublons', 'D''accord, merci.')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (25, NULL, 2, 1, '20/02/2005 16:42:51', '56E09F83-FD53-49BA-89EE-013FB883F454', 'Les transactions', 'Une étude sur le sujet. Voir PJ')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (26, NULL, 6, 2, '20/02/2005 16:54:15', 'BA5FDBB9-D34C-4B15-98F4-56416A60C706', 'DATALINK', 'Est-ce une spécialité IBM DB2 ou est-ce dans SQL ?')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (28, 21, 2, 4, '21/02/2005 11:33:22', '63BADCE4-BA5B-4950-8EEB-D2203C142899', 'Doublons', 'Finalement j''ai rien compris au DISTINCTROW...')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (29, NULL, 2, 5, '21/02/2005 16:21:39', 'D5EEBF6D-6461-4250-871F-04D4222428A5', 'Doublons', 'Le DISTINCTROW d''Access existe sous SQL Server ? C''est équivalent à DISTINCT ?')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (30, NULL, 9, 6, '22/02/2005 09:33:46', '7D1FDA98-F322-49AA-93AE-8633397893ED', 'Datamining', 'Qui pourrait me conseiller un bon livre sur le datamining/datamart ?')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (31, NULL, 4, 7, '23/02/2005 09:58:59', '74578638-5C7B-48DC-8458-ECE9B9B08F5A', 'Livres sur Oracle', 'Quels sont les meilleurs ouvrages sur le PL/SQL d''Oracle ?')
INSERT INTO T_NEWS_NEW (NEW_ID, NEW_ID_PERE, USR_ID, FRM_ID, NEW_MOMENT, NEW_GLOBAL_ID, NEW_TITRE, NEW_TEXT)
       VALUES (32, 31, 6, 7, '23/02/2005 11:28:13', '924B5F1F-894D-4AFB-ABC6-C9B14596EBB7', 'Livres sur Oracle', 'SQL pour Oracle de Soutou et Teste')




INSERT INTO T_FICHIER_FIC (FIC_ID,NEW_ID,FIC_NOM,FIC_TAILLE_O)
	VALUES (1, 2, 'D:\Donnees\News\RepNull\marqnul.htm', 2048)
INSERT INTO T_FICHIER_FIC (FIC_ID,NEW_ID,FIC_NOM,FIC_TAILLE_O)
	VALUES (2, 2, 'D:\Donnees\News\RepNull\marqnul2.htm', 4096)
INSERT INTO T_FICHIER_FIC (FIC_ID,NEW_ID,FIC_NOM,FIC_TAILLE_O)
	VALUES (3, 2, 'D:\Donnees\News\RepNull\marqnul3.htm', 1024)
INSERT INTO T_FICHIER_FIC (FIC_ID,NEW_ID,FIC_NOM,FIC_TAILLE_O)
	VALUES (4, 2, 'C:\Temp\News\marqnulRemarques.txt', 5120)
INSERT INTO T_FICHIER_FIC (FIC_ID,NEW_ID,FIC_NOM,FIC_TAILLE_O)
	VALUES (5, 4, 'http://sqlplro.iut.fr/objet1.htm', 1024)
INSERT INTO T_FICHIER_FIC (FIC_ID,NEW_ID,FIC_NOM,FIC_TAILLE_O)
	VALUES (6, 4, 'http://sqlplro.iut.fr/objet2.htm', 6656)
INSERT INTO T_FICHIER_FIC (FIC_ID,NEW_ID,FIC_NOM,FIC_TAILLE_O)
	VALUES (7, 10, 'http://www.ibm.fr/SQL.html', 1024)
INSERT INTO T_FICHIER_FIC (FIC_ID,NEW_ID,FIC_NOM,FIC_TAILLE_O)
	VALUES (8, 17, 'http://www.microsoft.fr/SQL/isolation_level.html', 2048)
INSERT INTO T_FICHIER_FIC (FIC_ID,NEW_ID,FIC_NOM,FIC_TAILLE_O)
	VALUES (9, 25, 'http://sql.developpez.com/sqlaz/techniques/#L1', 1024)

insert into T_CONNEXION values (1,1, '01/01/2006', 1)

insert into T_CONNEXION values (1,2, '01/01/2006', 1)

insert into T_CONNEXION values (1,1, '02/01/2006', 1)
insert into T_CONNEXION values (2,1, '01/01/2006', 2)
insert into T_CONNEXION values (2,4, '01/03/2006', 10)
insert into T_CONNEXION values (3,1, '04/01/2006', 7)