3V0g8KLK

1require 'rubygems'
2require 'sqlite3'
3
4def create_db()
5  db = SQLite3::Database.new('golf_courses.db')
6  
7  address_string = "CREATE TABLE IF NOT EXISTS address (
8                    id INTEGER NOT NULL PRIMARY KEY,
9                    street TEXT,
10                    city TEXT,
11                    state TEXT,
12                    zip TEXT,
13                    country TEXT
14                    )"
15                    
16  course_string = "CREATE TABLE IF NOT EXISTS course (
17                    id INTEGER NOT NULL PRIMARY KEY,
18                    name TEXT,
19                    address_id INTEGER NOT NULL REFERENCES address(id),
20                    public TEXT,
21                    phone TEXT,
22                    holes TEXT,
23                    advance_tee TEXT,
24                    cost TEXT
25                    )"
26
27  db.execute(address_string)
28  db.execute(course_string)
29end
30
31create_db()