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

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

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.1 - (show 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 #-------------------------------------------------------------------------------
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