ติดตั้งโปรแกรมเบี้ยยังชีพ อปท. ใช้ PostgreSQL

ติดตั้งโปรแกรมเบี้ยยังชีพ อปท. ใช้ PostgreSQL 9.5x86 เป็นฐานข้อมูล
ตัวใหม่มาแทน MariaDB

 

สำรวจเครื่องลงบน windows 7 ใช้ได้กับ windows 7x86 และ windows 7x64

 

ติดตั้งเลย

 

ติดตั้งเลย ...ต่อ.1.

 

ติดตั้งเลย ...ต่อ.2.

 

โหลดโปรแกรมที่นี่

ดาวน์โหลด PostgreSQL
http://www.enterprisedb.com/products-services-training/pgdownload#windows

ดาวน์โหลด jdk7u40
http://www.oracle.com/technetwork/j...ownloads-javase7-521261.html#jdk-7u40-oth-JPR

 

สร้าง dbolder ก่อน

CREATE SCHEMA postgres
AUTHORIZATION postgres;

GRANT ALL ON SCHEMA postgres TO postgres;
=======Old================================
CREATE SCHEMA public
AUTHORIZATION postgres;

GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO public;
COMMENT ON SCHEMA public
IS 'standard public schema';
==========================================

CREATE TABLE tblolder
(
codepk integer NOT NULL,
codeid character varying(7),
sexfk character varying(5),
titlefk character varying(15),
firstname character varying(30),
lastname character varying(30),
idcard character varying(17),
birthdate date,
banid character varying(10),
moo character varying(2),
typenamefk character varying(35),
accessfk character varying(35),
levelaccess character varying(2),
expiredate date,
getmoneyfk character varying(35),
methodmoneyfk character varying(25),
bankfk character varying(20),
bancee character varying(25),
caretakerf character varying(30),
caretakerl character varying(30),
moofullname character varying(3),
firstnameacc character varying(30),
lastnameacc character varying(30),
mooacc character varying(3),
box1 character varying(4),
box2 character varying(4),
box3 character varying(4),
moneyaccess real,
moneyaids real,
life character varying(25),
scomment character varying(30),
interaction character varying(1),
boxcal1 character varying(2),
boxcal2 character varying(2),
boxcal3 character varying(2),
health character varying(15),
fullnamechange character varying(50),
idcardchange character varying(17),
banidchange character varying(10),
moochange character varying(3),
duty real,
mydate date,
changechange character varying(25),
sdocument character varying(10),
notes character varying(60),
methodmoneyacc character varying(25),
bankacc character varying(20),
banceeacc character varying(25),
methodmoneyaids character varying(25),
bankaids character varying(20),
banceeaids character varying(25),
fullnamechange2 character varying(50),
idcardchange2 character varying(17),
banidchange2 character varying(10),
moochange2 character varying(3),
duty2 real,
mydate2 date,
changechange2 character varying(25),
document2 character varying(10),
notes2 character varying(60),
health2 character varying(15),
fullnamechange3 character varying(50),
idcardchange3 character varying(17),
banidchange3 character varying(10),
moochange3 character varying(3),
duty3 real,
mydate3 date,
changechange3 character varying(25),
document3 character varying(10),
notes3 character varying(60),
health3 character varying(15),
regacc date,
CONSTRAINT tblolder_pkey PRIMARY KEY (codepk)
)
WITH (
OIDS=FALSE
);
ALTER TABLE tblolder
OWNER TO postgres;


CREATE TABLE tblsetting
(
codepk integer NOT NULL,
codeid character varying(7),
interaction character varying(1),
budget character varying(4),
calymd date,
beforymd date,
budgetcompare character varying(4),
calymdcompare date,
beforymdcompare date,
CONSTRAINT tblsetting_pkey PRIMARY KEY (codepk)
)
WITH (
OIDS=FALSE
);
ALTER TABLE tblsetting
OWNER TO postgres;


CREATE TABLE tblbeenslow
(
codepk integer NOT NULL,
codeid character varying(7),
budget character varying(4),
strmonth character varying(10),
paydate date,
getdate date,
sexfk character varying(5),
fullname character varying(60),
idcard character varying(17),
banid character varying(10),
moo character varying(2),
typenamefk character varying(35),
totalmoney real,
scomment character varying(60),
status character varying(8),
CONSTRAINT tblbeenslow_pkey PRIMARY KEY (codepk)
)
WITH (
OIDS=FALSE
);
ALTER TABLE tblbeenslow
OWNER TO postgres;


CREATE TABLE tblcomplain
(
codepk integer NOT NULL,
codeid character varying(7),
budget character varying(4),
mydate date,
fullname character varying(60),
moo character varying(2),
age character varying(3),
typename character varying(30),
project character varying(120),
resultfk character varying(120),
resultfk2 character varying(120),
other character varying(120),
CONSTRAINT tblcomplain_pkey PRIMARY KEY (codepk)
)
WITH (
OIDS=FALSE
);
ALTER TABLE tblcomplain
OWNER TO postgres;


CREATE TABLE tbldescription
(
codepk integer NOT NULL,
codeid character varying(7),
budget character varying(4),
strmonth character varying(15),
typename character varying(3),
countpeople real,
totalmoney real,
countat character varying(60),
CONSTRAINT tbldescription_pkey PRIMARY KEY (codepk)
)
WITH (
OIDS=FALSE
);
ALTER TABLE tbldescription
OWNER TO postgres;


CREATE TABLE tblextrachange
(
codepk integer NOT NULL,
codeid character varying(7),
budget character varying(4),
strmonth character varying(10),
sexfk character varying(5),
fullname character varying(60),
idcard character varying(17),
birthdate date,
banid character varying(10),
moo character varying(2),
typenamefk character varying(35),
scomment character varying(80),
interaction character varying(1),
CONSTRAINT tblextrachange_pkey PRIMARY KEY (codepk)
)
WITH (
OIDS=FALSE
);
ALTER TABLE tblextrachange
OWNER TO postgres;


CREATE TABLE tblmoney
(
codepk integer NOT NULL,
codeid character varying(7),
budget character varying(4),
paydate date,
getmoneyold real,
getmoneyacc real,
totaloldcash real,
moneyoldcash real,
totaloldtran real,
moneyoldtran real,
totalacccash real,
moneyacccash real,
totalacctran real,
moneyacctran real,
totalaidscash real,
moneyaidscash real,
totalaidstran real,
moneyaidstran real,
backold real,
backacc real,
withdrawal character varying(7),
CONSTRAINT tblmoney_pkey PRIMARY KEY (codepk)
)
WITH (
OIDS=FALSE
);
ALTER TABLE tblmoney
OWNER TO postgres;


CREATE TABLE tblpersonpay
(
codepk integer NOT NULL,
codeid character varying(7),
budget character varying(4),
strmonth character varying(10),
paydate date,
fullname character varying(60),
moo character varying(3),
getmoney real,
balance real,
totalpeople real,
CONSTRAINT tblpersonpay_pkey PRIMARY KEY (codepk)
)
WITH (
OIDS=FALSE
);
ALTER TABLE tblpersonpay
OWNER TO postgres;


CREATE TABLE tblretier
(
codepk integer NOT NULL,
codeid character varying(7),
budget character varying(4),
fullname character varying(60),
idcard character varying(17),
banid character varying(10),
moo character varying(3),
birthdate date,
typename character varying(35),
status character varying(35),
dateat date,
datestop date,
scomment character varying(60),
CONSTRAINT tblretier_pkey PRIMARY KEY (codepk)
)
WITH (
OIDS=FALSE
);
ALTER TABLE tblretier
OWNER TO postgres;


CREATE TABLE tblsongkarn
(
codepk integer NOT NULL,
codeid character varying(7),
budget character varying(4),
peoplecount real,
moneycost real,
storeget character varying(60),
scomment date,
transfer character varying(60),
CONSTRAINT tblsongkarn_pkey PRIMARY KEY (codepk)
)
WITH (
OIDS=FALSE
);
ALTER TABLE tblsongkarn
OWNER TO postgres;

 

ตัวโปรแกรมนี้ยังไม่ปล่อยให้ดาวน์โหลดอยู่ในขั้นทดสอบอยู่ครับ