MakeDB


1   package allinone;
2   
3   import java.sql.*;
4   
5   public class MakeDB {
6      public static void main(String  []argv) throws Throwable   {
7         Class.forName("org.hsqldb.jdbcDriver");
8         Connection conn = DriverManager
9        .getConnection("jdbc:hsqldb:allinoneDB","sa","");
10        Statement stmt = conn.createStatement();
11        stmt.execute("create table TableDCC (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , somedata VARCHAR (32) NOT NULL , reftod DECIMAL (19,0) NOT NULL)");
12        stmt.close();
13        stmt = conn.createStatement();
14        stmt.execute("create table TableNDCC (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , somedata VARCHAR (32) NOT NULL , reftod DECIMAL (19,0) NOT NULL)");
15        stmt.close();
16        stmt = conn.createStatement();
17        stmt.execute("create table TableCRC (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , somedata VARCHAR (32) NOT NULL , reftoa DECIMAL (19,0))");
18        stmt.close();
19        stmt = conn.createStatement();
20        stmt.execute("create table personSelfRef (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , login VARCHAR (32) NOT NULL , password VARCHAR (32) NOT NULL , firstname VARCHAR (32) NOT NULL , lastname VARCHAR (32) NOT NULL , boss DECIMAL (19,0))");
21        stmt.close();
22        stmt = conn.createStatement();
23        stmt.execute("create table personT (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , login VARCHAR (32) NOT NULL , password VARCHAR (32) NOT NULL , firstname VARCHAR (32) NOT NULL , lastname VARCHAR (32) NOT NULL , favouredDisc DECIMAL (19,0))");
24        stmt.close();
25        stmt = conn.createStatement();
26        stmt.execute("create table TableDCA (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , somedata VARCHAR (32) NOT NULL , reftob DECIMAL (19,0) NOT NULL , reftoc DECIMAL (19,0) NOT NULL)");
27        stmt.close();
28        stmt = conn.createStatement();
29        stmt.execute("create table TableNDCA (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , somedata VARCHAR (32) NOT NULL , reftob DECIMAL (19,0) NOT NULL , reftoc DECIMAL (19,0) NOT NULL)");
30        stmt.close();
31        stmt = conn.createStatement();
32        stmt.execute("create table TableCRA (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , somedata VARCHAR (32) NOT NULL , reftob DECIMAL (19,0))");
33        stmt.close();
34        stmt = conn.createStatement();
35        stmt.execute("create table discT (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , title VARCHAR (32) NOT NULL , artist VARCHAR (32) NOT NULL , genre VARCHAR (32) NOT NULL , owner DECIMAL (19,0) NOT NULL , isLiked INTEGER NOT NULL)");
36        stmt.close();
37        stmt = conn.createStatement();
38        stmt.execute("create table TableCRB (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , somedata VARCHAR (32) NOT NULL , reftoc DECIMAL (19,0))");
39        stmt.close();
40        stmt = conn.createStatement();
41        stmt.execute("create table TableNDCB (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , somedata VARCHAR (32) NOT NULL , reftod DECIMAL (19,0) NOT NULL)");
42        stmt.close();
43        stmt = conn.createStatement();
44        stmt.execute("create table TableDCB (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , somedata VARCHAR (32) NOT NULL , reftod DECIMAL (19,0) NOT NULL)");
45        stmt.close();
46        stmt = conn.createStatement();
47        stmt.execute("create table TableDCD (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , somedata VARCHAR (32) NOT NULL)");
48        stmt.close();
49        stmt = conn.createStatement();
50        stmt.execute("create table TableNDCD (oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER , somedata VARCHAR (32) NOT NULL)");
51        stmt.close();
52        stmt = conn.createStatement();
53        stmt.execute("create table ObjectId (next DECIMAL (19,0))");
54        stmt.close();
55        stmt = conn.createStatement();
56        stmt.execute("create table tableA2 ( oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER  NOT NULL , somedata VARCHAR (32) NOT NULL)");
57        stmt.close();
58        stmt = conn.createStatement();
59        stmt.execute("create table tableC2 ( oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER  NOT NULL , somedata VARCHAR (32) NOT NULL , reftoa DECIMAL (19,0), reftob DECIMAL (19,0))");
60        stmt.close();
61        stmt = conn.createStatement();
62        stmt.execute("create table tableB2 ( oid DECIMAL (19,0) NOT NULL PRIMARY KEY, version INTEGER  NOT NULL , somedata VARCHAR (32) NOT NULL , reftoa DECIMAL (19,0) , reftob DECIMAL (19,0));");
63        stmt.close();
64        conn.commit();
65        conn.close();
66  
67        conn = DriverManager
68       .getConnection("jdbc:hsqldb:allinoneDB","sa","");
69        stmt = conn.createStatement();
70        stmt.execute("ALTER TABLE TableDCC ADD CONSTRAINT FK_TableDCC_1 FOREIGN KEY (reftod) REFERENCES TableDCD (oid)");
71        stmt.close();
72        stmt = conn.createStatement();
73        stmt.execute("ALTER TABLE TableNDCC ADD CONSTRAINT FK_TableNDCC_1 FOREIGN KEY (reftod) REFERENCES TableNDCD (oid)");
74        stmt.close();
75        stmt = conn.createStatement();
76        stmt.execute("ALTER TABLE TableCRC ADD CONSTRAINT FK_TableCRC_1 FOREIGN KEY (reftoa) REFERENCES TableCRA (oid)");
77        stmt.close();
78        stmt = conn.createStatement();
79        stmt.execute("ALTER TABLE personSelfRef ADD CONSTRAINT FK_personSelfRef_1 FOREIGN KEY (boss) REFERENCES personSelfRef (oid)");
80        stmt.close();
81        stmt = conn.createStatement();
82        stmt.execute("ALTER TABLE personT ADD CONSTRAINT FK_personT_1 FOREIGN KEY (favouredDisc) REFERENCES discT (oid)");
83        stmt.close();
84        stmt = conn.createStatement();
85        stmt.execute("ALTER TABLE TableDCA ADD CONSTRAINT FK_TableDCA_1 FOREIGN KEY (reftob) REFERENCES TableDCB (oid)");
86        stmt.close();
87        stmt = conn.createStatement();
88        stmt.execute("ALTER TABLE TableDCA ADD CONSTRAINT FK_TableDCA_2 FOREIGN KEY (reftoc) REFERENCES TableDCC (oid)");
89        stmt.close();
90        stmt = conn.createStatement();
91        stmt.execute("ALTER TABLE TableNDCA ADD CONSTRAINT FK_TableNDCA_1 FOREIGN KEY (reftob) REFERENCES TableNDCB (oid)");
92        stmt.close();
93        stmt = conn.createStatement();
94        stmt.execute("ALTER TABLE TableNDCA ADD CONSTRAINT FK_TableNDCA_2 FOREIGN KEY (reftoc) REFERENCES TableNDCC (oid)");
95        stmt.close();
96        stmt = conn.createStatement();
97        stmt.execute("ALTER TABLE TableCRA ADD CONSTRAINT FK_TableCRA_1 FOREIGN KEY (reftob) REFERENCES TableCRB (oid)");
98        stmt.close();
99        stmt = conn.createStatement();
100       stmt.execute("ALTER TABLE discT ADD CONSTRAINT FK_discT_1 FOREIGN KEY (owner) REFERENCES personT (oid)");
101       stmt.close();
102       stmt = conn.createStatement();
103       stmt.execute("ALTER TABLE TableCRB ADD CONSTRAINT FK_TableCRB_1 FOREIGN KEY (reftoc) REFERENCES TableCRC (oid)");
104       stmt.close();
105       stmt = conn.createStatement();
106       stmt.execute("ALTER TABLE TableNDCB ADD CONSTRAINT FK_TableNDCB_1 FOREIGN KEY (reftod) REFERENCES TableNDCD (oid)");
107       stmt.close();
108       stmt = conn.createStatement();
109       stmt.execute("ALTER TABLE TableDCB ADD CONSTRAINT FK_TableDCB_1 FOREIGN KEY (reftod) REFERENCES TableDCD (oid)");
110       stmt.close();
111       stmt = conn.createStatement();
112       stmt.execute("ALTER TABLE tableC2 ADD CONSTRAINT tableC2_reftoa FOREIGN KEY (reftoa) REFERENCES tableA2 (oid)");
113       stmt.close();
114       stmt = conn.createStatement();
115       stmt.execute("ALTER TABLE tableC2 ADD CONSTRAINT tableC2_reftob FOREIGN KEY (reftob) REFERENCES tableB2 (oid)");
116       stmt.close();
117       stmt = conn.createStatement();
118       stmt.execute("ALTER TABLE tableB2 ADD CONSTRAINT tableB2_reftoa FOREIGN KEY (reftoa) REFERENCES tableA2 (oid)");
119       stmt.close();
120       stmt = conn.createStatement();
121       stmt.execute("ALTER TABLE tableB2 ADD CONSTRAINT tableB2_reftob FOREIGN KEY (reftob) REFERENCES tableB2 (oid)");
122       stmt.close();
123       conn.commit();
124       conn.close();
125    }
126 }
127
A to Z: JavaDoc & Examples Daily Java News & Articles Open Source Projects Open Source Codes Free Computer Books Remove Frame
Popular Tags