fichecollege/CD67.FicheCollege.Entity/Model_initial_inserts.sql

USE [FicheCollege]

DELETE FROM [Actions-CLAS];
DELETE FROM Identites;
DELETE FROM Colleges;

DELETE FROM Annees;
DELETE FROM Territoires;
DELETE FROM TypesCollege;

IF EXISTS (SELECT * FROM sys.identity_columns WHERE OBJECT_NAME(OBJECT_ID) = 'Actions-CLAS' AND last_value IS NOT NULL) 
	DBCC CHECKIDENT([Actions-CLAS], RESEED,-1)
ELSE
	DBCC CHECKIDENT([Actions-CLAS], RESEED,0)

IF EXISTS (SELECT * FROM sys.identity_columns WHERE OBJECT_NAME(OBJECT_ID) = 'Identites' AND last_value IS NOT NULL) 
	DBCC CHECKIDENT(Identites, RESEED,-1)
ELSE
	DBCC CHECKIDENT(Identites, RESEED,0)

IF EXISTS (SELECT * FROM sys.identity_columns WHERE OBJECT_NAME(OBJECT_ID) = 'Colleges' AND last_value IS NOT NULL) 
	DBCC CHECKIDENT(Colleges, RESEED,-1)
ELSE
	DBCC CHECKIDENT(Colleges, RESEED,0)

IF EXISTS (SELECT * FROM sys.identity_columns WHERE OBJECT_NAME(OBJECT_ID) = 'Annees' AND last_value IS NOT NULL) 
	DBCC CHECKIDENT(Annees, RESEED,-1)
ELSE
	DBCC CHECKIDENT(Annees, RESEED,0)

IF EXISTS (SELECT * FROM sys.identity_columns WHERE OBJECT_NAME(OBJECT_ID) = 'Territoires' AND last_value IS NOT NULL) 
	DBCC CHECKIDENT(Territoires, RESEED,-1)
ELSE
	DBCC CHECKIDENT(Territoires, RESEED,0)

IF EXISTS (SELECT * FROM sys.identity_columns WHERE OBJECT_NAME(OBJECT_ID) = 'TypesCollege' AND last_value IS NOT NULL) 
	DBCC CHECKIDENT(TypesCollege, RESEED,-1)
ELSE
	DBCC CHECKIDENT(TypesCollege, RESEED,0)


INSERT INTO TypesCollege(Libelle,Ordre)
VALUES  ('Collège Publique',1), 
		('Collège Privé',2),
		('Cité Scolaire',3);

INSERT INTO Territoires(Libelle,Ordre)
VALUES	('Territoire Eurométropole',1),
		('Territoire Ouest',2), 
		('Territoire Sud',3), 
		('Territoire Nord',4);

INSERT INTO Annees(Libelle) 
VALUES ('2000-2001'),
		('2001-2002'),
		('2002-2003'),
		('2003-2004'),
		('2004-2005'),
		('2005-2006'),
		('2006-2007'),
		('2007-2008'),
		('2008-2009'),
		('2009-2010'),
		('2010-2011'),
		('2011-2012'),
		('2012-2013'),
		('2013-2014'),
		('2014-2015'),
		('2015-2016'),
		('2016-2017'),
		('2017-2018'),
		('2018-2019'),
		('2019-2020'),
		('2020-2021'),
		('2021-2022'),
		('2022-2023'),
		('2023-2024'),
		('2024-2025'),
		('2025-2026'),
		('2026-2027'),
		('2027-2028'),
		('2028-2029'),
		('2029-2030'),
		('2030-2031'),
		('2031-2032'),
		('2032-2033'),
		('2033-2034'),
		('2034-2035'),
		('2035-2036'),
		('2036-2037'),
		('2037-2038'),
		('2038-2039'),
		('2039-2040'),
		('2040-2041'),
		('2041-2042'),
		('2042-2043'),
		('2043-2044'),
		('2044-2045'),
		('2045-2046'),
		('2046-2047'),
		('2047-2048'),
		('2048-2049'),
		('2049-2050'),
		('2050-2051'),
		('2051-2052'),
		('2052-2053'),
		('2053-2054'),
		('2054-2055'),
		('2055-2056'),
		('2056-2057'),
		('2057-2058'),
		('2058-2059'),
		('2059-2060'),
		('2060-2061'),
		('2061-2062'),
		('2062-2063'),
		('2063-2064'),
		('2064-2065'),
		('2065-2066'),
		('2066-2067'),
		('2067-2068'),
		('2068-2069'),
		('2069-2070'),
		('2070-2071'),
		('2071-2072'),
		('2072-2073'),
		('2073-2074'),
		('2074-2075'),
		('2075-2076'),
		('2076-2077'),
		('2077-2078'),
		('2078-2079'),
		('2079-2080'),
		('2080-2081'),
		('2081-2082'),
		('2082-2083'),
		('2083-2084'),
		('2084-2085'),
		('2085-2086'),
		('2086-2087'),
		('2087-2088'),
		('2088-2089'),
		('2089-2090'),
		('2090-2091'),
		('2091-2092'),
		('2092-2093'),
		('2093-2094'),
		('2094-2095'),
		('2095-2096'),
		('2096-2097'),
		('2097-2098'),
		('2098-2099');