Gossamer Forum: General: Databases and SQL: CREATE TABLE.... (Andy)

Gossamer Threads

Home : General : Databases and SQL :

CREATE TABLE....

Jan 13, 2003, 3:17 PM

Andy

Veteran / Moderator (18441 posts)

Jan 13, 2003, 3:17 PM

Shortcut

CREATE TABLE....

Can anyone see a problem with this SQL code? I'm using PHPMyAdmin, which seems to play around with the codes a little. Anyone got any ideas? (this is for a script I'm trying to install on my server....not just creating certain entries).

CREATE TABLE account_type (
id integer unique default nextval ('serial') PRIMARY KEY,
tag VARCHAR (50) NOT NULL
);

Cheers

Andy (mod)
andy@ultranerds.co.uk

Subject	Author	Views	Date
CREATE TABLE....	Andy	14109	Jan 13, 2003, 3:17 PM

Re: [Andy] CREATE TABLE....	Paul	13520	Jan 13, 2003, 4:44 PM

Re: [Paul] CREATE TABLE....	Andy	13524	Jan 14, 2003, 1:51 AM

Re: [Andy] CREATE TABLE....	Paul	13547	Jan 14, 2003, 1:58 AM

Re: [Paul] CREATE TABLE....	Andy	13504	Jan 14, 2003, 2:04 AM

Re: [Andy] CREATE TABLE....	Paul	13572	Jan 14, 2003, 2:55 AM

Re: [Paul] CREATE TABLE....	Andy	13532	Jan 14, 2003, 3:00 AM

Re: [Andy] CREATE TABLE....	Paul	13579	Jan 14, 2003, 3:18 AM

Re: [Paul] CREATE TABLE....	Andy	13527	Jan 14, 2003, 3:22 AM

Re: [Andy] CREATE TABLE....	Wil	13528	Jan 14, 2003, 5:27 AM

Re: [Wil] CREATE TABLE....	Andy	13495	Jan 14, 2003, 6:27 AM

Gossamer Threads is a Vancouver-based company with over 28 years experience in web technology. From development to hosting, we partner with leading organizations around the globe and help to build their web presences, strategies and infrastructures.

Let’s talk: 1-877-715-7676