projects
/
fa-stable.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Changed get_unic_dec to get_qty_dec for eliminating return -1.
[fa-stable.git]
/
sql
/
alter2.2.sql
diff --git
a/sql/alter2.2.sql
b/sql/alter2.2.sql
index 9a50e75be87e54e555ec367e6b62385b1268a53e..a08cc39761a45209fda815e670f40bea18c04acf 100644
(file)
--- a/
sql/alter2.2.sql
+++ b/
sql/alter2.2.sql
@@
-129,16
+129,16
@@
CREATE TABLE `0_tag_associations` (
UNIQUE KEY(`record_id`,`tag_id`)
) TYPE=MyISAM;
UNIQUE KEY(`record_id`,`tag_id`)
) TYPE=MyISAM;
-DROP TABLE IF EXISTS `0_user
sonline`
;
+DROP TABLE IF EXISTS `0_user
online`
;
CREATE TABLE `0_useronline` (
CREATE TABLE `0_useronline` (
+ `id` int(11) NOT NULL AUTO_INCREMENT ,
`timestamp` int(15) NOT NULL default '0',
`ip` varchar(40) NOT NULL default '',
`file` varchar(100) NOT NULL default '',
`timestamp` int(15) NOT NULL default '0',
`ip` varchar(40) NOT NULL default '',
`file` varchar(100) NOT NULL default '',
- PRIMARY KEY (`timestamp`),
- KEY `ip` (`ip`),
- KEY `file` (`file`)
-) TYPE=MyISAM;
+ PRIMARY KEY `id` (`id`) ,
+ KEY (`timestamp`)
+) TYPE=MYISAM AUTO_INCREMENT=1;
ALTER TABLE `0_suppliers` ADD COLUMN `phone2` varchar(30) NOT NULL default '' AFTER `phone`;
ALTER TABLE `0_cust_branch` ADD COLUMN `phone2` varchar(30) NOT NULL default '' AFTER `phone`;
ALTER TABLE `0_suppliers` ADD COLUMN `phone2` varchar(30) NOT NULL default '' AFTER `phone`;
ALTER TABLE `0_cust_branch` ADD COLUMN `phone2` varchar(30) NOT NULL default '' AFTER `phone`;