Mercurial > sqlpython
view sqlpython/setup_test_db.sql @ 497:128aa57c4b8d
first try at switching postgres query to dbapiext form
author | Catherine Devlin <catherine.devlin@gmail.com> |
---|---|
date | Wed, 27 Oct 2010 10:04:31 -0400 |
parents | c5398d87498e |
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');