diff options
author | lresende <lresende@13f79535-47bb-0310-9956-ffa450edef68> | 2010-01-13 01:41:50 +0000 |
---|---|---|
committer | lresende <lresende@13f79535-47bb-0310-9956-ffa450edef68> | 2010-01-13 01:41:50 +0000 |
commit | aca1633212fe261c04861cd48ab53b5081089fd2 (patch) | |
tree | 41f9e8fa66e1b78204ae15071fd611d7205877a1 /sandbox/lresende/sca/samples/organization-das/organization.sql | |
parent | 8eb5bf1de6c82c6d6e2932630be767aaa086a2b8 (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.sql | 33 |
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 ); |