/[cvs]/nfo/site/etc/db/schema/nfo.changes.sql
ViewVC logotype

Annotation of /nfo/site/etc/db/schema/nfo.changes.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (hide annotations)
Sat Sep 4 14:55:57 2004 UTC (19 years, 11 months ago) by rabit
Branch: MAIN
CVS Tags: alpha-20040904-1, HEAD
Initial commit: SQL db schema for "changes" table.

1 rabit 1.1 #-------------------------------------------------------------------------------
2     #-- www.netfrag.org
3     #-- DB schema sql.
4     #-------------------------------------------------------------------------------
5     #-- rabit, 16:37 04.09.2004
6     #-- $Id$
7     #-------------------------------------------------------------------------------
8    
9     #---------------------------------------
10     #-- Data base: "nfo"
11     #-- Table: "changes"
12     #---------------------------------------
13    
14     DROP TABLE IF EXISTS changes;
15    
16     CREATE TABLE changes (
17     timestamp datetime NOT NULL default '0000-00-00 00:00:00',
18     user_id int(10) unsigned NOT NULL default '0',
19     content_id bigint(20) unsigned NOT NULL default '0',
20     operation varchar(255) NOT NULL default '',
21     method varchar(255) NOT NULL default '',
22     comment text
23     )
24     TYPE=MyISAM
25     COMMENT='NFO change log'
26     ;

MailToCvsAdmin">MailToCvsAdmin
ViewVC Help
Powered by ViewVC 1.1.26 RSS 2.0 feed