CREATE TABLE `0_tags` (
`id` int(11) NOT NULL auto_increment,
`type` smallint(6) NOT NULL,
- `name` varchar(60) NOT NULL,
+ `name` varchar(30) NOT NULL,
+ `description` varchar(60) default NULL,
+ `inactive` tinyint(1) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY(`type`,`name`)
) TYPE=MyISAM AUTO_INCREMENT=1;
DROP TABLE IF EXISTS `0_tag_associations`;
CREATE TABLE `0_tag_associations` (
- `id` int(11) NOT NULL auto_increment,
`record_id` varchar(11) NOT NULL,
`tag_id` int(11) NOT NULL,
- PRIMARY KEY (`id`)
-) TYPE=MyISAM AUTO_INCREMENT=1;
+ UNIQUE KEY(`record_id`,`tag_id`)
+) TYPE=MyISAM;
+
+DROP TABLE IF EXISTS `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 '',
+ 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`;