postgresql sql create table

发布时间：2020-12-13 17:22:04 所属栏目：百科来源：网络整理

导读：postgresql create table: BEGIN;CREATE TABLE t1 (idBIGSERIAL PRIMARY KEY,addressINTERGER DEFAULT '',nameVARCHAR UNIQUE NOT NULL,didVARCHAR,countINTERGER NOT NULL,moneyDOUBLE PRECISION NOT NULL DEFAULT 0,CONSTRAINT money_check (money = 0),ra

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;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!