User: user57
Date: 01/10/02 14:34:56
Added: src/database/schema/posgresql Survey.sql User.sql
Log:
o moved jboss-website/website/survey to jboss-website/survey (it's own
module)
Revision Changes Path
1.1 website-survey/src/database/schema/posgresql/Survey.sql
Index: Survey.sql
===================================================================
-- If the table and/or sequence already exists back them up and delete them
-- Create empty Survey table
CREATE TABLE Survey (
Id INT4 NOT NULL,
User_Id INT4 NOT NULL,
Permission INT2 NOT NULL,
Jboss_Version VARCHAR( 50 ),
Jboss_Download_Type VARCHAR( 50 ) NOT NULL,
Jboss_Usage VARCHAR( 2000 ),
Jboss_Website VARCHAR( 50 ),
Jboss_First_Time INT2 NOT NULL,
Jboss_Other_Server INT4 NOT NULL,
Jboss_Other_Server_Name VARCHAR( 50 ),
Jboss_Reason VARCHAR( 2000 ),
Environment_Equipement VARCHAR( 100 ) NOT NULL,
Environment_OS VARCHAR( 25 ) NOT NULL,
Environment_Processors INT4 NOT NULL,
Environment_Requests INT4,
Environment_Database VARCHAR( 50 ),
Environment_Data_Size INT4,
Environment_Stateless_EJBs INT4 NOT NULL,
Environment_Stateful_EJBs INT4 NOT NULL,
Environment_Entity_EJBs INT4 NOT NULL,
Environment_Message_EJBs INT4 NOT NULL,
Jboss_Features VARCHAR( 50 ),
Own_Interceptors INT2 NOT NULL,
Own_Container_Invokers INT2 NOT NULL,
Own_MBeans INT2 NOT NULL,
Own_Comments VARCHAR( 2000 ),
Creation_Date DATETIME NOT NULL,
Modification_Date DATETIME NOT NULL
);
CREATE SEQUENCE Survey_Seq;
1.1 website-survey/src/database/schema/posgresql/User.sql
Index: User.sql
===================================================================
-- If the table and/or sequence already exists back them up and delete them
-- Create empty User table (which must be named differently because it
-- conflict with the keyword Users
CREATE TABLE User_Info (
Id INT4 NOT NULL,
First_Name VARCHAR( 50 ) NOT NULL,
Last_Name VARCHAR( 50 ) NOT NULL,
Password VARCHAR( 50 ) NOT NULL,
Company VARCHAR( 50 ) NOT NULL,
Job_Description VARCHAR( 100 ) NOT NULL,
Email VARCHAR( 100 ) NOT NULL,
Subscription INT2 NOT NULL,
Industry_Type INT4 NOT NULL,
Other_Industry_Type VARCHAR( 50 ) NOT NULL,
Nr_Of_Employees INT4 NOT NULL,
Support INT4 NOT NULL,
Creation_Date DATETIME NOT NULL,
Modification_Date DATETIME NOT NULL
);
CREATE SEQUENCE User_Info_Seq;
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
