"Fossies" - the Fresh Open Source Software Archive

Member "mcLinksCounter/table.sql" (18 Mar 2002, 624 Bytes) of package /linux/privat/old/mcLinksCounter1.2.zip:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 #
    2 # Structure de la table `mclinkscounter`
    3 #
    4 
    5 CREATE TABLE mclinkscounter (
    6   id int(3) NOT NULL auto_increment,
    7   nom varchar(30) NOT NULL default '',
    8   cat varchar(20) NOT NULL default '',
    9   url varchar(50) NOT NULL default '',
   10   target varchar(20) NOT NULL default '',
   11   clic int(5) NOT NULL default '0',
   12   PRIMARY KEY  (id)
   13 ) TYPE=MyISAM;
   14 
   15 
   16 
   17 #
   18 # Structure de la table `mclinkscounter_detail`
   19 #
   20 
   21 CREATE TABLE mclinkscounter_detail (
   22   id varchar(20) NOT NULL default '',
   23   agent varchar(100) NOT NULL default '-',
   24   ip varchar(20) NOT NULL default '-',
   25   date varchar(25) NOT NULL default '',
   26   KEY id (id)
   27 ) TYPE=MyISAM;