Recent Changes - Search:

CONGO

PmWiki

edit SideBar

V2 /

PropertyTables

V2.PropertyTables History

Hide minor edits - Show changes to output

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

||border=1 width = 50%
||!config_properties ||||||
||prop_cid ||int(8) || PK ||
||prop_name ||varchar(20)  || PK ||
||prop_default ||varchar(100) || ||
||prop_type ||enum('boolean','string','float','date','numeric')|| ||
||prop_regprompt  ||tinyint(1)|| ||
||prop_cost        ||float(8,2)  || ||
||prop_description ||varchar(40)  || ||
||prop_sequence    ||int(2) || ||


||border=1 width = 50%
||!reg_properties ||||||
||prop_rid  ||int(8)      || PK ||
||prop_cid  ||int(8)      || PK ||
||prop_name  ||varchar(20)  || ||
||prop_value ||varchar(100) || ||

!!Proposed Structures

||border=1 width = 50%
||!config_properties ||||||
||prop_id ||int(8) || PK ||
||prop_name ||varchar(20)  ||  ||
||prop_default ||varchar(100) || ||
||prop_type ||enum('boolean','string','float','date','numeric')|| ||
||prop_description ||varchar(40)  || ||

||border=1 width = 50%
||!con_properties ||||||
||prop_cid ||int(8)      || PK ||
||prop_pid ||int(8)      || PK ||
||prop_value ||varchar(100) || ||
||prop_regprompt  ||tinyint(1)|| ||
||prop_cost        ||float(8,2)  || ||
||prop_sequence    ||int(2) || ||

||border=1 width = 50%
||!reg_properties ||||||
||prop_cid ||int(8)      || PK ||
||prop_rid ||int(8)      || PK ||
||prop_pid ||int(8)      || PK ||
||prop_value ||varchar(100) || ||

Restore
November 26, 2008, at 03:06 PM by blk -
Changed line 27 from:
||prop_name ||varchar(20)  || PK ||
to:
||prop_name ||varchar(20)  || ||
Restore
November 26, 2008, at 03:06 PM by blk -
Changed line 28 from:
||prop_default || varchar(100) || ||
to:
||prop_default ||varchar(100) || ||
Changed lines 34-35 from:
||prop_cid || int(8)      || PK ||
||prop_pid || int(8)      || PK ||
to:
||prop_cid ||int(8)      || PK ||
||prop_pid ||int(8)      || PK ||
Changed lines 43-45 from:
||prop_cid || int(8)      || PK ||
||prop_rid || int(8)      || PK ||
||prop_pid || int(8)      || PK ||
to:
||prop_cid ||int(8)      || PK ||
||prop_rid ||int(8)      || PK ||
||prop_pid ||int(8)      || PK ||
Restore
November 26, 2008, at 03:04 PM by blk -
Added lines 24-48:
||border=1 width = 50%
||!config_properties ||||||
||prop_id ||int(8) || PK ||
||prop_name ||varchar(20)  || PK ||
||prop_default || varchar(100) || ||
||prop_type ||enum('boolean','string','float','date','numeric')|| ||
||prop_description ||varchar(40)  || ||

||border=1 width = 50%
||!con_properties ||||||
||prop_cid || int(8)      || PK ||
||prop_pid || int(8)      || PK ||
||prop_value ||varchar(100) || ||
||prop_regprompt  ||tinyint(1)|| ||
||prop_cost        ||float(8,2)  || ||
||prop_sequence    ||int(2) || ||

||border=1 width = 50%
||!reg_properties ||||||
||prop_cid || int(8)      || PK ||
||prop_rid || int(8)      || PK ||
||prop_pid || int(8)      || PK ||
||prop_value ||varchar(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_sequence    ||int(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:
||border=1 width = 50%
||reg_properties ||||||
||prop_rid   ||int(8)      || PK ||
||prop_cid  ||int(8)       || PK ||
||prop_name  ||varchar(20)  || ||
||prop_value ||varchar(100) || ||
Restore
November 26, 2008, at 02:49 PM by blk -
Changed lines 7-13 from:
||prop_default ||varchar(100) ||||
||prop_type ||enum('boolean','string','float','date','numeric')||||
||prop_regprompt  ||tinyint(1)||||
||prop_cost        ||float(8,2)  ||||
||prop_description ||varchar(40)  ||||
|prop_sequence    ||int(2) ||||
to:
||prop_default ||varchar(100) || ||
||prop_type ||enum('boolean','string','float','date','numeric')|| ||
||prop_regprompt  ||tinyint(1)|| ||
||prop_cost        ||float(8,2)  || ||
||prop_description ||varchar(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_default ||varchar(100) ||||
||prop_type ||enum('boolean','string','float','date','numeric')||||
||prop_regprompt   ||tinyint(1)||||
||prop_cost        ||float(8,2)  ||||
||prop_description ||varchar(40)  ||||
|prop_sequence    ||int(2) ||||
Restore
November 26, 2008, at 02:47 PM by blk -
Changed line 3 from:
||width = 50%
to:
||border=1 width = 50%
Changed lines 5-8 from:
||  prop_cid || int(8) || PK ||
|| prop_name || varchar(20)  || PK ||

to:
||prop_cid ||int(8) || PK ||
||prop_name ||varchar(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:
||width = 50%
||!config_properties ||||||
||  prop_cid || int(8) || PK ||
|| prop_name || varchar(20)  || PK ||


||
Restore
November 26, 2008, at 02:45 PM by blk -
Changed lines 3-5 from:
||!config_properties||||||
||  prop_cid || int(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_cid || int(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