Generovßnφ SQL skriptu

---

Ukßzka vygenerovanΘ HTML dokumentace

Aplikace umo₧≥uje v²b∞r z n∞kolika databßzov²ch server∙, pro kterΘ bude skript vygenerovßn.
Tento v²b∞r mß vliv na syntaxi skriptu a na pou₧itΘ datovΘ typy.
V souΦasnΘ dob∞ jsou podporovßny tyto servery: Centura SQLBase, Microsoft SQL Server, Oracle, Sybase.
P°ipravuje se: Progress, MySQL, WinBase602 a dalÜφ...

Ukßzka vygenerovanΘho skriptu pro Centura SQLBase

CREATE TABLE MESIC (
   ROK_ID SMALLINT NOT NULL,
   MESIC_ID DECIMAL (6,0) NOT NULL,
   MESIC_JM CHAR (20)
);

CREATE UNIQUE INDEX IPK_MESIC ON MESIC (ROK_ID ASC, MESIC_ID ASC);
ALTER TABLE MESIC PRIMARY KEY (ROK_ID,MESIC_ID);

CREATE TABLE OBLAST (
   OBLAST_ID SMALLINT NOT NULL,
   OBLAST_JM CHAR (30)
);

CREATE UNIQUE INDEX IPK_OBLAST ON OBLAST (OBLAST_ID ASC);
ALTER TABLE OBLAST PRIMARY KEY (OBLAST_ID);

CREATE TABLE PRODEJ (
   VYROBEK_ID INTEGER NOT NULL,
   PRODEJNA_ID INTEGER NOT NULL,
   ROK_ID SMALLINT NOT NULL,
   MESIC_ID DECIMAL (6,0) NOT NULL,
   KUSU INTEGER,
   CENA DECIMAL (9,2),
   OBRAT DECIMAL (9,2),
   FLAG SMALLINT,
   OBLAST_ID SMALLINT NOT NULL
);

CREATE UNIQUE INDEX IPK_PRODEJ ON PRODEJ (VYROBEK_ID ASC, PRODEJNA_ID ASC, ROK_ID ASC, MESIC_ID ASC);
ALTER TABLE PRODEJ PRIMARY KEY (VYROBEK_ID,PRODEJNA_ID,ROK_ID,MESIC_ID);

CREATE TABLE PRODEJNA (
   PRODEJNA_ID INTEGER NOT NULL,
   OBLAST_ID SMALLINT NOT NULL,
   PRODEJNA_JM CHAR (30),
   PRODEJNA_ADR CHAR (30)
);

CREATE UNIQUE INDEX IPK_PRODEJNA ON PRODEJNA (PRODEJNA_ID ASC);
ALTER TABLE PRODEJNA PRIMARY KEY (PRODEJNA_ID);

CREATE TABLE ROK (
   ROK_ID SMALLINT NOT NULL,
   ROK_JM CHAR (10)
);

CREATE UNIQUE INDEX IPK_ROK ON ROK (ROK_ID ASC);
ALTER TABLE ROK PRIMARY KEY (ROK_ID);

CREATE TABLE SKUPINA (
   SKUPINA_ID SMALLINT NOT NULL,
   SKUPINA_JM CHAR (30)
);

CREATE UNIQUE INDEX IPK_SKUPINA ON SKUPINA (SKUPINA_ID ASC);
ALTER TABLE SKUPINA PRIMARY KEY (SKUPINA_ID);

CREATE TABLE VYROBEK (
   VYROBEK_ID INTEGER NOT NULL,
   SKUPINA_ID SMALLINT NOT NULL,
   VYROBEK_JM CHAR (30)
);

CREATE UNIQUE INDEX IPK_VYROBEK ON VYROBEK (VYROBEK_ID ASC);
ALTER TABLE VYROBEK PRIMARY KEY (VYROBEK_ID);


ALTER TABLE MESIC FOREIGN KEY rok_mes (ROK_ID)
   REFERENCES ROK ON DELETE RESTRICT;
ALTER TABLE PRODEJ FOREIGN KEY mesic2p (ROK_ID,MESIC_ID)
   REFERENCES MESIC ON DELETE RESTRICT;
ALTER TABLE PRODEJ FOREIGN KEY prodejna2p (PRODEJNA_ID)
   REFERENCES PRODEJNA ON DELETE RESTRICT;
ALTER TABLE PRODEJ FOREIGN KEY vyrobek2p (VYROBEK_ID)
   REFERENCES VYROBEK ON DELETE RESTRICT;
ALTER TABLE PRODEJNA FOREIGN KEY obl_pro (OBLAST_ID)
   REFERENCES OBLAST ON DELETE RESTRICT;
ALTER TABLE VYROBEK FOREIGN KEY sku_vyr (SKUPINA_ID)
   REFERENCES SKUPINA ON DELETE RESTRICT;
ALTER TABLE PRODEJ FOREIGN KEY oblast2p (OBLAST_ID)
   REFERENCES OBLAST ON DELETE RESTRICT;


CREATE INDEX xprodej_oblast ON PRODEJ (OBLAST_ID ASC);
CREATE INDEX xprodej_vyrobek ON PRODEJ (VYROBEK_ID ASC);
CREATE INDEX xprodej_rok ON PRODEJ (ROK_ID DESC);
CREATE INDEX xprodej_prodejna ON PRODEJ (PRODEJNA_ID ASC);
CREATE INDEX xprodej_mesic ON PRODEJ (MESIC_ID ASC);