Category : Windows 3.X Files
Archive   : QWNSQL2C.ZIP
Filename : CREATE.SQL

 
Output of file : CREATE.SQL contained in archive : QWNSQL2C.ZIP
create table s (
sno char(5) not null,
sname char(20),
status smallint,
city char(15),
unique (sno)
);
create table p (
pno char(6) not null,
pname char(20),
color char(6),
weight smallint,
city char(15),
unique (pno)
);
create table j (
jno char(4) not null,
jname char(10),
city char(15),
unique (jno)
);
create table sp (
sno char(5) not null,
pno char(6) not null,
qty integer,
unique (sno, pno)
);
create table spj (
sno char(5) not null,
pno char(6) not null,
jno char(4) not null,
qty integer,
unique (sno, pno, jno)
);


  3 Responses to “Category : Windows 3.X Files
Archive   : QWNSQL2C.ZIP
Filename : CREATE.SQL

  1. Very nice! Thank you for this wonderful archive. I wonder why I found it only now. Long live the BBS file archives!

  2. This is so awesome! 😀 I’d be cool if you could download an entire archive of this at once, though.

  3. But one thing that puzzles me is the “mtswslnkmcjklsdlsbdmMICROSOFT” string. There is an article about it here. It is definitely worth a read: http://www.os2museum.com/wp/mtswslnk/