blob: 5397570935e5474f08007ed643d40a7703d28cc4 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
|
DROP TABLE IF EXISTS DBMSes;
CREATE TABLE DBMSes (
DBMS_name VARCHAR(30) PRIMARY KEY,
DBMS_available_as_FLOSS BOOLEAN NOT NULL,
language_name VARCHAR(30)
);
INSERT INTO DBMSes VALUES('IndexedDB', TRUE, 'JavaScript');
INSERT INTO DBMSes VALUES('Mnesia', TRUE, 'Erlang');
INSERT INTO DBMSes VALUES('MySQL', TRUE, NULL);
INSERT INTO DBMSes VALUES('SQL Server', FALSE, NULL);
DROP TABLE IF EXISTS languages;
CREATE TABLE languages (
language_name VARCHAR(30) PRIMARY KEY
);
INSERT INTO languages VALUES('C');
INSERT INTO languages VALUES('Erlang');
INSERT INTO languages VALUES('Java');
INSERT INTO languages VALUES('JavaScript');
INSERT INTO languages VALUES('Python');
|
