postgresql create table:

BEGIN;

CREATE TABLE t1 (
	id		BIGSERIAL PRIMARY KEY,address	INTERGER DEFAULT '',name	VARCHAR UNIQUE NOT NULL,did		VARCHAR,count	INTERGER NOT NULL,money	DOUBLE PRECISION NOT NULL DEFAULT 0,CONSTRAINT money_check (money >= 0),ratio	REAL NOT NULL DEFAULT 0,tm		TIMESTAMP,pass	BOOLEAN NOT NULL DEFAULT FALSE,);
CREATE TABLE t2 (
	p_id		BITINT NOT NULL,ticket_id	BITINT NOT NULL,"type"		VARCHAR NOT NULL,PRIMARY KEY (p_id,ticket_id)
);
CREATE INDEX ticket_player ON t2(p_id);

COMMIT;