1 | /*=============================================================*/ |
---|
2 | /*== http://www.postgresql.org/docs/8.1/static/datatype.html ==*/ |
---|
3 | /*=============================================================*/ |
---|
4 | |
---|
5 | CREATE SEQUENCE S_TABLE_TEST; |
---|
6 | |
---|
7 | /*=============================================================*/ |
---|
8 | /* Table : TABLE_TEST */ |
---|
9 | /*=============================================================*/ |
---|
10 | CREATE TABLE TABLE_TEST ( |
---|
11 | TABLE_TEST_ID NUMERIC NOT NULL, |
---|
12 | CODE VARCHAR(50) NOT NULL, |
---|
13 | VALUE INTEGER, |
---|
14 | IS_VISIBLE BOOLEAN DEFAULT FALSE NOT NULL, |
---|
15 | DEFAULT_TRANSLATION VARCHAR(255), |
---|
16 | CONSTRAINT PK_TABLE_TEST PRIMARY KEY (TABLE_TEST_ID), |
---|
17 | CONSTRAINT AK_TABLE_TEST_CO_ACH_ACHI UNIQUE (CODE) |
---|
18 | ); |
---|
19 | |
---|
20 | COMMENT ON TABLE TABLE_TEST IS 'Table de test'; |
---|
21 | COMMENT ON COLUMN TABLE_TEST.TABLE_TEST_ID IS 'The identifier of the element'; |
---|
22 | COMMENT ON COLUMN TABLE_TEST.CODE IS 'The element code'; |
---|
23 | COMMENT ON COLUMN TABLE_TEST.VALUE IS 'The element value'; |
---|
24 | COMMENT ON COLUMN TABLE_TEST.IS_VISIBLE IS 'Test for a boolean'; |
---|
25 | COMMENT ON COLUMN TABLE_TEST.DEFAULT_TRANSLATION IS 'The default translation of the element'; |
---|
26 | |
---|
27 | |
---|
28 | /*=============================================================*/ |
---|
29 | /* INSERTS */ |
---|
30 | /*=============================================================*/ |
---|
31 | INSERT INTO table_test VALUES (nextval('S_TABLE_TEST'),'code_test_1','6548','FALSE','code test translation 1'); |
---|
32 | INSERT INTO table_test VALUES (nextval('S_TABLE_TEST'),'code_test_2','789','TRUE','code test translation 2'); |
---|
33 | INSERT INTO table_test VALUES (nextval('S_TABLE_TEST'),'code_test_3','1234','FALSE','code test translation 3'); |
---|