File: sample.sql

package info (click to toggle)
ruby-gnome2 0.17.0~rc1-6
  • links: PTS, VCS
  • area: main
  • in suites: lenny
  • size: 9,164 kB
  • ctags: 10,650
  • sloc: ansic: 80,703; ruby: 26,156; xml: 35; makefile: 21; sql: 13
file content (18 lines) | stat: -rw-r--r-- 431 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 

-- SQL definitions of tables needed by sample.rb.

drop table if exists customers;
create table customers (
    ref int unsigned not null auto_increment primary key,
    name varchar(50),
    surname varchar(50),
    phone varchar(50)
);

drop table if exists accounts;
create table accounts (
    ref int unsigned not null auto_increment primary key,
    ref_customer int unsigned references customers(ref),
    balance int 
);