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