|
|
Database
Type of database: MySQL
Minimum version required: 4.x
Create table definitions: http://phpyellow.com/phpyellow/docs/phpyellow_db_v4.sql.txt
Extra fields
Account table
The following Account table fields are unused in phpYellow 4.x:
- `extra_1` char(1) default NULL,
- `extra_2` char(1) default NULL,
- `extra_3` char(1) default NULL,
- `extra_4` char(1) default NULL,
- `extra_5` char(1) default NULL,
The extra fields above are coded into the table record insert. Modify register_result.php and - if applicable - loginResult.php
Listing table
The following Listing table fields are unused in phpYellow 4.x:
- `id_ratings` int(9) unsigned default NULL,
- `id_coupon` int(9) unsigned default NULL,
- `id_agent` int(9) unsigned default NULL,
- `id_extra_20` int(9) unsigned default NULL,
- `extra_21` char(1) default NULL,
- `extra_22` char(1) default NULL,
The extra fields above are NOT coded in any script and may be freely used for your own purposes.
Typically, you would hook into the listing id field - ckey - and use ckey as the foreign key
in your new table, for example a coupon table.
Ask a question.
|
|
