← Back to branch summary

~halega/+junk/sqlinstaller

« back to all changes in this revision

Viewing changes to SQLInstaller.Sample/Scripts/MySql/Install/Tables/suppliers.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/MySql/Install/Tables/suppliers.Table.sql
 
1
CREATE TABLE suppliers 
 
2
(
 
3
    supplierid int NOT NULL AUTO_INCREMENT,
 
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
    homepage varchar(512),
 
15
    PRIMARY KEY (supplierid) 
 
16
) Type=InnoDB;
 
17
 
 
18
CREATE INDEX suppliers_companyname_idx ON suppliers (companyname);
 
19
CREATE INDEX suppliers_postalcode_idx ON suppliers (postalcode);