Recent Changes - Search:

CONGO

PmWiki

edit SideBar

V2 /

PropertyTables

V2.PropertyTables History

Hide minor edits - Show changes to markup

November 27, 2008, at 08:13 AM by blk -
Deleted lines 0-47:

Current Structures:

config_properties
prop_cidint(8)PK
prop_namevarchar(20)PK
prop_defaultvarchar(100) 
prop_typeenum('boolean','string','float','date','numeric') 
prop_regprompttinyint(1) 
prop_costfloat(8,2) 
prop_descriptionvarchar(40) 
prop_sequenceint(2) 
reg_properties
prop_ridint(8)PK
prop_cidint(8)PK
prop_namevarchar(20) 
prop_valuevarchar(100) 

Proposed Structures

config_properties
prop_idint(8)PK
prop_namevarchar(20) 
prop_defaultvarchar(100) 
prop_typeenum('boolean','string','float','date','numeric') 
prop_descriptionvarchar(40) 
con_properties
prop_cidint(8)PK
prop_pidint(8)PK
prop_valuevarchar(100) 
prop_regprompttinyint(1) 
prop_costfloat(8,2) 
prop_sequenceint(2) 
reg_properties
prop_cidint(8)PK
prop_ridint(8)PK
prop_pidint(8)PK
prop_valuevarchar(100) 
Restore
November 26, 2008, at 03:06 PM by blk -
Changed line 27 from:
prop_namevarchar(20)PK
to:
prop_namevarchar(20) 
Restore
November 26, 2008, at 03:06 PM by blk -
Changed line 28 from:
prop_defaultvarchar(100) 
to:
prop_defaultvarchar(100) 
Changed lines 34-35 from:
prop_cidint(8)PK
prop_pidint(8)PK
to:
prop_cidint(8)PK
prop_pidint(8)PK
Changed lines 43-45 from:
prop_cidint(8)PK
prop_ridint(8)PK
prop_pidint(8)PK
to:
prop_cidint(8)PK
prop_ridint(8)PK
prop_pidint(8)PK
Restore
November 26, 2008, at 03:04 PM by blk -
Added lines 24-48:
config_properties
prop_idint(8)PK
prop_namevarchar(20)PK
prop_defaultvarchar(100) 
prop_typeenum('boolean','string','float','date','numeric') 
prop_descriptionvarchar(40) 
con_properties
prop_cidint(8)PK
prop_pidint(8)PK
prop_valuevarchar(100) 
prop_regprompttinyint(1) 
prop_costfloat(8,2) 
prop_sequenceint(2) 
reg_properties
prop_cidint(8)PK
prop_ridint(8)PK
prop_pidint(8)PK
prop_valuevarchar(100) 
Restore
November 26, 2008, at 02:51 PM by blk -
Changed lines 1-2 from:

Current Structures:

to:

Current Structures:

Changed line 16 from:
reg_properties
to:
reg_properties
Added lines 22-23:

Proposed Structures

Restore
November 26, 2008, at 02:50 PM by blk -
Changed lines 12-13 from:

|prop_sequence ||int(2) || ||

to:
prop_sequenceint(2) 
Restore
November 26, 2008, at 02:50 PM by blk -
Changed lines 14-22 from:

reg_properties: +------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+-------+ | prop_rid | int(8) | NO | MUL | 0 | | | prop_cid | int(8) | YES | MUL | NULL | | | prop_name | varchar(20) | YES | | NULL | | | prop_value | varchar(100) | YES | | NULL | | +------------+--------------+------+-----+---------+-------+

to:
reg_properties
prop_ridint(8)PK
prop_cidint(8)PK
prop_namevarchar(20) 
prop_valuevarchar(100) 
Restore
November 26, 2008, at 02:49 PM by blk -
Changed lines 7-13 from:
prop_defaultvarchar(100)
prop_typeenum('boolean','string','float','date','numeric')
prop_regprompttinyint(1)
prop_costfloat(8,2)
prop_descriptionvarchar(40)

|prop_sequence ||int(2) ||||

to:
prop_defaultvarchar(100) 
prop_typeenum('boolean','string','float','date','numeric') 
prop_regprompttinyint(1) 
prop_costfloat(8,2) 
prop_descriptionvarchar(40) 

|prop_sequence ||int(2) || ||

Restore
November 26, 2008, at 02:49 PM by blk -
Changed lines 7-21 from:

| Field | Type | Null | Key | Default | Extra | +------------------+---------------------------------------------------+------+-----+---------+-------+ | prop_cid | int(8) | NO | MUL | 0 | | | prop_name | varchar(20) | YES | MUL | NULL | | | prop_default | varchar(100) | YES | | NULL | | | prop_type | enum('boolean','string','float','date','numeric') | YES | | NULL | | | prop_regprompt | tinyint(1) | YES | | NULL | | | prop_cost | float(8,2) | YES | | NULL | | | prop_description | varchar(40) | YES | | NULL | | | prop_sequence | int(2) | YES | | NULL | | +------------------+---------------------------------------------------+------+-----+---------+-------+

to:
prop_defaultvarchar(100)
prop_typeenum('boolean','string','float','date','numeric')
prop_regprompttinyint(1)
prop_costfloat(8,2)
prop_descriptionvarchar(40)

|prop_sequence ||int(2) ||||

Restore
November 26, 2008, at 02:47 PM by blk -
Changed line 3 from:
to:
Changed lines 5-8 from:
prop_cidint(8)PK
prop_namevarchar(20)PK
to:
prop_cidint(8)PK
prop_namevarchar(20)PK
Restore
November 26, 2008, at 02:46 PM by blk -
Changed lines 3-6 from:
 ||!config_properties|||||| 
 ||  prop_cid || int(8) || PL ||
to:
config_properties
prop_cidint(8)PK
prop_namevarchar(20)PK
Restore
November 26, 2008, at 02:45 PM by blk -
Changed lines 3-5 from:
config_properties
prop_cidint(8)PL
to:
 ||!config_properties|||||| 
 ||  prop_cid || int(8) || PL ||
Restore
November 26, 2008, at 02:45 PM by blk -
Changed lines 3-4 from:

config_properties

to:
config_properties
prop_cidint(8)PL

| Field | Type | Null | Key | Default | Extra |

Deleted lines 7-8:

| Field | Type | Null | Key | Default | Extra | +------------------+---------------------------------------------------+------+-----+---------+-------+

Restore
November 26, 2008, at 02:41 PM by blk -
Added lines 1-26:

Current Structures:

config_properties

+------------------+---------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------------------------------------------------+------+-----+---------+-------+ | prop_cid | int(8) | NO | MUL | 0 | | | prop_name | varchar(20) | YES | MUL | NULL | | | prop_default | varchar(100) | YES | | NULL | | | prop_type | enum('boolean','string','float','date','numeric') | YES | | NULL | | | prop_regprompt | tinyint(1) | YES | | NULL | | | prop_cost | float(8,2) | YES | | NULL | | | prop_description | varchar(40) | YES | | NULL | | | prop_sequence | int(2) | YES | | NULL | | +------------------+---------------------------------------------------+------+-----+---------+-------+

reg_properties: +------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+--------------+------+-----+---------+-------+ | prop_rid | int(8) | NO | MUL | 0 | | | prop_cid | int(8) | YES | MUL | NULL | | | prop_name | varchar(20) | YES | | NULL | | | prop_value | varchar(100) | YES | | NULL | | +------------+--------------+------+-----+---------+-------+

Restore
Edit - History - Print - Recent Changes - Search
Page last modified on November 27, 2008, at 08:13 AM