private void createTables() {
Connection connection = null;
Statement statement = null;
try {
connection = getConnection();
statement = connection.createStatement();
statement.execute("drop table if exists agent");
statement.execute(
"create table agent (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, username varchar(20), "
+ "emailaddress varchar(132), name varchar(132), city varchar(50), state char(2), "
+ "zipcode varchar(9), latitude DECIMAL(18,12), longitude DECIMAL(18,12), level smallint, "
+ "profileid char(21), imageurl varchar(132), role smallint, vetted char(1)) ");
statement.execute("create unique index agent1 on agent (emailaddress)");
statement.execute("create unique index agent2 on agent (profileid)");
statement.execute("drop table if exists googleapiclient");
statement.execute("create table googleapiclient (id varchar(132), secret varchar(50))");
statement.execute("drop table if exists geocache");
statement.execute(
"create table geocache "
+ "(query varchar(132) primary key, latitude DECIMAL(18,12), longitude DECIMAL(18,12), "
+ "formatted_address varchar(256) ,city varchar(50), state char(2), zipcode char(9) )");
statement.execute("drop table if exists comment");
statement.execute(
"create table comment (id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, commenttype smallint, commenttext varchar(256), emailaddress varchar(132), logtime timestamp)");
statement.execute("create index comment1 on comment (emailaddress)");
} catch (Exception e) {
e.printStackTrace();
} finally {
close(statement, connection);
}
GoogleApiClientDAO googleApiClientDAO = new GoogleApiClientDAO();
GoogleApiClient googleApiClient = new GoogleApiClient();
googleApiClient.setId(properties.getProperty("googleapiclientid"));
googleApiClient.setSecret(properties.getProperty("googleapisecret"));
googleApiClientDAO.insert(googleApiClient);
}
