lemon-project-template-glpk
view deps/glpk/examples/sql/transp.sql @ 9:33de93886c88
Import GLPK 4.47
author | Alpar Juttner <alpar@cs.elte.hu> |
---|---|
date | Sun, 06 Nov 2011 20:59:10 +0100 |
parents | |
children |
line source
1 CREATE DATABASE glpk;
2 CREATE USER glpk@localhost IDENTIFIED BY 'gnu';
3 GRANT ALL PRIVILEGES ON glpk.* TO glpk@localhost;
4 USE glpk;
5 # production capacity
6 DROP TABLE transp_capa;
7 CREATE TABLE transp_capa (
8 PLANT TEXT(127),
9 CAPA REAL,
10 PRIMARY KEY ( PLANT(127) )
11 );
12 INSERT INTO transp_capa ( PLANT, CAPA ) VALUES ( 'Seattle', 350 );
13 INSERT INTO transp_capa ( PLANT, CAPA ) VALUES ( 'San Diego', 600 );
14 # demand
15 DROP TABLE transp_demand;
16 CREATE TABLE transp_demand (
17 MARKET TEXT(127),
18 DEMAND REAL,
19 PRIMARY KEY ( MARKET(127) )
20 );
21 INSERT INTO transp_demand ( MARKET, DEMAND ) VALUES ( 'New York', 325 );
22 INSERT INTO transp_demand ( MARKET, DEMAND ) VALUES ( 'Chicago', 300 );
23 INSERT INTO transp_demand ( MARKET, DEMAND ) VALUES ( 'Topeka', 275 );
24 # distance
25 DROP TABLE transp_dist;
26 CREATE TABLE transp_dist (
27 LOC1 TEXT(127),
28 LOC2 TEXT(127),
29 DIST REAL,
30 PRIMARY KEY ( LOC1(127), LOC2(127) )
31 );
32 INSERT INTO transp_dist ( LOC1, LOC2, DIST ) VALUES ( 'Seattle', 'New York', 2.5 );
33 INSERT INTO transp_dist ( LOC1, LOC2, DIST ) VALUES ( 'Seattle', 'Chicago', 1.7 );
34 INSERT INTO transp_dist ( LOC1, LOC2, DIST ) VALUES ( 'Seattle', 'Topeka', 1.8 );
35 INSERT INTO transp_dist ( LOC1, LOC2, DIST ) VALUES ( 'San Diego', 'New York', 2.5 );
36 INSERT INTO transp_dist ( LOC1, LOC2, DIST ) VALUES ( 'San Diego', 'Chicago', 1.8 );
37 INSERT INTO transp_dist ( LOC1, LOC2, DIST ) VALUES ( 'San Diego', 'Topeka', 1.4 );
38 # result
39 DROP TABLE transp_result;
40 CREATE TABLE transp_result (
41 LOC1 TEXT(127),
42 LOC2 TEXT(127),
43 QUANTITY REAL,
44 PRIMARY KEY ( LOC1(127), LOC2(127) )
45 );