home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
ftp.sanbilgisayar.com
/
ftp.sanbilgisayar.com.tar
/
ftp.sanbilgisayar.com
/
FlyTicket
/
AirLineFiy.sql
next >
Wrap
Text File
|
2007-02-01
|
515b
|
23 lines
CREATE TABLE [dbo].[AirLineFiy] (
[AirLine] [varchar] (6) NOT NULL ,
[BasTarih] [datetime] NOT NULL ,
[BitTarih] [datetime] NOT NULL ,
[Doviz] [varchar] (3) NOT NULL ,
[AceFiyat] [float] NULL ,
[AceOran] [smallint] NULL ,
[SatFiyat] [float] NULL ,
[SatOran] [smallint] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[AirLineFiy] ADD
CONSTRAINT [PK_AirLineFiy] PRIMARY KEY NONCLUSTERED
(
[AirLine],
[BasTarih],
[BitTarih],
[Doviz]
) WITH FILLFACTOR = 90 ON [PRIMARY]
GO