io.odysz.semantic.meta.AutoSeqMeta Maven / Gradle / Ivy

Go to download
package io.odysz.semantic.meta;

/**
 * For Sqlite3,
 * CREATE TABLE if not exists %s (
 * sid text(50),
 * seq INTEGER,
 * remarks text(200),
 * CONSTRAINT oz_autoseq_pk PRIMARY KEY (sid));
 * 
 * Max rows (sid) is 2 ^ 64, which is not reachable in Sqlite3,
 * see 
 * 13. Maximum Number Of Rows In A Table
 * 
 * @author [email protected]
 */
public class AutoSeqMeta extends SemanticTableMeta {

	public AutoSeqMeta(String... conn) {
		super("oz_autoseq", conn);
	 
		ddlSqlite = String.format(
			"CREATE TABLE if not exists %s (\n" +
			"  sid text(50),\n" +
			"  seq INTEGER,\n" +
			"  remarks text(200),\n" +
			"  CONSTRAINT oz_autoseq_pk PRIMARY KEY (sid)\n" +
			");", tbl);
	}
}