← Back to branch summary

~halega/+junk/sqlinstaller

« back to all changes in this revision

Viewing changes to SQLInstaller.Sample/Scripts/SQLite/Install/Tables/EMPLOYEES.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/SQLite/Install/Tables/EMPLOYEES.Table.sql
 
1
CREATE TABLE EMPLOYEES 
 
2
(
 
3
    EMPLOYEEid decimal NOT NULL,
 
4
    LASTNAME varchar(20) NOT NULL,
 
5
    FIRSTNAME varchar(10) NOT NULL,
 
6
    TITLE varchar(30),
 
7
    TITLEOFCOURTESY varchar(25),
 
8
    BIRTHDATE date,
 
9
    HIREDATE date,
 
10
    ADDRESS varchar(60),
 
11
    CITY varchar(15),
 
12
    REGION varchar(15),
 
13
    POSTALCODE varchar(10),
 
14
    COUNTRY varchar(15),
 
15
    HOMEPHONE varchar(24),
 
16
    EXTENSION varchar(4),
 
17
    PHOTOPATH varchar(255),
 
18
    NOTES varchar(1000),
 
19
    REPORTSTO decimal,
 
20
    PRIMARY KEY(EMPLOYEEID)
 
21
);
 
22
 
 
23
CREATE INDEX EMPLOYEES_LASTNAME_IDX ON EMPLOYEES (LASTNAME);
 
24
 
 
25
CREATE INDEX EMPLOYEES_POSTALCODE_IDX ON EMPLOYEES (POSTALCODE);