Create User table:
/****** Object: Table [dbo].[TURBINE_USER] Script Date: 1/10/2002 2:50:45 PM
******/
CREATE TABLE [dbo].[TURBINE_USER] (
[USER_ID] [int] IDENTITY (1, 1) NOT NULL ,
[LOGIN_NAME] [varchar] (32) NOT NULL ,
[PASSWORD_VALUE] [varchar] (32) NOT NULL ,
[FIRST_NAME] [varchar] (99) NOT NULL ,
[LAST_NAME] [varchar] (99) NOT NULL ,
[EMAIL] [varchar] (99) NULL ,
[CONFIRM_VALUE] [varchar] (99) NULL ,
[MODIFIED] [datetime] NULL ,
[CREATED] [datetime] NULL ,
[LAST_LOGIN] [datetime] NULL ,
[OBJECTDATA] [binary] (250) NULL
) ON [PRIMARY]
GO
Populate usertable:
INSERT INTO TURBINE_USER
VALUES('admin','jetspeed','Raphael','Admin','[EMAIL PROTECTED]','CONFIRMED'
,NULL,NULL,NULL,0xaced0005737200136a6176612e7574696c2e486173687461626c6513bb
0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f40
0000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e
7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f61
63636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4
f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac95
1d0b94e08b0200007870000000a778);
INSERT INTO TURBINE_USER
VALUES('turbine','turbine','David','Turbine','[EMAIL PROTECTED]','CONFIRMED'
,NULL,NULL,NULL,0xaced0005737200136a6176612e7574696c2e486173687461626c6513bb
0f25214ae4b803000246000a6c6f6164466163746f724900097468726573686f6c6478703f40
0000000000037708000000050000000274000a4c4153545f4c4f47494e7372000e6a6176612e
7574696c2e44617465686a81014b5974190300007870770800000000000000007874000f5f61
63636573735f636f756e746572737200116a6176612e6c616e672e496e746567657212e2a0a4
f781873802000149000576616c7565787200106a6176612e6c616e672e4e756d62657286ac95
1d0b94e08b02000078700000007478);
----- Original Message -----
From: "Jakarta Apache" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, April 29, 2002 4:13 PM
Subject: SQL Script for MS SQL Server 2000
>
> Hi to All,
>
> If someone have a SQL Script for MS SQL Server 2000, please send me!!!
>
> I try to create my script for jetspeed, but nothing!!!
>
> I have just a connection to SQL Server 2000 but I have some problem with
MediumBlob type fields.
>
> Please send me a sql scrip.
>
> tnx in advance
>
> Gigi
>
>
>
> ---------------------------------
> Con Yahoo! vinci viaggi per i Mondiali FIFA 2002
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
