diff options
author | brain <brain@e03df62e-2008-0410-955e-edbf42e46eb7> | 2007-01-15 00:45:23 +0000 |
---|---|---|
committer | brain <brain@e03df62e-2008-0410-955e-edbf42e46eb7> | 2007-01-15 00:45:23 +0000 |
commit | 6b23783b71e98bae6aced7144c6730f028873cb6 (patch) | |
tree | 4d1a5f8f6831ab5adb6499c55099cce708256723 /extras/m_sqllog.pgschema.sql | |
parent | f927c17c606bb6f13376a683f2f6776fc4c3e4c9 (diff) |
Rename all these so that the names reflect the database server theyre used with more accurately -- for example, the old mysql ones were just .schema.sql, and
the postgres ones were .pgschema.sql.
Theyre now .mysql.sql, .postgresql.sql and .sqlite3.sql
git-svn-id: http://svn.inspircd.org/repository/trunk/inspircd@6345 e03df62e-2008-0410-955e-edbf42e46eb7
Diffstat (limited to 'extras/m_sqllog.pgschema.sql')
-rw-r--r-- | extras/m_sqllog.pgschema.sql | 51 |
1 files changed, 0 insertions, 51 deletions
diff --git a/extras/m_sqllog.pgschema.sql b/extras/m_sqllog.pgschema.sql deleted file mode 100644 index 2e40dd90d..000000000 --- a/extras/m_sqllog.pgschema.sql +++ /dev/null @@ -1,51 +0,0 @@ --- --- PostgreSQL database dump --- - -CREATE TABLE ircd_log ( - id serial NOT NULL, - category_id bigint, - nick bigint, - host bigint, - source bigint, - dtime bigint DEFAULT 0 NOT NULL -); -ALTER TABLE ONLY ircd_log - ADD CONSTRAINT ircd_log_pkey PRIMARY KEY (id); - - - -CREATE TABLE ircd_log_actors ( - id serial NOT NULL, - actor text -); -ALTER TABLE ONLY ircd_log_actors - ADD CONSTRAINT ircd_log_actors_pkey PRIMARY KEY (id); - - - -CREATE TABLE ircd_log_categories ( - category_id serial NOT NULL, - category text NOT NULL -); - -INSERT INTO ircd_log_categories VALUES (1, 'Oper'); -INSERT INTO ircd_log_categories VALUES (2, 'Kill'); -INSERT INTO ircd_log_categories VALUES (3, 'Server Link'); -INSERT INTO ircd_log_categories VALUES (4, 'G/Z/K/E Line'); -INSERT INTO ircd_log_categories VALUES (5, 'Connect'); -INSERT INTO ircd_log_categories VALUES (6, 'Disconnect'); -INSERT INTO ircd_log_categories VALUES (7, 'Flooding'); -INSERT INTO ircd_log_categories VALUES (8, 'Load Module'); - -ALTER TABLE ONLY ircd_log_categories - ADD CONSTRAINT ircd_log_categories_pkey PRIMARY KEY (category_id); - - - -CREATE TABLE ircd_log_hosts ( - id serial NOT NULL, - hostname text -); -ALTER TABLE ONLY ircd_log_hosts - ADD CONSTRAINT ircd_log_hosts_pkey PRIMARY KEY (id); |