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

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

Parent Directory Parent Directory | Revision Log Revision Log


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

1 rabit 1.1 #-------------------------------------------------------------------------------
2     #-- www.netfrag.org
3     #-- DB schema sql.
4     #-------------------------------------------------------------------------------
5     #-- rabit, 16:30 04.09.2004
6     #-- $Id$
7     #-------------------------------------------------------------------------------
8    
9     #---------------------------------------
10     #-- Data base: "nfo"
11     #-- Table: "languages"
12     #---------------------------------------
13    
14     DROP TABLE IF EXISTS languages;
15    
16     CREATE TABLE languages (
17     id int(10) unsigned NOT NULL auto_increment,
18     abbreviation char(2) NOT NULL default '',
19     name varchar(64) NOT NULL default '',
20     parameters varchar(255) default NULL,
21     PRIMARY KEY (id),
22     UNIQUE KEY abbreviation (abbreviation)
23     )
24     TYPE=MyISAM
25     COMMENT='NFO content language references'
26     ;

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