constraints...

Pokrewne:

Cytat:

constraints...

Wiaz - Czw Sie 02, 2007 10:30 am
" />DDL:
Kod:CREATE TABLE [dostawca]
(
[id] INTEGER primary key autoincrement not null,
[nazwa] VARCHAR (100) unique not null,
[uwagi] TEXT
)

in modify table schema there is not checked 'unique' and 'not null'.
in some another cases there are checked constraints, e.g.:
DDL:
Kod:CREATE TABLE [el_modul]
(
[id] INTEGER PRIMARY KEY autoincrement not null ,
[desygnator] VARCHAR
(
100
)
not null,
[id_modul] INTEGER references modul
(
id
)
not null,
[id_element] INTEGER references element
(
id
)
not null,
[uwagi] TEXT,
UNIQUE
(
id_modul,
desygnator
)
)

DDL:
Kod:CREATE TABLE [produkt]
(
[id] INTEGER PRIMARY KEY autoincrement not null,
[nazwa] VARCHAR
(
100
)
unique not null,
[w_produkcji] INTEGER default '0',
[uwagi] TEXT
)
there is default value checked but there is empty editbox on [w_produkcji]. On [nazwa] no checkbox is checked.

Googie - Czw Sie 02, 2007 10:49 am
" />Will be fixed in beta3.

Darmowy hosting zapewnia PRV.PL