-- Valentina 7 SQL dump --
----------------------------------------------------
;
-- Create database
-- Note - the database creation will be skipped in case of database exists
-- But SET PROPERTY will be applied anyway
----------------------------------------------------
;
CREATE DATABASE IF NOT EXISTS [timereg] WITH
SET PROPERTY
[Mode],
[IdentsCaseSensitive],
[SegmentSize],
[SchemaVersion],
[DateTimeFormat],
[DateSeparator],
[TimeSeparator],
[KeyDelimiter],
[LocaleName],
[StorageEncoding],
[FrenchCollation],
[AlternateHandling],
[CaseFirst],
[CaseLevel],
[NormalizationMode],
[Strength],
[HiraganaQuaternaryMode],
[NumericCollation]
of DATABASE TO
'kDscDatBlbInd',
false,
32768,
1,
'kMDY',
'/',
':',
'.',
'nb_NO',
'UTF-16',
'kOff',
'kNonIgnorable',
'kOff',
'kOff',
'kOff',
'kSecondary',
'kOff',
'kOff';
;
USE [timereg];
-- Create KeyValues
-- Create types
-- Dump for 'Person' table
----------------------------------------------------
;
CREATE TABLE "Person" (
"Fornavn" VARCHAR (2044) ,
"Etternavn" VARCHAR (2044) ,
"Epost" VARCHAR (2044) ,
"Telefon" VARCHAR (2044) ,
"Kontonr" VARCHAR (2044) ,
"Adresse" VARCHAR (2044) ,
"Postnr" VARCHAR (2044) ,
"Poststed" VARCHAR (2044) );
-- Create KeyValues
-- Dump for 'Firma' table
----------------------------------------------------
;
CREATE TABLE "Firma" (
"Navn" VARCHAR (2044) );
-- Create KeyValues
-- Dump for 'Timene' table
----------------------------------------------------
;
CREATE TABLE "Timene" (
"Tid_start" DATETIME ,
"Tid_slutt" DATETIME ,
"Avtale" ULONG );
-- Create KeyValues
-- Dump for 'Avtale' table
----------------------------------------------------
;
CREATE TABLE "Avtale" (
"Overtid_pr_time" BOOLEAN ,
"Overtid_pr_uke" BOOLEAN ,
"Overtid_pr_hviletid" BOOLEAN ,
"Timerate" DOUBLE (4,6) ,
"Dato_fra" DATE ,
"Dato_til" DATE ,
"Firma" ULONG ,
"Person" ULONG );
-- Create KeyValues
-- Dump for 'Medarbeider' table
----------------------------------------------------
;
CREATE TABLE "Medarbeider" (
"Fornavn" VARCHAR (2044) ,
"Etternavn" VARCHAR (2044) ,
"epost" VARCHAR (2044) ,
"telefon" VARCHAR (2044) ,
"Firma" ULONG );
SET PROPERTY
[comment]
of TABLE "Medarbeider" TO
'Dette er ansatte i firmaer som skal kunne ha oversikt over og lage avtaler. Skal kunne hente ut oversikt for sine ansatte/personer.'
;
-- Create KeyValues
-- Dump for 'lnk_Firma_Avtale' link
----------------------------------------------------
;
ALTER TABLE "Avtale" MODIFY Firma OBJECTPTR CONSTRAINT "lnk_Firma_Avtale" REFERENCES "Firma" ON DELETE SET NULL;
-- Create KeyValues
-- Dump for 'lnk_Person_Avtale' link
----------------------------------------------------
;
ALTER TABLE "Avtale" MODIFY Person OBJECTPTR CONSTRAINT "lnk_Person_Avtale" REFERENCES "Person" ON DELETE RESTRICT;
-- Create KeyValues
-- Dump for 'lnk_Timene_Timene' link
----------------------------------------------------
;
ALTER TABLE "Timene" MODIFY Avtale OBJECTPTR CONSTRAINT "lnk_Timene_Timene" REFERENCES "Avtale" ON DELETE RESTRICT;
-- Create KeyValues
-- Dump for 'lnk_Firma_Medarbeider' link
----------------------------------------------------
;
ALTER TABLE "Medarbeider" MODIFY Firma OBJECTPTR CONSTRAINT "lnk_Firma_Medarbeider" REFERENCES "Firma" ON DELETE SET NULL;