summaryrefslogtreecommitdiffstats
path: root/sandbox/lresende/sca/samples/organization-das/organization.sql
diff options
context:
space:
mode:
authorlresende <lresende@13f79535-47bb-0310-9956-ffa450edef68>2010-01-13 01:41:50 +0000
committerlresende <lresende@13f79535-47bb-0310-9956-ffa450edef68>2010-01-13 01:41:50 +0000
commitaca1633212fe261c04861cd48ab53b5081089fd2 (patch)
tree41f9e8fa66e1b78204ae15071fd611d7205877a1 /sandbox/lresende/sca/samples/organization-das/organization.sql
parent8eb5bf1de6c82c6d6e2932630be767aaa086a2b8 (diff)
Cleaning up sandbox
git-svn-id: http://svn.us.apache.org/repos/asf/tuscany@898604 13f79535-47bb-0310-9956-ffa450edef68
Diffstat (limited to 'sandbox/lresende/sca/samples/organization-das/organization.sql')
-rw-r--r--sandbox/lresende/sca/samples/organization-das/organization.sql33
1 files changed, 0 insertions, 33 deletions
diff --git a/sandbox/lresende/sca/samples/organization-das/organization.sql b/sandbox/lresende/sca/samples/organization-das/organization.sql
deleted file mode 100644
index 3990fa3166..0000000000
--- a/sandbox/lresende/sca/samples/organization-das/organization.sql
+++ /dev/null
@@ -1,33 +0,0 @@
-DROP TABLE ACCOUNT;
-DROP TABLE ORGANIZATIONTYPELIST;
-
-CREATE TABLE ACCOUNT (
- ACCOUNT_ID INT PRIMARY KEY NOT NULL GENERATED ALWAYS AS IDENTITY,
- ACCOUNTTYPE_CD VARCHAR(30),
- ACCOUNT_NAME VARCHAR(30),
- WEB_SITE_ADDRESS VARCHAR(30),
- STREET_ADDRESS_1 VARCHAR(30),
- STREET_ADDRESS_2 VARCHAR(30),
- STREET_ADDRESS_3 VARCHAR(30),
- CITY VARCHAR(10),
- STATE_CD VARCHAR(2),
- POSTAL_CD VARCHAR(5),
- COUNTRY_CD VARCHAR(3),
- PHONE_NUMBER VARCHAR(15),
- FAX_NUMBER VARCHAR(15),
- NOTE VARCHAR(50));
-
-CREATE TABLE ORGANIZATIONTYPELIST (
- ORGANIZATIONTYPEID INT PRIMARY KEY NOT NULL GENERATED ALWAYS AS IDENTITY,
- CODE VARCHAR(10),
- DISPLAYVALUE VARCHAR(30),
- DESCRIPTION VARCHAR(30),
- ISEDITABLE INT);
-
-
-INSERT INTO ACCOUNT (ACCOUNTTYPE_CD, ACCOUNT_NAME, WEB_SITE_ADDRESS, STREET_ADDRESS_1, STREET_ADDRESS_2, STREET_ADDRESS_3, CITY, STATE_CD, POSTAL_CD, COUNTRY_CD, PHONE_NUMBER, FAX_NUMBER, NOTE) VALUES ('ACC_TYPE_01', 'NAME_001', 'http://name_001.com', '1234 Street 1', '', '', 'San Jose', 'CA', '95134', 'USA', '', '', 'NAME 001 NOTES');
-
-
-INSERT INTO ORGANIZATIONTYPELIST (CODE, DISPLAYVALUE, DESCRIPTION, ISEDITABLE) VALUES('ACME', 'ACME Organization', 'ACME Description', 0 );
-INSERT INTO ORGANIZATIONTYPELIST (CODE, DISPLAYVALUE, DESCRIPTION, ISEDITABLE) VALUES('DO-RITE', 'DO-RITE Plumbing', 'DO-RITE Plumbing Description', 0 );
-INSERT INTO ORGANIZATIONTYPELIST (CODE, DISPLAYVALUE, DESCRIPTION, ISEDITABLE) VALUES('MEGACORP', 'MEGACORP Organization', 'MEGACORP Description', 0 );