History for maihamadb (postgresql)

to PropertiesHTML

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

next_schema_product
nextschema.white_same_name
nextschema.white_same_name_ref

Add Sequence

maihamadb.nextschema.next_schema_product_product_id_seq

Add Procedure

maihamadb.nextschema.sp_next_in_out_parameter
maihamadb.nextschema.sp_next_no_parameter

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

table count: 39 -> 36

Delete Table

next_schema_product
nextschema.white_same_name
nextschema.white_same_name_ref

Delete Sequence

maihamadb.nextschema.next_schema_product_product_id_seq

Delete Procedure

maihamadb.nextschema.sp_next_in_out_parameter
maihamadb.nextschema.sp_next_no_parameter

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

next_schema_product
nextschema.white_same_name
nextschema.white_same_name_ref

Add Sequence

maihamadb.nextschema.next_schema_product_product_id_seq

Add Procedure

maihamadb.nextschema.sp_next_in_out_parameter
maihamadb.nextschema.sp_next_no_parameter

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

table count: 39 -> 36

Delete Table

next_schema_product
nextschema.white_same_name
nextschema.white_same_name_ref

Delete Sequence

maihamadb.nextschema.next_schema_product_product_id_seq

Delete Procedure

maihamadb.nextschema.sp_next_in_out_parameter
maihamadb.nextschema.sp_next_no_parameter

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

white_compound_pk_wrong_order

Change Table

vendor_check

Add Column

type_of_json

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

Add Table

nextschema.white_same_name
nextschema.white_same_name_ref
white_same_name
white_same_name_ref

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

exampledb.nextschema.white_same_name
exampledb.nextschema.white_same_name_ref
exampledb.public.white_same_name
exampledb.public.white_same_name_ref

Add Sequence

maihamadb.public.member_member_id_seq
maihamadb.public.member_address_member_address_id_seq
maihamadb.public.member_login_member_login_id_seq
maihamadb.public.member_service_member_service_id_seq
maihamadb.public.purchase_purchase_id_seq
maihamadb.public.purchase_payment_purchase_payment_id_seq
maihamadb.public.product_product_id_seq
maihamadb.public.seq_not_related_to_table
maihamadb.public.seq_purchase
maihamadb.public.seq_sub_display_order
maihamadb.public.seq_sub_purchase_count
maihamadb.nextschema.next_schema_product_product_id_seq

Delete Sequence

exampledb.public.member_member_id_seq
exampledb.public.member_address_member_address_id_seq
exampledb.public.member_login_member_login_id_seq
exampledb.public.member_service_member_service_id_seq
exampledb.public.purchase_purchase_id_seq
exampledb.public.purchase_payment_purchase_payment_id_seq
exampledb.public.product_product_id_seq
exampledb.public.seq_not_related_to_table
exampledb.public.seq_purchase
exampledb.public.seq_sub_display_order
exampledb.public.seq_sub_purchase_count
exampledb.nextschema.next_schema_product_product_id_seq

Add Procedure

maihamadb.public.part_man_insert_trigger
maihamadb.public.sp_in_out_parameter
maihamadb.public.sp_result_set_parameter
maihamadb.public.sp_result_set_parameter_more
maihamadb.public.sp_return_parameter
maihamadb.public.sp_return_result_set
maihamadb.public.sp_return_result_set_with
maihamadb.public.sp_transaction_inherit
maihamadb.public.sp_various_type_parameter
maihamadb.public.spcamelcaseprocedure
maihamadb.nextschema.sp_next_in_out_parameter
maihamadb.nextschema.sp_next_no_parameter

Delete Procedure

exampledb.public.part_man_insert_trigger
exampledb.public.sp_in_out_parameter
exampledb.public.sp_result_set_parameter
exampledb.public.sp_result_set_parameter_more
exampledb.public.sp_return_parameter
exampledb.public.sp_return_result_set
exampledb.public.sp_return_result_set_with
exampledb.public.sp_transaction_inherit
exampledb.public.sp_various_type_parameter
exampledb.public.spcamelcaseprocedure
exampledb.nextschema.sp_next_in_out_parameter
exampledb.nextschema.sp_next_no_parameter

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

vendor_part_man
vendor_part_man_high

Delete Table

yahoo_ss_reports
yahoo_ss_reports_201406
yahoo_ss_reports_201407
yahoo_ss_reports_201408
yahoo_ss_reports_201409
yahoo_ss_reports_201410
yahoo_ss_reports_201411
yahoo_ss_reports_201412
yahoo_ss_reports_201501
yahoo_ss_reports_201502
yahoo_ss_reports_201503
yahoo_ss_reports_201504
yahoo_ss_reports_201505
yahoo_ss_reports_201506
yahoo_ss_reports_201507
yahoo_ss_reports_201508

Add Procedure

exampledb.public.part_man_insert_trigger

Delete Procedure

exampledb.public.create_month_partition_children_tables

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

table count: 36 -> 52

Add Table

yahoo_ss_reports
yahoo_ss_reports_201406
yahoo_ss_reports_201407
yahoo_ss_reports_201408
yahoo_ss_reports_201409
yahoo_ss_reports_201410
yahoo_ss_reports_201411
yahoo_ss_reports_201412
yahoo_ss_reports_201501
yahoo_ss_reports_201502
yahoo_ss_reports_201503
yahoo_ss_reports_201504
yahoo_ss_reports_201505
yahoo_ss_reports_201506
yahoo_ss_reports_201507
yahoo_ss_reports_201508

Add Procedure

exampledb.public.create_month_partition_children_tables

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

table count: 34 -> 36

Add Table

vendor_inherit_inu
vendor_inherit_neko

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

summary_product_aaaaa

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

summary_product_aaaaa

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

purchase_payment

Add Sequence

exampledb.public.purchase_payment_purchase_payment_id_seq

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

nextschema.white_same_name
nextschema.white_same_name_ref

Delete Table

white_next_same_name
white_next_same_name_ref

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

table count: 29 -> 33

Add Table

white_same_name
white_same_name_ref
white_next_same_name
white_next_same_name_ref

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

exampledb.public.seq_tmp

Change Procedure

exampledb.public.sp_in_out_parameter

SourceHash

c6f8474b -> 3c16b43d

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

Add Sequence

exampledb.public.seq_tmp

Delete Sequence

nextexampledb.public.seq_tmp

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

Add Sequence

exampledb.public.seq_tmp

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

table count: 30 -> 29

Delete Table

vendor_pg_trgm

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

table count: 29 -> 30

Add Table

vendor_pg_trgm

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

table count: 30 -> 29

Delete Table

vendor_pg_trgm

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

table count: 29 -> 30

Add Table

vendor_pg_trgm

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

table count: 27 -> 29

Add Table

white_compound_pk
white_compound_pk_ref

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

table count: 30 -> 27

Delete Table

vendor_pg_trgm
white_compound_pk
white_compound_pk_ref

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

table count: 28 -> 30

Add Table

white_compound_pk
white_compound_pk_ref

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

table count: 27 -> 28

Add Table

vendor_pg_trgm

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

table count: 28 -> 27

Delete Table

vendor_pg_trgm

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

table count: 27 -> 28

Add Table

vendor_pg_trgm

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

table count: 28 -> 27

Delete Table

vendor_pg_trgm

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

table count: 27 -> 28

Add Table

vendor_pg_trgm

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

table count: 28 -> 27

Delete Table

vendor_pg_trgm

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

table count: 1 -> 28

Add Table

VENDOR-NON COMPILABLE
member
member_address
member_login
member_security
member_service
member_status
member_withdrawal
product
product_category
product_status
purchase
region
service_rank
vendor_$_dollar
vendor_check
vendor_date_fk
vendor_date_pk
vendor_large_data
vendor_large_data_ref
vendor_pg_trgm
vendor_uuid_bar
vendor_uuid_foo
white_not_pk
white_xls_man
withdrawal_reason
summary_product

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

table count: 27 -> 1

Delete Table

VENDOR-NON COMPILABLE
member
member_address
member_login
member_security
member_service
member_status
member_withdrawal
product
product_category
product_status
purchase
region
service_rank
vendor_$_dollar
vendor_check
vendor_date_fk
vendor_date_pk
vendor_large_data
vendor_large_data_ref
vendor_uuid_bar
vendor_uuid_foo
white_not_pk
white_xls_man
withdrawal_reason
summary_product

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

table count: 26 -> 27

Add Table

white_xls_man

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

table count: 23 -> 26

Add Table

member_service
region
service_rank

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

product_category

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

vendor_large_data
vendor_large_data_ref

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

table count: 18 -> 20

Add Table

vendor_date_fk
vendor_date_pk

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

VENDOR-NON COMPILABLE
vendor_$_dollar

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

diff_fk_

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

Add Table

diff_fk_

Delete Table

diff_fk

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

table count: 16 -> 17

Add Table

diff_fk

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

table count: 19 -> 16

Delete Table

diff_check
diff_fk
diff_pk

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

diff_fk
diff_pk

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

diff_check

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

table count: 17 -> 16

Delete Table

vendor_differ

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

vendor_differ

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

table count: 18 -> 16

Delete Table

diff_first
diffsecond

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

diffsecond

Delete Table

diff_second

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

diff_first
diff_second

Thanks

Created by DBFlute(AutoGenerator)