Mercurial > sqlpython
view sqlpython/setup_test_db.sql @ 189:c5398d87498e
cat bug
author | catherine@dellzilla |
---|---|
date | Mon, 17 Nov 2008 14:26:53 -0500 |
parents | |
children |
line wrap: on
line source
CREATE USER testdata IDENTIFIED BY testdata; GRANT connect, resource TO testdata; CONNECT testdata/testdata@orcl DROP TABLE species; CREATE TABLE species ( id NUMBER(6,0) CONSTRAINT xpk_species PRIMARY KEY CONSTRAINT xnn1_species NOT NULL, name VARCHAR2(40) CONSTRAINT xnn2_species NOT NULL ); INSERT INTO species VALUES (0, 'turtle'); INSERT INTO species VALUES (1, 'python'); INSERT INTO species VALUES (2, 'parrot');