← Back to branch summary

~halega/+junk/sqlinstaller

« back to all changes in this revision

Viewing changes to SQLInstaller.Sample/Scripts/Firebird/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/Firebird/Install/Tables/CUSTOMERS.Table.sql
 
1
CREATE TABLE CUSTOMERS 
 
2
(
 
3
    CUSTOMERID varchar(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);