connect to demodb;

drop table sinn.customer;

create table  customer
(cusnum INTEGER NOT NULL,
name VARCHAR(50),
type CHAR(4),
noOfEmp BIGINT,
description CHAR(200),
address CHAR(100),
totalRevenue BIGINT,
salesperson CHAR(60),
primary key(cusnum));

insert into  customer
(cusnum, name, type, noOfEmp, description, address, totalRevenue, salesperson)
values
(5001,
'Siebel Systems, Inc.',
'TECH',
5909,
'provider of e-business applications software',
'2207 Bridgepointe Parkway, San Mateo, CA 94404', 
394736000,
'cn=Susan Moller, ou=West, ou=Sales, o=Company, c=US');
 
insert into  customer
(cusnum, name, type, noOfEmp, description, address, totalRevenue, salesperson)
values
(5002,
'SAP AKTIENGESELL',
'ERP',
28654,
'provider of e-business software solutions',
'Neurottstrasse 16, 69190 Walldorf Walldorf, Germany',
200000,
'cn=Jim Iring, ou=East, ou=Sales, o=Company, c=US');

insert into  customer
(cusnum, name, type, noOfEmp, description, address, totalRevenue, salesperson)
values
(5003,
'IBM',
'BLUE',
315889,
'manufactures and sells computer services, hardware and software',
'One New Orchard Road Armonk, NY 10504',
22913000000,
'cn=Robert Lee, ou=East, ou=Sales, o=Company, c=US');

insert into  customer
(cusnum, name, type, noOfEmp, description, address, totalRevenue, salesperson)
values
(5004,
'Citigroup',
'FINA',
250000,
'diversified global financial services holding company whose businesses provide a broad range of financial services to consumer and corporate customers',
'399 Park Avenue New York, NY 10043',
22956000000,
'cn=Ann Nish, ou=East, ou=Sales, o=Company, c=US');

insert into  customer
(cusnum, name, type, noOfEmp, description, address, totalRevenue, salesperson)
values
(5005,
'Cisco Systems',
'TECH',
36000,
'manufactures and sells networking and communications products, and provides services associated with that equipment and its use',
'170 West Tasman Drive San Jose, CA 95134',
4713000000,
'cn=Jenny Chan, ou=West, ou=Sales, o=Company, c=US');

insert into  customer
(cusnum, name, type, noOfEmp, description, address, totalRevenue, salesperson)
values
(5006,
'Sanrio',
'RETL',
36000,
'Retail system',
'Great Mall',
4713000000,
'cn=Jenny Chan, ou=West, ou=Sales, o=Company, c=US');