← Back to branch summary

~halega/+junk/sqlinstaller

« back to all changes in this revision

Viewing changes to SQLInstaller.Sample/Scripts/Oracle/Install/Tables/CUSTOMERS.Table.sql

  • Committer: sk
  • Date: 2011-09-10 05:32:36 UTC
  • Revision ID: halega@halega.com-20110910053236-1877r3p0k4a64bgx
Tags: 1.2.2
1.2.2

Show diffs side-by-side

added added

removed removed

Lines of Context:
SQLInstaller.Sample/Scripts/Oracle/Install/Tables/CUSTOMERS.Table.sql
 
1
CREATE TABLE customers 
 
2
(
 
3
    customerid char(5) NOT NULL,
 
4
    companyname varchar(40) NOT NULL,
 
5
    contactname varchar(30),
 
6
    contacttitle varchar(30),
 
7
    address varchar(60),
 
8
    city varchar(15),
 
9
    region varchar(15),
 
10
    postalcode varchar(10),
 
11
    country varchar(15),
 
12
    phone varchar(24),
 
13
    fax varchar(24),
 
14
    PRIMARY KEY(customerid)
 
15
);
 
16
 
 
17
CREATE INDEX customers_city_idx ON customers (city);
 
18
CREATE INDEX customers_companyname_idx ON customers (companyname);
 
19
CREATE INDEX customers_postalcode_idx ON customers (postalcode);
 
20
CREATE INDEX customers_region_idx ON customers (region);