  |
1 | | - | # $Id: oscommerce.sql 1317 2007-03-05 05:36:15Z hpdl $ |
| |
| 1 | + | # $Id: oscommerce.sql 1372 2007-03-05 22:58:51Z hpdl $ |
|
2 | 2 | | # |
| |
3 | 3 | | # osCommerce, Open Source E-Commerce Solutions |
| |
4 | 4 | | # http://www.oscommerce.com |
| |
|
|
 |
… |
|
55 | 55 | | PRIMARY KEY (administrators_id, module) |
| |
56 | 56 | | ); |
| |
57 | 57 | | |
 |
| 58 | + | DROP TABLE IF EXISTS osc_administrators_log; |
| |
| 59 | + | CREATE TABLE osc_administrators_log ( |
| |
| 60 | + | id int NOT NULL, |
| |
| 61 | + | module varchar(255) NOT NULL, |
| |
| 62 | + | module_action varchar(32), |
| |
| 63 | + | module_id int, |
| |
| 64 | + | field_key varchar(255) NOT NULL, |
| |
| 65 | + | old_value text, |
| |
| 66 | + | new_value text, |
| |
| 67 | + | action varchar(255) NOT NULL, |
| |
| 68 | + | administrators_id int NOT NULL, |
| |
| 69 | + | datestamp datetime NOT NULL, |
| |
| 70 | + | KEY idx_administrators_log_id (id) |
| |
| 71 | + | ); |
| |
| 72 | + | |
|
58 | 73 | | DROP TABLE IF EXISTS osc_banners; |
| |
59 | 74 | | CREATE TABLE osc_banners ( |
| |
60 | 75 | | banners_id int NOT NULL auto_increment, |