diff options
| author |  brain | 2007-01-15 00:45:23 +0000 |
|---|---|---|
| committer | brain | 2007-01-15 00:45:23 +0000 |
| commit | 6b23783b71e98bae6aced7144c6730f028873cb6 (patch) | |
| tree | 4d1a5f8f6831ab5adb6499c55099cce708256723 /extras/m_sqloper.postgresql.sql | |
| parent | Hook qlite3_update_hook to queries to also catch affected rows on UPDATE/INSE... (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_sqloper.postgresql.sql')
| -rw-r--r-- | extras/m_sqloper.postgresql.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/extras/m_sqloper.postgresql.sql b/extras/m_sqloper.postgresql.sql new file mode 100644 index 000000000..fd640949f --- /dev/null +++ b/extras/m_sqloper.postgresql.sql @@ -0,0 +1,14 @@ +-- +-- PostgreSQL database dump +-- + +CREATE TABLE ircd_opers ( + id serial NOT NULL, + username text, + "password" text, + hostname text, + "type" text +); +ALTER TABLE ONLY ircd_opers + ADD CONSTRAINT ircd_opers_pkey PRIMARY KEY (id); + |