History for maihamadb (postgresql)

diffNo. 96: 2018/03/30 02:23:53



	

Change Sequence

maihamadb.public.member_member_id_seq

Maximum Value
9223372036854775807 -> 2147483647

maihamadb.public.member_address_member_address_id_seq

Maximum Value
9223372036854775807 -> 2147483647

maihamadb.public.member_service_member_service_id_seq

Maximum Value
9223372036854775807 -> 2147483647

maihamadb.public.product_product_id_seq

Maximum Value
9223372036854775807 -> 2147483647

maihamadb.nextschema.next_schema_product_product_id_seq

Maximum Value
9223372036854775807 -> 2147483647

diffNo. 95: 2017/03/03 21:20:54


	

table count: 36 -> 39

Add Table

Add Sequence

Add Procedure

diffNo. 94: 2017/03/03 21:19:59


	

table count: 39 -> 36

Delete Table

Delete Sequence

Delete Procedure

diffNo. 93: 2016/12/31 23:00:31



	

Change Table

VENDOR-NON COMPILABLE

Delete UQ
  • VENDOR-NON COMPILABLE_pkey
Change Index
Ix_Vendor_Index_NAME_CaseCrisis
Column"Next_ParentID" -> Next_ParentID

vendor_$_dollar

Delete UQ
  • vendor_$_dollar_pkey

diffNo. 92: 2016/11/26 18:31:42


	

table count: 36 -> 39

Add Table

Add Sequence

Add Procedure

diffNo. 91: 2016/11/26 18:20:28


	

table count: 39 -> 36

Delete Table

Delete Sequence

Delete Procedure

diffNo. 90: 2016/08/22 12:16:15



	

Change Table

vendor_check

Change Column
type_of_json
Typexml -> json

diffNo. 89: 2016/08/22 12:12:39


	

table count: 38 -> 39

Add Table

Change Table

vendor_check

Add Column
  • type_of_json

diffNo. 88: 2014/10/12 21:45:29



	

Add Table

Change Table

next_schema_product

Schema
exampledb.nextschema -> maihamadb.nextschema

VENDOR-NON COMPILABLE

Schema
exampledb.public -> maihamadb.public

member

Schema
exampledb.public -> maihamadb.public

member_address

Schema
exampledb.public -> maihamadb.public

member_login

Schema
exampledb.public -> maihamadb.public

member_security

Schema
exampledb.public -> maihamadb.public

member_service

Schema
exampledb.public -> maihamadb.public

member_status

Schema
exampledb.public -> maihamadb.public

member_withdrawal

Schema
exampledb.public -> maihamadb.public

product

Schema
exampledb.public -> maihamadb.public

product_category

Schema
exampledb.public -> maihamadb.public

product_status

Schema
exampledb.public -> maihamadb.public

purchase

Schema
exampledb.public -> maihamadb.public

purchase_payment

Schema
exampledb.public -> maihamadb.public

region

Schema
exampledb.public -> maihamadb.public

service_rank

Schema
exampledb.public -> maihamadb.public

summary_product

Schema
exampledb.public -> maihamadb.public

vendor_$_dollar

Schema
exampledb.public -> maihamadb.public

vendor_check

Schema
exampledb.public -> maihamadb.public

vendor_date_fk

Schema
exampledb.public -> maihamadb.public

vendor_date_pk

Schema
exampledb.public -> maihamadb.public

vendor_inherit_inu

Schema
exampledb.public -> maihamadb.public

vendor_inherit_neko

Schema
exampledb.public -> maihamadb.public

vendor_large_data

Schema
exampledb.public -> maihamadb.public

vendor_large_data_ref

Schema
exampledb.public -> maihamadb.public

vendor_part_man

Schema
exampledb.public -> maihamadb.public

vendor_part_man_high

Schema
exampledb.public -> maihamadb.public

vendor_uuid_bar

Schema
exampledb.public -> maihamadb.public

vendor_uuid_foo

Schema
exampledb.public -> maihamadb.public

white_compound_pk

Schema
exampledb.public -> maihamadb.public

white_compound_pk_ref

Schema
exampledb.public -> maihamadb.public

white_not_pk

Schema
exampledb.public -> maihamadb.public

white_xls_man

Schema
exampledb.public -> maihamadb.public

withdrawal_reason

Schema
exampledb.public -> maihamadb.public

Delete Table

Add Sequence

Delete Sequence

Add Procedure

Delete Procedure

diffNo. 87: 2014/09/13 20:11:07



	

Change Table

member_service

Add UQ
  • uq_member_service

diffNo. 86: 2014/09/13 20:08:14



	

Change Table

member_service

Add FK
  • fk_member_service_member

diffNo. 85: 2014/07/30 23:26:40


	

table count: 52 -> 38

Add Table

Delete Table

Add Procedure

Delete Procedure

diffNo. 84: 2014/07/30 18:41:49


	

table count: 36 -> 52

Add Table

Add Procedure

diffNo. 83: 2014/07/25 22:36:12


	

table count: 34 -> 36

Add Table

diffNo. 82: 2014/07/09 23:17:00



	

Change Table

VENDOR-NON COMPILABLE

Add Column
  • Next_ParentID
Add FK
  • Fk_Vendor_ForeignKey_NAME_CaseCrisis
Add Index
  • Ix_Vendor_Index_NAME_CaseCrisis

diffNo. 81: 2014/07/04 01:11:24


	

table count: 35 -> 34

Delete Table

diffNo. 80: 2014/07/04 00:59:25



	

Change Table

vendor_large_data

Add Index
  • ix_large_data_numeric_integer
  • ix_large_data_string

vendor_large_data_ref

Add FK
  • fk_vendor_large_data_ref_data
  • fk_vendor_large_data_ref_self
Add Index
  • ix_large_data_ref_date
  • ix_large_data_ref_nullable_dec
  • ix_large_data_ref_timestamp

diffNo. 79: 2014/07/03 18:56:08


	

table count: 34 -> 35

Add Table

Change Table

vendor_large_data

Delete Index
  • ix_large_data_numeric_integer
  • ix_large_data_string

vendor_large_data_ref

Delete FK
  • fk_vendor_large_data_ref_data
  • fk_vendor_large_data_ref_self
Delete Index
  • ix_large_data_ref_date
  • ix_large_data_ref_nullable_dec
  • ix_large_data_ref_timestamp

diffNo. 78: 2014/06/01 23:19:07


	

table count: 33 -> 34

Add Table

Add Sequence

diffNo. 77: 2013/11/30 23:29:00



	

Change Table

vendor_large_data

Add Index
  • ix_large_data_numeric_integer
  • ix_large_data_string

vendor_large_data_ref

Add FK
  • fk_vendor_large_data_ref_data
  • fk_vendor_large_data_ref_self
Add Index
  • ix_large_data_ref_date
  • ix_large_data_ref_nullable_dec
  • ix_large_data_ref_timestamp

diffNo. 76: 2013/11/30 20:55:26



	

Change Table

vendor_check

Add Column
  • type_of_float
  • type_of_real

vendor_large_data

Delete Index
  • ix_large_data_numeric_integer
  • ix_large_data_string

vendor_large_data_ref

Delete FK
  • fk_vendor_large_data_ref_data
  • fk_vendor_large_data_ref_self
Delete Index
  • ix_large_data_ref_date
  • ix_large_data_ref_nullable_dec
  • ix_large_data_ref_timestamp

diffNo. 75: 2013/07/06 21:49:15



	

Change Table

white_not_pk

Change Column
not_pk_integer
Typeint8 -> int4
Size19 -> 10

white_same_name

Change Column
same_name_integer
Typeint8 -> int4
Size19 -> 10

diffNo. 74: 2013/07/06 21:36:14



	

Change Table

nextschema.white_same_name

Change Column
same_name_id
Typeint8 -> int4
Size19 -> 10

diffNo. 73: 2013/07/05 01:13:39



	

Change Table

white_same_name

Delete FK
  • fk_white_same_name_product

diffNo. 72: 2013/07/04 02:27:28



	

Change Table

white_same_name_ref

Delete FK
  • fk_white_same_name_ref_next

diffNo. 71: 2013/07/04 02:25:08



	

Change Table

white_same_name_ref

Add Column
  • next_same_name_id
Add FK
  • fk_white_same_name_ref_next

diffNo. 70: 2013/07/04 02:20:08



	

Change Table

white_same_name_ref

Delete FK
  • fk_white_same_name_ref_next

diffNo. 69: 2013/07/04 02:15:04



	

Change Table

white_same_name_ref

Add FK
  • fk_white_same_name_ref_next

diffNo. 68: 2013/07/04 02:06:22



	

Change Table

nextschema.white_same_name

Change Column
same_name_id
Typeint4 -> int8
Size10 -> 19

nextschema.white_same_name_ref

Change Column
same_name_ref_id
Typeint4 -> int8
Size10 -> 19

diffNo. 67: 2013/07/04 01:53:06



	

Change Table

white_same_name

Add Column
  • next_schema_product_id
Add FK
  • fk_white_same_name_product

diffNo. 66: 2013/07/04 01:19:59



	

Add Table

Delete Table

diffNo. 65: 2013/07/04 01:17:28


	

table count: 29 -> 33

Add Table

diffNo. 64: 2012/09/11 22:04:06



	

Change Procedure

exampledb.public.sp_various_type_parameter

SourceHash
783a78b4 -> c06949cf

diffNo. 63: 2012/09/11 21:53:41



	

Change Procedure

exampledb.public.sp_various_type_parameter

SourceLine
12 -> 13
SourceSize
279 -> 305
SourceHash
e9d3b310 -> 783a78b4

diffNo. 62: 2012/09/11 21:47:37



	

Change Procedure

exampledb.public.sp_various_type_parameter

SourceSize
268 -> 279
SourceHash
5e1e686e -> e9d3b310

diffNo. 61: 2012/09/11 21:46:24



	

Change Procedure

exampledb.public.sp_various_type_parameter

SourceLine
11 -> 12
SourceSize
231 -> 268
SourceHash
13bd4ab2 -> 5e1e686e

diffNo. 60: 2012/09/11 21:32:33



	

Change Procedure

exampledb.public.sp_various_type_parameter

SourceHash
a37ca26d -> 13bd4ab2

diffNo. 59: 2012/09/11 12:43:25



	

Change Procedure

exampledb.public.sp_in_out_parameter

SourceSize
73 -> 83
SourceHash
e9ab68a6 -> 2b1690a2

exampledb.public.sp_result_set_parameter

SourceHash
24361cc -> b47bc12f

diffNo. 58: 2012/09/11 12:37:19



	

Change Procedure

exampledb.public.sp_result_set_parameter

SourceHash
b47bc12f -> 24361cc

diffNo. 57: 2012/09/11 12:35:52



	

Change Procedure

exampledb.public.sp_in_out_parameter

SourceHash
c6f8474b -> e9ab68a6

diffNo. 56: 2012/08/22 13:55:15



	

Change Procedure

exampledb.public.sp_in_out_parameter

SourceHash
3c16b43d -> c6f8474b

diffNo. 55: 2012/08/22 13:53:20



	

Delete Sequence

Change Procedure

exampledb.public.sp_in_out_parameter

SourceHash
c6f8474b -> 3c16b43d

diffNo. 54: 2012/08/19 02:12:43



	

Add Sequence

Delete Sequence

diffNo. 53: 2012/08/18 17:28:33



	

Add Sequence

diffNo. 52: 2012/07/05 17:15:27


	

table count: 30 -> 29

Delete Table

diffNo. 51: 2012/07/05 15:59:13


	

table count: 29 -> 30

Add Table

diffNo. 50: 2012/07/04 21:33:06


	

table count: 30 -> 29

Delete Table

diffNo. 49: 2012/06/07 17:50:22


	

table count: 29 -> 30

Add Table

diffNo. 48: 2012/05/28 14:22:46


	

table count: 27 -> 29

Add Table

diffNo. 47: 2012/05/28 12:45:47


	

table count: 30 -> 27

Delete Table

diffNo. 46: 2012/05/27 16:47:10


	

table count: 28 -> 30

Add Table

diffNo. 45: 2012/05/09 22:40:08


	

table count: 27 -> 28

Add Table

diffNo. 44: 2012/05/06 23:47:46


	

table count: 28 -> 27

Delete Table

diffNo. 43: 2012/05/03 22:53:33


	

table count: 27 -> 28

Add Table

diffNo. 42: 2012/04/22 21:47:38


	

table count: 28 -> 27

Delete Table

diffNo. 41: 2012/04/22 21:23:15


	

table count: 27 -> 28

Add Table

diffNo. 40: 2012/04/22 19:00:07


	

table count: 28 -> 27

Delete Table

diffNo. 39: 2012/04/20 21:56:10


	

table count: 1 -> 28

Add Table

diffNo. 38: 2012/04/19 14:05:42


	

table count: 27 -> 1

Delete Table

diffNo. 37: 2011/07/30 12:35:42


	

table count: 26 -> 27

Add Table

diffNo. 36: 2011/05/20 16:57:36


	

table count: 23 -> 26

Add Table

Change Table

member_address

Add Column
  • region_id
Add FK
  • fk_member_address_region

member_withdrawal

Delete Column
  • version_no

diffNo. 35: 2011/05/05 09:43:01


	

table count: 22 -> 23

Add Table

Change Table

member_security

Add Column
  • reminder_use_count

member_status

Delete UQ
  • uq_member_status_member_status_name

product

Add Column
  • product_category_code
  • regular_price
Add FK
  • fk_product_product_category

product_status

Add Column
  • display_order
Add UQ
  • uq_product_status_display_order
Delete UQ
  • uq_product_status_product_status_name

diffNo. 34: 2010/11/12 23:58:18



	

Change Table

vendor_large_data

Add Index
  • ix_large_data_numeric_integer
  • ix_large_data_string

vendor_large_data_ref

Add FK
  • fk_vendor_large_data_ref_data
  • fk_vendor_large_data_ref_self
Add Index
  • ix_large_data_ref_date
  • ix_large_data_ref_nullable_dec
  • ix_large_data_ref_timestamp

diffNo. 33: 2010/11/12 23:42:05



	

Change Table

vendor_large_data

Delete Index
  • ix_large_data_numeric_integer
  • ix_large_data_string

vendor_large_data_ref

Delete FK
  • fk_vendor_large_data_ref_data
  • fk_vendor_large_data_ref_self
Delete Index
  • ix_large_data_ref_date
  • ix_large_data_ref_nullable_dec
  • ix_large_data_ref_timestamp

diffNo. 32: 2010/11/12 21:55:54


	

table count: 20 -> 22

Add Table

diffNo. 31: 2010/09/07 17:09:22


	

table count: 18 -> 20

Add Table

diffNo. 30: 2010/06/18 15:11:04



	

Change Table

VENDOR-NON COMPILABLE

Change Column
NON COMPILABLE-NAME
Size32 -> 64

vendor_$_dollar

Change Column
vendor_$_dollar_name
Size32 -> 64

diffNo. 29: 2010/06/15 11:58:59


	

table count: 16 -> 18

Add Table

diffNo. 28: 2010/06/07 21:51:17



	

Change Table

vendor_check

Delete UQ
  • uq_vendor_check

diffNo. 27: 2010/06/07 21:50:43



	

Change Table

vendor_check

Change UQ
uq_vendor_check
Columntype_of_bigint, type_of_int8 -> type_of_int8, type_of_bigint

diffNo. 26: 2010/06/07 21:50:28



	

Change Table

vendor_check

Add UQ
  • uq_vendor_check
Delete Index
  • ix_vendor_check

diffNo. 25: 2010/06/07 21:48:58



	

Change Table

vendor_check

Change Index
ix_vendor_check
Columntype_of_date, type_of_timestamp -> type_of_timestamp, type_of_date

diffNo. 24: 2010/06/07 21:48:29



	

Change Table

vendor_check

Add Index
  • ix_vendor_check

diffNo. 23: 2010/06/07 21:46:28



	

Change Table

member

Add Index
  • ix_member_formalized_datetime
  • ix_member_member_name

member_login

Add Index
  • ix_member_login_datetime

product

Add Index
  • ix_product_product_name

purchase

Add Index
  • ix_purchase_datetime_member
  • ix_purchase_price
  • ix_purchase_product_datetime

diffNo. 22: 2010/06/07 21:18:53


	

table count: 17 -> 16

Delete Table

diffNo. 21: 2010/06/07 21:18:19



	

Add Table

Delete Table

diffNo. 20: 2010/06/07 21:17:59


	

table count: 16 -> 17

Add Table

diffNo. 19: 2010/06/07 21:17:27


	

table count: 19 -> 16

Delete Table

diffNo. 18: 2010/06/07 21:15:18



	

Change Table

diff_pk

Change UQ
uq_diff_pk
Columntype_of_char -> type_of_char, diff_third_id

diffNo. 17: 2010/06/07 21:14:29



	

Change Table

diff_fk

Change FK
fk_dif_fk
Columndiff_id -> diff_second_id

diffNo. 16: 2010/06/07 21:13:15



	

Change Table

diff_pk

Change PK
diff_pk_pkey
Columndiff_id -> diff_second_id

diffNo. 15: 2010/06/07 21:11:56



	

Change Table

diff_fk

Add Column
  • diff_second_id
Change Column
diff_id
Typenumeric -> int4
Size16 -> 10

diff_pk

Add Column
  • diff_second_id
  • diff_third_id
Change Column
diff_id
Typenumeric -> int4
Size16 -> 10
Add UQ
  • uq_diff_pk

diffNo. 14: 2010/06/07 21:06:23



	

Change Table

diff_fk

Add FK
  • fk_dif_fk
Delete FK
  • fk_diff_fk

diffNo. 13: 2010/06/07 21:02:32


	

table count: 17 -> 19

Add Table

Change Table

diff_check

Change Column
type_of_char
Not Nullfalse -> true
Delete Column
  • type_of_vc_array
  • type_of_text
Change PK
diff_check_pkey
Columnvendor_check_id -> type_of_char

diffNo. 12: 2010/06/07 18:43:19



	

Change Table

diff_check

Change Column
type_of_char
Not Nulltrue -> false
Change PK
diff_check_pkey
Columntype_of_char -> vendor_check_id

diffNo. 11: 2010/06/07 18:35:44



	

Change Table

diff_check

Change Column
type_of_char
Not Nullfalse -> true

diffNo. 10: 2010/06/07 18:35:20


	

table count: 16 -> 17

Add Table

diffNo. 9: 2010/06/07 16:52:24


	

table count: 17 -> 16

Delete Table

diffNo. 8: 2010/06/07 16:51:57



	

Change Table

vendor_differ

Change Column
type_of_varchar
Size2147483647 -> 3
type_of_text
Typetext -> bpchar
Size2147483647 -> 3
Delete Column
  • type_of_vc_array
  • type_of_numeric_integer

diffNo. 7: 2010/06/07 16:51:23


	

table count: 16 -> 17

Add Table

diffNo. 6: 2010/06/07 15:23:34


	

table count: 18 -> 16

Delete Table

diffNo. 5: 2010/06/07 15:21:00



	

Change Table

diffsecond

Object Type
TABLE -> VIEW
Add Column
  • member_id
  • member_name
  • member_account
  • member_status_code
  • formalized_datetime
  • birthdate
  • register_datetime
  • register_user
  • register_process
  • update_datetime
  • update_user
  • update_process
  • version_no
Delete Column
  • vendor_check_id
  • type_of_char
  • type_of_char2
  • type_of_xml

diffNo. 4: 2010/06/07 15:20:31



	

Add Table

Delete Table

diffNo. 3: 2010/06/07 15:19:48



	

Change Table

diff_second

Add Column
  • type_of_char2

diffNo. 2: 2010/06/07 15:18:39



	

Change Table

diff_first

Add Column
  • type_of_int4
Change Column
type_of_char
Size3 -> 4
type_of_int8
Typeint8 -> int4
Size19 -> 10

diff_second

Delete Column
  • type_of_int8

diffNo. 1: 2010/06/07 15:02:59


	

table count: 16 -> 18

Add Table

Thanks

Created by DBFlute(AutoGenerator)

x

Input the new comment of diffdate: