|
Lines 484-493
CREATE TABLE collections (
Link Here
|
| 484 |
-- |
484 |
-- |
| 485 |
DROP TABLE IF EXISTS collections_tracking; |
485 |
DROP TABLE IF EXISTS collections_tracking; |
| 486 |
CREATE TABLE collections_tracking ( |
486 |
CREATE TABLE collections_tracking ( |
| 487 |
ctId integer(11) NOT NULL auto_increment, |
487 |
collections_tracking_id integer(11) NOT NULL auto_increment, |
| 488 |
colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId', |
488 |
colId integer(11) NOT NULL DEFAULT 0 comment 'collections.colId', |
| 489 |
itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber', |
489 |
itemnumber integer(11) NOT NULL DEFAULT 0 comment 'items.itemnumber', |
| 490 |
PRIMARY KEY (ctId) |
490 |
PRIMARY KEY (collections_tracking_id) |
| 491 |
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; |
491 |
) ENGINE=InnoDB DEFAULT CHARACTER SET utf8; |
| 492 |
|
492 |
|
| 493 |
-- |
493 |
-- |