File: sample.sql

package info (click to toggle)
ruby-gnome2 0.15.0-1.1etch1
  • links: PTS
  • area: main
  • in suites: etch
  • size: 7,704 kB
  • ctags: 8,558
  • sloc: ansic: 69,912; ruby: 19,511; makefile: 97; xml: 35; 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 
);