-
Notifications
You must be signed in to change notification settings - Fork 0
/
sqlEditions
38 lines (32 loc) · 1.6 KB
/
sqlEditions
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
ALTER TABLE `lp_settings` MODIFY COLUMN `currency_glyph` VARCHAR(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '$';
ALTER TABLE `lp_settings` MODIFY COLUMN `currency_glyph` VARCHAR(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '$';
ALTER TABLE `lp_settings`
ADD COLUMN `scanning_method` VARCHAR(10) NULL DEFAULT 'qr' AFTER `points_CTransPickList`,
ADD COLUMN `alert_preferences` VARCHAR(45) NULL DEFAULT 'email' AFTER `scanning_method`;
CREATE TABLE `app_users` (
`app_user_id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(40) DEFAULT NULL,
`password` varchar(100) NOT NULL,
`type` varchar(20) DEFAULT NULL,
`email` varchar(100) DEFAULT NULL,
`name` varchar(150) DEFAULT NULL,
`account_id` varchar(30) DEFAULT NULL,
PRIMARY KEY (`app_user_id`),
KEY `_ID` (`app_user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
ALTER TABLE `lp_customfields`
ADD COLUMN `unique_id` INT NOT NULL AUTO_INCREMENT AFTER `is_available`,
DROP PRIMARY KEY,
ADD PRIMARY KEY (`unique_id`, `account_id`, `custom_field_name`);
CREATE TABLE `lp_customlanguage` (
`account_id` VARCHAR(100) NOT NULL,
`custom_language` TEXT NOT NULL,
PRIMARY KEY(`account_id`)
)
ENGINE = InnoDB
CHARACTER SET utf8;
ALTER TABLE `lp_settings`
ADD COLUMN `allow_text_message_on_add` TINYINT(1) NULL DEFAULT 0 AFTER `alert_preferences`,
ADD COLUMN `allow_text_message_on_redeem` TINYINT(1) NULL DEFAULT 0 AFTER `allow_text_message_on_add`,
ADD COLUMN `text_message_on_add` TEXT NULL AFTER `allow_text_message_on_redeem`,
ADD COLUMN `text_message_on_redeem` TEXT NULL AFTER `text_message_on_add`;