Lines 3577-3582
CREATE TABLE discharges (
Link Here
|
3577 |
-- This table add the ability to add new fields for a record |
3577 |
-- This table add the ability to add new fields for a record |
3578 |
-- |
3578 |
-- |
3579 |
|
3579 |
|
|
|
3580 |
DROP TABLE IF EXISTS additional_fields; |
3580 |
CREATE TABLE `additional_fields` ( |
3581 |
CREATE TABLE `additional_fields` ( |
3581 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier |
3582 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier |
3582 |
`tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field |
3583 |
`tablename` varchar(255) NOT NULL DEFAULT '', -- tablename of the new field |
Lines 3593-3598
CREATE TABLE `additional_fields` (
Link Here
|
3593 |
-- This table store values for additional fields |
3594 |
-- This table store values for additional fields |
3594 |
-- |
3595 |
-- |
3595 |
|
3596 |
|
|
|
3597 |
DROP TABLE IF EXISTS additional_field_values; |
3596 |
CREATE TABLE `additional_field_values` ( |
3598 |
CREATE TABLE `additional_field_values` ( |
3597 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier |
3599 |
`id` int(11) NOT NULL AUTO_INCREMENT, -- primary key identifier |
3598 |
`field_id` int(11) NOT NULL, -- foreign key references additional_fields(id) |
3600 |
`field_id` int(11) NOT NULL, -- foreign key references additional_fields(id) |
3599 |
- |
|
|