Definitions More Info.
Definition ID	624
Title	POSTGRESQL
Category	SCRIPT
Definition	Sequence olusturma_identity
Definition Description	/* PGSQL Backup Source Server Version: 9.4.0 Source Database: hede Date: 09.02.2015 16:44:54 */ -- ---------------------------- -- Sequence definition for "public"."hedeSequence" -- ---------------------------- DROP SEQUENCE "public"."hedeSequence"; CREATE SEQUENCE "public"."hedeSequence" INCREMENT 1 MINVALUE 100 MAXVALUE 9223372036854775807 START 101 CACHE 1;; -- ---------------------------- -- Sequence definition for "public"."TestTable_ID_seq" -- ---------------------------- DROP SEQUENCE "public"."TestTable_ID_seq"; CREATE SEQUENCE "public"."TestTable_ID_seq" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 8 CACHE 1; SELECT setval('"public"."TestTable_ID_seq"', 8, true);; -- ---------------------------- -- Table structure for "public"."TestTable" -- ---------------------------- DROP TABLE "public"."TestTable"; CREATE TABLE "public"."TestTable" ( "ID" int2 DEFAULT nextval('"TestTable_ID_seq"'::regclass) NOT NULL, "name" char(55) COLLATE "default", "surname" char(55) COLLATE "default", "email" char(55) COLLATE "default", PRIMARY KEY ("ID") ) WITH (OIDS=FALSE) ;; -- ---------------------------- -- Table structure for "public"."Customer" -- ---------------------------- DROP TABLE "public"."Customer"; CREATE TABLE "public"."Customer" ( "ID" int2 DEFAULT nextval('"TestTable_ID_seq"'::regclass) NOT NULL, "name" char(55) COLLATE "default", "surname" char(55) COLLATE "default", "email" char(55) COLLATE "default" ) INHERITS ("public"."TestTable") WITH (OIDS=FALSE) ;; -- ---------------------------- -- Table structure for "public"."TestTable" -- ---------------------------- DROP TABLE "public"."TestTable"; CREATE TABLE "public"."TestTable" ( "ID" int2 DEFAULT nextval('"TestTable_ID_seq"'::regclass) NOT NULL, "name" char(55) COLLATE "default", "surname" char(55) COLLATE "default", "email" char(55) COLLATE "default", PRIMARY KEY ("ID") ) WITH (OIDS=FALSE) ;; -- ---------------------------- -- Records -- ---------------------------- INSERT INTO "public"."Customer" VALUES ('3','Cuneyd','Tanriverdi','[email protected]'); INSERT INTO "public"."Customer" VALUES ('5','Cuneyd','Tanriverdi','[email protected]'); INSERT INTO "public"."Customer" VALUES ('6','Niki ','Lauda ','[email protected]'); INSERT INTO "public"."Customer" VALUES ('7','Hugo ','Hernandez ','[email protected] '); INSERT INTO "public"."Customer" VALUES ('8','Cuneyd','Tanriverdi','[email protected]'); INSERT INTO "public"."TestTable" VALUES ('1','Cuneyd','Tanriverdi','[email protected]'); INSERT INTO "public"."TestTable" VALUES ('2','Niki ','Lauda ','[email protected]'); INSERT INTO "public"."TestTable" VALUES ('3','Cuneyd','Tanriverdi','[email protected]'); INSERT INTO "public"."TestTable" VALUES ('4','Hugo ','Hernandez ','[email protected] '); INSERT INTO "public"."TestTable" VALUES ('5','Cuneyd','Tanriverdi','[email protected]'); INSERT INTO "public"."TestTable" VALUES ('6','Niki ','Lauda ','[email protected]'); INSERT INTO "public"."TestTable" VALUES ('7','Hugo ','Hernandez ','[email protected] '); INSERT INTO "public"."TestTable" VALUES ('8','Cuneyd','Tanriverdi','[email protected]'); -- ---------------------------- -- Index definition for "public"."TestTable" -- ---------------------------- CREATE INDEX "TestTable_idx_Name" ON "public"."TestTable" USING btree (name);
RecordBy	cunay
Record Date	12-02-2015 09:10:12
Düzenle
Kopyala
Sil