FilesExpand file tree

master

/

scriptdev2_create_structure_pgsql.sql

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

67 lines (63 loc) · 1.72 KB

master

/

scriptdev2_create_structure_pgsql.sql

Copy path

Top

File metadata and controls

• Code
• Blame

67 lines (63 loc) · 1.72 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

CREATE TABLE custom_texts (

entry bigint NOT NULL,

content_default text NOT NULL,

content_loc1 text,

content_loc2 text,

content_loc3 text,

content_loc4 text,

content_loc5 text,

content_loc6 text,

content_loc7 text,

content_loc8 text,

sound integer DEFAULT 0 NOT NULL,

type smallint DEFAULT (0)::smallint NOT NULL,

language smallint DEFAULT (0)::smallint NOT NULL,

emote smallint DEFAULT (0)::smallint NOT NULL,

comment text,

PRIMARY KEY(entry)

);

CREATE TABLE gossip_texts (

entry bigint NOT NULL,

content_default text NOT NULL,

content_loc1 text,

content_loc2 text,

content_loc3 text,

content_loc4 text,

content_loc5 text,

content_loc6 text,

content_loc7 text,

content_loc8 text,

comment text,

PRIMARY KEY(entry)

);

CREATE TABLE script_texts (

entry bigint NOT NULL,

content_default text NOT NULL,

content_loc1 text,

content_loc2 text,

content_loc3 text,

content_loc4 text,

content_loc5 text,

content_loc6 text,

content_loc7 text,

content_loc8 text,

sound integer DEFAULT 0 NOT NULL,

type smallint DEFAULT (0)::smallint NOT NULL,

language smallint DEFAULT (0)::smallint NOT NULL,

emote smallint DEFAULT (0)::smallint NOT NULL,

comment text,

PRIMARY KEY(entry)

);

CREATE TABLE script_waypoint (

entry bigint NOT NULL,

pointid bigint NOT NULL,

location_x float DEFAULT (0)::float NOT NULL,

location_y float DEFAULT (0)::float NOT NULL,

location_z float DEFAULT (0)::float NOT NULL,

waittime integer DEFAULT 0 NOT NULL,

point_comment text,

PRIMARY KEY(entry,pointid)

);

CREATE TABLE sd2_db_version (

version varchar(255) NOT NULL DEFAULT ''

);