db/schema/nfo.contents.sql

#-------------------------------------------------------------------------------
#-- www.netfrag.org
#-- DB schema sql.
#-------------------------------------------------------------------------------
#-- rabit, 16:22 04.09.2004
#-- $Id$
#-------------------------------------------------------------------------------

#---------------------------------------
#-- Data base:  "nfo"
#-- Table:      "contents"
#---------------------------------------

DROP TABLE IF EXISTS contents;

CREATE TABLE contents (
  id bigint(20) unsigned NOT NULL auto_increment,
  keyname varchar(255) NOT NULL default '',
  type varchar(255) NOT NULL default '',
  creator_id int(10) unsigned NOT NULL default '0',
  method varchar(255) NOT NULL default '',
  timestamp datetime NOT NULL default '0000-00-00 00:00:00',
  flags varchar(16) default NULL,
  language_id int(10) unsigned NOT NULL default '1',
  description varchar(255) default NULL,
  content text NOT NULL,
  editor_id int(10) unsigned NOT NULL default '0',
  edit_timestamp datetime default NULL,
  UNIQUE KEY id (id)
)
TYPE=MyISAM
COMMENT='NFO table of contents'
;
1	rabit	1.1	#-------------------------------------------------------------------------------
2			#-- www.netfrag.org
3			#-- DB schema sql.
4			#-------------------------------------------------------------------------------
5			#-- rabit, 16:22 04.09.2004
6			#-- $Id$
7			#-------------------------------------------------------------------------------
8
9			#---------------------------------------
10			#-- Data base: "nfo"
11			#-- Table: "contents"
12			#---------------------------------------
13
14			DROP TABLE IF EXISTS contents;
15
16			CREATE TABLE contents (
17			id bigint(20) unsigned NOT NULL auto_increment,
18			keyname varchar(255) NOT NULL default '',
19			type varchar(255) NOT NULL default '',
20			creator_id int(10) unsigned NOT NULL default '0',
21			method varchar(255) NOT NULL default '',
22			timestamp datetime NOT NULL default '0000-00-00 00:00:00',
23			flags varchar(16) default NULL,
24			language_id int(10) unsigned NOT NULL default '1',
25			description varchar(255) default NULL,
26			content text NOT NULL,
27			editor_id int(10) unsigned NOT NULL default '0',
28			edit_timestamp datetime default NULL,
29			UNIQUE KEY id (id)
30			)
31			TYPE=MyISAM
32			COMMENT='NFO table of contents'
33			;
MailToCvsAdmin">MailToCvsAdmin	ViewVC Help
Powered by ViewVC 1.1.26