0:00, Starson 45, Neighbour, Radio edit, Homebreakin Canada, 3:44, Spring Affair (Go Go Bizkitt! Remix), Donna Summer, Radio edit, N/A, 9:15, Freak, Ivan Pica, Radio edit, Pornostar Records, 14:27, Let's All Chant (Manuel De La Mare & Marshall Remix), Frederico Scavo, Radio edit, HotFingers, 18:55, Air Breaks, Koen Groeneveld, Radio edit, Toolroom Records, 23:08, Kung Fu Funk, Dr. Kucho!, Radio edit, Netswork, 27:22, Disco Mustaccio, Magik Johnson, Radio edit, Southern Fried, 31:57, Disco Dancin', DJ Agent 86, Radio edit, Lightspeed Recordings, 35:26, Dirtee Disco, Dizzee Rascal, Radio edit, Dirtee Stank, 38:55, Spaced Invader 2010 (Hatiras 2010 ...
0:00, Starson 45, Neighbour, Radio edit, Homebreakin Canada, 3:44, Spring Affair (Go Go Bizkitt! Remix), Donna Summer, Radio edit, N/A, 9:15, Freak, Ivan Pica, Radio edit, Pornostar Records, 14:27, Let's All Chant (Manuel De La Mare & Marshall Remix), Frederico Scavo, Radio edit, HotFingers, 18:55, Air Breaks, Koen Groeneveld, Radio edit, Toolroom Records, 23:08, Kung Fu Funk, Dr. Kucho!, Radio edit, Netswork, 27:22, Disco Mustaccio, Magik Johnson, Radio edit, Southern Fried, 31:57, Disco Dancin', DJ Agent 86, Radio edit, Lightspeed Recordings, 35:26, Dirtee Disco, Dizzee Rascal, Radio edit, Dirtee Stank, 38:55, Spaced Invader 2010 (Hatiras 2010 Vocal Remix), Hatiras, Radio edit, Hatrax Records, 44:37, ADD SUV (Arman van Helden Vocal Remix), Uffie feat. Pharrell Williams, Radio edit, Ed Banger Records - Because Music, 47:55, A Fifth Of Beethoven (Soulwax Edit), Walter Murphy, Radio edit, International DeeJay Gigolo Records, 50:24, Music Is My Life, Joey Chicago, Radio edit, Banging Grooves Records, 55:22, I Think I Like It (Original Mix), Fake Blood, Radio edit, Cheap Thrills, 57:21, I Think I Like It (Tommie Sunshine & Figure present EC$TACY EDIT), Fake Blood, Radio edit, N/A, 61:08, Reflections, Markfunk, Radio edit, Disco Zoo Records, , 65:37, Ruckus, Jamie Jones, Radio edit, Hot Creations, 71:50, Funky Day (Special Long), DJ RobDee, Radio edit, Knatter,
A mix with some of my favourite Disco House tracks of 2010. Enjoy.
-- Script généré par WinDev le 03/11/2010 10:51:10 -- Tables de l'analyse GEECI.wda -- pour SQL Server
-- Suppression de la table Utilisat DROP TABLE [Utilisat] ; -- Création de la table Utilisat CREATE TABLE [Utilisat] ( [UT_Nom] VARCHAR(30) NOT NULL , [UT_PREN] VARCHAR(20) NOT NULL , [UT_...
-- Script généré par WinDev le 03/11/2010 10:51:10 -- Tables de l'analyse GEECI.wda -- pour SQL Server
-- Suppression de la table Utilisat DROP TABLE [Utilisat] ; -- Création de la table Utilisat CREATE TABLE [Utilisat] ( [UT_Nom] VARCHAR(30) NOT NULL , [UT_PREN] VARCHAR(20) NOT NULL , [UT_TYPE] INTEGER NOT NULL , [UT_TAILLE_MIN] TINYINT NOT NULL , [UT_DELAI] SMALLINT NOT NULL , [UT_CPT_CONNEXION] TINYINT NOT NULL , [UT_DER_CONNEXION] DATETIME NOT NULL , [UT_DER_CONNEXION_HEURE] DATETIME NOT NULL , [UT_DERNIER_MOT_PASSE] VARCHAR(10) NOT NULL , [UT_PASS_1] VARCHAR(10) NOT NULL , [UT_PASS_2] VARCHAR(10) NOT NULL , [UT_PASS_3] VARCHAR(10) NOT NULL , [UT_CREER] TINYINT NOT NULL , [UT_TAB] TINYINT NOT NULL , [UT_CONSULTER] TINYINT NOT NULL , [UT_IMPRIMER] TINYINT NOT NULL , [UT_ACTE] TINYINT NOT NULL , [UT_DEBLOCAGE] TINYINT NOT NULL , [UT_MODIFIER] TINYINT NOT NULL , [UT_COMMENTAIRES] TEXT NOT NULL , [GroupName] VARCHAR(100) NOT NULL , [Name] VARCHAR(15) NOT NULL UNIQUE , [PASSWORD] VARCHAR(20) NOT NULL ); CREATE INDEX [WDIDX_Utilisat_UT_Nom] ON [Utilisat] ([UT_Nom]); CREATE INDEX [WDIDX_Utilisat_GroupName] ON [Utilisat] ([GroupName]);
-- Suppression de la table USER DROP TABLE [USER] ; -- Création de la table USER CREATE TABLE [USER] ( [Name] VARCHAR(15) NOT NULL UNIQUE , [GroupName] VARCHAR(100) NOT NULL , [PASSWORD] VARCHAR(20) NOT NULL , [UT_ACTE] TINYINT NOT NULL , [UT_COMMENTAIRES] TEXT NOT NULL , [UT_CONSULTER] TINYINT NOT NULL , [UT_CPT_CONNEXION] TINYINT NOT NULL , [UT_CREER] TINYINT NOT NULL , [UT_DEBLOCAGE] TINYINT NOT NULL , [UT_DELAI] SMALLINT NOT NULL , [UT_DERNIER_MOT_PASSE] VARCHAR(10) NOT NULL , [UT_DER_CONNEXION] DATETIME NOT NULL , [UT_DER_CONNEXION_HEURE] DATETIME NOT NULL , [UT_IMPRIMER] TINYINT NOT NULL , [UT_MODIFIER] TINYINT NOT NULL , [UT_Nom] VARCHAR(30) NOT NULL , [UT_PASS_1] VARCHAR(10) NOT NULL , [UT_PASS_2] VARCHAR(10) NOT NULL , [UT_PASS_3] VARCHAR(10) NOT NULL , [UT_PREN] VARCHAR(20) NOT NULL , [UT_TAB] TINYINT NOT NULL , [UT_TAILLE_MIN] TINYINT NOT NULL , [UT_TYPE] INTEGER NOT NULL , [US_IMAGE] VARCHAR(255) NOT NULL , [US_IMAGE_ACTIF] VARCHAR(255) NOT NULL , [US_IMAGE_INACTIF] VARCHAR(255) NOT NULL ); CREATE INDEX [WDIDX_USER_GroupName] ON [USER] ([GroupName]);
-- Suppression de la table Reconais DROP TABLE [Reconais] ; -- Création de la table Reconais CREATE TABLE [Reconais] ( [RE_VOL] VARCHAR(4) NOT NULL , [RE_NO] VARCHAR(4) NOT NULL , [RE_PAGE] VARCHAR(4) NOT NULL , [RE_ANNULE] TINYINT NOT NULL , [RE_DATE_REC] DATETIME NOT NULL , [RE_LIEU] VARCHAR(100) NOT NULL , [RE_AUT_TUTEL] VARCHAR(40) NOT NULL , [RE_TYPE_REC] INTEGER NOT NULL , [RE_JUDICIAIRE] TINYINT NOT NULL , [RE_COMMUNIQUES] TEXT NOT NULL , [RE_ART_106] TEXT NOT NULL , [RE_ART_125] TEXT NOT NULL , [RE_FEUILLET] VARCHAR(20) NOT NULL , [RE_VOL_ANI] INTEGER NOT NULL , [RE_NO_NAIS] INTEGER NOT NULL , [RE_PAGE_NAI] INTEGER NOT NULL , [RE_COMMEnTAIRES] TEXT NOT NULL , [CREE_LE] DATETIME NOT NULL , [CREE_A] DATETIME NOT NULL , [CREE_PAR] VARCHAR(8) NOT NULL , [MODIFIE_LE] DATETIME NOT NULL , [MODIFIE_PAR] VARCHAR(8) NOT NULL , [MODIFIE_A] DATETIME NOT NULL , [RE_SEXE] INTEGER NOT NULL , [RE_NOM] VARCHAR(100) NOT NULL , [RE_PRENOMS] TEXT NOT NULL , [RE_NOM_AV] TEXT NOT NULL , [RE_NE_A] VARCHAR(50) NOT NULL , [RE_NE_LE] DATETIME NOT NULL , [RE_NE_EN] INTEGER NOT NULL , [RE_NOM_PERE] VARCHAR(100) NOT NULL , [RE_PREN_PERE] TEXT NOT NULL , [RE_EC_PERE] INTEGER NOT NULL , [RE_PAYS_PERE] VARCHAR(3) NOT NULL , [RE_ORIGINE_PERE] TEXT NOT NULL , [RE_NE_A_PERE] VARCHAR(100) NOT NULL , [RE_NE_LE_PERE] DATETIME NOT NULL , [RE_NE_EN_PERE] INTEGER NOT NULL , [RE_ADOPTE_PERE] TINYINT NOT NULL , [RE_FIL_SANG_PERE] TEXT NOT NULL , [RE_PERE_PERE] TEXT NOT NULL , [RE_MERE_PERE] TEXT NOT NULL , [RE_COM_DOM_PERE] VARCHAR(50) NOT NULL , [RE_CANT_DOM_PERE] INTEGER NOT NULL , [RE_PAYS_DOM_PERE] VARCHAR(3) NOT NULL , [RE_NPA_PERE] VARCHAR(10) NOT NULL , [RE_COM_DOM_ACT_PERE] VARCHAR(50) NOT NULL , [RE_RUE_DOM_ACT_PERE] VARCHAR(35) NOT NULL , [RE_COM_DOM_SEJ_PERE] VARCHAR(50) NOT NULL , [RE_RUE_DOM_SEJ_PERE] VARCHAR(35) NOT NULL , [RE_RELIGION_PERE] INTEGER NOT NULL , [RE_NOM_MERE] VARCHAR(100) NOT NULL , [RE_PREN_MERE] TEXT NOT NULL , [RE_EC_MERE] INTEGER NOT NULL , [RE_PAYS_MERE] VARCHAR(3) NOT NULL , [RE_ORIGN_MERE] TEXT NOT NULL , [RE_NE_A_MERE] VARCHAR(100) NOT NULL , [RE_NE_LE_MERE] DATETIME NOT NULL , [RE_NE_EN_MERE] INTEGER NOT NULL , [RE_ADOPTE_MERE] TINYINT NOT NULL , [RE_FIL_SANG_MERE] TEXT NOT NULL , [RE_PERE_MERE] TEXT NOT NULL , [RE_MERE_MERE] TEXT NOT NULL , [RE_COM_DOM_MERE] VARCHAR(50) NOT NULL , [RE_CANT_DOM_MERE] INTEGER NOT NULL , [RE_PAYS_DOM_MERE] VARCHAR(3) NOT NULL , [RE_NPA_DOM_MERE] VARCHAR(10) NOT NULL , [RE_COM_DOM_ACT_MERE] VARCHAR(50) NOT NULL , [RE_RUE_COM_ACT_MERE] VARCHAR(35) NOT NULL , [RE_DOM_SEJ_MERE] VARCHAR(50) NOT NULL , [RE_RUE_DOM_SEJ_MERE] VARCHAR(35) NOT NULL , [RE_RELIGION_MERE] INTEGER NOT NULL , [EXPEDIE_OFS] TINYINT NOT NULL , [REGISTRE_IMPRIME] TINYINT NOT NULL , [RE_RECH_ENFANT] VARCHAR(100) NOT NULL , [RE_RECH_PERE] VARCHAR(100) NOT NULL , [RE_RECH_MERE] VARCHAR(100) NOT NULL , [RE_ATT_I_PERE] VARCHAR(60) NOT NULL , [RE_ATT_I_MERE] VARCHAR(60) NOT NULL , [RE_CODE_OFS] INTEGER NOT NULL , [RE_EPOUSE_AUTEUR] TINYINT NOT NULL , [RE_CP_NOM] TEXT NOT NULL , [RE_CP_PYAS] VARCHAR(3) NOT NULL , [RE_CP_ORIGINE] TEXT NOT NULL , [RE_CP_COM_DOM] VARCHAR(50) NOT NULL , [RE_CP_CANT] INTEGER NOT NULL , [RE_CP_PAYS_DOM] VARCHAR(3) NOT NULL , [RE_CP_DOM_ACT] VARCHAR(50) NOT NULL , [RE_CP_RUE] VARCHAR(35) NOT NULL , [RE_FLAG1] TINYINT NOT NULL , [RE_FLAG2] TINYINT NOT NULL , [RE_COMBO1] INTEGER NOT NULL , [RE_COMBO2] INTEGER NOT NULL , [RE_TEXTE1] VARCHAR(100) NOT NULL , [RE_TEXTE2] VARCHAR(100) NOT NULL , [RE_DATE1] DATETIME NOT NULL , [RE_DATE2] DATETIME NOT NULL , [RE_MEMO] TEXT NOT NULL ); CREATE INDEX [WDIDX_Reconais_RE_VOL] ON [Reconais] ([RE_VOL]); CREATE INDEX [WDIDX_Reconais_RE_NO] ON [Reconais] ([RE_NO]); CREATE INDEX [WDIDX_Reconais_RE_DATE_REC] ON [Reconais] ([RE_DATE_REC]); CREATE INDEX [WDIDX_Reconais_RE_NOM] ON [Reconais] ([RE_NOM]); CREATE INDEX [WDIDX_Reconais_RE_NOM_PERE] ON [Reconais] ([RE_NOM_PERE]); CREATE INDEX [WDIDX_Reconais_RE_NOM_MERE] ON [Reconais] ([RE_NOM_MERE]); CREATE INDEX [WDIDX_Reconais_EXPEDIE_OFS] ON [Reconais] ([EXPEDIE_OFS]); CREATE INDEX [WDIDX_Reconais_RE_RECH_ENFANT] ON [Reconais] ([RE_RECH_ENFANT]); CREATE INDEX [WDIDX_Reconais_RE_RECH_PERE] ON [Reconais] ([RE_RECH_PERE]); CREATE INDEX [WDIDX_Reconais_RE_RECH_MERE] ON [Reconais] ([RE_RECH_MERE]); CREATE INDEX [WDIDX_Reconais_RE_CODE_OFS] ON [Reconais] ([RE_CODE_OFS]); CREATE INDEX [WDIDX_Reconais_RE_CP_PYAS] ON [Reconais] ([RE_CP_PYAS]); CREATE INDEX [WDIDX_Reconais_RE_CP_CANT] ON [Reconais] ([RE_CP_CANT]); CREATE INDEX [WDIDX_Reconais_RE_CP_PAYS_DOM] ON [Reconais] ([RE_CP_PAYS_DOM]); CREATE INDEX [WDIDX_Reconais_RE_FLAG1] ON [Reconais] ([RE_FLAG1]); CREATE INDEX [WDIDX_Reconais_RE_FLAG2] ON [Reconais] ([RE_FLAG2]); CREATE INDEX [WDIDX_Reconais_RE_COMBO1] ON [Reconais] ([RE_COMBO1]); CREATE INDEX [WDIDX_Reconais_RE_COMBO2] ON [Reconais] ([RE_COMBO2]); CREATE INDEX [WDIDX_Reconais_RE_DATE1] ON [Reconais] ([RE_DATE1]); CREATE INDEX [WDIDX_Reconais_RE_DATE2] ON [Reconais] ([RE_DATE2]);
-- Suppression de la table Recona_1 DROP TABLE [Recona_1] ; -- Création de la table Recona_1 CREATE TABLE [Recona_1] ( [RE_VOL] VARCHAR(4) NOT NULL , [RE_NO] VARCHAR(4) NOT NULL , [RE_PAGE] VARCHAR(4) NOT NULL , [RE_ANNULE] TINYINT NOT NULL , [RE_DATE_REC] DATETIME NOT NULL , [RE_LIEU] VARCHAR(100) NOT NULL , [RE_AUT_TUTEL] VARCHAR(40) NOT NULL , [RE_TYPE_REC] INTEGER NOT NULL , [RE_JUDICIAIRE] TINYINT NOT NULL , [RE_COMMUNIQUES] TEXT NOT NULL , [RE_ART_106] TEXT NOT NULL , [RE_ART_125] TEXT NOT NULL , [RE_FEUILLET] VARCHAR(20) NOT NULL , [RE_VOL_ANI] INTEGER NOT NULL , [RE_NO_NAIS] INTEGER NOT NULL , [RE_PAGE_NAI] INTEGER NOT NULL , [RE_COMMEnTAIRES] TEXT NOT NULL , [CREE_LE] DATETIME NOT NULL , [CREE_A] DATETIME NOT NULL , [CREE_PAR] VARCHAR(8) NOT NULL , [MODIFIE_LE] DATETIME NOT NULL , [MODIFIE_PAR] VARCHAR(8) NOT NULL , [MODIFIE_A] DATETIME NOT NULL , [RE_SEXE] INTEGER NOT NULL , [RE_NOM] VARCHAR(100) NOT NULL , [RE_PRENOMS] TEXT NOT NULL , [RE_NOM_AV] TEXT NOT NULL , [RE_NE_A] VARCHAR(50) NOT NULL , [RE_NE_LE] DATETIME NOT NULL , [RE_NE_EN] INTEGER NOT NULL , [RE_NOM_PERE] VARCHAR(100) NOT NULL , [RE_PREN_PERE] TEXT NOT NULL , [RE_EC_PERE] INTEGER NOT NULL , [RE_PAYS_PERE] VARCHAR(3) NOT NULL , [RE_ORIGINE_PERE] TEXT NOT NULL , [RE_NE_A_PERE] VARCHAR(100) NOT NULL , [RE_NE_LE_PERE] DATETIME NOT NULL , [RE_NE_EN_PERE] INTEGER NOT NULL , [RE_ADOPTE_PERE] TINYINT NOT NULL , [RE_FIL_SANG_PERE] TEXT NOT NULL , [RE_PERE_PERE] TEXT NOT NULL , [RE_MERE_PERE] TEXT NOT NULL , [RE_COM_DOM_PERE] VARCHAR(50) NOT NULL , [RE_CANT_DOM_PERE] INTEGER NOT NULL , [RE_PAYS_DOM_PERE] VARCHAR(3) NOT NULL , [RE_NPA_PERE] VARCHAR(10) NOT NULL , [RE_COM_DOM_ACT_PERE] VARCHAR(50) NOT NULL , [RE_RUE_DOM_ACT_PERE] VARCHAR(35) NOT NULL , [RE_COM_DOM_SEJ_PERE] VARCHAR(50) NOT NULL , [RE_RUE_DOM_SEJ_PERE] VARCHAR(35) NOT NULL , [RE_RELIGION_PERE] INTEGER NOT NULL , [RE_NOM_MERE] VARCHAR(100) NOT NULL , [RE_PREN_MERE] TEXT NOT NULL , [RE_EC_MERE] INTEGER NOT NULL , [RE_PAYS_MERE] VARCHAR(3) NOT NULL , [RE_ORIGN_MERE] TEXT NOT NULL , [RE_NE_A_MERE] VARCHAR(100) NOT NULL , [RE_NE_LE_MERE] DATETIME NOT NULL , [RE_NE_EN_MERE] INTEGER NOT NULL , [RE_ADOPTE_MERE] TINYINT NOT NULL , [RE_FIL_SANG_MERE] TEXT NOT NULL , [RE_PERE_MERE] TEXT NOT NULL , [RE_MERE_MERE] TEXT NOT NULL , [RE_COM_DOM_MERE] VARCHAR(50) NOT NULL , [RE_CANT_DOM_MERE] INTEGER NOT NULL , [RE_PAYS_DOM_MERE] VARCHAR(3) NOT NULL , [RE_NPA_DOM_MERE] VARCHAR(10) NOT NULL , [RE_COM_DOM_ACT_MERE] VARCHAR(50) NOT NULL , [RE_RUE_COM_ACT_MERE] VARCHAR(35) NOT NULL , [RE_DOM_SEJ_MERE] VARCHAR(50) NOT NULL , [RE_RUE_DOM_SEJ_MERE] VARCHAR(35) NOT NULL , [RE_RELIGION_MERE] INTEGER NOT NULL , [EXPEDIE_OFS] TINYINT NOT NULL , [REGISTRE_IMPRIME] TINYINT NOT NULL , [RE_RECH_ENFANT] VARCHAR(100) NOT NULL , [RE_RECH_PERE] VARCHAR(100) NOT NULL , [RE_RECH_MERE] VARCHAR(100) NOT NULL , [RE_ATT_I_PERE] VARCHAR(60) NOT NULL , [RE_ATT_I_MERE] VARCHAR(60) NOT NULL , [RE_CODE_OFS] INTEGER NOT NULL , [RE_EPOUSE_AUTEUR] TINYINT NOT NULL , [RE_CP_NOM] TEXT NOT NULL , [RE_CP_PYAS] VARCHAR(3) NOT NULL , [RE_CP_ORIGINE] TEXT NOT NULL , [RE_CP_COM_DOM] VARCHAR(50) NOT NULL , [RE_CP_CANT] INTEGER NOT NULL , [RE_CP_PAYS_DOM] VARCHAR(3) NOT NULL , [RE_CP_DOM_ACT] VARCHAR(50) NOT NULL , [RE_CP_RUE] VARCHAR(35) NOT NULL , [RE_FLAG1] TINYINT NOT NULL , [RE_FLAG2] TINYINT NOT NULL , [RE_COMBO1] INTEGER NOT NULL , [RE_COMBO2] INTEGER NOT NULL , [RE_TEXTE1] VARCHAR(100) NOT NULL , [RE_TEXTE2] VARCHAR(100) NOT NULL , [RE_DATE1] DATETIME NOT NULL , [RE_DATE2] DATETIME NOT NULL , [RE_MEMO] TEXT NOT NULL ); CREATE INDEX [WDIDX_Recona_1_RE_VOL] ON [Recona_1] ([RE_VOL]); CREATE INDEX [WDIDX_Recona_1_RE_NO] ON [Recona_1] ([RE_NO]); CREATE INDEX [WDIDX_Recona_1_RE_DATE_REC] ON [Recona_1] ([RE_DATE_REC]); CREATE INDEX [WDIDX_Recona_1_RE_NOM] ON [Recona_1] ([RE_NOM]); CREATE INDEX [WDIDX_Recona_1_RE_NOM_PERE] ON [Recona_1] ([RE_NOM_PERE]); CREATE INDEX [WDIDX_Recona_1_RE_NOM_MERE] ON [Recona_1] ([RE_NOM_MERE]); CREATE INDEX [WDIDX_Recona_1_EXPEDIE_OFS] ON [Recona_1] ([EXPEDIE_OFS]); CREATE INDEX [WDIDX_Recona_1_RE_RECH_ENFANT] ON [Recona_1] ([RE_RECH_ENFANT]); CREATE INDEX [WDIDX_Recona_1_RE_RECH_PERE] ON [Recona_1] ([RE_RECH_PERE]); CREATE INDEX [WDIDX_Recona_1_RE_RECH_MERE] ON [Recona_1] ([RE_RECH_MERE]); CREATE INDEX [WDIDX_Recona_1_RE_CODE_OFS] ON [Recona_1] ([RE_CODE_OFS]); CREATE INDEX [WDIDX_Recona_1_RE_CP_PYAS] ON [Recona_1] ([RE_CP_PYAS]); CREATE INDEX [WDIDX_Recona_1_RE_CP_CANT] ON [Recona_1] ([RE_CP_CANT]); CREATE INDEX [WDIDX_Recona_1_RE_CP_PAYS_DOM] ON [Recona_1] ([RE_CP_PAYS_DOM]); CREATE INDEX [WDIDX_Recona_1_RE_FLAG1] ON [Recona_1] ([RE_FLAG1]); CREATE INDEX [WDIDX_Recona_1_RE_FLAG2] ON [Recona_1] ([RE_FLAG2]); CREATE INDEX [WDIDX_Recona_1_RE_COMBO1] ON [Recona_1] ([RE_COMBO1]); CREATE INDEX [WDIDX_Recona_1_RE_COMBO2] ON [Recona_1] ([RE_COMBO2]); CREATE INDEX [WDIDX_Recona_1_RE_DATE1] ON [Recona_1] ([RE_DATE1]); CREATE INDEX [WDIDX_Recona_1_RE_DATE2] ON [Recona_1] ([RE_DATE2]);
-- Suppression de la table RA_REC DROP TABLE [RA_REC] ; -- Création de la table RA_REC CREATE TABLE [RA_REC] ( [VOLUME] VARCHAR(4) NOT NULL , [NOM] VARCHAR(100) NOT NULL , [PRENOMS] VARCHAR(255) NOT NULL , [SEXE] VARCHAR(1) NOT NULL , [NEE_LE] DATETIME NOT NULL , [RECONNU_LE] DATETIME NOT NULL , [No] VARCHAR(4) NOT NULL ); CREATE INDEX [WDIDX_RA_REC_VOLUME] ON [RA_REC] ([VOLUME]); CREATE INDEX [WDIDX_RA_REC_NEE_LE] ON [RA_REC] ([NEE_LE]); CREATE INDEX [WDIDX_RA_REC_No] ON [RA_REC] ([No]); CREATE INDEX [WDIDX_RA_REC_VOLUME_NO] ON [RA_REC] ([VOLUME],[No]);
-- Suppression de la table RA_MAR DROP TABLE [RA_MAR] ; -- Création de la table RA_MAR CREATE TABLE [RA_MAR] ( [VOLUME] VARCHAR(4) NOT NULL , [NOM] VARCHAR(100) NOT NULL , [PRENOMS] VARCHAR(255) NOT NULL , [SEXE] VARCHAR(1) NOT NULL , [NE_LE] DATETIME NOT NULL , [MARIE_LE] DATETIME NOT NULL , [No] VARCHAR(4) NOT NULL , [ANNEE_NE] VARCHAR(4) NOT NULL ); CREATE INDEX [WDIDX_RA_MAR_VOLUME] ON [RA_MAR] ([VOLUME]); CREATE INDEX [WDIDX_RA_MAR_MARIE_LE] ON [RA_MAR] ([MARIE_LE]); CREATE INDEX [WDIDX_RA_MAR_VOLUME_NO] ON [RA_MAR] ([VOLUME],[No]);
-- Suppression de la table PGEN DROP TABLE [PGEN] ; -- Création de la table PGEN CREATE TABLE [PGEN] ( [PGCLEUNIK] INTEGER IDENTITY PRIMARY KEY , [PG_COMMUNE] VARCHAR(30) NOT NULL , [PG_COMPL_COMMUNE] VARCHAR(30) NOT NULL , [PG_ADRESSE] VARCHAR(30) NOT NULL , [PG_ADRESSE2] VARCHAR(30) NOT NULL , [PG_NP] INTEGER NOT NULL , [PG_CANTON] INTEGER NOT NULL , [PG_PAYS] VARCHAR(3) NOT NULL , [PG_CODE_OFS] VARCHAR(4) NOT NULL , [PG_CODE_OFS_2] VARCHAR(30) NOT NULL , [PG_OFFICE_ETAT_CIVIL] VARCHAR(40) NOT NULL , [PG_DISTRICT] VARCHAR(40) NOT NULL , [PG_AUT_TUT_DEF] VARCHAR(40) NOT NULL , [PG_HOP_DEF] VARCHAR(60) NOT NULL , [PG_FIN_LIGNE] VARCHAR(10) NOT NULL , [PG_GEST_PAGE_MA] TINYINT NOT NULL , [PG_GEST_PAGE_DECES] TINYINT NOT NULL , [PG_GEST_PAGE_NAIS] TINYINT NOT NULL , [PG_GEST_PAGE_REC] TINYINT NOT NULL , [PG_DERN_DATE_PUBL] SMALLINT NOT NULL , [PG_TEL_OFS] VARCHAR(20) NOT NULL , [PG_FAX_OFS] VARCHAR(20) NOT NULL , [PG_EMAIL] VARCHAR(100) NOT NULL , [PG_CONTROLE_ACCES] VARCHAR(10) NOT NULL , [PG_GENER_DISQUETTE] TINYINT NOT NULL , [PG_ART_106] TEXT NOT NULL , [PG_ART_125] TEXT NOT NULL , [PG_LOGO_COMMUNE] VARCHAR(100) NOT NULL , [PG_OLD_COMMUNES] INTEGER NOT NULL , [PG_OLD_PAYS] INTEGER NOT NULL , [PG_OLD_MARIAGES] INTEGER NOT NULL , [PG_OLD_NAISSANCES] INTEGER NOT NULL , [PG_OLD_RECONAISSANCES] INTEGER NOT NULL , [PG_OLD_DECES] INTEGER NOT NULL , [PG_OLD_DECLARANTS] INTEGER NOT NULL , [PG_OLD_MEDECINS] INTEGER NOT NULL , [PG_DECLARANT_NA] TINYINT NOT NULL , [PG_DECLARANT_DE] TINYINT NOT NULL , [PG_IMAGE_MENU] VARCHAR(100) NOT NULL , [PG_NA_LIEU_MARIAGE] INTEGER NOT NULL , [PG_IMAGE_FOND] VARCHAR(255) NOT NULL , [PG_IMAGE_ACTIF] VARCHAR(255) NOT NULL , [PG_IMAGE_INACTIF] VARCHAR(255) NOT NULL , [PG_COM_MAJ] VARCHAR(30) NOT NULL ); CREATE INDEX [WDIDX_PGEN_PG_PAYS] ON [PGEN] ([PG_PAYS]);
-- Suppression de la table PERSONNE DROP TABLE [PERSONNE] ; -- Création de la table PERSONNE CREATE TABLE [PERSONNE] ( [NOM] VARCHAR(100) NOT NULL , [NOM_AV_MARI] VARCHAR(100) NOT NULL , [PRENOM] VARCHAR(100) NOT NULL , [SEXE] VARCHAR(1) NOT NULL , [DATE_DE_NAISSANCE] DATETIME NOT NULL , [LIEUX_ORIGINE] TEXT NOT NULL , [REFERENCE_NO_FEUILLET] VARCHAR(10) NOT NULL , [PROVENANCE] VARCHAR(20) NOT NULL ); CREATE INDEX [WDIDX_PERSONNE_NOM] ON [PERSONNE] ([NOM]); CREATE INDEX [WDIDX_PERSONNE_NOM_AV_MARI] ON [PERSONNE] ([NOM_AV_MARI]); CREATE INDEX [WDIDX_PERSONNE_SEXE] ON [PERSONNE] ([SEXE]); CREATE INDEX [WDIDX_PERSONNE_DATE_DE_NAISSANCE] ON [PERSONNE] ([DATE_DE_NAISSANCE]); CREATE INDEX [WDIDX_PERSONNE_REFERENCE_NO_FEUILLET] ON [PERSONNE] ([REFERENCE_NO_FEUILLET]); CREATE INDEX [WDIDX_PERSONNE_PROVENANCE] ON [PERSONNE] ([PROVENANCE]);
-- Suppression de la table Pays DROP TABLE [Pays] ; -- Création de la table Pays CREATE TABLE [Pays] ( [PA_CODE] VARCHAR(3) NOT NULL UNIQUE , [PA_PAYS] VARCHAR(45) NOT NULL , [PA_NAT_HOMME] VARCHAR(60) NOT NULL , [PA_NAT_FEMME] VARCHAR(60) NOT NULL , [PA_OFS] VARCHAR(4) NOT NULL , [PA_REPRE] VARCHAR(100) NOT NULL , [PA_ADRESSE] TEXT NOT NULL , [PA_NP] INTEGER NOT NULL , [PA_LIEU] VARCHAR(40) NOT NULL , [PA_NP2] VARCHAR(10) NOT NULL ); CREATE INDEX [WDIDX_Pays_PA_PAYS] ON [Pays] ([PA_PAYS]); CREATE INDEX [WDIDX_Pays_PA_OFS] ON [Pays] ([PA_OFS]);
-- Suppression de la table Naissanc DROP TABLE [Naissanc] ; -- Création de la table Naissanc CREATE TABLE [Naissanc] ( [NA_VOL] VARCHAR(4) NOT NULL , [NA_NO] VARCHAR(4) NOT NULL , [NA_PAGE] VARCHAR(4) NOT NULL , [NA_ANNULE] TINYINT NOT NULL , [NA_NE_LE] DATETIME NOT NULL , [NA_HEURE] DATETIME NOT NULL , [NA_PAYS] VARCHAR(3) NOT NULL , [NA_LIEU] VARCHAR(100) NOT NULL , [NA_LIEU_NAISSANCE] INTEGER NOT NULL , [NA_TYPE_NAISSANCE] INTEGER NOT NULL , [NA_AUT_TUL] VARCHAR(40) NOT NULL , [NA_JUMEAU_NO] VARCHAR(25) NOT NULL , [NA_TOT_GARCONS] TINYINT NOT NULL , [NA_TOT_FILLES] TINYINT NOT NULL , [NA_SAGE_FEMME] VARCHAR(30) NOT NULL , [NA_NOM_SAGE_FEMME] VARCHAR(30) NOT NULL , [NA_NO_SAGE_FEMME] VARCHAR(10) NOT NULL , [NA_DATE_DECL] DATETIME NOT NULL , [NA_FORME_DECL] INTEGER NOT NULL , [NA_CODE_DECLARANT] TINYINT NOT NULL , [NA_DECLARANT] TEXT NOT NULL , [NA_DATE_MARIAGE] DATETIME NOT NULL , [NA_LIEU_MAR_PARENTS] INTEGER NOT NULL , [NA_DATE_DIV_PARENTS] DATETIME NOT NULL , [NA_INSCRIP_REG] INTEGER NOT NULL , [NA_RANG_NAISSANCE] TINYINT NOT NULL , [NA_RANG_VIVANT_TOT] INTEGER NOT NULL , [NA_DATE_PREC_VIVANT] DATETIME NOT NULL , [NA_DATE_VIVANT_TOT] DATETIME NOT NULL , [NA_COMMUNIQUES] TEXT NOT NULL , [NA_FEUILLET] TEXT NOT NULL , [NA_NOM] VARCHAR(100) NOT NULL , [NA_PRENOM] TEXT NOT NULL , [NA_SEXE] INTEGER NOT NULL , [NA_MORT_NE] TINYINT NOT NULL , [NA_POIDS] INTEGER NOT NULL , [NA_LONGUEUR] REAL NOT NULL , [NA_CODE_ORIGINE_ENF] INTEGER NOT NULL , [NA_ORIGINES] TEXT NOT NULL , [NA_NOM_PERE] VARCHAR(100) NOT NULL , [NA_PRENOM_PERE] TEXT NOT NULL , [NA_EC_PERE] INTEGER NOT NULL , [NA_PAYS_PERE] VARCHAR(3) NOT NULL , [NA_ORIG_PERE] TEXT NOT NULL , [NA_NE_A_PERE] VARCHAR(100) NOT NULL , [NA_NE_LE_PERE] DATETIME NOT NULL , [NA_NE_EN_PERE] INTEGER NOT NULL , [NA_DATE_DECES_PERE] DATETIME NOT NULL , [CREE_LE] DATETIME NOT NULL , [CREE_A] DATETIME NOT NULL , [CREE_PAR] VARCHAR(8) NOT NULL , [MODIFIE_LE] DATETIME NOT NULL , [MODIFIE_A] DATETIME NOT NULL , [MODIFIE_PAR] VARCHAR(8) NOT NULL , [NA_COMMENTAIRES] TEXT NOT NULL , [NA_ADOPTE_PERE] TINYINT NOT NULL , [NA_FILL_SNG_PERE] TEXT NOT NULL , [NA_NOM_PERE_PERE] TEXT NOT NULL , [NA_NOM_PERE_MERE] TEXT NOT NULL , [NA_COM_DOM_PERE] VARCHAR(40) NOT NULL , [NA_CANT_DOM_PERE] INTEGER NOT NULL , [NA_PAYS_DOM_PERE] VARCHAR(3) NOT NULL , [NA_DOM_ACT_PERE] VARCHAR(50) NOT NULL , [NA_RUE_DOM_ACT_PERE] VARCHAR(35) NOT NULL , [NA_DOM_SEJ_PERE] VARCHAR(50) NOT NULL , [NA_RUE_DOM_SEJ_PERE] VARCHAR(35) NOT NULL , [NA_RELIGION_PERE] INTEGER NOT NULL , [NA_SIT_PROF_PERE] INTEGER NOT NULL , [NA_GENRE_ENTR_PERE] INTEGER NOT NULL , [NA_NOM_MERE] VARCHAR(100) NOT NULL , [NA_PREN_MERE] TEXT NOT NULL , [NA_EC_MERE] INTEGER NOT NULL , [NA_PAYS_ORI_MERE] VARCHAR(3) NOT NULL , [NA_ORIG_MERE] TEXT NOT NULL , [NA_NE_A_MERE] VARCHAR(100) NOT NULL , [NA_LE_MERE] DATETIME NOT NULL , [NA_NE_EN_MERE] INTEGER NOT NULL , [NA_DATE_DECES_MERE] DATETIME NOT NULL , [NA_ADOPTE_MERE] TINYINT NOT NULL , [NA_FIL_SNG_MERE] TEXT NOT NULL , [NA_NOM_MERE_MERE] TEXT NOT NULL , [NA_MERE_PERE] TEXT NOT NULL , [NA_COM_DOM_MERE] VARCHAR(40) NOT NULL , [NA_CANT_DOM_MERE] INTEGER NOT NULL , [NA_PAYS_DOM_MERE] VARCHAR(3) NOT NULL , [NA_DOM_ACT_MERE] VARCHAR(50) NOT NULL , [NA_RUE_DOM_ACT_MERE] VARCHAR(35) NOT NULL , [NA_DOM_SEJ_MERE] VARCHAR(50) NOT NULL , [NA_RUE_DOM_SEJ_MERE] VARCHAR(35) NOT NULL , [NA_RELIGION_MERE] INTEGER NOT NULL , [NA_PROF_MERE] VARCHAR(30) NOT NULL , [NA_SIT_PROF_MERE] INTEGER NOT NULL , [NA_GENRE_ENTR_MERE] INTEGER NOT NULL , [NA_RECH_ENFANT] VARCHAR(100) NOT NULL , [NA_RECH_PERE] VARCHAR(100) NOT NULL , [NA_RECH_MERE] VARCHAR(100) NOT NULL , [EXPEDIE_OFS] TINYINT NOT NULL , [REGISTRE_IMPRIME] TINYINT NOT NULL , [NA_PROF_PERE] VARCHAR(30) NOT NULL , [NA_ATT_I_PERE] VARCHAR(60) NOT NULL , [NA_ATT_I_MERE] VARCHAR(60) NOT NULL , [NA_CODE_OFS] INTEGER NOT NULL ); CREATE INDEX [WDIDX_Naissanc_NA_VOL] ON [Naissanc] ([NA_VOL]); CREATE INDEX [WDIDX_Naissanc_NA_NO] ON [Naissanc] ([NA_NO]); CREATE INDEX [WDIDX_Naissanc_NA_NE_LE] ON [Naissanc] ([NA_NE_LE]); CREATE INDEX [WDIDX_Naissanc_NA_NOM] ON [Naissanc] ([NA_NOM]); CREATE INDEX [WDIDX_Naissanc_NA_SEXE] ON [Naissanc] ([NA_SEXE]); CREATE INDEX [WDIDX_Naissanc_NA_NOM_PERE] ON [Naissanc] ([NA_NOM_PERE]); CREATE INDEX [WDIDX_Naissanc_NA_NOM_MERE] ON [Naissanc] ([NA_NOM_MERE]); CREATE INDEX [WDIDX_Naissanc_NA_RECH_ENFANT] ON [Naissanc] ([NA_RECH_ENFANT]); CREATE INDEX [WDIDX_Naissanc_NA_RECH_PERE] ON [Naissanc] ([NA_RECH_PERE]); CREATE INDEX [WDIDX_Naissanc_NA_RECH_MERE] ON [Naissanc] ([NA_RECH_MERE]); CREATE INDEX [WDIDX_Naissanc_EXPEDIE_OFS] ON [Naissanc] ([EXPEDIE_OFS]); CREATE INDEX [WDIDX_Naissanc_NA_CODE_OFS] ON [Naissanc] ([NA_CODE_OFS]);
-- Suppression de la table Naissa_2 DROP TABLE [Naissa_2] ; -- Création de la table Naissa_2 CREATE TABLE [Naissa_2] ( [NA_VOL] VARCHAR(4) NOT NULL , [NA_NO] VARCHAR(4) NOT NULL , [NA_PAGE] VARCHAR(4) NOT NULL , [NA_ANNULE] TINYINT NOT NULL , [NA_NE_LE] DATETIME NOT NULL , [NA_HEURE] DATETIME NOT NULL , [NA_PAYS] VARCHAR(3) NOT NULL , [NA_LIEU] VARCHAR(100) NOT NULL , [NA_LIEU_NAISSANCE] INTEGER NOT NULL , [NA_TYPE_NAISSANCE] INTEGER NOT NULL , [NA_AUT_TUL] VARCHAR(40) NOT NULL , [NA_JUMEAU_NO] VARCHAR(25) NOT NULL , [NA_TOT_GARCONS] TINYINT NOT NULL , [NA_TOT_FILLES] TINYINT NOT NULL , [NA_SAGE_FEMME] VARCHAR(30) NOT NULL , [NA_NOM_SAGE_FEMME] VARCHAR(30) NOT NULL , [NA_NO_SAGE_FEMME] VARCHAR(10) NOT NULL , [NA_DATE_DECL] DATETIME NOT NULL , [NA_FORME_DECL] INTEGER NOT NULL , [NA_CODE_DECLARANT] TINYINT NOT NULL , [NA_DECLARANT] TEXT NOT NULL , [NA_DATE_MARIAGE] DATETIME NOT NULL , [NA_LIEU_MAR_PARENTS] INTEGER NOT NULL , [NA_DATE_DIV_PARENTS] DATETIME NOT NULL , [NA_INSCRIP_REG] INTEGER NOT NULL , [NA_RANG_NAISSANCE] TINYINT NOT NULL , [NA_RANG_VIVANT_TOT] INTEGER NOT NULL , [NA_DATE_PREC_VIVANT] DATETIME NOT NULL , [NA_DATE_VIVANT_TOT] DATETIME NOT NULL , [NA_COMMUNIQUES] TEXT NOT NULL , [NA_FEUILLET] TEXT NOT NULL , [NA_NOM] VARCHAR(100) NOT NULL , [NA_PRENOM] TEXT NOT NULL , [NA_SEXE] INTEGER NOT NULL , [NA_MORT_NE] TINYINT NOT NULL , [NA_POIDS] INTEGER NOT NULL , [NA_LONGUEUR] REAL NOT NULL , [NA_CODE_ORIGINE_ENF] INTEGER NOT NULL , [NA_ORIGINES] TEXT NOT NULL , [NA_NOM_PERE] VARCHAR(100) NOT NULL , [NA_PRENOM_PERE] TEXT NOT NULL , [NA_EC_PERE] INTEGER NOT NULL , [NA_PAYS_PERE] VARCHAR(3) NOT NULL , [NA_ORIG_PERE] TEXT NOT NULL , [NA_NE_A_PERE] VARCHAR(100) NOT NULL , [NA_NE_LE_PERE] DATETIME NOT NULL , [NA_NE_EN_PERE] INTEGER NOT NULL , [NA_DATE_DECES_PERE] DATETIME NOT NULL , [CREE_LE] DATETIME NOT NULL , [CREE_A] DATETIME NOT NULL , [CREE_PAR] VARCHAR(8) NOT NULL , [MODIFIE_LE] DATETIME NOT NULL , [MODIFIE_A] DATETIME NOT NULL , [MODIFIE_PAR] VARCHAR(8) NOT NULL , [NA_COMMENTAIRES] TEXT NOT NULL , [NA_ADOPTE_PERE] TINYINT NOT NULL , [NA_FILL_SNG_PERE] TEXT NOT NULL , [NA_NOM_PERE_PERE] TEXT NOT NULL , [NA_NOM_PERE_MERE] TEXT NOT NULL , [NA_COM_DOM_PERE] VARCHAR(40) NOT NULL , [NA_CANT_DOM_PERE] INTEGER NOT NULL , [NA_PAYS_DOM_PERE] VARCHAR(3) NOT NULL , [NA_DOM_ACT_PERE] VARCHAR(50) NOT NULL , [NA_RUE_DOM_ACT_PERE] VARCHAR(35) NOT NULL , [NA_DOM_SEJ_PERE] VARCHAR(50) NOT NULL , [NA_RUE_DOM_SEJ_PERE] VARCHAR(35) NOT NULL , [NA_RELIGION_PERE] INTEGER NOT NULL , [NA_SIT_PROF_PERE] INTEGER NOT NULL , [NA_GENRE_ENTR_PERE] INTEGER NOT NULL , [NA_NOM_MERE] VARCHAR(100) NOT NULL , [NA_PREN_MERE] TEXT NOT NULL , [NA_EC_MERE] INTEGER NOT NULL , [NA_PAYS_ORI_MERE] VARCHAR(3) NOT NULL , [NA_ORIG_MERE] TEXT NOT NULL , [NA_NE_A_MERE] VARCHAR(100) NOT NULL , [NA_LE_MERE] DATETIME NOT NULL , [NA_NE_EN_MERE] INTEGER NOT NULL , [NA_DATE_DECES_MERE] DATETIME NOT NULL , [NA_ADOPTE_MERE] TINYINT NOT NULL , [NA_FIL_SNG_MERE] TEXT NOT NULL , [NA_NOM_MERE_MERE] TEXT NOT NULL , [NA_MERE_PERE] TEXT NOT NULL , [NA_COM_DOM_MERE] VARCHAR(40) NOT NULL , [NA_CANT_DOM_MERE] INTEGER NOT NULL , [NA_PAYS_DOM_MERE] VARCHAR(3) NOT NULL , [NA_DOM_ACT_MERE] VARCHAR(50) NOT NULL , [NA_RUE_DOM_ACT_MERE] VARCHAR(35) NOT NULL , [NA_DOM_SEJ_MERE] VARCHAR(50) NOT NULL , [NA_RUE_DOM_SEJ_MERE] VARCHAR(35) NOT NULL , [NA_RELIGION_MERE] INTEGER NOT NULL , [NA_PROF_MERE] VARCHAR(30) NOT NULL , [NA_SIT_PROF_MERE] INTEGER NOT NULL , [NA_GENRE_ENTR_MERE] INTEGER NOT NULL , [NA_RECH_ENFANT] VARCHAR(100) NOT NULL , [NA_RECH_PERE] VARCHAR(100) NOT NULL , [NA_RECH_MERE] VARCHAR(100) NOT NULL , [EXPEDIE_OFS] TINYINT NOT NULL , [REGISTRE_IMPRIME] TINYINT NOT NULL , [NA_PROF_PERE] VARCHAR(30) NOT NULL , [NA_ATT_I_PERE] VARCHAR(60) NOT NULL , [NA_ATT_I_MERE] VARCHAR(60) NOT NULL , [NA_CODE_OFS] INTEGER NOT NULL ); CREATE INDEX [WDIDX_Naissa_2_NA_VOL] ON [Naissa_2] ([NA_VOL]); CREATE INDEX [WDIDX_Naissa_2_NA_NO] ON [Naissa_2] ([NA_NO]); CREATE INDEX [WDIDX_Naissa_2_NA_NE_LE] ON [Naissa_2] ([NA_NE_LE]); CREATE INDEX [WDIDX_Naissa_2_NA_NOM] ON [Naissa_2] ([NA_NOM]); CREATE INDEX [WDIDX_Naissa_2_NA_SEXE] ON [Naissa_2] ([NA_SEXE]); CREATE INDEX [WDIDX_Naissa_2_NA_NOM_PERE] ON [Naissa_2] ([NA_NOM_PERE]); CREATE INDEX [WDIDX_Naissa_2_NA_NOM_MERE] ON [Naissa_2] ([NA_NOM_MERE]); CREATE INDEX [WDIDX_Naissa_2_NA_RECH_ENFANT] ON [Naissa_2] ([NA_RECH_ENFANT]); CREATE INDEX [WDIDX_Naissa_2_NA_RECH_PERE] ON [Naissa_2] ([NA_RECH_PERE]); CREATE INDEX [WDIDX_Naissa_2_NA_RECH_MERE] ON [Naissa_2] ([NA_RECH_MERE]); CREATE INDEX [WDIDX_Naissa_2_EXPEDIE_OFS] ON [Naissa_2] ([EXPEDIE_OFS]); CREATE INDEX [WDIDX_Naissa_2_NA_CODE_OFS] ON [Naissa_2] ([NA_CODE_OFS]);
-- Suppression de la table Naissa_1 DROP TABLE [Naissa_1] ; -- Création de la table Naissa_1 CREATE TABLE [Naissa_1] ( [NA_VOL] VARCHAR(4) NOT NULL , [NA_NO] VARCHAR(4) NOT NULL , [NA_PAGE] VARCHAR(4) NOT NULL , [NA_ANNULE] TINYINT NOT NULL , [NA_NE_LE] DATETIME NOT NULL , [NA_HEURE] DATETIME NOT NULL , [NA_PAYS] VARCHAR(3) NOT NULL , [NA_LIEU] VARCHAR(100) NOT NULL , [NA_LIEU_NAISSANCE] INTEGER NOT NULL , [NA_TYPE_NAISSANCE] INTEGER NOT NULL , [NA_AUT_TUL] VARCHAR(40) NOT NULL , [NA_JUMEAU_NO] VARCHAR(25) NOT NULL , [NA_TOT_GARCONS] TINYINT NOT NULL , [NA_TOT_FILLES] TINYINT NOT NULL , [NA_SAGE_FEMME] VARCHAR(30) NOT NULL , [NA_NOM_SAGE_FEMME] VARCHAR(30) NOT NULL , [NA_NO_SAGE_FEMME] VARCHAR(10) NOT NULL , [NA_DATE_DECL] DATETIME NOT NULL , [NA_FORME_DECL] INTEGER NOT NULL , [NA_CODE_DECLARANT] TINYINT NOT NULL , [NA_DECLARANT] TEXT NOT NULL , [NA_DATE_MARIAGE] DATETIME NOT NULL , [NA_LIEU_MAR_PARENTS] INTEGER NOT NULL , [NA_DATE_DIV_PARENTS] DATETIME NOT NULL , [NA_INSCRIP_REG] INTEGER NOT NULL , [NA_RANG_NAISSANCE] TINYINT NOT NULL , [NA_RANG_VIVANT_TOT] INTEGER NOT NULL , [NA_DATE_PREC_VIVANT] DATETIME NOT NULL , [NA_DATE_VIVANT_TOT] DATETIME NOT NULL , [NA_COMMUNIQUES] TEXT NOT NULL , [NA_FEUILLET] TEXT NOT NULL , [NA_NOM] VARCHAR(100) NOT NULL , [NA_PRENOM] TEXT NOT NULL , [NA_SEXE] INTEGER NOT NULL , [NA_MORT_NE] TINYINT NOT NULL , [NA_POIDS] INTEGER NOT NULL , [NA_LONGUEUR] REAL NOT NULL , [NA_CODE_ORIGINE_ENF] INTEGER NOT NULL , [NA_ORIGINES] TEXT NOT NULL , [NA_NOM_PERE] VARCHAR(100) NOT NULL , [NA_PRENOM_PERE] TEXT NOT NULL , [NA_EC_PERE] INTEGER NOT NULL , [NA_PAYS_PERE] VARCHAR(3) NOT NULL , [NA_ORIG_PERE] TEXT NOT NULL , [NA_NE_A_PERE] VARCHAR(100) NOT NULL , [NA_NE_LE_PERE] DATETIME NOT NULL , [NA_NE_EN_PERE] INTEGER NOT NULL , [NA_DATE_DECES_PERE] DATETIME NOT NULL , [CREE_LE] DATETIME NOT NULL , [CREE_A] DATETIME NOT NULL , [CREE_PAR] VARCHAR(8) NOT NULL , [MODIFIE_LE] DATETIME NOT NULL , [MODIFIE_A] DATETIME NOT NULL , [MODIFIE_PAR] VARCHAR(8) NOT NULL , [NA_COMMENTAIRES] TEXT NOT NULL , [NA_ADOPTE_PERE] TINYINT NOT NULL , [NA_FILL_SNG_PERE] TEXT NOT NULL , [NA_NOM_PERE_PERE] TEXT NOT NULL , [NA_NOM_PERE_MERE] TEXT NOT NULL , [NA_COM_DOM_PERE] VARCHAR(40) NOT NULL , [NA_CANT_DOM_PERE] INTEGER NOT NULL , [NA_PAYS_DOM_PERE] VARCHAR(3) NOT NULL , [NA_DOM_ACT_PERE] VARCHAR(50) NOT NULL , [NA_RUE_DOM_ACT_PERE] VARCHAR(35) NOT NULL , [NA_DOM_SEJ_PERE] VARCHAR(50) NOT NULL , [NA_RUE_DOM_SEJ_PERE] VARCHAR(35) NOT NULL , [NA_RELIGION_PERE] INTEGER NOT NULL , [NA_SIT_PROF_PERE] INTEGER NOT NULL , [NA_GENRE_ENTR_PERE] INTEGER NOT NULL , [NA_NOM_MERE] VARCHAR(100) NOT NULL , [NA_PREN_MERE] TEXT NOT NULL , [NA_EC_MERE] INTEGER NOT NULL , [NA_PAYS_ORI_MERE] VARCHAR(3) NOT NULL , [NA_ORIG_MERE] TEXT NOT NULL , [NA_NE_A_MERE] VARCHAR(100) NOT NULL , [NA_LE_MERE] DATETIME NOT NULL , [NA_NE_EN_MERE] INTEGER NOT NULL , [NA_DATE_DECES_MERE] DATETIME NOT NULL , [NA_ADOPTE_MERE] TINYINT NOT NULL , [NA_FIL_SNG_MERE] TEXT NOT NULL , [NA_NOM_MERE_MERE] TEXT NOT NULL , [NA_MERE_PERE] TEXT NOT NULL , [NA_COM_DOM_MERE] VARCHAR(40) NOT NULL , [NA_CANT_DOM_MERE] INTEGER NOT NULL , [NA_PAYS_DOM_MERE] VARCHAR(3) NOT NULL , [NA_DOM_ACT_MERE] VARCHAR(50) NOT NULL , [NA_RUE_DOM_ACT_MERE] VARCHAR(35) NOT NULL , [NA_DOM_SEJ_MERE] VARCHAR(50) NOT NULL , [NA_RUE_DOM_SEJ_MERE] VARCHAR(35) NOT NULL , [NA_RELIGION_MERE] INTEGER NOT NULL , [NA_PROF_MERE] VARCHAR(30) NOT NULL , [NA_SIT_PROF_MERE] INTEGER NOT NULL , [NA_GENRE_ENTR_MERE] INTEGER NOT NULL , [NA_RECH_ENFANT] VARCHAR(100) NOT NULL , [NA_RECH_PERE] VARCHAR(100) NOT NULL , [NA_RECH_MERE] VARCHAR(100) NOT NULL , [EXPEDIE_OFS] TINYINT NOT NULL , [REGISTRE_IMPRIME] TINYINT NOT NULL , [NA_PROF_PERE] VARCHAR(30) NOT NULL , [NA_ATT_I_PERE] VARCHAR(60) NOT NULL , [NA_ATT_I_MERE] VARCHAR(60) NOT NULL , [NA_CODE_OFS] INTEGER NOT NULL ); CREATE INDEX [WDIDX_Naissa_1_NA_VOL] ON [Naissa_1] ([NA_VOL]); CREATE INDEX [WDIDX_Naissa_1_NA_NO] ON [Naissa_1] ([NA_NO]); CREATE INDEX [WDIDX_Naissa_1_NA_NE_LE] ON [Naissa_1] ([NA_NE_LE]); CREATE INDEX [WDIDX_Naissa_1_NA_NOM] ON [Naissa_1] ([NA_NOM]); CREATE INDEX [WDIDX_Naissa_1_NA_SEXE] ON [Naissa_1] ([NA_SEXE]); CREATE INDEX [WDIDX_Naissa_1_NA_NOM_PERE] ON [Naissa_1] ([NA_NOM_PERE]); CREATE INDEX [WDIDX_Naissa_1_NA_NOM_MERE] ON [Naissa_1] ([NA_NOM_MERE]); CREATE INDEX [WDIDX_Naissa_1_NA_RECH_ENFANT] ON [Naissa_1] ([NA_RECH_ENFANT]); CREATE INDEX [WDIDX_Naissa_1_NA_RECH_PERE] ON [Naissa_1] ([NA_RECH_PERE]); CREATE INDEX [WDIDX_Naissa_1_NA_RECH_MERE] ON [Naissa_1] ([NA_RECH_MERE]); CREATE INDEX [WDIDX_Naissa_1_EXPEDIE_OFS] ON [Naissa_1] ([EXPEDIE_OFS]); CREATE INDEX [WDIDX_Naissa_1_NA_CODE_OFS] ON [Naissa_1] ([NA_CODE_OFS]);
-- Suppression de la table Medecins DROP TABLE [Medecins] ; -- Création de la table Medecins CREATE TABLE [Medecins] ( [MD_MEDECIN] VARCHAR(40) NOT NULL UNIQUE , [MD_RUE_NO] VARCHAR(30) NOT NULL , [MD_NP] INTEGER NOT NULL , [MD_LOCALITE] VARCHAR(28) NOT NULL ); CREATE INDEX [WDIDX_Medecins_MD_NP] ON [Medecins] ([MD_NP]);
-- Suppression de la table Mariages DROP TABLE [Mariages] ; -- Création de la table Mariages CREATE TABLE [Mariages] ( [MA_PUBL] INTEGER NOT NULL , [MA_DATE_PUBL] DATETIME NOT NULL , [MA_ANNULE] TINYINT NOT NULL , [MA_AFFICHAGE] DATETIME NOT NULL , [MA_FIN_PUB] DATETIME NOT NULL , [MA_FORME_DEM] INTEGER NOT NULL , [MA_REM_DC] TEXT NOT NULL , [MA_REM_EVEN_FCE] TEXT NOT NULL , [MA_REM_EVEN_FCEE] TEXT NOT NULL , [MA_NOM_FCE] TEXT NOT NULL , [MA_NOM_APRES_FCE] VARCHAR(100) NOT NULL , [MA_PREN_FCE] TEXT NOT NULL , [MA_ETAT_CIVIL_FCE] INTEGER NOT NULL , [MA_EC_ABREGE_FCE] VARCHAR(35) NOT NULL , [MA_NOM_EX_CONJOINT_FCE] TEXT NOT NULL , [MA_PREN_EX_CONJ_FCE] TEXT NOT NULL , [MA_DATE_DISS_MAR_FCE] DATETIME NOT NULL , [MA_LIEU_DISS_FCE] VARCHAR(80) NOT NULL , [MA_COMPL_EC_FCE] INTEGER NOT NULL , [MA_PAYS_ORI_FCE] VARCHAR(3) NOT NULL , [MA_ORIGINES_FCE] TEXT NOT NULL , [MA_CONS_NAT_CH_FCE] TINYINT NOT NULL , [MA_DATE_DECL_CNS_FCE] DATETIME NOT NULL , [MA_NE_A_FCE] VARCHAR(80) NOT NULL , [MA_CANTON_NAIS_FCE] INTEGER NOT NULL , [MA_NE_LE_FCE] DATETIME NOT NULL , [MA_ANNEE_NAIS_FCE] INTEGER NOT NULL , [MA_ADOPTE_FCE] TINYINT NOT NULL , [MA_FILL_SNG_GCE] TEXT NOT NULL , [MA_PERE_FCE] TEXT NOT NULL , [MA_MERE_FCE] TEXT NOT NULL , [MA_COMM_DOM_FCE] VARCHAR(40) NOT NULL , [MA_CANT_DOM_FCE] INTEGER NOT NULL , [MA_PAYS_DOM_FCE] VARCHAR(3) NOT NULL , [MA_DOM_ACT_FCE] VARCHAR(50) NOT NULL , [MA_RUE_DOM_ACT_FCE] VARCHAR(35) NOT NULL , [MA_DOM_PRE_FCE] VARCHAR(50) NOT NULL , [MA_RUE_PRE_FCE] VARCHAR(35) NOT NULL , [MA_DOM_SEJ_FCE] VARCHAR(50) NOT NULL , [MA_RUE_SEJ_FCE] VARCHAR(35) NOT NULL , [MA_RELIGION_FCE] INTEGER NOT NULL , [MA_DROIT_CITE_FCE] TEXT NOT NULL , [MA_CONS_NOM_FCE] INTEGER NOT NULL , [MA_NOM_FCEE] TEXT NOT NULL , [MA_NOM_APRES_FCEE] VARCHAR(100) NOT NULL , [MA_CONS_NOM_FCEE] INTEGER NOT NULL , [MA_PREN_FCEE] TEXT NOT NULL , [MA_ETAT_CIVIL_FCEE] INTEGER NOT NULL , [MA_EC_ABREGGE_FCEE] VARCHAR(35) NOT NULL , [MA_NOM_EX_CONJ_FCEE] TEXT NOT NULL , [MA_PREN_EX_CONJ_FCEE] TEXT NOT NULL , [MA_DATE_DISS_MAR_FCEE] DATETIME NOT NULL , [MA_LIEU_DISS_FCEE] VARCHAR(80) NOT NULL , [MA_COMPL_EC] INTEGER NOT NULL , [MA_PAYS_ORIG_FCEE] VARCHAR(3) NOT NULL , [MA_ORIG_FCEE] TEXT NOT NULL , [MA_CONS_NAT_FCEE] TINYINT NOT NULL , [MA_DATE_DECL_NAT] DATETIME NOT NULL , [MA_NE_A_FCEE] VARCHAR(80) NOT NULL , [MA_NE_LE_FCEE] DATETIME NOT NULL , [MA_CANT_NAI_FCEE] INTEGER NOT NULL , [MA_NAIS_EN_FCEE] INTEGER NOT NULL , [MA_ADOPTEE_FCEE] TINYINT NOT NULL , [MA_FILL_SNG_FCEE] TEXT NOT NULL , [MA_PERE_FCEE] TEXT NOT NULL , [MA_MERE_FCEE] TEXT NOT NULL , [MA_COMM_DOM_FCEE] VARCHAR(40) NOT NULL , [MA_CANTON_DOM_FCEE] INTEGER NOT NULL , [MA_PAYS_DOM_FCEE] VARCHAR(3) NOT NULL , [MA_DOM_ACT_FCEE] VARCHAR(50) NOT NULL , [MA_RUE_DOC_ACT_FCEE] VARCHAR(35) NOT NULL , [MA_DOM_PRE_FCEE] VARCHAR(50) NOT NULL , [MA_RUE_PRE_FCEE] VARCHAR(35) NOT NULL , [MA_DOM_SEJ_FCEE] VARCHAR(50) NOT NULL , [MA_RUE_SEJ_FCEE] VARCHAR(35) NOT NULL , [MA_RELIGION_FCEE] INTEGER NOT NULL , [MA_DROIT_CITE_FCEE] TEXT NOT NULL , [MA_DEPOSE_PAR_1] TINYINT NOT NULL , [MA_DEPOSE_PAR_2] TINYINT NOT NULL , [MA_DEPOSE_PAR_3] TINYINT NOT NULL , [MA_DEPOSE_PAR_4] TINYINT NOT NULL , [MA_DEPOSE_PAR_5] TINYINT NOT NULL , [MA_DEPOSE_PAR_6] TINYINT NOT NULL , [MA_DEPOSE_PAR_7] TINYINT NOT NULL , [MA_DEPOSE_PAR_8] TINYINT NOT NULL , [MA_DEPOSE_PAR_9] TINYINT NOT NULL , [MA_DEPOSE_PAR_10] TINYINT NOT NULL , [MA_DEPOSE_PAR_11] TINYINT NOT NULL , [MA_DEPOSE_PAR_12] TINYINT NOT NULL , [MA_DEPOSE_PAR_13] TINYINT NOT NULL , [MA_DEPOSE_PAR_14] TINYINT NOT NULL , [MA_DEPOSE_PAR_15] TINYINT NOT NULL , [MA_DEPOSE_PAR_16] TINYINT NOT NULL , [MA_DEPOSE_PAR_17] TINYINT NOT NULL , [MA_DEPOSE_PAR_18] TINYINT NOT NULL , [MA_DEPOSE_PAR_19] TINYINT NOT NULL , [MA_DEPOSE_PAR_20] TINYINT NOT NULL , [MA_DEPOSE_PAR_21] TINYINT NOT NULL , [MA_DEPOSE_PAR_22] TINYINT NOT NULL , [MA_DEPOSE_PAR_23] TINYINT NOT NULL , [MA_DEPOSE_PAR_24] TINYINT NOT NULL , [MA_LIBRE_14] VARCHAR(40) NOT NULL , [MA_LIBRE_15] VARCHAR(40) NOT NULL , [MA_LIBRE_16] VARCHAR(40) NOT NULL , [MA_LIBRE_19] VARCHAR(40) NOT NULL , [MA_LIBRE_20] VARCHAR(40) NOT NULL , [MA_LIBRE_21] VARCHAR(40) NOT NULL , [MA_LIBRE_22] VARCHAR(40) NOT NULL , [MA_LIBRE_23] VARCHAR(40) NOT NULL , [MA_LIBRE_24] VARCHAR(40) NOT NULL , [MA_OFFICE_AVISE_1] VARCHAR(30) NOT NULL , [MA_OFFICE_AVISE_2] VARCHAR(30) NOT NULL , [MA_OFFICE_AVISE_3] VARCHAR(30) NOT NULL , [MA_OFFICE_AVISE_4] VARCHAR(30) NOT NULL , [MA_OFFICE_AVISE_5] VARCHAR(30) NOT NULL , [MA_OFFICE_AVISE_6] VARCHAR(30) NOT NULL , [MA_OFFICE_AVISE_7] VARCHAR(30) NOT NULL , [MA_OFFICE_AVISE_8] VARCHAR(30) NOT NULL , [MA_OFFICE_AVISE_9] VARCHAR(30) NOT NULL , [MA_OFFICE_PAR_AP_1] TINYINT NOT NULL , [MA_OFFICE_PAR_AP_2] TINYINT NOT NULL , [MA_OFFICE_PAR_AP_3] TINYINT NOT NULL , [MA_OFFICE_PAR_AP_4] TINYINT NOT NULL , [MA_OFFICE_PAR_AP_5] TINYINT NOT NULL , [MA_OFFICE_PAR_AP_6] TINYINT NOT NULL , [MA_OFFICE_PAR_AP_7] TINYINT NOT NULL , [MA_OFFICE_PAR_AP_8] TINYINT NOT NULL , [MA_OFFICE_PAR_AP_9] TINYINT NOT NULL , [MA_OFFICE_DATE_1] DATETIME NOT NULL , [MA_OFFICE_DATE_2] DATETIME NOT NULL , [MA_OFFICE_DATE_3] DATETIME NOT NULL , [MA_OFFICE_DATE_4] DATETIME NOT NULL , [MA_OFFICE_DATE_5] DATETIME NOT NULL , [MA_OFFICE_DATE_6] DATETIME NOT NULL , [MA_OFFICE_DATE_7] DATETIME NOT NULL , [MA_OFFICE_DATE_8] DATETIME NOT NULL , [MA_OFFICE_DATE_9] DATETIME NOT NULL , [MA_NOM_ENF_1] VARCHAR(80) NOT NULL , [MA_NOM_ENF_2] VARCHAR(80) NOT NULL , [MA_NOM_ENF_3] VARCHAR(80) NOT NULL , [MA_NOM_ENF_4] VARCHAR(80) NOT NULL , [MA_NOM_AM_ENF_1] VARCHAR(80) NOT NULL , [MA_NOM_AM_ENF_2] VARCHAR(80) NOT NULL , [MA_NOM_AM_ENF_3] VARCHAR(80) NOT NULL , [MA_NOM_AM_ENF_4] VARCHAR(80) NOT NULL , [MA_PREN_ENF_1] VARCHAR(50) NOT NULL , [MA_PREN_ENF_2] VARCHAR(50) NOT NULL , [MA_PREN_ENF_3] VARCHAR(50) NOT NULL , [MA_PREN_ENF_4] VARCHAR(50) NOT NULL , [MA_LIEU_NE_ENF_1] VARCHAR(50) NOT NULL , [MA_LIEU_NE_ENF_2] VARCHAR(50) NOT NULL , [MA_LIEU_NE_ENF_3] VARCHAR(50) NOT NULL , [MA_LIEU_NE_ENF_4] VARCHAR(50) NOT NULL , [MA_NE_LE_ENF_1] DATETIME NOT NULL , [MA_NE_LE_ENF_2] DATETIME NOT NULL , [MA_NE_LE_ENF_3] DATETIME NOT NULL , [MA_NE_LE_ENF_4] DATETIME NOT NULL , [MA_ORIGINE_ENF_1] TEXT NOT NULL , [MA_ORIGINE_ENF_2] TEXT NOT NULL , [MA_ORIGINE_ENF_3] TEXT NOT NULL , [MA_ORIGINE_ENF_4] TEXT NOT NULL , [MA_CODE_ORIG_ENF_1] INTEGER NOT NULL , [MA_CODE_ORIG_ENF_2] INTEGER NOT NULL , [MA_CODE_ORIG_ENF_3] INTEGER NOT NULL , [MA_CODE_ORIG_ENF_4] INTEGER NOT NULL , [MA_SEXE_ENF_1] INTEGER NOT NULL , [MA_SEXE_ENF_2] INTEGER NOT NULL , [MA_SEXE_ENF_3] INTEGER NOT NULL , [MA_SEXE_ENF_4] INTEGER NOT NULL , [MA_CANT_ENF_1] INTEGER NOT NULL , [MA_CANT_ENF_2] INTEGER NOT NULL , [MA_CANT_ENF_3] INTEGER NOT NULL , [MA_CANT_ENF_4] INTEGER NOT NULL , [MA_VOL] VARCHAR(4) NOT NULL , [MA_NO] VARCHAR(4) NOT NULL , [MA_PAGE] VARCHAR(4) NOT NULL , [MA_DATE_MARIAGE] DATETIME NOT NULL , [MA_HEURE_MARIAGE] DATETIME NOT NULL , [MA_LIEU_MARIAGE] TEXT NOT NULL , [MA_COMMUNIQUES] TEXT NOT NULL , [MA_FEUILLET] TEXT NOT NULL , [CREE_LE] DATETIME NOT NULL , [CREE_A] DATETIME NOT NULL , [CREE_PAR] VARCHAR(8) NOT NULL , [MODIFIE_LE] DATETIME NOT NULL , [MODIFIE_A] DATETIME NOT NULL , [MODIFIE_PAR] VARCHAR(8) NOT NULL , [MA_NOM_RECH_FCE] VARCHAR(80) NOT NULL , [MA_NOM_RECH_FCEE] VARCHAR(80) NOT NULL , [EXPEDIE_OFS] TINYINT NOT NULL , [REGISTRE_IMPRIME] TINYINT NOT NULL , [MA_ATT_I_FCE] VARCHAR(60) NOT NULL , [MA_ATT_I_FCEE] VARCHAR(60) NOT NULL , [MA_COMMENTAIRE] TEXT NOT NULL , [MA_CODE_OFS] INTEGER NOT NULL , [AUT_AU] DATETIME NOT NULL , [FCE_TUT_RECU_LE] DATETIME NOT NULL , [FCE_ADOP_RECU_LE] DATETIME NOT NULL , [FCE_TUT_OUI_NON] TINYINT NOT NULL , [FCE_ADOP_OUI_NON] TINYINT NOT NULL , [FCEE_DC_RECU_LE] DATETIME NOT NULL , [FCEE_TUT_RECU_LE] DATETIME NOT NULL , [FCEE_ADOP_RECU_LE] DATETIME NOT NULL , [FCEE_DC_OUI_NON] TINYINT NOT NULL , [FCEE_TUT_OUI_NON] TINYINT NOT NULL , [FCEE_ADOP_OUI_NON] TINYINT NOT NULL , [PAP_DEPOSE_PAR_25] TINYINT NOT NULL , [PAP_DEPOSE_PAR_26] TINYINT NOT NULL , [DATE_RESERVE_1] DATETIME NOT NULL , [DATE_RESERVE_2] DATETIME NOT NULL , [DATE_RESERVE_3] DATETIME NOT NULL , [DATE_RESERVE_4] DATETIME NOT NULL , [DATE_RESERVE_5] DATETIME NOT NULL , [DATE_RESERVE_6] DATETIME NOT NULL , [INTERRUPTEUR_RESERVE_1] TINYINT NOT NULL , [INTERRUPTEUR_RESERVE_2] TINYINT NOT NULL , [INTERRUPTEUR_RESERVE_3] TINYINT NOT NULL , [INTERRUPTEUR_RESERVE_4] TINYINT NOT NULL , [INTERRUPTEUR_RESERVE_5] TINYINT NOT NULL , [INTERRUPTEUR_RESERVE_6] TINYINT NOT NULL , [NB_RESERVE_1] SMALLINT NOT NULL , [NB_RESERVE_2] SMALLINT NOT NULL , [NB_RESERVE_3] SMALLINT NOT NULL , [NB_RESERVE_4] SMALLINT NOT NULL , [NB_RESERVE_5] SMALLINT NOT NULL , [NB_RESERVE_6] SMALLINT NOT NULL , [TEXTE_RESERVE_1] VARCHAR(50) NOT NULL , [TEXTE_RESERVE_2] VARCHAR(50) NOT NULL , [TEXTE_RESERVE_3] VARCHAR(50) NOT NULL , [TEXTE_RESERVE_4] VARCHAR(50) NOT NULL , [MEMO_RESERVE_1] TEXT NOT NULL , [MEMO_RESERVE_2] TEXT NOT NULL , [MEMO_RESERVE_3] TEXT NOT NULL , [MEMO_RESERVE_4] TEXT NOT NULL ); CREATE INDEX [WDIDX_Mariages_MA_PUBL] ON [Mariages] ([MA_PUBL]); CREATE INDEX [WDIDX_Mariages_MA_NOM_APRES_FCE] ON [Mariages] ([MA_NOM_APRES_FCE]); CREATE INDEX [WDIDX_Mariages_MA_NOM_APRES_FCEE] ON [Mariages] ([MA_NOM_APRES_FCEE]); CREATE INDEX [WDIDX_Mariages_MA_VOL] ON [Mariages] ([MA_VOL]); CREATE INDEX [WDIDX_Mariages_MA_NO] ON [Mariages] ([MA_NO]); CREATE INDEX [WDIDX_Mariages_MA_DATE_MARIAGE] ON [Mariages] ([MA_DATE_MARIAGE]); CREATE INDEX [WDIDX_Mariages_MA_NOM_RECH_FCE] ON [Mariages] ([MA_NOM_RECH_FCE]); CREATE INDEX [WDIDX_Mariages_MA_NOM_RECH_FCEE] ON [Mariages] ([MA_NOM_RECH_FCEE]); CREATE INDEX [WDIDX_Mariages_EXPEDIE_OFS] ON [Mariages] ([EXPEDIE_OFS]); CREATE INDEX [WDIDX_Mariages_MA_CODE_OFS] ON [Mariages] ([MA_CODE_OFS]); CREATE INDEX [WDIDX_Mariages_VOLUME_NO] ON [Mariages] ([MA_VOL],[MA_NO]);
-- Suppression de la table HIST_OFS DROP TABLE [HIST_OFS] ; -- Création de la table HIST_OFS CREATE TABLE [HIST_OFS] ( [FICHIER_OFS] VARCHAR(8) NOT NULL , [REGISTRE] VARCHAR(20) NOT NULL , [VOLUME] VARCHAR(4) NOT NULL , [No] VARCHAR(4) NOT NULL ); CREATE INDEX [WDIDX_HIST_OFS_FICHIER_OFS] ON [HIST_OFS] ([FICHIER_OFS]);
-- Suppression de la table GROUP DROP TABLE [GROUP] ; -- Création de la table GROUP CREATE TABLE [GROUP] ( [GroupName] VARCHAR(100) NOT NULL UNIQUE );
-- Suppression de la table Document DROP TABLE [Document] ; -- Création de la table Document CREATE TABLE [Document] ( [DT_Registre] VARCHAR(2) NOT NULL , [DT_CODE] SMALLINT NOT NULL , [DT_NOM] VARCHAR(100) NOT NULL , [DT_NOM_WD] VARCHAR(8) NOT NULL , [DT_NB_COPIES] TINYINT NOT NULL , [DT_DATE_IMPRESSION] DATETIME NOT NULL , [DT_COULEUR] INTEGER NOT NULL , [DT_DEC_HAUT] TINYINT NOT NULL , [DT_DEC_GAUCHE] TINYINT NOT NULL , [DT_SEQ_ORDRE] VARCHAR(5) NOT NULL , [DT_GROUPE] TINYINT NOT NULL ); CREATE INDEX [WDIDX_Document_DT_Registre] ON [Document] ([DT_Registre]); CREATE INDEX [WDIDX_Document_DT_CODE] ON [Document] ([DT_CODE]); CREATE INDEX [WDIDX_Document_DT_NOM] ON [Document] ([DT_NOM]); CREATE INDEX [WDIDX_Document_DT_NOM_WD] ON [Document] ([DT_NOM_WD]); CREATE INDEX [WDIDX_Document_CLE_REGISTRE_SEQ] ON [Document] ([DT_Registre],[DT_SEQ_ORDRE]);
-- Suppression de la table DISQ_OFS DROP TABLE [DISQ_OFS] ; -- Création de la table DISQ_OFS CREATE TABLE [DISQ_OFS] ( [FICHIER_OFS] VARCHAR(8) NOT NULL UNIQUE , [GENERE_LE] DATETIME NOT NULL , [TOT_MAR] INTEGER NOT NULL , [TOT_NAI] INTEGER NOT NULL , [TOT_MORT_NE] INTEGER NOT NULL , [TOT_DEC] INTEGER NOT NULL , [TOT_REC] INTEGER NOT NULL ); CREATE INDEX [WDIDX_DISQ_OFS_GENERE_LE] ON [DISQ_OFS] ([GENERE_LE]);
-- Suppression de la table DISQ_O_1 DROP TABLE [DISQ_O_1] ; -- Création de la table DISQ_O_1 CREATE TABLE [DISQ_O_1] ( [D1CLEUNIK] INTEGER IDENTITY PRIMARY KEY , [FICHIER_OFS] VARCHAR(8) NOT NULL , [GENERE_LE] DATETIME NOT NULL , [TOT_MAR] INTEGER NOT NULL , [TOT_NAI] INTEGER NOT NULL , [TOT_MORT_NE] INTEGER NOT NULL , [TOT_DEC] INTEGER NOT NULL , [TOT_REC] INTEGER NOT NULL ); CREATE INDEX [WDIDX_DISQ_O_1_FICHIER_OFS] ON [DISQ_O_1] ([FICHIER_OFS]); CREATE INDEX [WDIDX_DISQ_O_1_GENERE_LE] ON [DISQ_O_1] ([GENERE_LE]);
-- Suppression de la table Declaran DROP TABLE [Declaran] ; -- Création de la table Declaran CREATE TABLE [Declaran] ( [DE_CODE] TINYINT NOT NULL UNIQUE , [DE_DECLARANT] TEXT NOT NULL );
-- Suppression de la table DECES DROP TABLE [DECES] ; -- Création de la table DECES CREATE TABLE [DECES] ( [DE_VOLUME] VARCHAR(4) NOT NULL , [DE_NO] VARCHAR(4) NOT NULL , [DE_PAGE] VARCHAR(4) NOT NULL , [DE_DATE_DECES] DATETIME NOT NULL , [DE_HEURE_DECES] DATETIME NOT NULL , [DE_ANNULE] TINYINT NOT NULL , [DE_LIEU_DECES] VARCHAR(50) NOT NULL , [DE_AUT_TUT] VARCHAR(40) NOT NULL , [DE_TYPE_DECES] INTEGER NOT NULL , [DE_CIRC_DEC_CORPS] TEXT NOT NULL , [DE_DR_HOPITAL] VARCHAR(40) NOT NULL , [DE_DR_RUE] VARCHAR(30) NOT NULL , [DE_DR_NP] INTEGER NOT NULL , [DE_DATE_DECLARANT] DATETIME NOT NULL , [DE_DR_LOCALITE] VARCHAR(30) NOT NULL , [DE_FORME_DECL] INTEGER NOT NULL , [DE_NO_DECL] TINYINT NOT NULL , [DE_COMMUNIQUES] TEXT NOT NULL , [DE_FEUILLET] VARCHAR(50) NOT NULL , [DE_SEXE] TINYINT NOT NULL , [DE_NOM_DEFUNT] VARCHAR(100) NOT NULL , [DE_PRENOM_DEFUNT] TEXT NOT NULL , [DE_ETAT_CIVIL_DEFUNT] INTEGER NOT NULL , [DE_DATE_DISSOL] DATETIME NOT NULL , [DE_PAYS_ORIGINE_DEFUNT] VARCHAR(3) NOT NULL , [DE_ORIGINES_DEFUNT] TEXT NOT NULL , [RPCLEUNIK] INTEGER NOT NULL , [DE_LIEU_NAISSANCE] VARCHAR(100) NOT NULL , [DE_NE_LE] DATETIME NOT NULL , [DE_ANNEE_NAISSANCE] INTEGER NOT NULL , [DE_HEURE_NAISSANCE] DATETIME NOT NULL , [DE_NAI_MERE] DATETIME NOT NULL , [DE_AN_NAI_MERE] INTEGER NOT NULL , [DE_ADOPTE] TINYINT NOT NULL , [DE_NOM_PERE] TEXT NOT NULL , [DE_PREN_PERE] TEXT NOT NULL , [DE_NOM_MERE] TEXT NOT NULL , [DE_PREN_MERE] TEXT NOT NULL , [DE_NOM_PERE_ADO] TEXT NOT NULL , [DE_PREN_PERE_ADOP] TEXT NOT NULL , [DE_NOM_MERE_ADOP] TEXT NOT NULL , [DE_PREN_MERE_ADOP] TEXT NOT NULL , [DE_COMM_DOM] VARCHAR(40) NOT NULL , [DE_CANTON_DOM] INTEGER NOT NULL , [DE_PAYS_DOM] VARCHAR(3) NOT NULL , [DE_PAYS_DOM_ACT] VARCHAR(50) NOT NULL , [DE_RUE_DOM_ACT] VARCHAR(35) NOT NULL , [DE_COM_DOM_SEJ] VARCHAR(50) NOT NULL , [DE_RUE_DOM_SEJ] VARCHAR(35) NOT NULL , [DE_RELIGION] INTEGER NOT NULL , [DE_ACT_ECONOMIQUE] INTEGER NOT NULL , [DE_PROFESSION] VARCHAR(30) NOT NULL , [DE_SIT_PROF] INTEGER NOT NULL , [DE_NOM_CONJ] VARCHAR(100) NOT NULL , [DE_PREN_CONJ] TEXT NOT NULL , [DE_NE_LE_CONJOINT] DATETIME NOT NULL , [DE_NE_EN_CONJ] INTEGER NOT NULL , [DE_PAYS_CONJ] VARCHAR(3) NOT NULL , [DE_ORIGINE_CONJ] TEXT NOT NULL , [DE_COM_DOM_CONJ] VARCHAR(50) NOT NULL , [DE_RUE_DOM_CONJ] VARCHAR(35) NOT NULL , [DE_LIEU_DECES_CONJ] VARCHAR(40) NOT NULL , [DE_NOM_ENF_1] VARCHAR(150) NOT NULL , [DE_PREN_ENF_1] VARCHAR(120) NOT NULL , [DE_NE_ENF_LE_1] DATETIME NOT NULL , [DE_NOM_ENF_2] VARCHAR(150) NOT NULL , [DE_PREN_ENF_2] VARCHAR(120) NOT NULL , [DE_NE_ENF_LE_2] DATETIME NOT NULL , [DE_NOM_ENF_3] VARCHAR(150) NOT NULL , [DE_PREN_ENF_3] VARCHAR(120) NOT NULL , [DE_NE_ENF_LE_3] DATETIME NOT NULL , [DE_NOM_4] VARCHAR(150) NOT NULL , [DE_PREN_ENF_4] VARCHAR(120) NOT NULL , [DE_NE_ENF_LE_4] DATETIME NOT NULL , [DE_NOM_5] VARCHAR(150) NOT NULL , [DE_PREN_ENF_5] VARCHAR(120) NOT NULL , [DE_NE_ENF_LE_5] DATETIME NOT NULL , [DE_NOM_ENF_6] VARCHAR(150) NOT NULL , [DE_PREN_ENF_6] VARCHAR(120) NOT NULL , [DE_NE_ENF_LE_6] DATETIME NOT NULL , [DE_COMMENTAIRES] TEXT NOT NULL , [CREE_LE] DATETIME NOT NULL , [CREE_A] DATETIME NOT NULL , [CREE_PAR] VARCHAR(8) NOT NULL , [MODIFIE_LE] DATETIME NOT NULL , [MODIFIE_A] DATETIME NOT NULL , [MODIFIE_PAR] VARCHAR(8) NOT NULL , [DE_NOM_RECH] VARCHAR(100) NOT NULL , [DE_DECLARANTS] TEXT NOT NULL , [DE_PROCHE_PARENT] TEXT NOT NULL , [EXPEDIE_OFS] TINYINT NOT NULL , [REGISTRE_IMPRIME] TINYINT NOT NULL , [DE_ATT_I_DEF] VARCHAR(60) NOT NULL , [DE_CODE_OFS] INTEGER NOT NULL , [DE_AN_VEUVAGE] INTEGER NOT NULL ); CREATE INDEX [WDIDX_DECES_DE_VOLUME] ON [DECES] ([DE_VOLUME]); CREATE INDEX [WDIDX_DECES_DE_NO] ON [DECES] ([DE_NO]); CREATE INDEX [WDIDX_DECES_DE_DATE_DECES] ON [DECES] ([DE_DATE_DECES]); CREATE INDEX [WDIDX_DECES_DE_NOM_DEFUNT] ON [DECES] ([DE_NOM_DEFUNT]); CREATE INDEX [WDIDX_DECES_DE_NOM_RECH] ON [DECES] ([DE_NOM_RECH]); CREATE INDEX [WDIDX_DECES_EXPEDIE_OFS] ON [DECES] ([EXPEDIE_OFS]); CREATE INDEX [WDIDX_DECES_DE_CODE_OFS] ON [DECES] ([DE_CODE_OFS]);
-- Suppression de la table ConnUtil DROP TABLE [ConnUtil] ; -- Création de la table ConnUtil CREATE TABLE [ConnUtil] ( [UC_CONNECTE_LE] DATETIME NOT NULL , [UC_CON_A] DATETIME NOT NULL , [UC_DEC_LE] DATETIME NOT NULL , [UC_DEC_A] DATETIME NOT NULL , [UC_TYPE_CONNEXION] INTEGER NOT NULL , [Name] VARCHAR(15) NOT NULL ); CREATE INDEX [WDIDX_ConnUtil_Name] ON [ConnUtil] ([Name]);
-- Suppression de la table Communes DROP TABLE [Communes] ; -- Création de la table Communes CREATE TABLE [Communes] ( [CO_CODE] INTEGER NOT NULL , [CO_FRANCAIS] VARCHAR(60) NOT NULL , [CO_ALLEMAND] VARCHAR(60) NOT NULL , [CO_NOTE] VARCHAR(5) NOT NULL , [CO_CANTON] INTEGER NOT NULL , [CO_CODE_ARRONDISSEMENT] INTEGER NOT NULL , [CO_ARRONDISSEMENT] VARCHAR(50) NOT NULL , [CO_NPA] INTEGER NOT NULL , [CO_ADRESSE_POSTAL] TEXT NOT NULL , [CO_TELEPHONE] VARCHAR(30) NOT NULL , [CO_FAX] VARCHAR(30) NOT NULL ); CREATE INDEX [WDIDX_Communes_CO_CODE] ON [Communes] ([CO_CODE]); CREATE INDEX [WDIDX_Communes_CO_FRANCAIS] ON [Communes] ([CO_FRANCAIS]); CREATE INDEX [WDIDX_Communes_CO_ALLEMAND] ON [Communes] ([CO_ALLEMAND]); CREATE INDEX [WDIDX_Communes_CO_CODE_ARRONDISSEMENT] ON [Communes] ([CO_CODE_ARRONDISSEMENT]); CREATE INDEX [WDIDX_Communes_CO_ARRONDISSEMENT] ON [Communes] ([CO_ARRONDISSEMENT]); CREATE INDEX [WDIDX_Communes_CO_TELEPHONE] ON [Communes] ([CO_TELEPHONE]); CREATE INDEX [WDIDX_Communes_CO_FAX] ON [Communes] ([CO_FAX]);
-- Suppression de la table brouilla DROP TABLE [brouilla] ; -- Création de la table brouilla CREATE TABLE [brouilla] ( [ANNEE] VARCHAR(4) NOT NULL , [NAISSANCES] TINYINT NOT NULL , [MARIAGES] TINYINT NOT NULL , [DECES] TINYINT NOT NULL , [RECONNAISSANCES] TINYINT NOT NULL , [ADOPTIONS] TINYINT NOT NULL , [DIVORCES] TINYINT NOT NULL , [NATUR_REINTEGR] TINYINT NOT NULL , [CHG_DE_NOM] TINYINT NOT NULL , [RECTIF_RADIAT] TINYINT NOT NULL , [DIVERS] TINYINT NOT NULL , [NOM_TITULAIRES] TEXT NOT NULL , [NO_FEUILLET] VARCHAR(8) NOT NULL , [MAR_PER_MER] TINYINT NOT NULL , [NOM_RECH] VARCHAR(100) NOT NULL , [ETAT_CIVIL] VARCHAR(30) NOT NULL , [NB_PERSONNES] SMALLINT NOT NULL , [DATE_JOURNAL] DATETIME NOT NULL ); CREATE INDEX [WDIDX_brouilla_NO_FEUILLET] ON [brouilla] ([NO_FEUILLET]); CREATE INDEX [WDIDX_brouilla_NOM_RECH] ON [brouilla] ([NOM_RECH]); CREATE INDEX [WDIDX_brouilla_ETAT_CIVIL] ON [brouilla] ([ETAT_CIVIL]); CREATE INDEX [WDIDX_brouilla_DATE_JOURNAL] ON [brouilla] ([DATE_JOURNAL]); --Contraintes d'intégrité ALTER TABLE [USER] ADD FOREIGN KEY ([GroupName]) REFERENCES [GROUP] ([GroupName]); ALTER TABLE [ConnUtil] ADD FOREIGN KEY ([Name]) REFERENCES [USER] ([Name]); ALTER TABLE [HIST_OFS] ADD FOREIGN KEY ([FICHIER_OFS]) REFERENCES [DISQ_OFS] ([FICHIER_OFS]);