File: upgrade_3.2cvs.sql

package info (click to toggle)
sitebar 3.3.8-7etch1
  • links: PTS
  • area: main
  • in suites: etch
  • size: 4,168 kB
  • ctags: 3,234
  • sloc: php: 52,374; sql: 570; sh: 331; makefile: 35
file content (12 lines) | stat: -rw-r--r-- 368 bytes parent folder | download | duplicates (5) 
1
2
3
4
5
6
7
8
9
10
11
12
 
CREATE TABLE `sitebar_visit` (
    `lid` int(10) unsigned NOT NULL,
    `uid` int(10) unsigned NOT NULL,
    `t_visit` timestamp(14) NOT NULL,
    PRIMARY KEY  (`lid`,`uid`)
) TYPE=MyISAM COMMENT='Last link visit for each user';

ALTER TABLE `sitebar_link`
    ADD `hits` int(10) unsigned NOT NULL default '0';

UPDATE `sitebar_config`
    SET `release` = '3.2 CVS2';