|
Last change
on this file since 110 was 2, checked in by Rick van der Zwet, 15 years ago |
|
Initial import of data of old repository ('data') worth keeping (e.g. tracking
means of URL access statistics)
|
-
Property svn:executable
set to
*
|
|
File size:
397 bytes
|
| Line | |
|---|
| 1 | CREATE TABLE Branch (
|
|---|
| 2 | branch_no VARCHAR(10),
|
|---|
| 3 | address VARCHAR(60),
|
|---|
| 4 | phone VARCHAR(13),
|
|---|
| 5 | fax VARCHAR(13),
|
|---|
| 6 | PRIMARY KEY (branch_no)
|
|---|
| 7 | );
|
|---|
| 8 |
|
|---|
| 9 | INSERT INTO Branch VALUES ('1','Niels Bohrweg 1','071-5272222','071-5272345');
|
|---|
| 10 | INSERT INTO Branch VALUES ('2','Einsteinweg 5','071-5272332','071-5273345');
|
|---|
| 11 | INSERT INTO Branch VALUES ('3','Rapenburg 70','071-5271234','071-5278970');
|
|---|
| 12 |
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
