This is an old revision of the document!
User Area:
Admin Area:
ALTER TABLE `invoices` CHANGE `created` `inv_date` DATE NOT NULL; ALTER TABLE `invoices` CHANGE `method` `pay_method` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; ALTER TABLE `invoices` ADD `taxrate` DECIMAL( 6, 4 ) NOT NULL AFTER `pay_method`; ALTER TABLE `invoices` CHANGE `tax` `taxtotal` DECIMAL( 8, 2 ) NOT NULL DEFAULT '0.00'; ALTER TABLE `invoices` CHANGE `status` `status_OLD` VARCHAR( 45 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL; ALTER TABLE `invoices` ADD `status` TINYINT( 2 ) NOT NULL, ADD `notes` TEXT NOT NULL; UPDATE `invoices` SET `status` =1 WHERE `status_OLD` = 'Paid'; ALTER TABLE `invoices` DROP `status_OLD`;
RENAME TABLE `donias2_iasdb`.`users` TO `donias2_iasdb`.`site_users`; ALTER TABLE `site_users` CHANGE `password` `user_password` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; ALTER TABLE `site_users` CHANGE `email` `user_email` VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; ALTER TABLE `site_users` DROP `currency`; ALTER TABLE `site_users` CHANGE `userlevel` `group_id` TINYINT( 1 ) NOT NULL DEFAULT '1'; UPDATE `site_users` SET `group_id` = 20 WHERE group_id = 1; UPDATE `site_users` SET `group_id` =1 WHERE group_id =9;