private void createTable() {
		
		writeLine("-- create table --");
		writeLine("CREATE TABLE " + table.name);
		writeLine("(");
		write("id " + getPostgresqlType(table.idType));

		for (Column column:table.columns) {
			writeLine(",");
			write(column.name + " " + getPostgresqlType(column.dataType));
			if (column.nullable) {
				write(" NULL");
			} else {
				write(" NOT NULL");
			}
		}

		skipLine();
		writeLine(");");
		writeLine("/");
		skipLine();

		writeLine("ALTER TABLE " + table.name + " ADD CONSTRAINT PK_" + table.name + " PRIMARY KEY (ID);");
		writeLine("/");
		skipLine();			

		if (table.idGeneratorType.equals(IdGeneratorType.SEQUENCE)) {
			writeLine("-- create sequence --");
			writeLine("CREATE SEQUENCE " + sequenceName);
			writeLine("INCREMENT 1");
			writeLine("MINVALUE 0");
			writeLine("MAXVALUE 9223372036854775807");
			writeLine("START 0");
			writeLine("CACHE 1;");
			writeLine("/");
			skipLine();
		}
	}
private void createTable() {
		
		writeLine("-- create table --");
		writeLine("CREATE TABLE " + table.name);
		writeLine("(");
		write("id " + getPostgresqlType(table.idType));

		for (Column column:table.columns) {
			writeLine(",");
			write(column.name + " " + getPostgresqlType(column.dataType));
			if (column.nullable) {
				write(" NULL");
			} else {
				write(" NOT NULL");
			}
		}

		skipLine();
		writeLine(");");
		writeLine("/");
		skipLine();

		writeLine("ALTER TABLE " + table.name + " ADD CONSTRAINT PK_" + table.name + " PRIMARY KEY (ID);");
		writeLine("/");
		skipLine();			

		if (table.idGeneratorType.equals(IdGeneratorType.SEQUENCE)) {
			writeLine("-- create sequence --");
			writeLine("CREATE SEQUENCE " + sequenceName);
			writeLine("INCREMENT 1");
			writeLine("MINVALUE 0");
			writeLine("MAXVALUE 9223372036854775807");
			writeLine("START 0");
			writeLine("CACHE 1;");
			writeLine("/");
			skipLine();
		}
	}
private void createTable ( ) { writeLine ( "-- create table --" ) ; writeLine ( "CREATE TABLE " + table . name ) ; writeLine ( "(" ) ; write ( "id " + getPostgresqlType ( table . idType ) ) ; for ( Column column : table . columns ) { writeLine ( "," ) ; write ( column . name + " " + getPostgresqlType ( column . dataType ) ) ; if ( column . nullable ) { write ( " NULL" ) ; } else { write ( " NOT NULL" ) ; } } skipLine ( ) ; writeLine ( ");" ) ; writeLine ( "/" ) ; skipLine ( ) ; writeLine ( "ALTER TABLE " + table . name + " ADD CONSTRAINT PK_" + table . name + " PRIMARY KEY (ID);" ) ; writeLine ( "/" ) ; skipLine ( ) ; if ( table . idGeneratorType . equals ( IdGeneratorType . SEQUENCE ) ) { writeLine ( "-- create sequence --" ) ; writeLine ( "CREATE SEQUENCE " + sequenceName ) ; writeLine ( "INCREMENT 1" ) ; writeLine ( "MINVALUE 0" ) ; writeLine ( "MAXVALUE 9223372036854775807" ) ; writeLine ( "START 0" ) ; writeLine ( "CACHE 1;" ) ; writeLine ( "/" ) ; skipLine ( ) ; } }
/*
create table
/ * create table