You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
108 lines
3.0 KiB
108 lines
3.0 KiB
2 years ago
|
#IfNotTable lang_constants
|
||
|
|
|
||
|
|
## ########################################################
|
||
|
|
|
||
|
|
##
|
||
|
|
## Table structure for table `lang_constants`
|
||
|
|
##
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `lang_constants` (
|
||
|
|
`cons_id` int(11) NOT NULL auto_increment,
|
||
|
|
`constant_name` varchar(255) NOT NULL default '',
|
||
|
|
UNIQUE KEY `cons_id` (`cons_id`),
|
||
|
|
KEY `cons_name` (`constant_name`)
|
||
|
|
) ENGINE=MyISAM AUTO_INCREMENT=6 ;
|
||
|
|
|
||
|
|
##
|
||
|
|
## Dumping data for table `lang_constants`
|
||
|
|
##
|
||
|
|
|
||
|
|
## ########################################################
|
||
|
|
|
||
|
|
##
|
||
|
|
## Table structure for table `lang_definitions`
|
||
|
|
##
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `lang_definitions` (
|
||
|
|
`def_id` int(11) NOT NULL auto_increment,
|
||
|
|
`cons_id` int(11) NOT NULL default '0',
|
||
|
|
`lang_id` int(11) NOT NULL default '0',
|
||
|
|
`definition` mediumtext NOT NULL,
|
||
|
|
UNIQUE KEY `def_id` (`def_id`),
|
||
|
|
KEY `definition` (`definition`(100))
|
||
|
|
) ENGINE=MyISAM ;
|
||
|
|
|
||
|
|
##
|
||
|
|
## Dumping data for table `lang_definitions`
|
||
|
|
##
|
||
|
|
|
||
|
|
|
||
|
|
## ########################################################
|
||
|
|
|
||
|
|
##
|
||
|
|
## Table structure for table `lang_languages`
|
||
|
|
##
|
||
|
|
|
||
|
|
CREATE TABLE IF NOT EXISTS `lang_languages` (
|
||
|
|
`lang_id` int(11) NOT NULL auto_increment,
|
||
|
|
`lang_code` char(2) NOT NULL default '',
|
||
|
|
`lang_description` varchar(100) NOT NULL default '',
|
||
|
|
UNIQUE KEY `lang_id` (`lang_id`)
|
||
|
|
) ENGINE=MyISAM ;
|
||
|
|
|
||
|
|
##
|
||
|
|
## Dumping data for table `lang_languages`
|
||
|
|
##
|
||
|
|
|
||
|
|
INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (1, 'en', 'English');
|
||
|
|
INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (2, 'se', 'Swedish');
|
||
|
|
INSERT INTO `lang_languages` (`lang_id`, `lang_code`, `lang_description`) VALUES (3, 'es', 'Spanish');
|
||
|
|
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfMissingColumn lists outcome
|
||
|
|
ALTER TABLE lists
|
||
|
|
ADD outcome int(11) NOT NULL DEFAULT 0,
|
||
|
|
ADD destination varchar(255) DEFAULT NULL;
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfMissingColumn pnotes title
|
||
|
|
ALTER TABLE pnotes
|
||
|
|
ADD title varchar(255) NOT NULL DEFAULT 'Unassigned',
|
||
|
|
ADD assigned_to varchar(255) NOT NULL DEFAULT '';
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfMissingColumn users see_auth
|
||
|
|
ALTER TABLE users ADD see_auth int(11) NOT NULL DEFAULT 1;
|
||
|
|
UPDATE users SET see_auth = 3 WHERE authorized = 1;
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfNotTable payments
|
||
|
|
CREATE TABLE `payments` (
|
||
|
|
`id` bigint(20) NOT NULL auto_increment,
|
||
|
|
`pid` bigint(20) NOT NULL DEFAULT 0,
|
||
|
|
`dtime` datetime NOT NULL,
|
||
|
|
`user` varchar(255) NOT NULL DEFAULT '',
|
||
|
|
`method` varchar(255) NOT NULL DEFAULT '',
|
||
|
|
`source` varchar(255) NOT NULL DEFAULT '',
|
||
|
|
`amount1` decimal(7,2) NOT NULL DEFAULT 0,
|
||
|
|
`amount2` decimal(7,2) NOT NULL DEFAULT 0,
|
||
|
|
`posted1` decimal(7,2) NOT NULL DEFAULT 0,
|
||
|
|
`posted2` decimal(7,2) NOT NULL DEFAULT 0,
|
||
|
|
PRIMARY KEY (`id`)
|
||
|
|
) ;
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfNotColumnType form_vitals temperature float(5,2)
|
||
|
|
ALTER TABLE form_vitals
|
||
|
|
MODIFY temperature float(5,2) default 0,
|
||
|
|
MODIFY pulse float(5,2) default 0,
|
||
|
|
MODIFY respiration float(5,2) default 0,
|
||
|
|
MODIFY waist_circ float(5,2) default 0;
|
||
|
|
#EndIf
|
||
|
|
|
||
|
|
#IfNotColumnType form_clinical_notes followup_required int(11)
|
||
|
|
ALTER TABLE form_clinical_notes
|
||
|
|
MODIFY followup_required int(11) NOT NULL DEFAULT 0;
|
||
|
|
#EndIf
|