01 package wodbupdate;
02
03 import java.sql.*;
04
05
06 public class Update1 extends Update {
07 // this is an example
08 public void executeUpdate() throws SQLException {
09 executeSQL("CREATE TABLE PERSON (NAME VARCHAR(255), OID INTEGER NOT NULL)");
10 executeSQL("SET UNIQUE = 1000000 FOR PERSON");
11 executeSQL("ALTER TABLE PERSON ADD PRIMARY KEY (OID) NOT DEFERRABLE INITIALLY IMMEDIATE");
12 }
13
14 }
|